Forum Discussion
Excel scenario multiple cell selection issue
Hi,
I eventually solved the issue. Indeed I had same issue with some excel functions that request more than one parameters.
The problem was located in windows parameters where list separators was set to ';' and ','.
I removed the ',' and everything is now back to normal.
Multiple cell selection create list with ; separator now e.g. $G$27:$H$27;$B$11 instead of $G$27:$H$27 $B$11
Hi Francois,
If you'd like to add some value to all selected cell when select your cells, in formula bar type the value and press Ctrl+Enter
- HI Sergei,
Well, doesn't work.
What I've found is that when editing the scenario afterword only the first cell or vector appears. It looks like the extra cell is never saved, thus it does not ask for value.
Note that I'm using a french version of excel, that may be the issue here as I've seen somewhere that cells should be separated by ',' for me I only have something that look like space but is not.
Thanks,Perhaps I misunderstood your scenario, let me repeat. You select you cells, click on nothing
after that you by mouse focus on formula bar and type something (while you are typing the value will appear in the ast selected cell), at the end Ctrl+Enter
IMHO, it doesn't depend on which Excel SKU you use.
Hi,
What I mean about scenario is the feature available in data ribbon: "What-If Analysis"->"Scenario Manager". This allows saving use case (scenario) where some cells have pre-defined value.