Excel Keyboard Shortcuts. Before we get started, take out a small screwdriver or key and pop off the F1, Scroll Lock, and Insert keys from your keyboard and store them in a safe place. There are many Excel keyboard shortcuts, but we focus here only on those you might actually use and benefit from. In reality, Excel shortcuts on the Mac are quite capable, you just have to understand and adjust to certain differences. In this article, I'll walk you through the key differences you need to be aware of to work productively with Excel shortcuts on a Mac.
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 CellsWorksheets 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.
Windows keys
ShiftF11
CtrlPgDn
CtrlPgUp
F6
CtrlTab
CtrlShiftTab
CtrlF9
CtrlF10
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
![Alt T I Excel For Mac Alt T I Excel For Mac](/uploads/1/2/5/8/125850377/679836750.png)
Advanced Selection
Adding Content to Cells
Get more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.