Here are the steps to highlight every alternate row in Excel: This can easily be achieved using conditional formatting. Let’s say you want to highlight every second month (i.e., February, April and so on) in this data set. Suppose you have a dataset as shown below: Watch Video – How to Highlight Alternate (Every Other Row) in Excelīelow is the complete written tutorial, in case you prefer reading over watching a video.Ĭonditional Formatting in Excel can be a great ally in while working with spreadsheets.Ī trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |