What it does
Shows a form where user can search references contained in the active cell formula, including the range, sheet, and file.  User can jump to any of the references contained in the active cell’s formula.  Also allows jumping back from the cell referenced to the one with the reference in the formula.

When to use it
When you want to list out or jump to one of the cells referenced in a formula, this will list all cell references out so you can easily jump to them.

Why to use it
This makes it very quick to review formulas/references and hop around within one or more workbooks that are linked together via formula references.

Default shortcut
Ctrl+Shift+R

Other Details

• Category: Formulas / General
• Difficulty: 3/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 30 seconds saved each time used)
• Type: Shortcut
• Date added: 2/18/2018
• Tags: references, formulas, search

Related Macros
None

Other Articles
None

None

Prerequisites
Select the cell with the formula/references you want to evaluate.

Instructions

Run the Show Cell References macro.  It will prompt you with a search form of all the cell references used in the active cell’s formula.  Click the drop-down button in the search box, or type part of the reference (file path, sheet name, and range address/name), and matching results will be filtered/displayed as you type.  Use the up and down arrows (or click with the mouse) to select a suggested reference and insert the entire range reference in the search box.  When the entire range reference is in the search box, press the Enter key (or press the Go button) to jump to that reference.  When the entire range reference is in the search box, file path, sheet, and cell reference are split and separately displayed to the right.

When you jump to a reference, the file/sheet/cell address you came from is logged so that you can easily jump back to it.  Simply run the Show Cell References macro again and click the Back button.