Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to shade every other row in Excel 2007 or Excel 2010
Article ID: 919194 - View products that this article applies to.
This article describes how to shade every other row in a Microsoft Office Excel 2007 or Microsoft Excel 2010 worksheet.
Note For information about how to do this in earlier versions of Microsoft Excel, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/268568/ )How to use conditional formatting to shade every other row in Excel
To shade every other row in an Excel 2007 or Excel 2010 worksheet, use one of the following methods.
Method 1: Use the "Format as Table" optionTo use the Format as Table option to shade rows in a worksheet, follow these steps:
Method 2: Use the "Conditional Formatting" optionTo use the Conditional Formatting option to shade rows in a worksheet, follow these steps: