under the radar for so long!. . .hardly any press or questions about these cool features.
My supervisor turned me on to tracing precedents and dependents on the formula tab. This provides a graphic visualization of how your worksheet ties itself together.
For eons I've been going to F2, or CTRL+~ to view formulas and from whence they cometh. (Not to mention certain squints that follow).
If you're not using these, give them a go. It's changing the way I work.
Cheerio.
Pete
Bookmarks