35 Excel Shortcuts with Alt Key
35 Excel Shortcuts with Alt Key
What to do | Shortcuts |
Format Style dialog box | Alt + ' |
Select the visible cells | Alt + ; |
AutoSum the numbers | Alt + = |
Go to Data tab | Alt + A |
Open the File page | Alt + F |
Go to the Home tab | Alt + H |
Go to Formula tab | Alt + M |
Go to Insert tab | Alt + N |
Go to Page Layout tab | Alt + P |
Open the "Tell me" box | Alt + Q |
Open the Review tab | Alt + R |
Open the View tab | Alt + W |
Open the dropdown menu | Alt + ↓ |
Start a new line in the same cell | Alt + Enter |
Create an embedded chart | Alt + F1 |
Save As | Alt + F2 |
Closes Excel | Alt + F4 |
Open Macro dialog box | Alt + F8 |
Open the Microsoft Visual Basic for Applications | Alt + F11 |
Move one screen to the right | Alt + PageDown |
Move one screen to the left | Alt + PageUp |
Inserts a new worksheet | Alt + Shift + F1 |
Save the workbook | Alt + Shift + F2 |
Display the menu for Error Checking | Alt + Shift + F10 |
Calculate worksheets in all open workbooks | Ctrl + Alt + F9 |
Check formulas and calculate all cells | Ctrl + Alt + Shift + F9 |
Display "Paste Special" dialog box | Ctrl + Alt + V |
Center align cell contents | Alt + H, A, C |
Add borders | Alt + H, B |
Delete column | Alt + H, D, C |
Choose a fill color | Alt + H, H |
Define a name to use in references | Alt + M, M, D |
Switches to Page Break Preview view | Alt + W, I |
Switches to Normal view | Alt + W, L |
Switches to Page Layout view | Alt, W, P |