O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required