Quickly shade every other row/column in Excel 2007/2010

If a worksheet contains too many rows and columns, it will reduce the readability of the worksheet. To resolve this problem, you may apply coloring or shading to every other row or column by using a Conditional Formatting formula or a predefined Excel table style to your data in the worksheet. But no matter which way you choose to apply coloring or shading to alternate row, you cannot get it done easily and quickly. Nevertheless, with Alternate Row Shading tool of Kutools for Excel, you can quickly:

Apply coloring or shading to alternate row/column in a worksheet;
Apply coloring or shading to alternate row/column in a specified range;
Remove existing alternate row/column shading or coloring from a worksheet or specified range. Demo

Usage:

1. Specify a range before or after clicking “Kutools”>>” Alternate Row Shading”. See screenshots (Fig.1 and Fig.2).


Fig.1 Alternate Row Shading		Fig.2 Alternate Row/column Shading dialog box

2. Select the operation options (either Conditional Formatting, Standard Formatting or Remove existing alternate row shading).

3. Specify the related settings, and click “OK” to apply Alternate Row Shading. See screenshots (Fig.3 and Fig.4).


Fig.3 Apply Alternate Row Shading to this range		Fig.2 After Applying Alternate Row Shading

Notes:

Conditional Formatting: this option uses Excel's Conditional Formatting to apply shading to alternate row. The advantage of conditional formatting is that if you insert new rows within the range, the alternate row shading will be adjusted automatically.
Standard Formatting: this option use standard formatting to apply shading to alternate row. If you insert new rows within the range, the alternate row shading will not be adjusted automatically, and you have to reapply the alternate row shading manually.
You can press Undo (Ctrl+Z) immediately to restore it.

See Alternate Row Shading feature demo (video 1)

Video 1. Alternate Row Shading feature demo.