Ctrl+[: Cells Referenced by Formula

The shortcut Ctrl+[ (left square bracket) is to select all cells directly referenced by formulas in the selection. Please refer to the shortcut Ctrl+Shift+{.

Step 1: Click the cell with the formula;

Step 2: Press and hold the Ctrl key, then press the left square bracket sign ( [ ). All the cells directly refer to the formula will be selected.

Check More Excel Shortcuts

Leave a Reply