Hi everyone,
Is it possible when auditing a formula to trace the dependent cells or to highlight them even if they are on another sheet ,because Excel 2003 only trace cells on exisiting sheet !
Thank you much .
Hi everyone,
Is it possible when auditing a formula to trace the dependent cells or to highlight them even if they are on another sheet ,because Excel 2003 only trace cells on exisiting sheet !
Thank you much .
If you have a cell on Sheet1 linked to say Sheet2!A1, when using the Formula Audit toolbar, trace precedents, it draws a dashed line to another sheet, if you double-click on the line it will open the "Go to" dialog box with the cell reference shown. If you click on that you go to the cell on Sheet2.
Another quick way to jump from the linked cell on Sheet1 to Sheet2!A1 is by double-clicking on the cell in Sheet1. Note: For this to work you must first go to Tools > Options > Edit and switch off "Edit directly in cell".
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
That worked well thank you much !
Glad to help - thanks for the feedback
Thank you. You help me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks