1. Business Ideas
  2. Business Plans
  3. Startup Basics
  4. Startup Funding
  5. Franchising
  6. Success Stories
  7. Entrepreneurs
  1. Sales & Marketing
  2. Finances
  3. Your Team
  4. Technology
  5. Social Media
  6. Security
  1. Get the Job
  2. Get Ahead
  3. Office Life
  4. Work-Life Balance
  5. Home Office
  1. Leadership
  2. Women in Business
  3. Managing
  4. Strategy
  5. Personal Growth
  1. HR Solutions
  2. Financial Solutions
  3. Marketing Solutions
  4. Security Solutions
  5. Retail Solutions
  6. SMB Solutions
Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.
Grow Your Business Technology

Microsoft Excel Keyboard Shortcuts: 3 Cheat Sheets

Microsoft Excel Credit: Shutterstock/Dennizn

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. 

Mona Bushnell

Mona Bushnell is a New York City-based Staff Writer for Tom’s IT Pro and Business News Daily. She has a B.A. in Writing, Literature, and Publishing from Emerson College and has previously worked as an IT Technician, a Copywriter, a Software Administrator, a Scheduling Manager and an Editorial Writer. Mona began freelance writing full-time in 2014 and joined the Purch team in 2017.