Table of contents
Key & Symbols
">" represents keys pressed sequentially (from left to right)
"+" represents keys pressed simultaneously
General
Ribbon
View shortcut navigation/selection keys
Press Alt to view shortcut navigation/selection keys on the Excel ribbon.
Hide/Unhide Ribbon
Ctrl + f1
"Full-page view"
Hide/Unhide ribbon, title bar, and status bar
Ctrl + Shift + f1
Context Menu
Shift + fn + f10
Update All Data
Ctrl + Alt + f5
Name Manager
Ctrl + f3
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
Find and Replace
Alt > E > E
Copy Paste
Paste Special (after copy)
Alt > E > S
Paste Down
Select cell pasting
Extend selection to include where pasting it
- Select All Down or Stepwise Select Down
Ctrl + D
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
With a data region selected to select another data region, use Shift + f8
Hint: when using Shift + f8 don't use Ctrl + A to select data regions
Go To Top Left Cell
Alt + W + N
Formula
Trace
Trace Precedents
Alt > M > P
Trace Dependents
Alt > M > D
Remove All Trace Arrows
Alt > M > A > A
Show All
Alt > M > H
Format
Format Cells
Ctrl + 1
Check Spelling In A Worksheet
fn + f7
Comments & Notes
Show All Comments
Alt > R > H > 1
Show All Notes
Alt > R > T > S
Create A Note
Shift + fn + f2
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