Excel is one of the most robust tools any entrepreneur has at their disposal, and just like other systems, it has its own keyboard shortcuts that make advanced and basic tasks quicker and easier. These keyboard shortcuts are targeted at users who work on PC machines, but most of them can be replicated on a Mac keyboard with a few minor substitutions. All the charts here are JPEGs, so you can easily save them or even print them out.
First on our list are essential shortcuts. These are basic shortcuts that pretty much any Excel user, from a beginner to an advanced power user, can benefit from.
Formatting keyboard shortcuts not only save you time, they also allow you to take advantage of your entire computer screen by minimizing the formatting ribbon at the top of each Excel workbook. Most of these shortcuts will work on individual cells as well as entire rows or columns, so you can efficiently format entire workbooks in just a few keystrokes.
Keyboard navigation shortcuts are a great way to save time when you’re moving through massive spreadsheets and between multiple workbooks and worksheets. Some of these navigations will be more useful for business owners who regularly deal with spreadsheets that contain thousands of data points, while others are helpful for even basic navigation.
If you’re interested in getting better at Excel, check out our Basic Arithmetic Cheat Sheets and our guides to calculating a running total and calculating days between dates. If you’re still hungry for more Excel knowledge, consider taking an affordable online course.
Sign up for a beginner Excel course now.