How to Shade Every Other Row in Microsoft Excel

0
436
highlight every other row in excel

How to Shade Every Other Row in Microsoft Excel

In many cases, you need to select or shade various rows in MS Excel and it does not seem very easy. Here, we will discuss about “How to Shade Every Other Row in Microsoft Excel.”

There are various pre-formatted color schemes that can be used or you can just try shading colors to every alternating line.

See Also: How To Restore Your Kindle If It Experiences A Critical Battery Error

It gives a quite natural, smooth and professional look. It can be done using the built-in tools of Ms. Excel.

Step 1: Open Blank Excel workbook:

How to Shade Every Other Row in Microsoft Excel

Step 2: Highlight the particular area:

All you need to do is to highlight the area, which you want to shade. Try highlighting the columns as shown below.

How to Shade Every Other Row in Microsoft Excel

Step 3: Click Conditional Formatting:

Just head to Home tab and then click Conditional formatting for viewing different options for shading.

How to Shade Every Other Row in Microsoft Excel

Step 4: Select the New Rule:

How to Shade Every Other Row in Microsoft Excel

Step 5: In the Format Style drop-down, choose Classic.  <classic.png>:

Step 6: Select Use a formula to determine which cells to format:

How to Shade Every Other Row in Microsoft Excel

Step 7: Enter Formula:

After selecting the Use a Formula option in the above step, just try entering the following formula into the appropriate area: =MOD(ROW(),2)=1

How to Shade Every Other Row in Microsoft Excel

Step 8: Tap Format:

How to Shade Every Other Row in Microsoft Excel

Step 9: Go To Fill tab and select the desired color:

How to Shade Every Other Row in Microsoft Excel

Step 10: Click OK:

excel highlight every other row

Step 11: Click OK once more to apply the formatting:

shade rows in excel

LEAVE A REPLY

Please enter your comment!
Please enter your name here