O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Select Cells with Special Characteristics

Press

To

Ctrl+Shift+* (asterisk)

Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, select the entire PivotTable.

Ctrl+/ (slash)

Select the array containing the active cell.

Ctrl+Shift+O (the letter O)

Select all cells that contain comments.

Ctrl+\ (backslash)

In a selected row, select the cells that don't match the value in the active cell.

Ctrl+Shift+| (vertical bar)

In a selected column, select the cells that don't match the value in the active cell.

Ctrl+[ (opening bracket)

Select all cells directly referenced by formulas in the selection.

Ctrl+Shift+{ (opening brace)

Select all cells directly or indirectly referenced by formulas in the selection. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required