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.

Trace Precedents_image 1

  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.

Trace Precedents_image 2

  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.

Trace Precedents_image 3

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> Basics

Microsoft® Excel® Basics

May. 31

Eastern Time Zone

Jun. 1

Central Time Zone

Jun. 5

Eastern Time Zone

Jun. 7

Pacific Time Zone

Jun. 8

Central Time Zone

Jun. 12

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 15

Eastern Time Zone

Jun. 20

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 26

Pacific Time Zone

Jun. 27

Central Time Zone

Jun. 28

Eastern Time Zone

Jul. 5

Eastern Time Zone

Jul. 10

Eastern Time Zone

Jul. 11

Pacific Time Zone

Jul. 13

Central Time Zone

Jul. 17

Central Time Zone

Jul. 18

Eastern Time Zone

Jul. 19

Central Time Zone

Jul. 20

Pacific Time Zone

Jul. 24

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Eastern Time Zone

Jul. 31

Pacific Time Zone

Aug. 1

Central Time Zone

Aug. 3

Eastern Time Zone

Aug. 8

Pacific Time Zone

Aug. 9

Central Time Zone

Aug. 15

Eastern Time Zone

Aug. 17

Central Time Zone

Aug. 21

Central Time Zone

Aug. 23

Pacific Time Zone

Aug. 24

Eastern Time Zone

Aug. 28

Pacific Time Zone

Aug. 30

Eastern Time Zone

Sep. 6

Eastern Time Zone

Sep. 7

Central Time Zone

Sep. 11

Central Time Zone

Sep. 12

Eastern Time Zone

Sep. 14

Pacific Time Zone

Sep. 18

Pacific Time Zone

Sep. 20

Central Time Zone

Sep. 21

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 27

Eastern Time Zone

Sep. 28

Central Time Zone

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

Microsoft® Excel®: Beyond the Basics

Jun. 1

Eastern Time Zone

Jun. 2

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 8

Pacific Time Zone

Jun. 9

Central Time Zone

Jun. 13

Central Time Zone

Jun. 14

Pacific Time Zone

Jun. 16

Eastern Time Zone

Jun. 21

Eastern Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Pacific Time Zone

Jun. 28

Central Time Zone

Jun. 29

Eastern Time Zone

Jul. 6

Eastern Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Pacific Time Zone

Jul. 14

Central Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 20

Central Time Zone

Jul. 21

Pacific Time Zone

Jul. 25

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Eastern Time Zone

Aug. 1

Pacific Time Zone

Aug. 2

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 9

Pacific Time Zone

Aug. 10

Central Time Zone

Aug. 16

Eastern Time Zone

Aug. 18

Central Time Zone

Aug. 22

Central Time Zone

Aug. 24

Pacific Time Zone

Aug. 25

Eastern Time Zone

Aug. 29

Pacific Time Zone

Aug. 31

Eastern Time Zone

Sep. 7

Eastern Time Zone

Sep. 8

Central Time Zone

Sep. 12

Central Time Zone

Sep. 13

Eastern Time Zone

Sep. 15

Pacific Time Zone

Sep. 19

Pacific Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 27

Pacific Time Zone

Sep. 28

Eastern Time Zone

Sep. 29

Central 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

Jun. 2

Eastern Time Zone

Jun. 7

Eastern Time Zone

Jun. 9

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 19

Central Time Zone

Jun. 20

Eastern Time Zone

Jun. 29

Pacific Time Zone

Jul. 5

Pacific Time Zone

Jul. 10

Central Time Zone

Jul. 14

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 25

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 8

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 22

Pacific Time Zone

Aug. 23

Central Time Zone

Aug. 28

Eastern Time Zone

Aug. 31

Central Time Zone

Sep. 8

Eastern Time Zone

Sep. 11

Central Time Zone

Sep. 20

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 28

Central 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