Shortcut Keys

This is a list of all the shortcut keys related to worksheets.

Shift + F9Smart Calculation. Calculates the Active / Selected worksheets in the Active workbook.
(only cells containing formulas that have changed since the last calculation, will be updated).
Alt + Page DownMoves you one screen of columns to the right
Alt + Page UpMoves you one screen of columns to the left
Alt + Shift + F1Inserts a new worksheet before the active worksheet.
Ctrl + 'Toggles between the Value layer and the Formula layer.
Ctrl + Down ArrowMoves to the last row in the current region
Ctrl + EndMoves to the Last Used Cell on the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + GDisplays the (Edit > GoTo) dialog box
Ctrl + HomeMoves to cell "A1" on the active worksheet
Ctrl + Page DownMoves to the Next Worksheet in the active workbook.
Ctrl + Page UpMoves to the Previous Worksheet in the active workbook.
Ctrl + Shift + EndExtends the selection to the last used cell on the worksheet.
Ctrl + Shift + Page DownSelects the active worksheet and the one after it.
Ctrl + Shift + Page UpSelects the active worksheet and the one before it.
Ctrl + Shift + F1Toggles full screen.
Ctrl + Up ArrowMoves to the first row in the current region
Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
EnterMoves to the cell below
HomeMoves to column "A" in the current row
Page DownMoves down one screen
Page UpMoves up one screen
Shift + F11Inserts a new worksheet before the active worksheet.
Shift + TabMoves to the previous cell on the left
TabMoves to the next cell on the right
Alt + E, LDeletes the current worksheet.
Alt + E, MDisplays the Move or Copy dialog box.
Alt + H, D, SDeletes the active worksheet, with no prompt
Alt + O, H, RRenames the current worksheet.
Alt + W, F, FToggles freeze panes on the active worksheet.
Alt + W, LSwitches the view to Normal View.
Alt + W, PSwitches the view to Page Layout View.
Shift + F9
Smart Calculation. Calculates the Active / Selected worksheets in the Active workbook.
(only cells containing formulas that have changed since the last calculation, will be updated).
Alt + Page Down
Moves you one screen of columns to the right
Alt + Page Up
Moves you one screen of columns to the left
Alt + Shift + F1
Inserts a new worksheet before the active worksheet.
Ctrl + '
Toggles between the Value layer and the Formula layer.
Ctrl + Down Arrow
Moves to the last row in the current region
Ctrl + End
Moves to the Last Used Cell on the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + G
Displays the (Edit > GoTo) dialog box
Ctrl + Home
Moves to cell "A1" on the active worksheet
Ctrl + Page Down
Moves to the Next Worksheet in the active workbook.
Ctrl + Page Up
Moves to the Previous Worksheet in the active workbook.
Ctrl + Shift + End
Extends the selection to the last used cell on the worksheet.
Ctrl + Shift + Page Down
Selects the active worksheet and the one after it.
Ctrl + Shift + Page Up
Selects the active worksheet and the one before it.
Ctrl + Shift + F1
Toggles full screen.
Ctrl + Up Arrow
Moves to the first row in the current region
Ctrl + Backspace
Selects the current active cell (scrolling if necessary).
Enter
Moves to the cell below
Home
Moves to column "A" in the current row
Page Down
Moves down one screen
Page Up
Moves up one screen
Shift + F11
Inserts a new worksheet before the active worksheet.
Shift + Tab
Moves to the previous cell on the left
Tab
Moves to the next cell on the right
Alt + E, L
Deletes the current worksheet.
Alt + E, M
Displays the Move or Copy dialog box.
Alt + H, D, S
Deletes the active worksheet, with no prompt
Alt + O, H, R
Renames the current worksheet.
Alt + W, F, F
Toggles freeze panes on the active worksheet.
Alt + W, L
Switches the view to Normal View.
Alt + W, P
Switches the view to Page Layout View.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext