Microsoft Excel is a powerful software that lets you turn data into useful insights. You can also share your spreadsheet with others and edit together in real time.
Here are some of UWM IT’s favorite Excel keyboard shortcuts to help you excel with Excel!
| Action | Windows Shortcut | Mac Shortcut |
|---|---|---|
| Search in spreadsheet | Ctrl + F | Command + F |
| Navigate to the edge of your data | Crtl + arrow key | Command + arrow key |
| Add multiple lines in a cell | Alt + enter | Option + enter |
| Select entire table/all data | Crtl + A | Command + A |
| Fill the selected cell range with the current entry | Crtl + C, then Select range of cells and press Enter | Command + C, then Select a range of cells and press Enter |
| Select entire column in worksheet | Ctrl + Spacebar | Control + Spacebar |
| Select entire row in worksheet | Shift + Spacebar | Shift + Spacebar |
For more Excel shortcuts, visit Microsoft’s Support article.
UWM TechTraining offers training opportunities and resources including a live, online Excel course. All online courses are recorded and viewable on-demand. Visit the Online Training page for information.
For self-paced online Excel courses, visit LinkedIn Learning!
If you need assistance regarding this topic, please contact the UWM Help Desk.