Turning Learners into Developers
Microsoft Excel Shortcut Keys
Microsoft Excel shortcut keys help you work faster, save time, and boost productivity. These powerful Excel keyboard shortcuts make data entry, formatting, navigation, and formula tasks quicker and easier. With CodeKilla’s shortcut guide, you can improve your workflow and master Excel efficiently.
- General Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
Ctrl + N |
New workbook |
Creates a new blank workbook instantly. |
|
Ctrl + O |
Open workbook |
Opens the file explorer to load an existing workbook. |
|
Ctrl + S |
Save workbook |
Saves your current file in the existing location. |
|
F12 |
Save As |
Opens Save As dialog to save in a new location or format. |
|
Ctrl + P |
|
Opens the print settings and preview window. |
|
Ctrl + W |
Close workbook |
Closes the current file but keeps Excel open. |
|
Ctrl + F4 |
Close Excel window |
Closes the entire Excel application. |
|
Ctrl + Z |
Undo |
Reverses the last action performed. |
|
Ctrl + Y |
Redo |
Re-applies the last undone action. |
|
Ctrl + X |
Cut |
Cuts selected cells and stores them in clipboard. |
|
Ctrl + C |
Copy |
Copies selected cells to clipboard. |
|
Ctrl + V |
Paste |
Inserts clipboard contents. |
|
Ctrl + A |
Select all |
Selects all cells in the sheet. |
|
Ctrl + F |
Find |
Opens search box to find text or numbers. |
|
Ctrl + H |
Replace |
Opens replace box to find and replace data. |
|
Ctrl + K |
Insert hyperlink |
Adds a clickable hyperlink to a cell or text. |
- Navigation Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
Arrow Keys |
Move one cell |
Moves selection in the direction of the arrow. |
|
Ctrl + Arrow Keys |
Jump to edge |
Jumps to the last continuous data cell in that direction. |
|
Home |
Go to start of row |
Moves selection to column A of the current row. |
|
Ctrl + Home |
Go to A1 |
Moves selection directly to cell A1. |
|
Ctrl + End |
Go to last used cell |
Jumps to the bottom-right active cell. |
|
Page Up / Down |
Move screen up/down |
Scrolls one full screen without moving cells too much. |
|
Alt + Page Up / Down |
Move left/right |
Moves one screen horizontally. |
|
Tab / Shift + Tab |
Move right/left |
Moves to next or previous cell. |
- Row & Column Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
Ctrl + Space |
Select column |
Highlights the entire selected column. |
|
Shift + Space |
Select row |
Highlights the entire selected row. |
|
Ctrl + Shift + + |
Insert row/column |
Adds a new row or column depending on selection. |
|
Ctrl + - |
Delete row/column |
Deletes selected row, column, or cell block. |
|
Ctrl + 0 |
Hide column |
Hides the entire column. |
|
Ctrl + 9 |
Hide row |
Hides the entire row. |
|
Ctrl + Shift + 0 |
Unhide column |
Unhides hidden columns. |
|
Ctrl + Shift + 9 |
Unhide row |
Unhides hidden rows. |
- Formatting Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
Ctrl + B |
Bold |
Makes text bold or removes bold. |
|
Ctrl + I |
Italic |
Makes text italic or removes italic. |
|
Ctrl + U |
Underline |
Adds or removes underline. |
|
Ctrl + 1 |
Format cells |
Opens the advanced formatting dialog. |
|
Ctrl + Shift + $ |
Currency format |
Applies currency symbol and decimal formatting. |
|
Ctrl + Shift + % |
Percent format |
Converts numbers to percentage format. |
|
Ctrl + Shift + # |
Date format |
Formats numbers as dates. |
|
Ctrl + Shift + @ |
Time format |
Formats numbers as time. |
|
Ctrl + Shift + ! |
Number format |
Applies two-decimal number formatting. |
|
Alt + E + S + V |
Paste values |
Pastes only the raw values (legacy menu). |
|
Alt + E + S + T |
Paste formats |
Pastes cell formatting only. |
- Cell Editing
|
Shortcut |
Action |
Description |
|---|---|---|
|
F2 |
Edit cell |
Opens the cell for editing without deleting content. |
|
Ctrl + Enter |
Fill selection |
Inserts the same value in all selected cells. |
|
Shift + Enter |
Enter & move up |
Enters value and moves to the cell above. |
|
Alt + Enter |
Insert line break |
Adds a new line within a cell. |
|
Ctrl + D |
Fill down |
Copies top cell value/formula downwards. |
|
Ctrl + R |
Fill right |
Copies left cell value/formula to the right. |
- Workbook & Worksheet Management
|
Shortcut |
Action |
Description |
|---|---|---|
|
Ctrl + Page Up |
Previous sheet |
Switches to prior sheet tab. |
|
Ctrl + Page Down |
Next sheet |
Switches to next sheet tab. |
|
Shift + F11 |
New sheet |
Inserts a new blank worksheet. |
|
Alt + H + O + R |
Rename sheet |
Opens the rename box for sheet tab. |
|
Ctrl + F3 |
Name Manager |
Opens name manager for ranges. |
|
Ctrl + Shift + F3 |
Create names |
Auto-creates named ranges from headers. |
- Data / Analysis Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
Alt + A + T |
Sort |
Opens the sort options. |
|
Ctrl + Shift + L |
Toggle filter |
Enables or disables auto-filter in a table. |
|
Alt + A + Q |
Remove duplicates |
Removes repeated rows. |
|
Alt + = |
AutoSum |
Automatically adds SUM formula. |
|
Ctrl + ; |
Insert date |
Inserts today’s date in the cell. |
|
Ctrl + Shift + ; |
Insert time |
Inserts current system time. |
|
F4 |
Repeat last action |
Re-performs last formatting or command. |
- Special Shortcuts
|
Shortcut |
Action |
Description |
|---|---|---|
|
F7 |
Spell check |
Checks spelling in worksheet. |
|
F11 |
Chart on new sheet |
Creates a chart using selected data. |
|
Shift + F9 |
Calculate sheet |
Recalculates formulas on active sheet only. |
|
Ctrl + Alt + F9 |
Full recalculation |
Forces Excel to recalculate all formulas. |
|
Ctrl + F9 |
Minimize window |
Minimizes workbook window. |
|
Ctrl + F10 |
Maximize/restore |
Toggles window size. |
