Excel Shortcuts List for Mac and PC (Searchable) How to Use this Shortcut List: + Indicates to hold the previous key, while pressing the next key. Indicates to tap the previous key, releasing it before pressing the next key. Find the shortcuts list below: # Description. 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. 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. Special symbols. One of more confusing aspects of keyboard shortcuts on the Mac are the symbols. Increase/Decrease Font Size – SHIFT+COMMAND+. (increase) SHIFT+COMMAND+, (decrease) The.

In Office 2011 for Mac, use Excel’s Group tool to identify ranges of rows in worksheets that you can then turn on and off. Activate the rows by using switches in a new margin that’s displayed when Group is active. Group is particularly useful when you have large tables with Total Rows turned on because it lets you hide data rows to reduce visual clutter on a busy worksheet.

To group an Excel worksheet that has multiple data tables that all begin flush left (or at least in the first few columns), do the following:

Select the rows that contain the tables with Total Rows turned on.
Tables need at least one empty row between them as separators. Contracted rows may not be included in Total Row calculations.
On the Ribbon’s Data tab, go to the Group & Outline group and choose Group→Auto Outline.
Excel turns on the group controls in a new margin.

To use the new controls, here’s what you do:

Click the 1 button at the top of the new margin to contract all groups. A plus sign displays next to the Total Row of each contracted group.
Click the + and – signs in the margin to expand or contract individual tables.
Click the 2 button at the top of the new margin to expand all groups.

You can select a range of adjacent rows within a single table and on the Ribbon’s Data tab; go to the Group & Outline group and choose Group→Group to group just the selected rows.

To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.

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

View

Row and Column Selection

Ribbon Control

Pivot Tables

Operating within a Cell

Excel Shortcuts For Mac Pdf

Navigating and Selecting Cells

Help and Menus

Group Selection

General Excel

General Cell Control

Formulas and Functions

Formatting Text and Numbers

Dialog Boxes

Borders

Keyboard Shortcuts For Excel

Advanced Selection

Excel For Mac 2011 Keyboard Shortcuts

Adding Content to Cells

Get more Reference tips and tricks

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

Table of contents

Worksheets and Workbooks

Worksheets and Workbooks

View

Row and Column Selection

Ribbon Control

Pivot Tables

Operating within a Cell

Excel Shortcuts For Mac Pdf

Navigating and Selecting Cells

Help and Menus

Group Selection

General Excel

General Cell Control

Formulas and Functions

Formatting Text and Numbers

Dialog Boxes

Borders

Keyboard Shortcuts For Excel

Advanced Selection

Excel For Mac 2011 Keyboard Shortcuts

Adding Content to Cells

Get more Reference tips and tricks

Excel 2011 For Mac Shortcuts