GENERAL SHORCUT KEYS IN MS EXCEL
Open help : F1
Undo last action : Ctrl + Z
Redo last action : Ctrl + Y
Copy selection : Ctrl + C
Cut selection : Ctrl + X
Paste content from clipboard : Ctrl + V
Display the Paste Special dialog box : Ctrl + Alt + V
Display Find and replace with Find tab selected : Ctrl + F
Display Find 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 Filter : Ctrl + Shift + L
Activate Filter : 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 Filter : Alt + C
Run Spellcheck : F7
Open Thesaurus : Shift + F7
Open Macro dialog box : Alt + F8
Open VBA Editor: Alt + F11
Duplicate object : Ctrl + D
Snap to grid (whilst dragging) : Alt
Hide or show objects : Ctrl + 6
Open Modify Cell Style dialog box : Alt + '
Show right-click menu : Shift + F10
Display control menu : Alt Space
Comments
Post a Comment