Reading through massive amounts of data in Microsoft Excel can get extremely confusing. Ever been the type to hover your mouse over a row while dragging it to the side, just so you won’t get lost while looking through your spreadsheet?
Well, instead of having to put up a ruler on your screen, you can figure out how to highlight every other row in MS Excel instead.
Now, if you can excuse the random shopping list, the steps to highlight every other row in MS Excel are relatively simple.
How to Highlight Every Other Row in MS Excel
- Using a custom formula to highlight every other row
We’ll go over the detailed steps throughout the guide below, so you can finally arrange your Excel sheet better.
At the same time, we’ll go over formulas and conditional formatting if you’re interested in figuring that out.
You’ll find these sections at the end of the article. Furthermore, we’ll also teach you how you can completely remove or clear highlighted areas rows. Finally, you can do more than just highlight, but also format the font color, size, cell border, and so on.
All of this will be discussed below, so keep an eye and your Excel sheet ready!
If you’re feeling hesitant about doing this because you’re bad with formulas, don’t worry.
This guide was made with beginners in mind, so hopefully, the steps should be easy to follow.
Let’s get started!