• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > Select Cells with Special Characteristics

Select Cells with Special Characteristics

PressTo
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.
Ctrl+] (closing bracket)Select cells that contain formulas that directly reference the active cell.
Ctrl+Shift+} (closing brace)Select cells that contain formulas that directly or indirectly reference the active cell.
Alt+; (semicolon)Select the visible cells in the current selection.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint