GENERAL SHORCUT KEYS IN MS EXCEL


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