Shortcuts Excel For Mac

  



A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right. 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. On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell. If youd like to see all of Excels keyboard shortcuts, open Help - Excel Help, then type keyboard shortcuts in the search box, and then select Excel Keyboard Shortcuts in the results box.

auto-download pdf after sign up

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 Cells

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.

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.

Excel Shortcuts - List of Keyboard Shortcut Keys for PC & Mac

View

Row and Column Selection

Ribbon Control

Pivot Tables

Save

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

See full list on automateexcel.com

Excel Shortcuts For Macros

Dialog Boxes

Borders

Excel Shortcuts For Macbook Pro

Advanced Selection

Keyboard Shortcuts For Excel

Adding Content to Cells

Get more Reference tips and tricks

Cached

Subscribe to our email updates and get Reference tips direct to your inbox.