We can use it to highlight (select) every other row in Excel. It is a very flexible tool and we can use it to highlight every other row in a data set. Highlight Every Other Row With Conditional FormattingĬonditional formatting alters the look of a cell based upon the value within it. You can also see from our example that the row selection exceeds the boundaries of our data which is also something you may not want to do. The downside to this technique is when you have large datasets and it becomes too laborious to select all the rows you want manually. You can very quickly select the rows you want to alter and then apply the change to all of them in one go. The advantage of this technique is it’s speed. To deselect a row, simply click on it again. You can also perform a non-contiguous selection on individual cells and columns. This sort of selection is referred to as a non-contiguous range. By holding down CTRL, we are able to select every other row or even a bunch of single cells. The simplest way to select every other row in Excel is to hold down down the CTRL button on your keyboard (⌘ on MAC) and then the number of the rows you want to select.Ĭlicking on the row number itself highlights the whole row. Using CTRL and Mouse Click To Select Every Other Row Use the contents table below to skip to each section. These 5 tips will improve your data manipulation skills. Here I show you 5 ways to select every other row in Excel.
Like many tasks in Excel, there is more than one way to achieve this.
CONDITIONAL FORMATTING EVERY OTHER ROW HIGHLIGHT EXCEL FOR MAC HOW TO
In this post I will show you how to select every other row in Excel.
0 kommentar(er)
