Hi,
Is there any wasy way to find out where a cell is referenced, ofr example my workbook is currently based on planned days, but I want to chnge this to hours and I want to make sure that I update all the formulas that are impacted.
Any short cuts to suing my memory?!?!
Thanks,
Martin
Hi Martin,
A relatively easy method would be to select a cell and use either Tools -> Trace Precedents or Tools -> Trace Dependents
Precedents are cells that the formula in the current cell refers to. Dependents are cells that use the current cell in their formula.
hmmm that was pretty easy!!
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks