Ribbon Control – Microsoft Excel Shortcuts
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.
Ribbon Control
The ribbon, which is located at the top of your Excel spreadsheet, includes tabs that can be accessed to control various aspects of your work within Excel. These simple shortcuts can be used to access the ribbon, navigate its features, and change the cells your ribbon is controlling or editing.
| Shortcut | Windows | Mac |
|---|---|---|
| Expand / collapse ribbon Quickly hide and show the ribbon located at the top of your spreadsheet. Wherever tab you currently have open will be minimized until you choose to open it again. | Ctrl F1 | ⌘ Shift R |
| Activate access keys This windows only function allows you to control the ribbon using on the keyboard. When accessed, all available controls will be listed for you. | Alt | |
| Move to next cell Jump with ease to the next cell in the row you are currently working. This shortcut also will change the cell being controlled by your ribbon tabs. | Tab | Tab |
| Move to previous cell Jump with ease to the previous cell in the row you are currently working. This shortcut also will change the cell being controlled by your ribbon tabs. | Shift Tab | Shift Tab |
| Activate selected cell Use this shortcut to begin typing or editing within the cell you have click on already. A space bar will appear, and you can get to work. | F2 | Space |
| Confirm edits / control changes Finalized your work within a given cell? Simple tap enter (or return on a mac) to lock in the changes you made or formulas you added. | Enter | Return |
| Get help on control selected If you are using a pc you can use this shortcut to get help and FAQ’s on whatever control you are currently working on. | F1 |