How to Find the Sheet a Formula Is Pulling From

A cell shows a number, but the formula behind it points somewhere you cannot see, and you need to know which sheet or which file it reads from. The reference is spelled out in the formula itself, in a shorthand that is hard to read at a glance. These steps decode it and jump you straight to the source.

Read the formula bar

Click the cell and look at the formula bar. A reference to another sheet in the same workbook looks like this:

='Q3 Sales'!B14

The part before the exclamation point is the sheet name, wrapped in single quotes when it contains spaces. A reference to a different workbook adds the file name in square brackets:

='[Budget 2026.xlsx]Summary'!B14

If that workbook is closed, the full folder path appears in front of the file name as well.

Jump to the source cell

With the cell selected, press Ctrl + [ (Mac: Cmd + [). Excel selects the cells the formula reads from directly, switching to the other sheet if needed. If the formula reads from several places, all of them on the first source sheet are selected. Press F5 (Mac: Ctrl + G) and then Enter to return to where you started.

Trace the arrows

Go to Formulas, Trace Precedents. Blue arrows point from each source cell to the formula. A dashed black line ending in a small worksheet icon means the source is on another sheet or in another workbook. Double-click that dashed line to open a Go To list of the off-sheet references, then click one and press OK to jump there. Formulas, Remove Arrows clears the display.

List the external workbooks

Go to Data, Edit Links in the Queries & Connections group. The dialog lists every outside workbook this file reads from, its status, and its folder. Open Source opens the file; Change Source repoints the link if the file has moved. If the button is grayed out, the workbook has no external links.

Search every formula for the reference

Press Ctrl + F (Mac: Cmd + F), open Options, set Look in to Formulas and Within to Workbook. Search for the sheet name to find every formula that reads from it, or search for [ to find every external reference. Find All returns a clickable list of matches.

If this is Google Sheets. Click the cell and press Enter to edit it. Each referenced range is color coded and named in the formula text, in the same 'Sheet name'!B14 form. Data from another spreadsheet comes through IMPORTRANGE, and the source spreadsheet's URL is written in the formula itself.