239
Excel
Keyboard
Shortcuts
WORK FASTER AND MORE EFFICIENTLY WITH THESE CLEARLY
ILLUSTRATED EXCEL SHORTCUTS.
My Online Training Hub
https://www.myonlinetraininghub.com/
,Below is a huge list of Excel keyboard shortcuts you can use to work faster. Scroll
through the list or use the Index to quickly go to the section you want.
How To Read The List
Where shortcut keys must be pressed together they will be shown like this
Ctrl + P
which means press CTRL and P together.
Where keys must be pressed one after the other they will be shown like this
Alt + H , A C
which means press Alt and H together, then release those keys and press A, then C.
Index
General Worksheet
Workbook Ribbon
Drag and Drop Navigation
Active Cell Selection
Extend Selection Select Special
Cell Edit Entering Data
Formatting Number Formatting
Borders Formulas
Rows and Columns Pivot Tables
Dialog Boxes
Further Resources
You can see a list of resources we provide including free training, a blog, a forum and
more.
, General Back To Index
Open help F1
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Copy selection Ctrl + C
Repeat last action F4
Cut selection Ctrl + X
Paste content from clipboard Ctrl + V
Display the Paste Special dialog box Ctrl + Alt + V
Display nd and replace with Find tab selected Ctrl + F
Display nd and replace with Replace tab selected Ctrl + H
Find previous match (after initial Find) Ctrl + Shift + F4
Find next match (after initial Find) Shift + F4
Insert embedded chart Alt + F1
Insert chart in new sheet F11
Toggle Auto lter Ctrl + Shift + L
Activate lter Alt + ↓
Create table Ctrl + T
Select table row Shift + Space
Select table column Ctrl + Space
Select table (when active cell is in table) Ctrl + A
Clear slicer lter Alt + C
Run Spellcheck F7
Excel
Keyboard
Shortcuts
WORK FASTER AND MORE EFFICIENTLY WITH THESE CLEARLY
ILLUSTRATED EXCEL SHORTCUTS.
My Online Training Hub
https://www.myonlinetraininghub.com/
,Below is a huge list of Excel keyboard shortcuts you can use to work faster. Scroll
through the list or use the Index to quickly go to the section you want.
How To Read The List
Where shortcut keys must be pressed together they will be shown like this
Ctrl + P
which means press CTRL and P together.
Where keys must be pressed one after the other they will be shown like this
Alt + H , A C
which means press Alt and H together, then release those keys and press A, then C.
Index
General Worksheet
Workbook Ribbon
Drag and Drop Navigation
Active Cell Selection
Extend Selection Select Special
Cell Edit Entering Data
Formatting Number Formatting
Borders Formulas
Rows and Columns Pivot Tables
Dialog Boxes
Further Resources
You can see a list of resources we provide including free training, a blog, a forum and
more.
, General Back To Index
Open help F1
Undo last action Ctrl + Z
Redo last action Ctrl + Y
Copy selection Ctrl + C
Repeat last action F4
Cut selection Ctrl + X
Paste content from clipboard Ctrl + V
Display the Paste Special dialog box Ctrl + Alt + V
Display nd and replace with Find tab selected Ctrl + F
Display nd and replace with Replace tab selected Ctrl + H
Find previous match (after initial Find) Ctrl + Shift + F4
Find next match (after initial Find) Shift + F4
Insert embedded chart Alt + F1
Insert chart in new sheet F11
Toggle Auto lter Ctrl + Shift + L
Activate lter Alt + ↓
Create table Ctrl + T
Select table row Shift + Space
Select table column Ctrl + Space
Select table (when active cell is in table) Ctrl + A
Clear slicer lter Alt + C
Run Spellcheck F7
