14 Keyboard Shortcuts for Moving the Cell Cursor in Excel - dummies

14 Keyboard Shortcuts for Moving the Cell Cursor in Excel

By Faithe Wempen

Part of Digital Literacy For Dummies Cheat Sheet

Anyone who works with Excel spreadsheets knows that they can become extremely long and complex. Here are some keyboard tricks for getting around in a spreadsheet quickly and easily.

Press This To Move . . .
Arrow keys One cell in the direction of the arrow
Tab One cell to the right
Shift+Tab One cell to the left
Ctrl+arrow key To the edge of the current data region (the first or last cell that isn’t empty) in the direction of the arrow
End To the cell in the lower-right corner of the window*
Ctrl+End To the last cell in the worksheet, in the lowest used row of the rightmost used column
Home To the beginning of the row containing the active cell
Ctrl+Home To the beginning of the worksheet (cell A1)
Page Down One screen down
Alt+Page Down One screen to the right
Ctrl+Page Down To the next sheet in the workbook
Page Up One screen up
Alt+Page Up One screen to the left
Ctrl+Page Up To the previous sheet in the workbook