In Excel, this is quick and simple to apply by formatting your data as a Table.

The row shading is then automatically applied to new rows added to the table.

Next, click the Format as Table button within the Home tab and then select the table style you want to use.

This will remove any current formatting before applying the table style.

Check that this range is correct, and change it if necessary.

You cannot directly edit the existing Excel table styles, but you can create your own or duplicate an existing style and edit that.

However, if you do not want this functionality, you can convert your table back to a range and still keep the alternate row shading.

But you can copy the formatting quickly using the Format Painter button, or a similar technique.

On most days, he can be found teaching Excel in a classroom or seminar.

Alan gets a buzz from helping people improve their productivity and working lives with Excel.

Since we launched in 2006, our articles have been read more than 1 billion times.

Shade Every Other Row In Excel For Mac