Subscribe
Tutorial search

Highlight Every Other Row or Column - Excel tutorial


You've surely seen Excel spreadsheets that have alternating row colors. For instance, odd-numbered rows might be white, while even-numbered rows might be gray. Conditional formatting makes this easy.
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



Creating Custom VBA Dialog Boxes
Creating Custom VBA Dialog Boxes
This tutorial starts you off by showing you how to use VBA's Microsoft Forms feature to create custom dialog boxes and input forms.
Difficulty:
Password-Protect a Worksheet from Viewing
Password-Protect a Worksheet from Viewing
Keep prying eyes from viewing a worksheet, unless they have the password.
Difficulty:
Lookup in a Column to the Left in Excel
Lookup in a Column to the Left in Excel
Lookup data in a column to the left in Excel. The Vlookup function cannot look to the left in Excel. Index and Match can be used to lookup data from any column.
Difficulty:
How to record and use a Macro in Excel
How to record and use a Macro in Excel
This is a video tutorial which teaches you how to use and record macros with the macro recorder in excel. The main website is : http://www.ExcelisHell.com
Difficulty:
Add/Subtract Months from a Date
Add/Subtract Months from a Date
Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets growand are reused.
Difficulty: