Ctrl+Shift+}: Cells with Formulas reference to Active Cell

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

Step 1: Click any cell in the worksheet;

This image has an empty alt attribute; its file name is excelctrlrightsquarebracket.jpg

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

Check More Excel Shortcuts

Leave a Reply