How to Shade Every Other Row in Excel

In this tutorial, you will learn how to shade every other row in Excel.

Your worksheet’s data may be easier to scan if you use colour banding, which is the practise of adding a different colour to alternate rows or columns. You can rapidly apply a pre-made table format to format different rows or columns. When rows and columns are added using this technique, alternative row or column shading is automatically applied.

Once ready, we’ll get started by utilizing real-world examples to show you how to shade every other row in Excel.

Shade Every Other Row

Before we begin we will need a group of data to be used to shade every other row in Excel.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

To apply shades on alternate rows, simply select ‘Home’, then select ‘Format as Table’. Now you can select any style you like.

Step 3

Once you are done, your excel will look like this.


That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

In this tutorial, I covered how to shade every other row in Excel.