Ctrl+Shift+|
Updated: 11/12/2023 by Computer Hope
The Ctrl+Shift+| or Ctrl+Shift+\ keyboard shortcut is most commonly used to select cells within a column that don't match the formula or static value in the active cell. Below are other programs that use this keyboard shortcut and related information.
How to use the Ctrl+Shift+| keyboard shortcut
To use this keyboard shortcut, press and hold either Ctrl and Shift key, and while continuing to hold, press the | key.
Ctrl+Shift+\ in Google Sheets
Pressing Alt+Shift+\ in a Google Sheets opens the context menu containing shortcuts to commonly accessed features.
Ctrl+Shift+| in Microsoft Excel
Pressing Ctrl+Shift+| selects the cells within a column that don't match the formula or static value in the active cell.
Related keyboard shortcuts and keys
Below are links to related keyboard shortcuts and individual key pages.