Using the Ctrl key and an arrow key, you can quickly navigate to the last populated cell in any direction. Thus, Ctrl + Right Arrow brings you to the last populated cell on the right side of your page, Ctrl + Down Arrow brings you to the last cell with data in the worksheet, etc. This is much faster than pressing the Page Down key to find the last row of data in your worksheet.
Additionally, if you press the Ctrl + Arrow + Shift keystroke combination, Excel will select all of the data between the active cell and the end of the range, as determined by which arrow key you press.
Similar Posts:
- Shortcut Keys in Excel
- Insert AutoSum using Keystrokes in Excel
- Creating a Refreshable Web Query in Excel
- Quickly Rearrange rows in a Word Table
- Using Excel 2007’s Extend Mode to Select Cells
- Apply Heading Styles in Word using the Keyboard
- Enter data in multiple cells in Excel 2007
