Advanced Selection

Worksheets and Workbooks 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 Adding Content to Cells

Navigating Excel to find certain cells based on data-driven criteria is a skill available even to Excel beginners. Try implementing shortcuts within this section to find cells such as dependents, precedents, and other advanced criteria.

To do this

Windows keys

Mac keys

Show "go-to" command center

Ctrl G

Control G

Select all cells with comments

Ctrl Shift O

Fn Control Shift O

Select all other cells in "region"

Ctrl Shift *

Shift Control Space

Select current region

Ctrl A

⌘ A

Select active array

Ctrl /

Control /

Select all different cells in row

Ctrl \

Control \

Select column difference

Ctrl Shift |

Control Shirt |

Select direct precedents

Ctrl [

Control {

Select all precedents

Ctrl Shift {

Control Shift {

Select direct dependents

Ctrl ]

Control ]

Select all dependents

Ctrl Shift }

Control Shift }

Select all visible cells

Alt ;

⌘ Shift Z

Worksheets and Workbooks

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