Shortcut Keys

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

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.

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.