Article ID: 919194 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

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:
268568 How to use conditional formatting to shade every other row in Excel

MORE INFORMATION

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" option

To use the Format as Table option to shade rows in a worksheet, follow these steps:
  1. Open the worksheet.
  2. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet.
  3. Click the Home tab.
  4. In the Styles group, click Format as Table, and then click the style of formatting that you want.
  5. In the Format as Table dialog box, click OK.

Method 2: Use the "Conditional Formatting" option

To use the Conditional Formatting option to shade rows in a worksheet, follow these steps:
  1. Open the worksheet.
  2. Select the cell range that you want to shade, or press Ctrl+A to select the whole worksheet.
  3. Click the Home tab.
  4. In the Styles group, click Conditional Formatting, and then click Manage Rules.
  5. Click New rule.
  6. Click Use a formula to determine which cells to format.
  7. In the Format values where this formula is true box, type =MOD(ROW(),2)=1, and then click Format.
  8. On the Fill tab, click the color that you want to use to shade every other row, and then click OK.
  9. Click OK to close the New Formatting Rule dialog box.
  10. Click Apply, and then click OK to close the Conditional Formatting Rules Manager dialog box.

Properties

Article ID: 919194 - Last Review: June 26, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
Keywords: 
kbinfo kbformat kbexpertisebeginner kbhowto KB919194

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com