14 Essential Microsoft Excel 2010 Tips for Intermediate Users

Highlight the Formulas that Reference the Current Cell

The previous tip explained how to use Ctrl-[ (Ctrl-open-square-bracket) to see all the cells referenced by a formula. What if you want to do the reverse, and see the formulas that reference the a cell, select the cell, and press Ctrl-] (Ctrl-close-square-bracket). As in the previous tip, the selection moves to the the first formula that references the cell. Press Enter repeatedly to navigate to the other formulas that reference the cell. In the screen shot, I was originally in cell D3. I pressed Ctrl-]. This highlighted B3, D12, and D35, and B3 became the current cell.