Table of contents
Worksheets and WorkbooksViewRow and Column SelectionRibbon ControlPivot TablesOperating within a CellNavigating and Selecting CellsHelp and MenusGroup Selection General ExcelGeneral Cell ControlFormulas and FunctionsFormatting Text and NumbersDialog BoxesBordersAdvanced Selection Adding Content to CellsCreate a keyboard shortcut in Excel for Mac. On the Tools menu, click Customize Keyboard. In the Categories list, click a tab name. In the Commands list, click the command that you want to assign a keyboard shortcut to. Any keyboard shortcuts that are currently assigned to the selected command will appear in the Current keys box. Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For a complete list of Windows and Mac shortcuts, see our side-by-side list. I've got version 16.34 of mac excel. I'm trying to modify some of the shortcuts. For instance, control + u - i would like to change to command + 2. If I got to toolscustomize keyboard, it requires me to find the description of the command as it is in the ribbon and then I can change it. Excel and any other open workbooks will remain open. Windows: Alt+F4. If you want to close out of Excel completely, including any open workbooks, this is the shortcut to use. It's the same as clicking on the X in the upper right corner. Again, you may be prompted to save your work before it closes.
Worksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
Worksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
View
Row and Column Selection
Ribbon Control
Pivot Tables
Operating within a Cell
Navigating and Selecting Cells
Help and Menus
Group Selection
General Excel
General Cell Control
Formulas and Functions
Formatting Text and Numbers
Dialog Boxes
Borders
Advanced Selection
Shortcuts On Mac For Excel Shortcuts
Adding Content to Cells
Get more Reference tips and tricks
Printable Excel Shortcuts Cheat Sheet
Subscribe to our email updates and get Reference tips direct to your inbox.