Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scenario Summary

Scenario Summary

ResolvedVersion 2007

Mon 20 Feb 2012, 12:03 Delegate Jill said...

Jill has attended:
Excel Intermediate course
Excel Advanced course

Scenario Summary

Whenever I create a scneario summary, the fields for changinng cells and result cells comes up with the cell reference (i.e. $C$4) and not the name of the cell.

Help.

Mon 20 Feb 2012, 14:51 Trainer Simon said...

RE: Scenario Summary

Hi Jill,

Thank you for your question.

Did you name the cells before creating the Scenario summary? If not delete the summary sheet and create the summary again.

Tell me how you get on.

Regards

Simon

Mon 27 Feb 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Scenario Summary

Scenario Summary

RE: Scenario Summary

Excel articles

Excel tip:

Importing Numbers in Excel 2010