| EXCEL SHORTCUT KEYS |
DESCRIPTION |
| F2 |
Edit the selected cell |
| F5 |
Go to a specific cell |
| F7 |
Spell check selected text and/or document |
| F11 |
Create chart |
| Ctrl + Shift + ; |
Enter the current time |
| Ctrl + ; |
Enter the current date |
| Alt + Shift + F1 |
Insert new worksheet |
| Shift + F3 |
Open the Excel formula window |
| Shift + F5 |
Bring up search box |
| Ctrl + A |
Select all contents of worksheet |
| Ctrl + B |
Bold highlighted selection |
| Ctrl + I |
Italicize highlighted selection |
| Ctrl + C |
Copy selected text |
| Ctrl + V |
Paste |
| Ctrl + D |
Fill |
| Ctrl + K |
Insert link |
| Ctrl + F |
Open find and replace options |
| Ctrl + G |
Open go-to options |
| Ctrl + H |
Open find and replace options |
| Ctrl + U |
Underline highlighted selection |
| Ctrl + Y |
Underline selected text |
| Ctrl + 5 |
Strikethrough highlighted selection |
| Ctrl + O |
Open options |
| Ctrl + N |
Open new document |
| Ctrl + P |
Open print dialog box |
| Ctrl + S |
Save |
| Ctrl + Z |
Undo last action |
| Ctrl + F9 |
Minimize current window |
| Ctrl + F10 |
Maximize currently selected window |
| Ctrl + F6 |
Switch between open workbooks/windows |
| Ctrl + Page up & Page Down |
Move between Excel® worksheets in the same document |
| Ctrl + Tab |
Move between two or more open Excel® files |
| Alt + = |
Create formula to sum all of above cells |
| Ctrl + ‘ |
Insert value of above cell into current cell |
| Ctrl + Shift + ! |
Format number in comma format |
| Ctrl + Shift + $ |
Format number in currency format |
| Ctrl + Shift + # |
Format number in date format |
| Ctrl + Shift + % |
Format number in percentage format |
| Ctrl + Shift + ^ |
Format number in scientific format |
| Ctrl + Shift + @ |
Format number in time format |
| Ctrl + 🡒 |
Move to next section of text |
| Ctrl + Space |
Select entire column |
| Shift + Space |
Select entire row |
| Ctrl + W |
Close document |
by 