

Useful Excel keyboard shortcuts Source: Microsoft Action Note: On Macs, the ⌘ key is the same as the Command or Cmd key.

For even more shortcuts, see Microsoft’s Office site. Most work whether you’re using a subscription (Microsoft 365/Office 365) or non-subscription version of Excel. We’ve listed the shortcuts we’ve found the most useful below. (Fewer shortcuts are available for the Mac, but you can create your own custom keyboard shortcuts if you like.) There are keyboard shortcuts to accomplish a vast array of tasks in the Excel desktop client, in both the Windows and Mac versions. Why bother to lift your hands from the keyboard if you want to open or close a file, apply formatting to cells, navigate through workbooks, undo and redo actions, calculate all worksheets in all open workbooks, and more? With keyboard shortcuts you won’t have to.

Results: The Close All icon will be available on the Quick Access toolbar. Click OK to close the Excel Options dialog. Click the Add button to add the icon to the Quick Access toolbar. Find the Close All item in the left list.In the left dropdown, choose Commands Not in the Ribbon.Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.Strategy: You can add a Close All button to your Quick Access toolbar. Excel no longer has a Close All icon on the ribbon, and selecting File, Close 22 times can get monotonous. I want to keep Excel open but close all the workbooks.
