Navigation Shortcuts

Once a worksheet gets more data in it than you can see without scrolling (almost immediately!), you need ways of getting around quickly. Here are some more CTRL key combinations for getting around.

• CTRL plus an Arrow Key (←↑→↓) jumps in that direction to the first non-empty cell if the current cell is empty, or the last non-empty cell if the current cell is not empty.
  
• CTRL plus Home key jumps to cell A1 or the top-left cell in the active pane if Freeze Panes is on.
  
• CTRL plus End jumps to the cell in the last row with data, and in the last column with data (that cell may itself be empty); sometimes the pointers get stuck, and you have to save the workbook to reset them.

These are included in the lists at these links (repeated from the prior post):
One of the free offerings at ASAP Utilities is their list of a great many keyboard shortcuts.

And of course Microsoft publishes this list of all possible shortcuts, including ALT sequences for accessing all menu items.