View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dsttexas dsttexas is offline
external usenet poster
 
Posts: 1
Default Naming the Result Cells on a Scenario Summary

When I run a scenario summary, the Results section has labels that refer to
the cell(s). How do I have it display a meaningful text label in those cells?

Somehow I managed to do this some time ago when I first created the
spreadsheet and did a number of scenarios. Then I re-did some of the
formulas, and need to change the labels that refer to those results. I tried
various
Edit / Name actions on the the result cells themselves, but they still show
the original labels I somehow created some time ago. I can type over the
labels in the Scenario Summary sheet, but then have to do that again each
time I re-run the scenario.