| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
ToolsAuditingShow Auditing Tool Bar
Once you can see the auditing tool bar click on the cell that contains the formula and press the "Trace Precendents" button on the new toolbar. This will show you which cells are providing data. If this isn't what you want to do then please post more details. "chrisatminara" wrote: How do I locate a cell that provides data to a formula ? A cell reference is needed. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Formula for copying data for every 8th cell | Setting up and Configuration of Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Formula to Seperate data in 1 cell | Excel Worksheet Functions | |||
Threaded Mode
