Shortcut Keys

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

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 + 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 + F9Calculates the active worksheet.
Shift + TabMoves to the previous cell on the left
TabMoves to the next cell on the right
Alt + H, D, SDeletes the active worksheet, with no prompt
Alt + W, F, FToggles freeze panes on the active worksheet.

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