Navigate your worksheets with ease
Learn to easily navigate your Excel worksheets with these straightforward keyboard shortcuts.
Move straight to the very top of your Excel worksheet by pressing Ctrl+Home.
Similarly, you can move to the very last cell (that contains or did contain data – far bottom right) within your Excel worksheet by pressing Ctrl+End.
There will be times when you want to navigate to other areas other than the very top or very bottom of your spreadsheet.
Pressing the Home key will take you to the first cell in the very left hand column of your worksheet. In most cases this will be column A. However, if you have “frozen panes” you will be taken to the first “unfrozen” column in your worksheet.
Pressing the End key on your keyboard, toggles END mode on or off in Excel. With END mode on and pressing an arrow key, you will navigate to the next nonblank cell in that direction. For example. if you are at cell C10 and press the End key and then the Up arrow, you will navigate to the top of the data in that column (assuming there are no blank cells in Column C).
Continue the Discussion
Continue the discussion and leave a comment below. How do you move around within Excel? Do you use keyboard shortcuts or do you use some other method for quickly navigating your worksheets?
Do you have a favourite productivity tip you would like to share? We would love to hear what it is and how you use it.
Please Share
If you liked this article or know someone who could benefit from this information, please feel free to share it with your friends and colleagues and spread the word on Facebook, Instagram, Twitter and/or Linkedin.
