How To Shade Every Other Row In Excel

Shading every other row in Excel can make your data more visually appealing and easier to read. This simple formatting technique is one of my favorite tricks to make my spreadsheets look polished and professional. Let me guide you through the process of adding this stylish touch to your own Excel sheets.

Step 1: Selecting the Range

To shade every other row, start by selecting the range of cells where you want the shading to appear. I usually begin by clicking and dragging to select the entire table or data set. It’s important to choose the correct range so that the shading applies to the desired rows.

Step 2: Open the Conditional Formatting Menu

Once the range is selected, I navigate to the “Home” tab in the Excel ribbon. From there, I click on “Conditional Formatting” in the “Styles” group to open the dropdown menu.

Step 3: Choose New Rule

In the Conditional Formatting dropdown menu, I select “New Rule” to open the New Formatting Rule dialog box. This is where the magic happens!

Step 4: Select Use a Formula to Determine Which Cells to Format

In the New Formatting Rule dialog box, I choose the option that says “Use a formula to determine which cells to format.” This allows me to input the specific formula that will determine which rows to shade.

Step 5: Enter the Formula

Here’s the moment of truth! I input the formula that will determine the shading. In the “Format values where this formula is true” field, I enter the formula =MOD(ROW(),2)=0. This formula checks if the row number is even and applies the formatting accordingly.

Step 6: Choose the Formatting Style

After entering the formula, I click on the “Format” button in the New Formatting Rule dialog box to choose the desired formatting style. I usually opt for a light gray fill color to distinguish the shaded rows.

Step 7: Apply and Enjoy!

With the formula and formatting style set, I click “OK” to exit the New Formatting Rule dialog box. Back in the Conditional Formatting menu, I can see a preview of the applied rule. I click “OK” again to finalize the formatting, and voila! Every other row in the selected range is now beautifully shaded.


Shading every other row in Excel is a simple yet effective way to enhance the readability and visual appeal of your spreadsheets. By following these steps, you can give your data a professional look that’s easy on the eyes. Whether it’s for work, school, or personal use, this formatting technique is a game-changer for anyone who works with Excel regularly.