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 + Up ArrowMoves to the first row in the current region.
Ctrl + Down ArrowMoves to the last row in the current region.
Ctrl + BackspaceSelects the current active cell (scrolling if necessary).
Ctrl + HomeMoves to cell "A1" on the active worksheet.
Ctrl + EndMoves to the Last Used Cell on the active worksheet. This cell is only updated when the workbook is closed.
Ctrl + GDisplays the GoTo dialog box.
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.
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, L(Compatibility) Deletes the current worksheet.
Alt + E, MDisplays the Move or Copy dialog box.
Alt + H, D, SDeletes the active worksheet, with no prompt.
Alt + I, WInserts a New Worksheet before the active worksheet.
Alt + O, H, RRenames the current worksheet.
Alt + O, H, UDisplays the Unhide dialog box.
Alt + W, F, FToggles freeze panes on the active worksheet.
Alt + W, LSwitches the view to Normal View.
Alt + W, JChanges the Zoom of the active worksheet to 100%.
Alt + W, PSwitches the view to Page Layout View.
Alt + W, V, GToggle the display the Gridlines on the active worksheet.
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 + Up Arrow
Moves to the first row in the current region.
Ctrl + Down Arrow
Moves to the last row in the current region.
Ctrl + Backspace
Selects the current active cell (scrolling if necessary).
Ctrl + Home
Moves to cell "A1" on the active worksheet.
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 GoTo dialog box.
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.
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
(Compatibility) 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 + I, W
Inserts a New Worksheet before the active worksheet.
Alt + O, H, R
Renames the current worksheet.
Alt + O, H, U
Displays the Unhide dialog box.
Alt + W, F, F
Toggles freeze panes on the active worksheet.
Alt + W, L
Switches the view to Normal View.
Alt + W, J
Changes the Zoom of the active worksheet to 100%.
Alt + W, P
Switches the view to Page Layout View.
Alt + W, V, G
Toggle the display the Gridlines on the active worksheet.

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