![]() For example, if I enter some value in the cell E20 and then delete it, the used range in excel would be A1:E20 (as E20 is the last used cell in the memory of Excel). So if you have more data on the right of the column, using the above keyboard shortcut would not only select the existing column but also any data that Is to the right,Īnd sometimes, the used range would remain in the memory of Excel even if you have deleted that data. When you use Control + Shift + End, it starts the selection from the cell that you selected (B2 in our example), and extends the selection till the last cell in the used range. In most cases, the last cell in your column would also be the last used cell, so this keyboard shortcut should work perfectly in selecting the end of the data in the column.Īnd the great thing about this method is that you do not need to worry about blank cells, as it selects all the cells between the first selected cell and the last used cell. The above steps would start the selection from cell B2, and select all the cells till the last used cell. Here is another keyboard shortcut that you can use to select the end of the data in a column: Control + Shift + Endīelow are the steps to use this keyboard shortcut: Also read: Select Every Other Row in Excel Keyboard Shortcut to Select the End of the Column (CONTROL + SHIFT + End)īelow, I have a data set where I want to select all the expense values in column B. While the method would still work in such a scenario, it could take a few more seconds (which in my experience is not something most Excel users are willing to give). One scenario where this may not be the best method to use is when you have a lot of blank cells (say a blank cell in every other row or after every two or three rows). While this is not the most elegant solution, it gets the work done, and if you do not have a lot of blank cells in your column, it could be quite fast. Once you have reached the end of the column in the worksheet, press the up arrow key (while still holding the Control and the Shift key).Press the down arrow key, and keep it pressed.Select the first cell from which you want the selection to begin (cell B2 in our example).So we need to use the same keyboard shortcut a little differently.īelow are the steps to select till the end of the data in a column when you have blank cells in the column: ![]()
0 Comments
Leave a Reply. |