Ctrl+Shift+Vertical Bar: Selects Static Values

The shortcut Ctrl+Shift+Vertical Bar (|) is to select the cells that don't match the formula or static values in the active cells.

Step 1: Select the cells in the worksheet;

Step 2: Press and hold the Ctrl and Shift keys, then press the vertical bar (|) from the keyboard.

Check More Excel Shortcuts

Leave a Reply