Following Links in Excel

A Name Box trick

Excel has a shortcut that allows you to follow a link to its source but it has a limitation find out how to get around that limitation.

If a cell has a formula like

=A1

Then the shortcut Ctrl + [ will take you directly to cell A1.

If you have a formula like

=A1-'Final Report'!A2

then Ctrl + [ will still take you to cell A1.

To get to ‘Final Report’!A2 takes a few steps.

This solution is more worthwhile in larger models where they are multiple sheets.

If you want to quickly navigate to the second reference ‘Final Report’!A2 then you can do this.

  1. In the Formula Bar or the cell select the whole reference and copy it using Ctrl + c. Make sure you include any apostrophes ‘.
  2. Press Esc.
  3. Click inside the Name Box (to the left of the Formula Bar above the column letters – see image below) and paste the reference Ctrl + v.
  4. Press Enter. This will take you to the cell or range.
  5. To return to where you were press F5 then press Enter.

This technique works for cells in the same sheet. Enter the cell reference in the Name Box and press Enter.

Please note: I reserve the right to delete comments that are offensive or off-topic.