Ctrl+]: Formula Refer to Active Cell

The shortcut Ctrl+] (right square bracket) is to select the cells that contain formulas that directly reference the active cell. Please refer to the shortcut Ctrl+Shift+}.

Step 1: Click any cell in the worksheet;

Step 2: Press and hold the Ctrl key, then press the right square bracket sign ( ] ). The cells with the formula referring to this cell will be selected.

Check More Excel Shortcuts

Leave a Reply