scenario summary

[lezawang]

In scenario summery, excel would show cell reference not cell title. for example
if I have in cell
A1 = Loan, B1= 15000

In the scenario summery excel will show
$B$1 1500

I was thinking if there is a way to replace $B$1 with word Loan automatically? I know I can do the report and change that manually.

Thanks

 

[HackSlash]

It's called a "named range"

see here:
https://support.office.com/en-us/ar...formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64