Microsoft Excel Shortcut Keys.
| Shortcut | Action | Description |
|---|---|---|
Alt+=
|
AutoSum | Insert AutoSum formula. |
Alt+Down Arrow
|
AutoFilter | Open AutoFilter dropdown. |
Alt+Enter
|
Line Break | Start new line in cell. |
Alt+F1
|
Create Chart | Create a chart from selected data. |
Alt+F11
|
Visual Basic Editor | Open Visual Basic Editor. |
Alt+Page Down
|
One Screen Right | Move one screen to the right. |
Alt+Page Up
|
One Screen Left | Move one screen to the left. |
Alt+Shift+F1
|
Insert Worksheet | Insert a new worksheet. |
Alt+Shift+F11
|
Microsoft Script Editor | Open Microsoft Script Editor. |
Ctrl+-
|
Delete Rows/Columns | Delete rows or columns. |
Ctrl+0
|
Hide Columns | Hide selected columns. |
Ctrl+1
|
Format Cells | Open Format Cells dialog. |
Ctrl+5
|
Strikethrough | Apply or remove strikethrough. |
Ctrl+8
|
Show Outline | Show or hide outline symbols. |
Ctrl+9
|
Hide Rows | Hide selected rows. |
Ctrl+;
|
Insert Date | Insert current date. |
Ctrl+A
|
Select All | Select all cells. |
Ctrl+Alt+=
|
Quick Fill | Use Flash Fill. |
Ctrl+Alt+F9
|
Calculate All | Calculate all worksheets in workbooks. |
Ctrl+Alt+Shift+F9
|
Force Calculate | Force full recalculation. |
Ctrl+Alt+V
|
Paste Special | Open Paste Special dialog. |
Ctrl+Arrow
|
Move to Edge | Move to edge of data region. |
Ctrl+B
|
Bold | Apply or remove bold formatting. |
Ctrl+C
|
Copy | Copy selected cells. |
Ctrl+D
|
Fill Down | Fill down from cell above. |
Ctrl+E
|
Flash Fill | Use Flash Fill. |
Ctrl+End
|
Go to Last Cell | Go to the last used cell. |
Ctrl+Enter
|
Fill Selection | Fill selected cells. |
Ctrl+F
|
Find | Find text or values. |
Ctrl+F11
|
Insert Macro Sheet | Insert a macro sheet. |
Ctrl+F12
|
Open | Open file dialog. |
Ctrl+F3
|
Name Manager | Open Name Manager. |
Ctrl+G
|
Go To | Open Go To dialog. |
Ctrl+H
|
Find and Replace | Find and replace text. |
Ctrl+Home
|
Go to Cell A1 | Go to cell A1. |
Ctrl+I
|
Italic | Apply or remove italic formatting. |
Ctrl+K
|
Insert Link | Insert a hyperlink. |
Ctrl+N
|
New Workbook | Create a new workbook. |
Ctrl+O
|
Open | Open an existing workbook. |
Ctrl+P
|
Print the worksheet. | |
Ctrl+Page Down
|
Next Sheet | Move to the next worksheet. |
Ctrl+Page Up
|
Previous Sheet | Move to the previous worksheet. |
Ctrl+Q
|
Quick Analysis | Open Quick Analysis tool. |
Ctrl+R
|
Fill Right | Fill right from cell to left. |
Ctrl+S
|
Save | Save the workbook. |
Ctrl+Shift+!
|
Number Format | Apply Number format. |
Ctrl+Shift+#
|
Date Format | Apply date format. |
Ctrl+Shift+$
|
Currency Format | Apply currency format. |
Ctrl+Shift+%
|
Percentage Format | Apply percentage format. |
Ctrl+Shift+'
|
Copy Value | Copy cell above value. |
Ctrl+Shift+(+)
|
Unhide Rows | Unhide rows. |
Ctrl+Shift+)
|
Unhide Columns | Unhide columns. |
Ctrl+Shift+*
|
Select Region | Select current region. |
Ctrl+Shift++
|
Insert Rows/Rows | Insert rows or columns. |
Ctrl+Shift+0
|
Unhide Columns | Unhide hidden columns. |
Ctrl+Shift+1
|
Format Cells | Open Format Cells dialog. |
Ctrl+Shift+2
|
Time Format | Apply time format. |
Ctrl+Shift+3
|
Date Format | Apply date format. |
Ctrl+Shift+4
|
Currency Format | Apply currency format. |
Ctrl+Shift+5
|
Percent Format | Apply percent format. |
Ctrl+Shift+6
|
Number Format | Apply number format. |
Ctrl+Shift+8
|
Select Region | Select current region. |
Ctrl+Shift+9
|
Unhide Rows | Unhide hidden rows. |
Ctrl+Shift+:
|
Insert Time | Insert current time. |
Ctrl+Shift+@
|
Time Format | Apply time format. |
Ctrl+Shift+Arrow
|
Select to Edge | Select to edge of data. |
Ctrl+Shift+Enter
|
Array Formula | Enter as array formula. |
Ctrl+Shift+F
|
Font Format | Open Format Cells - Font. |
Ctrl+Shift+F10
|
Show Tooltip | Show building block tooltip. |
Ctrl+Shift+F11
|
Edit Macro | Edit a macro. |
Ctrl+Shift+F3
|
Create Name | Create names from selection. |
Ctrl+Shift+G
|
Border | Open Format Cells - Border. |
Ctrl+Shift+H
|
Pattern | Open Format Cells - Pattern. |
Ctrl+Shift+L
|
AutoFilter | Turn AutoFilter on or off. |
Ctrl+Shift+M
|
Number Format | Open Format Cells - Number. |
Ctrl+Shift+N
|
Protection | Open Format Cells - Protection. |
Ctrl+Shift+O
|
Select Filtered | Select filtered cells. |
Ctrl+Shift+P
|
Font Size | Open Format Cells - Font size. |
Ctrl+Shift+S
|
Save As | Save workbook with a new name. |
Ctrl+Shift+U
|
Alignment | Open Format Cells - Alignment. |
Ctrl+Shift+~
|
General Format | Apply General format. |
Ctrl+Space
|
Select Column | Select entire column. |
Ctrl+U
|
Underline | Apply or remove underline. |
Ctrl+V
|
Paste | Paste clipboard contents. |
Ctrl+W
|
Close | Close the workbook. |
Ctrl+X
|
Cut | Cut selected cells. |
Ctrl+Y
|
Redo | Redo a previously undone action. |
Ctrl+Z
|
Undo | Undo the last action. |
Ctrl+`
|
Show Formulas | Show formulas instead of values. |
Delete
|
Clear Contents | Clear cell contents. |
Enter
|
Confirm | Confirm cell entry. |
Escape
|
Cancel | Cancel cell entry. |
F11
|
Create Chart | Create a chart. |
F2
|
Edit Cell | Edit the active cell. |
F3
|
Paste Name | Paste a defined name. |
F4
|
Toggle Reference | Toggle absolute/relative reference. |
F5
|
Go To | Open Go To dialog. |
F7
|
Spelling | Open Spelling dialog. |
F9
|
Calculate Sheets | Calculate all worksheets. |
Page Down
|
Next Screen | Move one screen down. |
Page Up
|
Previous Screen | Move one screen up. |
Shift+F3
|
Insert Function | Open Insert Function dialog. |
Shift+F5
|
Find | Open Find dialog. |
Shift+F9
|
Calculate Sheet | Calculate active worksheet. |
Shift+Space
|
Select Row | Select entire row. |
Shift+Tab
|
Previous Cell | Move to previous cell. |
Tab
|
Next Cell | Move to next cell. |