Handy Excel keyboard shortcuts for Windows and Mac

Excel’s Ribbon is nice for locating every thing you would possibly ever wish to do in a spreadsheet, significantly belongings you don’t do continuously, like managing and querying knowledge connections or robotically grabbing geographic statistics from the web and inserting them into cells.

However if you happen to’re seeking to do issues quick, you’ll discover keyboard shortcuts way more helpful. Why trouble to raise your arms from the keyboard if you wish to open or shut a file, apply formatting to cells, navigate by means of workbooks, undo and redo actions, calculate all worksheets in all open workbooks, and extra? With keyboard shortcuts you gained’t must.

There are keyboard shortcuts to perform an unlimited array of duties within the Excel desktop consumer, in each the Home windows and Mac variations. (Fewer shortcuts can be found for the Mac, however you'll be able to create your personal customized keyboard shortcuts if you happen to like.)

We’ve listed the shortcuts we’ve discovered probably the most helpful under. Most work whether or not you’re utilizing a subscription (Microsoft 365/Workplace 365) or non-subscription model of Excel. For much more shortcuts, see Microsoft’s Workplace web site.

Observe: On Macs, the ⌘ key is identical because the Command or Cmd key.

Helpful Excel keyboard shortcuts

In search of extra assist with Excel for Home windows? You probably have an Workplace subscription, see "Excel for Workplace 365/Microsoft 365 cheat sheet." You probably have a non-subscription model of Workplace, see "Excel 2016 and 2019 cheat sheet." We have additionally acquired cheat sheets for an array of different Microsoft merchandise, together with older variations of Workplace.