Q&A
| Q1: | Why don't the tracer arrows display on my worksheet? |
| A1: | The Hide All option is probably selected in the Options dialog box. When the Hide All option is not selected, Excel displays the tracer arrows on your worksheets. If the option is selected, Excel does not display any tracer arrows when you audit your worksheets. Choose Tools, Options, and click the View tab. Make sure the Show All option is selected in the Objects section on the View tab. |
| Q2: | I clicked the Remove Precedents Arrows tool twice on the Formula Auditing toolbar to remove two levels of precedent tracer arrows. Why did Excel remove only one level of arrows? |
| A2: | The maximum number of tracer arrow levels is two: red and blue. Dependent and precedent tracer arrows are blue and ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
