200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

General Cell Control – Microsoft Excel Shortcuts

General Cell Control

The data and text you input into Excel can do much more than act as placeholders within cells. Shortcuts in this section will expand your capabilities of cell control far beyond what your mouse is capable of. You will be able to do everything from locating cell matches to creating tables.

Open general help
F1
⌘ /
Undo previous action
Ctrl Z
⌘ Z
Redo previous action
Ctrl Y
⌘ Y
Copy selected cells
Ctrl C
⌘ C
Paste clipboard content
Ctrl V
⌘ V
Cut cell
Ctrl X
⌘ X
Repeat previous action
F4
⌘ Y
Display "paste special" box
Ctrl Alt V
⌘ Option V
Display find feature
Ctrl F
⌘ F
Display find and replace feature
Ctrl H
Control H
Locate previous match
Ctrl Shift F4
⌘ Shift G
Locate next match
Shift F4
⌘ G
Create an embedded chart
Alt F1
Fn Option F1
Create a chart in separate spreadsheet
F11
Fn F11
Toggle the auto filter
Ctrl Shift L
⌘ Shift F
Begin filter
Alt Down
Control Down
Insert table
Ctrl T
Control T
Select table row
Shift Space
Shift Space
Select table column
Ctrl Space
Control Space
Select table
Ctrl A
⌘ A
Snap to selected grid
Alt
⌘
Hide or show table or other objects
Ctrl A
⌘ A