Excel 100 Shortcut keys
General
- 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 find 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 Autolter : 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 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
Worksheet
- Insert new worksheet : Shift + F11
- Go to next worksheet : Ctrl + PgDn
- Go to previous worksheet : Ctrl + PgUp
- Rename current worksheet : Alt + O , H R
- Delete current worksheet : Alt + E , L
- Move current worksheet : Alt + E , M
- Move between the worksheet, Ribbon, task pane, and zoom controls in a worksheet that has been split : F6 OR Shift + F6
- Select adjacent worksheets : Ctrl + Shift + PgUp/PgDn
- Select non-adjacent worksheets : Ctrl + Click
- Toggle scroll : lock ScrLk
- Toggle full screen : Ctrl + Shift + F1
- Print : Ctrl + P
- Open print preview window : Ctrl + F2
- Set print area : Alt + P , R S
- Clear print area : Alt + P , R C
- Zoom in : Ctrl + Mouse Wheel Up
- Zoom out : Ctrl + Mouse Wheel Down
- Protect sheet : Alt + R, P S
- Create new workbook : Ctrl + N
- Open workbook : Ctrl + O
- Save workbook : Ctrl + S
- Save as : F12
- Go to next workbook : Ctrl + Tab
- Go to previous workbook : Ctrl + Shift + Tab
- Minimize current workbook : window Ctrl + F9
- Maximize current workbook : window Ctrl + F10
- Protect workbook : Alt + R , P W
- Close current workbook : Ctrl + F4
- Close Excel : Alt + F4
Ribbon
- Expand or collapse ribbon : Ctrl + F1
- Activate access keys : Alt
- Move through Ribbon tabs and groups : → ← ↑ ↓
- Activate or open selected control : Space OR Enter
- Confirm control change : Enter
- Get help on selected control :F1
Drag and cut Drag
- Drag and copy: Ctrl + Drag
- Drag and insert : Shift + Drag
- Drag and insert copy : Ctrl + Shift + Drag
- Drag to worksheet : Alt + Drag
- Drag to duplicate worksheet : Ctrl + Drag
0 Comments