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 |