Microsoft KB Archive/919194

= How to shade every other row in an Excel 2007 worksheet =

Article ID: 919194

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



INTRODUCTION
This article describes how to shade every other row in a Microsoft Office Excel 2007 worksheet.



MORE INFORMATION
To shade every other row in an Excel 2007 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.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbhowto kbinfo kbformat kbexpertisebeginner KB919194

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.