Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

goal seek

ResolvedVersion 2003

Kerry has attended:
Excel Advanced course

Goal Seek

When you've run a goal seek on a cell can you then turn the goal seek off to return the cell to normal?

RE: Goal Seek

Hello Kerry

Thank you for your question and welcome to the forum.

After you have used the goal seek, if you click Cancel rather than OK, the formula will display it's original result.

Kind regards
Amanda

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.