Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracing cell formulas to other spreadsheets on the same workbook
I work on large workbooks that consist of many spreadsheets. Some of the cell
formulae consist of using many cells from different spreadsheets. I know that pressing F2 will show you where the formula is from when all of its components are on the same spreadsheet. However, I don't know how to track the formula when its components are on different spreadsheets of the same workbook. I would really appreciate any advice on how to "work-out" where the multi-cell, multi-sheet formulas are coming from. Cheers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracing cell formulas to other spreadsheets on the same workbook
The Formula Auditing toolbar will likely help you. ToolsFormula
AuditingShow Auditing toolbar. Select a cell and click: Show Precedents button from the toolbar. If your precedents are in another sheet you will get an arrow on which you can double-click. HTH Kostis Vezerides On Dec 10, 5:11 pm, John Smith wrote: I work on large workbooks that consist of many spreadsheets. Some of the cell formulae consist of using many cells from different spreadsheets. I know that pressing F2 will show you where the formula is from when all of its components are on the same spreadsheet. However, I don't know how to track the formula when its components are on different spreadsheets of the same workbook. I would really appreciate any advice on how to "work-out" where the multi-cell, multi-sheet formulas are coming from. Cheers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fomula tracing | Links and Linking in Excel | |||
Looking for alphabet tracing | Excel Discussion (Misc queries) | |||
Tracing precedents | Excel Worksheet Functions | |||
tracing precedent by double clicking cell | Excel Discussion (Misc queries) | |||
Tracing Dependents | Excel Discussion (Misc queries) |