| Location | Shortcut Name | Shortcut |
|---|---|---|
| File Tab → Save Section | Save |
CTRL + S
Saves the current workbook.
|
| File Tab → Open Section | Open |
CTRL + O
Opens a workbook.
|
| File Tab → New Section | New Workbook |
CTRL + N
Creates a new workbook.
|
| File Tab → Print Section |
CTRL + P
Opens the Print dialog box.
|
|
| File Tab → Save As Section | Save As |
F12
Opens the Save As dialog box.
|
| Home Tab → Font Section | Bold |
CTRL + B
Makes selected text bold.
|
| Home Tab → Font Section | Italic |
CTRL + I
Makes selected text italic.
|
| Home Tab → Font Section | Underline |
CTRL + U
Underlines the selected text.
|
| Home Tab → Clipboard Section | Copy |
CTRL + C
Copies the selected content to clipboard.
|
| Home Tab → Clipboard Section | Cut |
CTRL + X
Cuts the selected content.
|
| Home Tab → Clipboard Section | Paste |
CTRL + V
Pastes the content from clipboard.
|
| Home Tab → Editing Section | Undo |
CTRL + Z
Undoes the last action.
|
| Home Tab → Editing Section | Redo |
CTRL + Y
Redoes the last undone action.
|
| Home Tab → Editing Section | Find |
CTRL + F
Opens the Find dialog box.
|
| Home Tab → Editing Section | Replace |
CTRL + H
Opens the Replace dialog box.
|
| Home Tab → Editing Section | Select All |
CTRL + A
Selects the entire worksheet.
|
| View Tab → Window Section | Switch Between Open Workbooks |
CTRL + TAB
Switches between open Excel workbooks.
|
| View Tab → Window Section | Minimize Window |
CTRL + F9
Minimizes the current workbook window.
|
| View Tab → Window Section | Maximize or Restore Window |
CTRL + F10
Maximizes or restores the current workbook window.
|
| View Tab → Zoom Section | Zoom In |
ALT + W + Q + I
Zooms in the worksheet view.
|
| View Tab → Zoom Section | Zoom Out |
ALT + W + Q + O
Zooms out the worksheet view.
|
| Formulas Tab → Function Library | Insert Function |
SHIFT + F3
Opens the Insert Function dialog box.
|
| Formulas Tab → Function Library | AutoSum |
ALT + = (Equal Sign)
Automatically sums the selected range.
|
| Formulas Tab → Calculation Section | Calculate Now |
F9
Calculates all worksheets in all open workbooks.
|
| Formulas Tab → Calculation Section | Calculate Sheet |
SHIFT + F9
Calculates the active worksheet.
|
| Data Tab → Sort & Filter Section | Sort Ascending |
ALT + A + S + A
Sorts the selected data in ascending order.
|
| Data Tab → Sort & Filter Section | Sort Descending |
ALT + A + S + D
Sorts the selected data in descending order.
|
| Data Tab → Data Tools Section | Remove Duplicates |
ALT + A + M
Removes duplicate values from the selected range.
|
| Insert Tab → Tables Section | Insert Table |
CTRL + T
Inserts a table based on the selected range.
|
| Insert Tab → Charts Section | Insert Chart |
ALT + F1
Creates a chart based on the selected data.
|
| Insert Tab → Illustrations Section | Insert Picture |
ALT + N + P
Inserts a picture from a file.
|
| Insert Tab → Text Section | Insert Text Box |
ALT + N + X
Inserts a text box into the worksheet.
|
| Insert Tab → Links Section | Insert Hyperlink |
CTRL + K
Inserts a hyperlink to the selected text or object.
|
| Insert Tab → Symbols Section | Insert Symbol |
ALT + N + U
Inserts a symbol or special character.
|
| Review Tab → Comments Section | New Comment |
SHIFT + F2
Inserts a new comment on the selected cell.
|
| Review Tab → Comments Section | Next Comment |
CTRL + ALT + ]
Moves to the next comment in the worksheet.
|
| Review Tab → Comments Section | Previous Comment |
CTRL + ALT + [
Moves to the previous comment in the worksheet.
|
| Review Tab → Proofing Section | Spelling Check |
F7
Checks the spelling in the active worksheet or selected range.
|
| Review Tab → Protect Section | Protect Workbook |
ALT + R + P + W
Protects the workbook structure and windows.
|
| View Tab → Show Section | Toggle Gridlines |
ALT + W + VG
Toggles gridlines on or off in the active worksheet.
|
| View Tab → Show Section | Toggle Headings |
ALT + W + VH
Toggles row and column headings on or off.
|
| View Tab → Zoom Section | 100% Zoom |
ALT + W + J
Sets the zoom level to 100%.
|
| View Tab → Window Section | New Window |
CTRL + N
Opens a new window for the active workbook.
|
| Formulas Tab → Function Library Section | Insert Function |
SHIFT + F3
Opens the Insert Function dialog box to create a new formula.
|
| General | Close Workbook |
CTRL + W
Closes the current workbook window.
|
| General | Close Excel |
CTRL + Q
Closes Excel.
|
