Useful keyboard shortcuts in Excel

Excel shortcuts

As we’re talking Excel shortcuts, I’ll keep this tip very short!

As your spreadsheet increases in size, you’ll want to find quick ways to move around it without needing to use the scroll buttons (especially with the latest versions having 1,048,576 rows and 16,384 columns!), so here are a few that I regularly use. To be fair, there are lots & lots of them; here’s a full list from the lovely people at Microsoft Microsoft Excel Shortcuts But to be honest, who can remember all of those & by the time that you’ve looked them up, you’ve done it the “slow way”… so work with a smaller number of really useful ones…

To do thisPress
  • Move one cell up in a worksheet.
  • Up Arrow key
  • Move one cell down in a worksheet.
  • Down Arrow key
  • Move one cell left in a worksheet.
  • Left Arrow key
  • Move one cell right in a worksheet.
  • Right Arrow key
  • Move to the edge of the current data region in a worksheet.
  • Ctrl+arrow key
  • Move to the next nonblank cell in the same column or row as the active cell. (If the cells are blank, this will move the cursor to the last cell in the row or column).
  • End, arrow key
  • Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.
  • Ctrl+End
  • Extend the selection of cells to the last used cell on the worksheet (lower-right corner).
  • Ctrl+Shift+End
  • Move to the beginning of a worksheet.
  • Ctrl+Home
  • Move one screen down in a worksheet.
  • Page Down
  • Move to the next sheet in a workbook.
  • Ctrl+Page Down
  • Move one screen to the right in a worksheet.
  • Alt+Page Down
  • Move one screen up in a worksheet.
  • Page Up
  • Move one screen to the left in a worksheet.
  • Alt+Page Up
  • Move to the previous sheet in a workbook.
  • Ctrl+Page Up
  • Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells.
  • Tab