Cell Names in Scenario Summaries

B

Bufo Calvin

Does anyone know a way to get a Scenario Summary to
automatically show Names for cells (assuming they exist)
rather than the cell references?

For example, a Scenario Summary will show:

$A$1 500
$B$1 1000

when those cells might be named "Dogs" and "Cats".

I can always copy and paste afterwards, but that's not
very elegant.

TIA
 
D

Debra Dalgleish

The Scenario Summary should automatically use the cell names, instead of
the cell references.

Check the Names List (Insert>Name>Define to see if the names exist.
 
B

Bufo Calvin

Thanks!

That wasn't the problem, but it pointed me to the
answer. I was incorrectly expecting it to list the key
values (the leftmost column), not the changing cells.
 
Top