200+ Best Excel Shortcuts for PC and Mac
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard shortcuts.
Worksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
| Shortcut | Windows | Mac |
|---|---|---|
| Insert new worksheet Without needing to click multiple on-screen buttons, this shortcut allows you to quickly add a new worksheet tab to your Excel workbook. | Shift F11 | Fn Control F11 |
| Go to next worksheet Slide forward to the next worksheet within your workbook with ease. This shortcut can be extremely useful if you have many tabs and frequently navigate between them. | Ctrl PgDn | Fn Control ▼ |
| Go to previous worksheet Slide back to the previously worksheet within your workbook with ease. This shortcut can be extremely useful if you have many tabs and frequently navigate between them. | Ctrl PgUp | Fn Control ▲ |
| Move to next pane If you are working between a split worksheet, this shortcut can be used to switch back and forth between each side. | F6 | Fn F6 |
| Navigate forward between workbooks Working on two or more workbooks at once? This shortcut is the best way to hop back and forth between them. Use this one to move forward and cycle between all workbooks that are open. | Ctrl Tab | Control Tab |
| Navigate back between workbooks This shortcut is the best way to hop back and forth between workbooks Use this one to move back between a group of 3 or more workbooks. | Ctrl Shift Tab | Control Shift Tab |
| Minimize current workbook Hide your active workbook from view if you need to focus your attention elsewhere. This shortcut can also be used to gain view of another workbook when one becomes minimized. | Ctrl F9 | ⌘ M |
| Maximize current workbook Bring back to your full screen a minimized workbook. | Ctrl F10 | Fn Control F10 |