Quickly move around (or) jump to the end of a range
Excel Tip #003
Quickly move around (or) jump to the end of a range
Shortcut through keyboard
This is one of the shortcut that most of us would know. Hold down the CTRL key and press one of the arrow keys. This will move to that direction to the last cell until it encounters a blank cell.
Shortcut through mouse
Everyone has an assumption that shortcuts are meant to be handled by keyboard but this shortcut is actually easier than the keyboard shortcut.
Double-click the edge of the currently selected range in the direction you want to move. When you double-click an edge of a cell, the active cell will jump in that direction to the last cell until it encounters a blank cell.
Mouse shortcut to move to the end of a range of cells |
ADDITIONAL TIP
CTRL + HOME - This will activate (or) direct to the first cell in an excel sheet, A1
CTRL + END - This will take to the end of the used cell in an excel sheet.
There are range of values through B2 to H17. In cell H20, "Hello" has been typed and this is referred as the last used cell in the excel sheet.
Using the keys CTRL + END will take me to H20.
Even though we delete the data in cell H20, Excel refers H20 as the last used cell.
CTRL + END - This will take to the end of the used cell in an excel sheet.
There are range of values through B2 to H17. In cell H20, "Hello" has been typed and this is referred as the last used cell in the excel sheet.
Using the keys CTRL + END will take me to H20.
CTRL + END - Hello in H20 |
CTRL + END - Hello in H20 deleted |
Comments
Post a Comment