Every Other Row Shaded Excel

4 In the Shade every. When you create a table in Excel for the web by default every other row in the table is shaded. Select the range of cells that you want to format. This video shows you how to automatically apply shading to every nth row in a worksheet.

Shade Alternate Rows In Excel Easy Excel Tutorial

3 Specify the color you want to use from the Shade color drop-down list.

Every other row shaded excel. The automatic banding continues if you add or delete rows in the table. In this case lets select all the cells in the spreadsheet by clicking on the Select all icon or by pressing Ctrl A in your keyboard. Click Home Format as Table.

Select any cell in the table. A trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set. You can apply the shading by using a simple conditional formatting f.

To begin the row shading with the first row instead of the second row at the end of the formula change 0 to 1. 2 Choose the Conditional formatting option in the Shading method section. Along with other benefits of tables such as automatic filtering color banding is applied to rows by default.

And it is as EASY as PIE. Conditional Formatting in Excel can be a great ally in while working with spreadsheets. To shade every third or fourth row instead of alternate rows change the 2 in the formula to 3 or 4.

How To Shade Every Other Row In Excel 2013 Youtube