1. Shortcuts
Shortcuts are essential if users wish to be effecient and save time while working in Excel. It can be tedious and cumbersome to switch between mouse and keyboard usage performing the same tasks over a large set of data. These shortcuts help to mitigate that.
Here are list of shortcuts that will aid users in becoming power excel users.
1.1. File
Combination |
Effect |
|---|---|
|
Create new workbook |
|
Open workbook |
|
Save workbook |
|
Save as |
|
Print file |
|
Open print preview window |
|
Close current workbook |
|
Close excel |
1.2. Ribbon
Combination |
Effect |
|---|---|
|
Expand or collapse ribbon |
|
Activate access keys |
|
Move to next ribbon control |
|
Activate or open selected control |
|
Confirm control change |
|
Get help on selected control |
1.3. Drag and Drop
Combination |
Effect |
|---|---|
|
Drag and cut |
|
Drag and copy |
|
Drag and insert |
|
Drag and insert copy |
|
Drag to worksheet |
|
Drag to duplicate worksheet |
1.4. Active Cell
Combination |
Effect |
|---|---|
|
Select active cell only |
|
Show active cell |
|
Move active cell cockwise in selection |
|
Move active cell down |
|
Move active cell up |
|
Move active cell right |
|
Move active cell left |
1.5. General
Combination |
Effect |
|---|---|
|
Open Help |
|
Undo last action |
|
Redo last action |
|
Copy selected cell(s) |
|
Repeat last action |
|
Cut selected cell(s) |
|
Paste content from clipboard |
|
Display paste special |
|
Display find and replace |
|
Find with replace selectd |
|
Find previous match |
|
Find next match |
|
Create embedded chart |
|
Create chart in a new worksheet |
|
Toggle autofilter |
|
Activate filter |
|
Insert table |
|
Select table row |
|
Select table column |
|
Select table |
1.6. Selection
Combination |
Effect |
|---|---|
|
Select entire row |
|
Select entire column |
|
Select entire worksheet |
|
Add adjacent cells to selection |
|
Add non-adjacent cells to selection |
|
Move right non-adjacent |
|
Move left non-adjacent |
|
Toggle add to selection mode |
|
Cancel selection |
1.8. Extend Selection
Combination |
Effect |
|---|---|
|
Extend last cell right |
|
Extend last cell left |
|
Extend last cell up |
|
Extend last cell down |
|
Extend selection up one screen |
|
Extend selection down one screen |
|
Extend selection right one screen |
|
Extend selection left one screen |
|
Extend selection to start of row |
|
Extend first cell |
|
Extend last worksheet cell |
|
Toggle extend selection mode |
1.9. Select Special
Combination |
Effect |
|---|---|
|
Display Go To dialog box |
|
Select cells with comments |
|
Select current region |
1.10. Cell edit
Combination |
Effect |
|---|---|
|
Edit active cell |
|
Insert or edit comment |
|
Cancel entry |
|
Select one character right |
|
Select one character left |
|
Move one word right |
|
Move one word left |
|
Select one word right |
|
Select one word left |
|
Select to beginning of cell |
|
Select to end of cell |
|
Delete to end of line |
|
New line in cell |
1.11. Data entry
Combination |
Effect |
|---|---|
|
Enter and move down |
|
Enter and move up |
|
Enter and move right |
|
Enter and move left |
|
Enter and stay in cell |
|
Enter same data in multiple cells |
|
Insert current date |
|
Insert current time |
|
Fill down from cell above |
|
Fill right from cell left |
|
Copy formula from cell above |
|
Copy value from cell above |
|
Add hyperlink |
|
Display AutoComplete list |
|
Flash fill |
1.12. Cell format
Combination |
Effect |
|---|---|
|
Format almost anything |
|
Display format cells font tab |
|
Apply or remove bold formatting |
|
Apply or remove italic formatting |
|
Apply or remove underscoring |
|
Toggle strikethrough formatting |
|
Aligin center |
|
Align left |
|
Align right |
|
Indent |
|
Remove Indent |
|
Increase font size one step |
|
Decrease font size one step |
1.13. Number format
Combination |
Effect |
|---|---|
|
Apply general format |
|
Apply currency format |
|
Apply percentage format |
|
Apply scientific format |
|
Apply data format |
|
Apply time format |
|
Apply number format |
|
Add border outline |
1.14. Border format
Combination |
Effect |
|---|---|
|
Add or remove border right |
|
Add or remove border left |
|
Add or remove border top |
|
Add or remove border bottom |
|
Add or remove border upward diagonal |
|
Add or remove border horizontal interior |
|
Add or remove border vertical interior |
|
Remove borders |
1.15. Formulas
Combination |
Effect |
|---|---|
|
Toggle absolute and relative references |
|
Open insert function dialog |
|
Autosum selected cells |
|
Toggle formulas on and off |
|
Insert function arguments |
|
Enter array formula |
|
Calculate worksheet |
|
Calculate active worksheet |
|
Force calculate all worksheets |
|
Evaluate part of a formula |
|
Expand/collapse formula bar |
|
Define name |
|
Define names from labels |
|
Paste name into formula |
|
Accept function with autocomplete |
1.16. Grid operations
Combination |
Effect |
|---|---|
|
Display insert dialog box |
|
Insert rows |
|
Insert columns |
|
Display delete dialog box |
|
Delete rows |
|
Delete columns |
|
Delete cells |
|
Delete contents of selected cells |
|
Hide columns |
|
Hide rows |
|
Unhide rows |
|
Unhide columns |
|
Group rows or columns |
|
Ungroup rows or columns |
|
Open group dialog box |
|
Open ungroup dialog box |
1.17. Pivot tables
Combination |
Effect |
|---|---|
|
Hide or show outline symbols |
|
Toggle pivot table field checkbox |
|
Group pivot table items |
|
Ungroup pivot table items |
|
Hide pivot table item |
|
Create pivot chart on same worksheet |
|
Create pivot chart on new worksheet |
|
Open pivot table wizard |
1.18. Workbook
Combination |
Effect |
|---|---|
|
Insert new worksheet |
|
Go to next worksheet |
|
Go to previous worksheet |
|
Move to next pane |
|
Move to previous pane |
|
Go to next workbook |
|
Go to previous workbook |
|
Minimize current workbook window |
|
Maximize current workbook window |
|
Select adjacent worksheets |
|
Select non-adjacent worksheets |
|
Toggle scroll lock |
1.19. Other
Combination |
Effect |
|---|---|
|
Open spelling dialog box |
|
Open thesaurus dialog box |
|
Open macro dialog box |
|
Open VBA editor |
|
Duplicate object |
|
Snap to grid |
|
Hide or show objects |
|
Display modify cell style |
|
Display shortcut menu |
|
Display control menu |