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:I want to hide sections in my Scenario Summary report. What should I do?
A1: Click on a minus sign (–) in the tree structure to the left of the row heading numbers in the Scenario Summary sheet. Excel hides the section in the report.
Q2:Can I pause the goal-seeking process so that I can stop and start whenever I want?
A2: Clicking the Pause button changes the choices in the Goal Seek Status dialog box to Stop and Continue.
Q3:Can I use the Goal Seek tool to change the value of two cells in a 3D Area chart?
A3: Sorry. When you use the Goal Seek tool to change the values in a chart, you can change the value of only one cell.

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