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

1. Open VBA Editor Fn + Alt + F11

2. Import file Ctrl + M

3. 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

1. Select cell pasting

2. Extend selection to include where pasting it

3. Select All Down or Stepwise Select Down

4. 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

References

Keyboard shortcuts in Excel