📞 01223 214177 ✉️ karen@roem.co.uk
📞 01223 214177 ✉️ karen@roem.co.uk
Are you using somebody else's Excel files, but don't have a clue what's going on? Or perhaps the formulas in the workbook are rather complicated and all over the place, making it hard to tell which cells are used. Maybe you use the Show Formulas button or the (rather unintuitive) keyboard shortcut CTRL+` (see tip 238 (tip_238.php) if you don't know what I'm talking about) but did you know you can display arrows that indicate what cells affect the value of the currently selected cell or those cells that are affected by the value of the currently selected cell?
Here's how:
A blue tracing arrow is displayed, connecting the selected cell to each of its precedents or dependents, assuming, of course, that the cell has a precedent or dependent.
When you double-click the blue line the cell you toggle between the two cells.
To remove tracing arrows from a worksheet click on the Remove Arrows button in the Formula Auditing group on the Formulas tab, or click on the arrow next to the Remove Arrows button and click on Remove Precedent Arrows or Remove Dependent Arrows.
By the way, we're celebrating ten years of top tips to help you 'tame your computer'. My enthusiasm for making technology work well for people has never waned and I look forward to continuing to help you make the most of your software.
.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.
