Inside Microsoft Office

Apply alternate row shading that updates automatically (2000/2002/2003/2010/2013)

Inside Microsoft Office

by Kara Hiltz

Worksheets often span hundreds or thousands of rows, which can wreak havoc on your eyes. Alternate row shading makes it easier to read large data tables, but if you manually shade rows, any changes you make to the data later will cause problems with your shading.

Here’s a quick way to apply row shading to every other row in your data using conditional formatting. Just follow these steps:

  1. Select the data range to which[…]

Subscribe to Inside Microsoft Office

(get full access to archives and more)