Ctrl+Shift+{: Select Cells referenced by Formulas

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

Step 1: Click the cell with the formula;

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

Check More Excel Shortcuts

Leave a Reply