Access Keyboard Shortcuts

Navigating Through a Worksheet

Key(s)

Function
Arrow Keys Move left, right, up, down one cell
Home Moves to the beginning of the row
PgUp Moves up one screen
Ctrl + PgUp Moves to the previous sheet
PdDn Moves down one screen
Ctrl + PgDn Moves to the next sheet
Alt + PgUp Moves one screen to the left
Alt + PgDn Moves one screen to the right
Ctrl + Home Moves to the first cell in the worksheet (A1)
Ctrl + End Moves to the last active cell of the worksheet
Ctrl + Backspace Scrolls to display the active cell
End + Home Moves to the last nonempty cell on the worksheet
F5 Prompts for a cell address to go to
F6 Moves to the next pane of a workbook that has been split
Shift + F6 Moves to the previous pane of a workbook that has been split
Ctrl + Tab Moves to the next window
Ctrl + Shift + Tab Moves to the previous window

Formatting Keys

Key(s)

Function
Ctrl + 1 Format [Selected Object]
Ctrl + B Makes text bold
Ctrl + I Makes text italicized
Ctrl + U Makes text underlined
Ctrl + 5 Makes text with strikethrough
Ctrl + Shift + ~ Applies general number format
Ctrl + Shift + ! Applies the comma format with 2 decimals
Ctrl + Shift + # Applies the date format (day, month, year)
Ctrl + Shift + @ Applies the time format (hour, minute, a.m./p.m.)
Ctrl + Shift + $ Applies the currency format with 2 decimal places
Ctrl + Shift + % Applies the precent format with no decimal places
Ctrl + Shift + & Applies border to outline of cell
Ctrl + Shift + _ Removes all borders

Other Shortcuts

Key(s)

Function
Alt + = Inserts the AutoSum formula
Alt + Backspace Initiates Undo
Alt + Enter Selects a new line in the current cell
Ctrl + ; Inserts the current date
Ctrl + 0 (zero) Hides columns
Ctrl + C Selects Edit Copy
Ctrl + Delete Selects Edit Cut
Ctrl + F Selects Edit Find
Ctrl + H Selects Edit Replace
Ctrl + Insert Selects Edit Copy
Ctrl + K Inserts Hyperlink
Ctrl + N Selects File New
Ctrl + O Selects File Open
Ctrl + P Selects File Print
Ctrl + S Selects File Save
Ctrl + Shift + : Inserts current time
Ctrl + V Selects Edit Paste
Ctrl + X Selects Edit Cut
Ctrl + Z Selects Edit Undo
Delete Selects Edit Clear
Shift + Insert Selects Edit Paste