![]() 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. In this post I will show you how to select every other row in Excel.
0 Comments
Leave a Reply. |