ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you name the changing cells in a scenario? (https://www.excelbanter.com/excel-discussion-misc-queries/104793-how-do-you-name-changing-cells-scenario.html)

Natalie M

how do you name the changing cells in a scenario?
 
i am just learning about scenarios in Excel and i am trying to find out how
to name the 'changing cells' to something more relative than just the cell
reference



Debra Dalgleish

how do you name the changing cells in a scenario?
 
There are instructions here for naming cells:

http://www.contextures.com/xlNames01.html

And an example Scenario that uses named ranges:

http://www.contextures.com/xlScenario01.html

Natalie M wrote:
i am just learning about scenarios in Excel and i am trying to find out how
to name the 'changing cells' to something more relative than just the cell
reference




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com