How to highlight alternate rows in MS Excel

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!


Read moreHow to highlight alternate rows in MS Excel

How to Wrap Text in MS Excel

Learning how to wrap text in Excel is a great way to format text in a cell, so it doesn’t take up your entire window. It’s one of those subtle quirks from Excel that affect how your data is displayed. Having a clear view of your dataset on Excel improves readability, efficiency, and helps reduce errors.

There are a few ways to go about text wrapping cells in Excel. 

2 Ways to Wrap Text In Excel

  • Wrapping Text automatically through a format setting
  • Manually adding a line break at each cell

We will cover both methods and guide you through the step-by-step instructions below. Along the way, we will also answer questions you may have so we can clear any confusion regarding how you can do this.

This article was written with beginners in mind, so you don’t need to know any technical knowledge before proceeding with this tutorial.

Let’s get started.

Read moreHow to Wrap Text in MS Excel