Table of contents
Key & Symbols
"
>
" represents keys pressed sequentially (from left to right)"
+
" represents keys pressed simultaneously
General
Context Menu
Fn + Shift + F10
Update All Data
Fn+ Ctrl + Alt + F5
Name Manager
Fn + Ctrl + F3
Ribbon
View shortcut navigation/selection keys
Press Alt
to view shortcut navigation/selection keys on the Excel ribbon
Hide/Unhide Ribbon
Fn + Ctrl + F1
"Full-page view"
Hide/Unhide ribbon, title bar, and status bar
Fn + Ctrl + Shift + F1
Macros
Open VBA Editor
Fn + Alt + F11
Exit VBA Editor
Alt + Q
Open Macro Dialog Box
Fn + Alt + F8
Hint: Each selection within macro dialog box has the keyboard shortcut to select it underlined; to select navigate to specific macro then for instance to select options for that macro Alt + O
; press Tab
to navigate through different elements/sections of a dialog box
Import Macro
Open VBA Editor
Fn + Alt + F11
Import file
Ctrl + M
Select macro to import
Group & Ungroup Columns/Rows
Select columns/rows to group then:
Group
Alt > D > G > G
or
Shift + Alt + Right Arrow
Ungroup
Shift + Alt + Right Arrow
Hide & Unhide Rows
Hide Rows
Navigate to row then:
Ctrl + 9
Unhide Row
Select rows immediately adjacent to the hidden row then:
Ctrl + Shift + (
Hide & Unhide Columns
Hide Columns
Navigate to row then:
Ctrl + 0
Unhide Columns
Select rows immediately adjacent to the hidden row then:
Ctrl + Shift + )
or
Alt > 0 > C > U
Copy, Paste, Insert, Replace
Paste Special (after copy)
Alt > E > S
Hint: Each selection within paste special dialog box has the keyboard shortcut to select it underlined
Paste Down
Select cell pasting
Extend selection to include where pasting it
Select All Down or Stepwise Select Down
Ctrl + D
Insert Copied Cells
Fn + Shift > F10 > E > Enter
Find and Replace
Alt > E > E
Selection & Navigation
Select All Cells of Certain Type (Go To Special)
Fn + F5
> Special
or
Ctrl + G
> Special
Entire Row
Shift + Space
Entire Column
Ctrl + Space
Select All Right
Ctrl + Shift + Right button
Select All Down
Ctrl + Shift + Down button
Select All Up
Ctrl + Shift + Up button
Stepwise Select Down
Shift + Down button
Select Multiple Data Regions
To select data region of adjacent cells without holding Shift
; press Fn + F8
when at starting cell of data region then select ending cell where you want to extend selection to
To select multiple data regions in addition to currently selected data region without using Ctrl
; press Fn + Shift + F8
then select additional data regions; to stop selection press Fn + Shift + F8
again then when another cell is selected prior selections will be deselected
Hint: when using Fn + Shift + F8
don't use Ctrl + A
to select data regions
Go To Top Left Cell
Ctrl + Home
Hint: If frozen panes then will take to top left cell within unfrozen region
Go To Last Cell with Data/Formatting
Ctrl + End
Formula & Functions
Insert Function
Alt > M > F
or
Fn + Shift + F3
Trace
Trace Precedents
Alt > M > P
Trace Dependents
Alt > M > D
Remove All Trace Arrows
Alt > M > A > A
Show All
Alt > M > H
Formatting
Format Cells
Ctrl + 1
Check Spelling In A Worksheet
Fn + F7
Repeat Most Recent Action
Fn + F4
Adjust Column Width
To value:
Alt > H > O > W
Autofit:
Alt > H > O > I
Adjust Row Height
To value:
Alt > H > O > H
Autofit:
Alt > H > O > A
Comments & Notes
Show All Comments
Alt > R > H > 1
Show All Notes
Alt > R > T > S
Create A Note
Fn + Shift+ F2
Sort & Filter
Sort
Select data then
Sort dialog box
Alt > A > S > S
Ascending order
Select data then
Alt > A > S > A
Descending order
Select data then
Alt > A > S > D
Filter
Select data then
Ctrl + Shift + L