Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

Quickly shade or color every other row / column in Excel

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 / Column Shading utility of Kutools for Excel, you can quickly: Demo

Shade or color every other row

Shade or color every other column

Remove all conditional formatting shading and background color


arrow blue right bubble Click Kutools >> Format >> Alternate Row / Column Shading. See screenshots:

  arrow-big shot-shade-every-other-row2

arrow blue right bubble Shade or color every other row

1. Highlight the range that you want to shade or color, and then apply this utility by clicking Kutools > Format > Alternate Row/Column Shading.

3. In the Alternate Row / Column Shading dialog box, check Rows from the Apply shading to option. And specify other options. See screenshot:

A: 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.

Remove existing alternate shading: this option removes all conditional formatting and background shading.

B: Click the drop down arrow to select the color that you like.

C : Specify the number of rows that you want to shade, such as every other row, every two rows, every three rows…

D : If your selected range is filled with background color, and you don’t want to remove the background color after you apply this operation, please checked Leave existing color for non-shaded rows.

4. Then click OK. And the selected range has been shaded every other row. See screenshots:

shot-shade-every-other-row4
-1
shot-shade-every-other-row5

arrow blue right bubbleShade or color every other column

1. Select the range that you want to shade.

2. Go to the Alternate Row / Column Shading dialog box, check Columns from the Apply shading to option. And specify other options. See screenshot:

A: 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.

Remove existing alternate shading: this option removes all conditional formatting and background shading.

B : Click the drop down arrow to select the color that you like.

C : Specify the number of rows that you want to shade, such as every other column, every two columns, every three columns…

D : If your selected range is colored with background color, and you don’t want to remove the background color after you apply this operation, please check Leave existing color for non-shaded rows.

3. Then click OK. The selected range has been shaded every other column. See screenshots:

shot-shade-every-other-row7
-1
shot-shade-every-other-row8

arrow blue right bubbleRemove all conditional formatting shading and background color

With this utility you can also remove the conditional formatting shading and background color in Excel.

1. Select the range which contains conditional formatting or background color that you want to remove.

2. Go to the Alternate Row / Column Shading dialog box, select Remove existing alternate row shading option. Then click OK. See screenshots:

shot-shade-every-other-row9 arrow-big shot-shade-every-other-row10

3. If you click Yes, the conditional formatting and background color will be deleted; and if you click No, only the background color will be deleted.


arrow blue right bubbleNote:

You can press Undo (Ctrl+Z) immediately to restore it.


arrow blue right bubbleSee Alternate Row Shading feature demo (video 1)

Video 1. Alternate Row Shading feature demo.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.