View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tracing precedent by double clicking cel tracing precedent by double clicking cel is offline
external usenet poster
 
Posts: 1
Default tracing precedent by double clicking cell

This is about tracing a precedent / dependent in an excel sheet. If we have
to trace either of these, toolsauditingtrace precedent/dependent command is
used, normally. However, i have seen on one excel sheet that this can be done
by simply double clicking the cell in/from which there is a reference. I am
surprised to see this as our work can be greatly reduced while tracing links.