SOLVED
Home

Excel scenario multiple cell selection issue

%3CLINGO-SUB%20id%3D%22lingo-sub-352009%22%20slang%3D%22en-US%22%3EExcel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352009%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20try%20to%20use%20scenario%20to%20change%203%20cells%20content.%3C%2FP%3E%3CP%3EI%20type%20a%20name%20then%20I%20select%20the%203%20cells%20by%20using%20ctrl%2Bclick%20(as%20usual)%3A%20I%20get%20%24G%2427%20%24H%2427%20%24B%2411%20then%20I%20click%20OK.%3C%2FP%3E%3CP%3EAt%20that%20time%20only%20one%20cell%20is%20proposed%20for%20data%20value%3A%20the%20first%20one%20so%20%24G%2427.%3C%2FP%3E%3CP%3EI%20tried%20also%20to%20select%20%24G%2427%20%24H%2427%20as%20a%20vector%3A%20so%20I%20get%20%24G%2427%3A%24H%2427%20%24B%2411.%20In%20this%20case%20the%202%20first%20rows%20are%20proposed%20for%20value%20changing%20but%20not%20the%20third%20one...%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3EThanks%20for%20support.%3C%2FP%3E%3CP%3EBT%2C%20Francois%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355204%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355204%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20eventually%20solved%20the%20issue.%20Indeed%20I%20had%20same%20issue%20with%20some%20excel%20functions%20that%20request%20more%20than%20one%20parameters.%3C%2FP%3E%3CP%3EThe%20problem%20was%20located%20in%20windows%20parameters%20where%20list%20separators%20was%20set%20to%20'%3B'%20and%20'%2C'.%3C%2FP%3E%3CP%3EI%20removed%20the%20'%2C'%20and%20everything%20is%20now%20back%20to%20normal.%3C%2FP%3E%3CP%3EMultiple%20cell%20selection%20create%20list%20with%20%3B%20separator%20now%26nbsp%3B%20e.g.%20%24G%2427%3A%24H%2427%3B%24B%2411%20instead%20of%20%24G%2427%3A%24H%2427%20%24B%2411%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353168%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353168%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ENobody%20else%20has%20same%20issue%20I%20have%20%3F%3C%2FP%3E%3CP%3ERegards%3CBR%20%2F%3EFrancois%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352043%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWhat%20I%20mean%20about%20scenario%20is%20the%20feature%20available%20in%20data%20ribbon%3A%20%22What-If%20Analysis%22-%26gt%3B%22Scenario%20Manager%22.%20This%20allows%20saving%20use%20case%20(scenario)%20where%20some%20cells%20have%20pre-defined%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352030%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352030%22%20slang%3D%22en-US%22%3E%3CP%3EPerhaps%20I%20misunderstood%20your%20scenario%2C%20let%20me%20repeat.%20You%20select%20you%20cells%2C%20click%20on%20nothing%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20491px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83388i7483C781F37FDAA6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eafter%20that%20you%20by%20mouse%20focus%20on%20formula%20bar%20and%20type%20something%20(while%20you%20are%20typing%20the%20value%20will%20appear%20in%20the%20ast%20selected%20cell)%2C%20at%20the%20end%20Ctrl%2BEnter%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83389i99ECAD0809F7A9D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIMHO%2C%20it%20doesn't%20depend%20on%20which%20Excel%20SKU%20you%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352022%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352022%22%20slang%3D%22en-US%22%3EHI%20Sergei%2C%3CBR%20%2F%3EWell%2C%20doesn't%20work.%3CBR%20%2F%3EWhat%20I've%20found%20is%20that%20when%20editing%20the%20scenario%20afterword%20only%20the%20first%20cell%20or%20vector%20appears.%20It%20looks%20like%20the%20extra%20cell%20is%20never%20saved%2C%20thus%20it%20does%20not%20ask%20for%20value.%3CBR%20%2F%3ENote%20that%20I'm%20using%20a%20french%20version%20of%20excel%2C%20that%20may%20be%20the%20issue%20here%20as%20I've%20seen%20somewhere%20that%20cells%20should%20be%20separated%20by%20'%2C'%20for%20me%20I%20only%20have%20something%20that%20look%20like%20space%20but%20is%20not.%3CBR%20%2F%3EThanks%2C%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352013%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20scenario%20multiple%20cell%20selection%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352013%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Francois%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you'd%20like%20to%20add%20some%20value%20to%20all%20selected%20cell%20when%20select%20your%20cells%2C%20in%20formula%20bar%20type%20the%20value%20and%20press%20Ctrl%2BEnter%3C%2FP%3E%3C%2FLINGO-BODY%3E
Franf44
Occasional Contributor

Hi,

I try to use scenario to change 3 cells content.

I type a name then I select the 3 cells by using ctrl+click (as usual): I get $G$27 $H$27 $B$11 then I click OK.

At that time only one cell is proposed for data value: the first one so $G$27.

I tried also to select $G$27 $H$27 as a vector: so I get $G$27:$H$27 $B$11. In this case the 2 first rows are proposed for value changing but not the third one...

What am I doing wrong?

Thanks for support.

BT, Francois

6 Replies

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

image.png

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

image.png

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.

Hi,

Nobody else has same issue I have ?

Regards
Francois

Solution

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies