1
General
29
 |
 Shortcut Key |
 Description |
|---|---|---|
| 1 | F1 | Open Help |
| 2 | Ctrl+Z | Undo last action |
| 3 | Ctrl+Y | Redo last action |
| 4 | Ctrl+C | Copy Slection |
| 5 | F4 | Repeat last action |
| 6 | Ctrl+X | Cut Selection |
| 5 | Ctrl+V | Paste content from clipboard |
| 6 | Ctrl+Alt+V | Display the paste special dialog box |
| 7 | Ctrl+F | Display find and replace with Find tab selected |
| 8 | Ctrl+H | Display find and replace with Replace tab selected |
| 9 | Ctrl+Shift+F4 | Find previous match (after initial Find ) |
| 10 | Shift+F4 | Find next match(after intial find) |
| 11 | Alt+F1 | Insert embedded chart |
| 12 | F11 | Insert chart in new sheet |
| 13 | Ctrl+Shift+L | Toggle Autofilter |
| 14 | Alt+↓ | Activate filter |
| 15 | Ctrl+T | Create table |
| 16 | Shift+Space | Select table row |
| 17 | Ctrl+Space | Select table column |
| 18 | Ctrl+A | Select table (when active cell in table) |
| 19 | Alt+C | Clear slicer filter |
| 20 | F7 | Run spellcheck |
| 21 | Shift+F7 | Open Thesaurus |
| 22 | Alt+F8 | Open Macro dialog box |
| 23 | Alt+F11 | Open VBA Editor |
| 24 | Ctrl+D | Duplicate object |
| 25 | Alt | Snap to grid (whilst dragging) |
| 26 | Ctrl+G | Hide or show objects |
| 27 | Alt+' | Open Modify Cell Style dialog box |
| 28 | Shift+F10 | Show right-click menu |
| 29 | Alt+Space | Display control menu |
2
Worksheet
18
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Shift+F11 | Insert new worksheet |
| 2 | Ctrl+PgDn | Go to next worksheet |
| 3 | Ctrl+PgUp | Go to previous worksheet |
| 4 | Alt+O , H R | Rename current worksheet |
| 5 | Alt+E , L | Delete current worksheet |
| 6 | Alt+E , M | Move current worksheet |
| 7 | F6 or Shift+F6 | Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split |
| 8 | Ctrl+Shift+PgUp / PgDn | Select adjacent worksheets |
| 9 | Ctrl+Click | Select non-adjacent worksheets |
| 10 | Scrlk | Toggle scroll lock |
| 11 | Ctrl+Shift+F1 | Toggle full screen |
| 12 | Ctrl+P | |
| 13 | Ctrl+F2 | Open print preview window |
| 14 | Alt+P , RS | Set print area |
| 15 | Alt+P , RC | Clear print area |
| 16 | Ctrl+Mouse Wheel Up | Zoom in |
| 17 | Ctrl+Mouse Wheel Down | Zoom out |
| 18 | Alt+R , PS | Protect sheet |
3
Rows & Columns
15
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl++ | Display Insert Dialog box |
| 2 | Ctrl++ | Insert selected number of rows |
| 3 | Ctrl++ | Insert selected number of columns |
| 4 | Ctrl+- | Display Delete dialog box |
| 5 | Ctrl+- | Delete selected number of rows |
| 6 | Delete | Delete contents of selected cells |
| 7 | Ctrl+0 | Hide columns |
| 8 | Ctrl+9 | Hide rows |
| 9 | Ctrl+Shift+9 | Unhide rows |
| 10 | Alt+Shift+→ | Group rows or columns |
| 11 | Alt+Shift+← | Ungroup rows or columns |
| 12 | Alt+Shift+→ | Open Group Dialog Box |
| 13 | Alt+Shift+← | Open Ungroup Dialog Box |
| 14 | Ctrl+B | Hide or show outline symbols |
| 15 | Ctrl+- | Delete selected number of columns |
4
Workbook
11
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+N | Create new workbook |
| 2 | Ctrl+O | Open workbook |
| 3 | Ctrl+S | Save Workbook |
| 4 | F12 | Save as |
| 5 | Ctrl+Tab | Go to next workbook |
| 6 | Ctrl+F9 | Minimize current workbook window |
| 7 | Ctrl+F10 | Maximize current workbook window |
| 8 | Alt+R , PW | Protect workbook |
| 9 | Ctrl+F4 | Close current workbook |
| 10 | Alt+F4 | Close Excel |
| 11 | Ctrl+Shift+Tab | Go to previous workbook |
5
Ribbon
6
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+F1 | Expand or collapse ribbon |
| 2 | Alt | Active access keys |
| 3 | →←↑↓ | Move through Ribbon tabs and groups |
| 4 | Space or Enter | Activate or open selected control |
| 5 | Enter | Confirm control change |
| 6 | F1 | Get help on selected control |
6
Drag & Drop
6
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Drag | Drag and cut |
| 2 | Ctrl+Drag | Drag and copy |
| 3 | Shift+Drag | Drag and insert |
| 4 | Ctrl+Shift+Drag | Drag and insert copy |
| 5 | Alt+Drag | Drag to worksheet |
| 6 | Ctrl+Drag | Drag to duplicate worksheet |
7
Navigation
16
|
Shortcut Key |
Description |
|---|---|---|
| 1 | → | Move one cell right |
| 2 | ← | Move one cell left |
| 3 | ↑ | Move one cell up |
| 4 | ↓ | Move one cell down |
| 5 | Alt+PgDn | Move one Screen right |
| 6 | Alt+PgUp | Move one Screen left |
| 7 | PgUp | Move one Screen up |
| 8 | PgDn | Move one Screen down |
| 9 | Ctrl+→ | Move to right edge of data region |
| 10 | Ctrl+← | Move to left edge of data region |
| 11 | Ctrl+↑ | Move to top edge of data region |
| 12 | Ctrl+↓ | Move to bottom edge of data region |
| 13 | Home | Move to beginning of row |
| 14 | Ctrl+End | Move to last cell in worksheet that contains data |
| 15 | Ctrl+Home | Move to first cell in worksheet |
| 16 | End | Turn End mode on |
8
Extend Selection
16
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Shift+→ | Extend selection right |
| 2 | Shift+← | Extend selection left |
| 3 | Shift+↑ | Extend selection up |
| 4 | Shift+↓ | Extend selection down |
| 5 | Ctrl+Shift+→ | Extend the selection to the last cell on the right that contains data, or to the next cell that contains data,or to the last column |
| 6 | Ctrl+Shift+← | Extend the selection to the last cell on the left that contains data, or to the next cell that contains data, or to the first column |
| 7 | Ctrl+Shift+↑ | Extend the selection to the last cell up that contains data, or to the next cell that contains data, or to the first row |
| 8 | Ctrl+Shift+↓ | Extend the selection to the last cell down that contains data, or to the next cell that contains data, or to the last row |
| 9 | Shift+PgUp | Extend selection up one screen |
| 10 | Shift+PgDn | Extend the selection down one screen |
| 11 | Alt+Shift+PgDn | Extend the selection right one screen |
| 12 | Alt+Shift+PgUp | Extend the selection left one screen |
| 13 | Shift+Home | Extend the selection to start of rows |
| 13 | Ctrl+Shift+Home | Extend the selection to first cell in worksheet |
| 14 | Ctrl+Shift+End | Extend the selection to last cell in worksheet |
| 15 | F8 | Toggle 'Extend Selection' mode |
| 16 | Esc | Cancel 'Extend Selection' mode |
9
Active Cell
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Shift+Backspace | Select active cell (when multiple cells already selected) |
| 2 | Ctrl+Backspace | Show the active cell on worksheet |
| 3 | Ctrl+. | Move active cell clockwise to corners of selection |
| 4 | Enter | Move active cell down in seleciton-wrap to next column |
| 5 | Shift+Enter | Move active cell up in selection-wrap to previous column |
| 6 | Tab | Move active cell right in a selection-wrap to next row |
| 7 | Shift+Tab | Move active cell left in a selection-wrap to Previous row |
10
Selection
9
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Shift+Space | Select entire row |
| 2 | Ctrl+Space | Select entire Column |
| 3 | Ctrl+A | Select current region if worksheet contains data. Press again to select current region and summary rows. Press again to select entire worksheet. |
| 4 | Shift+Click | Expand selction |
| 5 | Ctrl+Click | Add non-adjacent cells to selection |
| 6 | Ctrl+Alt+→ | Move right between non-adjacent selections |
| 7 | Ctrl+Alt+← | Move left between non-adjacent selections |
| 8 | Shift+F8 | Toggle 'Add to selection' mode |
| 9 | Esc | Exit 'Add to Selection' mode |
11
Select Special
9
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+G or F5 | Display 'Go To' dialog box |
| 2 | Ctrl+Shift+O | Select cells with comments |
| 3 | Ctrl+Shift+* | Select current region around active cell |
| 4 | Ctrl+A | Select current region |
| 5 | Ctrl+[ | Select direct precedents |
| 6 | Ctrl+Shift+[ | Select all precedents |
| 7 | Ctrl+] | Select direct dependents |
| 8 | Ctrl+Shift+] | Select all dependents |
| 9 | Alt+; | Select visible cells only |
12
Borders
8
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Alt+H , B | Open list of border styles from Ribbon |
| 2 | Ctrl+Shift+& | Add border around selected cells |
| 3 | Alt+H , BR | Add or remove right border |
| 4 | Alt+H , BL | Add or remove left border |
| 5 | Alt+H , BP | Add or remove top border |
| 6 | Alt+H , B0 | Add or remove bottom border |
| 7 | Alt+H , BA | Add all borders to all cells in selection |
| 8 | Ctrl+Shift+- | Remove borders |
13
Cell Edit Mode
16
|
Shortcut Key |
Description |
|---|---|---|
| 1 | F2 | Edit the active cell |
| 2 | Shift+F2 | Insert or edit comment |
| 3 | Shift+F10 , M | Delete comment |
| 4 | Esc | Cancel editing |
| 5 | Shift+→ | Select one character right |
| 6 | Shift+← | Select one character left |
| 7 | Ctrl+→ | Move one word right |
| 8 | Ctrl+← | Move one word left |
| 9 | Ctrl+Shift+→ | Select one word right |
| 10 | Ctrl+Shift+← | Select one word left |
| 11 | Shift+Home | Select to begining of cell |
| 12 | Shift+End | Select to end of cell |
| 13 | Ctrl+Delete | Delete to end of a line |
| 14 | Backspace | Delete character to the left cursor |
| 15 | Delete | Delete character to right of cursor |
| 16 | Alt+Enter | Start a new line in the same cell |
14
Entering Data
16
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Enter | Enter data and move down |
| 2 | Shift+Enter | Enter data and move up |
| 3 | Tab | Enter data and move right |
| 4 | Shift+Tab | Enter data and move left |
| 5 | Ctrl+Enter | Enter data and stay in same cell |
| 6 | Enter | Enter same data in multiple cells (after copying then selecting cells) |
| 7 | Ctrl+; | Insert current data |
| 8 | Ctrl+Shift+; | Insert current time |
| 9 | Ctrl+D | Fill down from cell above |
| 10 | Ctrl+R | Fill right from cell on left |
| 11 | Ctrl+` | Copy formula from cell |
| 12 | Ctrl+Shift+" | Copy value from cell above |
| 14 | Ctrl+K | Insert hyperlink |
| 15 | Alt+↓ | Display Auto Complete list |
| 16 | Ctrl+E | Flash fill |
15
Formatting
17
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+1 | Format cells |
| 2 | Ctrl+Shift+F | Display Format Cells with Font tab selected |
| 3 | Ctrl+B | Apply or remove bold |
| 4 | Ctrl+I | Apply or remove italics |
| 5 | Ctrl+U | Apply or remove underscore |
| 6 | Ctrl+5 | Apply or remove strikethrough |
| 7 | Alt+H , AC | Align center |
| 8 | Alt+H , AL | Align left |
| 9 | Alt+H , AR | Align right |
| 10 | Alt+H , 6 | Indent |
| 11 | Alt+H , 5 | Remove Indent |
| 12 | Alt+H , W | Wrap text |
| 13 | Alt+H , AT | Align Top |
| 14 | Alt+H , AM | Align middle |
| 15 | Alt+H , AB | Align bottom |
| 16 | Alt+H , FG | Increase font size one step |
| 17 | Alt+H , FK | Decrease font size one step |
16
Formulas
17
|
Shortcut Key |
Description |
|---|---|---|
| 1 | = or + | Begin entering a formula |
| 2 | F4 | Toggle absolute and relative reference |
| 3 | Shift+F3 | Open the Insert Function Dialog Box |
| 4 | Alt+= | Autosum |
| 5 | Ctrl+` | Toggle displaying formulas on and off |
| 6 | Ctrl+Shift+A | Insert function arguments |
| 7 | Ctrl+Shift+Enter | Enter array formula |
| 8 | F9 | Calculate worksheets |
| 9 | Shift+F9 | Calculate active worksheets |
| 10 | Ctrl+Alt+F9 | Force calculate all worksheets |
| 11 | Ctrl+Shift+U | Expand or collapse the formula bar |
| 12 | F9 | Evaluate part of a formula ( in cell edit mode) |
| 13 | Ctrl+Shift+F3 | Create name from values in rows / columns |
| 14 | Ctrl+A | Display function arguments dialog box |
| 15 | Ctrl+F3 | Open Name Manager |
| 16 | F3 | Paste name into formula |
| 17 | Tab | Accept function with auto-complete |
17
Number Formatting
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Ctrl+Shift+~ | Apply general format |
| 2 | Ctrl+Shift+! | Apply number format |
| 3 | Ctrl+Shift+@ | Apply time format |
| 4 | Ctrl+Shift+# | Apply date format |
| 5 | Ctrl+Shift+$ | Apply currency format |
| 6 | Ctrl+Shift+% | Apply percentage format |
| 7 | Ctrl+Shift+^ | Apply scientific format |
18
Pivot Tables
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Alt+N , V | Create pivot table |
| 2 | Ctrl+A | Select entire pivot table |
| 3 | Alt+Shift+→ | Group pivot table items |
| 4 | Alt+Shift+← | Ungroup pivot table items |
| 5 | Ctrl+- | Hide (filter out) pivot table item |
| 6 | Alt+H , SC | Unhide (clear filter on) pivot table item |
| 7 | Alt+N , SZC | Insert pivot chart |
19
Dialog Boxes
7
|
Shortcut Key |
Description |
|---|---|---|
| 1 | Tab | Move to next control |
| 2 | Shift+Tab | Move to previous control |
| 3 | Ctrl+Tab | Move to next tab |
| 4 | Ctrl+Shift+Tab | Move to previous tab |
| 5 | Space | Check and uncheck box |
| 6 | Esc | Cancel and close the dialog box |
| 7 | Enter | Accept and apply |