| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Dependencies
Is there anything similar to the 'Object Dependencies' function in Access for
cells/forumlae in Excel? I've taken over a spreadsheet that needs a massive overhaul and want to see which cells reference a cell that I may alter? Ta |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Dependencies
Move to a cell with a formula and the click TOOLS, FORMULA AUDITING and
select TRACE DEPENDENTS. Repeat the process and select TRACE PRECEDENTS -- Kevin Backmann "Andy" wrote: Is there anything similar to the 'Object Dependencies' function in Access for cells/forumlae in Excel? I've taken over a spreadsheet that needs a massive overhaul and want to see which cells reference a cell that I may alter? Ta |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Dependencies
You can also select a multiple cells and press F5 and then click the SPECIAL
command button and select PRECEDENTS or DEPENDENTS. This will highlight the cells instead of showing auditing arrows -- Kevin Backmann "Andy" wrote: Is there anything similar to the 'Object Dependencies' function in Access for cells/forumlae in Excel? I've taken over a spreadsheet that needs a massive overhaul and want to see which cells reference a cell that I may alter? Ta |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation dependencies | Excel Worksheet Functions | |||
| Excel Lists Dependencies | New Users to Excel | |||
| No Record Source, no dependencies? | Charts and Charting in Excel | |||
| Named ranges with dependencies | Excel Discussion (Misc queries) | |||
| List Dependencies | Excel Discussion (Misc queries) | |||
Linear Mode
