Trace Precedents in Excel: Find Formulas, Functions and Cells Connected to a Cell

Have you ever inherited a worksheet that someone else set up or you created and haven’t played in for some time? If you need to update the formulas and functions, but do not know what other calculations will be affected you could quickly make a lot of work for yourself! You might also be hunting a miscalculation and need to know where the formula is grabbing data from.

Excel offers a simple way to review which cells are both dependent on and depended upon by other cells. The feature is called trace precedents and dependents.

Find Formulas, Functions and Cells Connected to a Cell

  1. Open your workbook to a sheet that contains cells with precedents or dependents.
  2. Select the cell in which you want to check precedents and/or dependents.
  3. Click the Trace Precedents or Trace Dependents button in the Formula Auditing group of the Formulas tab.

  1. Arrows leading from the selected cell extend and point to those cells that use its data in their calculations. You can now go work on the data in the dependent cells using the arrows for reference.

  1. When you are through working with the data for that cell, click the Remove Arrows button to clear all precedent and dependent arrows from the screen.

Use trace precedents and dependents to repair formulas and functions, make updates without breaking your spreadsheet, and to quickly visualize all the data impacted by your calculations.

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

Oct. 7

Eastern Time Zone

Oct. 12

Eastern Time Zone

Oct. 13

Central Time Zone

Oct. 14

Pacific Time Zone

Oct. 18

Eastern Time Zone

Oct. 19

Central Time Zone

Oct. 25

Pacific Time Zone

Oct. 27

Central Time Zone

Oct. 28

Eastern Time Zone

Nov. 1

Central Time Zone

Nov. 3

Pacific Time Zone

Nov. 4

Eastern Time Zone

Nov. 8

Eastern Time Zone

Nov. 9

Central Time Zone

Nov. 10

Pacific Time Zone

Nov. 15

Pacific Time Zone

Nov. 16

Eastern Time Zone

Nov. 18

Central Time Zone

Nov. 29

Eastern Time Zone

Dec. 1

Pacific Time Zone

Dec. 2

Central Time Zone

Dec. 6

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 16

Eastern Time Zone

Dec. 20

Pacific Time Zone

Dec. 21

Central Time Zone

Jan. 5

Eastern Time Zone

Jan. 6

Central Time Zone

Jan. 10

Central Time Zone

Jan. 12

Eastern Time Zone

Jan. 13

Pacific Time Zone

Jan. 18

Pacific Time Zone

Jan. 19

Central Time Zone

Jan. 20

Eastern Time Zone

Jan. 24

Eastern Time Zone

Jan. 25

Central Time Zone

Jan. 26

Pacific Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

Oct. 11

Eastern Time Zone

Oct. 12

Central Time Zone

Oct. 13

Pacific Time Zone

Oct. 17

Eastern Time Zone

Oct. 18

Central Time Zone

Oct. 24

Pacific Time Zone

Oct. 26

Central Time Zone

Oct. 27

Eastern Time Zone

Oct. 31

Central Time Zone

Nov. 2

Pacific Time Zone

Nov. 3

Eastern Time Zone

Nov. 7

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 9

Pacific Time Zone

Nov. 14

Pacific Time Zone

Nov. 15

Eastern Time Zone

Nov. 17

Central Time Zone

Nov. 28

Eastern Time Zone

Nov. 30

Pacific Time Zone

Dec. 1

Central Time Zone

Dec. 5

Central Time Zone

Dec. 7

Eastern Time Zone

Dec. 8

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 19

Pacific Time Zone

Dec. 20

Central Time Zone

Jan. 4

Eastern Time Zone

Jan. 5

Central Time Zone

Jan. 9

Central Time Zone

Jan. 11

Eastern Time Zone

Jan. 12

Pacific Time Zone

Jan. 17

Pacific Time Zone

Jan. 18

Central Time Zone

Jan. 19

Eastern Time Zone

Jan. 23

Eastern Time Zone

Jan. 24

Central Time Zone

Jan. 25

Pacific Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

Oct. 11

Central Time Zone

Oct. 12

Pacific Time Zone

Oct. 20

Central Time Zone

Oct. 21

Eastern Time Zone

Oct. 24

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 7

Central Time Zone

Nov. 10

Pacific Time Zone

Nov. 15

Central Time Zone

Nov. 17

Eastern Time Zone

Nov. 29

Pacific Time Zone

Nov. 30

Central Time Zone

Dec. 5

Eastern Time Zone

Dec. 9

Central Time Zone

Dec. 15

Eastern Time Zone

Dec. 21

Pacific Time Zone

Jan. 4

Central Time Zone

Jan. 9

Pacific Time Zone

Jan. 10

Eastern Time Zone

Jan. 17

Central Time Zone

Jan. 18

Eastern Time Zone

Jan. 26

Central Time Zone

Jan. 27

Pacific Time Zone

Related Excel® Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories

1 Comment