How can I stop multi cell selection and only select the cell I am clicking on?

Leonie Hammill

Trying to click on one cell to make a quick change. An annoying blue box has appeared that selects the entire area between the cell I need and another random cell. How can I turn it off?

Paul Newcome

I had this issue a little over a year ago. I can't remember exactly what the cause/solution was. Try logging out, clearing your cookies and cache, then logging back in again.

Paul Newcome

@Andrée Starå If I understood correctly then basically what is happening is that you click on a single cell and it selects multiple cells.

Example:

Click on A1

A1:C4 are highlighted as if you selected those

Paul Newcome

I have had it happen once in SS and a couple of times in Excel. I can't remember for sure what the solution was for SS, but in Excel I just had to close out the workbook and reopen it.

Andrée Starå

Hi @Leonie Hammill

Not sure I follow!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

I had this issue a little over a year ago. I can't remember exactly what the cause/solution was. Try logging out, clearing your cookies and cache, then logging back in again.

Leonie Hammill

Thanks very much Paul.

Paul Newcome

@Andrée Starå If I understood correctly then basically what is happening is that you click on a single cell and it selects multiple cells.

Example:

Click on A1

A1:C4 are highlighted as if you selected those

Andrée Starå

@Paul Newcome

Aha! Strange!

Fortunately, I've never experienced it.

Paul Newcome

I have had it happen once in SS and a couple of times in Excel. I can't remember for sure what the solution was for SS, but in Excel I just had to close out the workbook and reopen it.

Leonie Hammill

Hi @Andrée Starå

Here's a screenshot: Click cell on row 125 (green highlight). Separate click to select a different cell on row 127 (yellow highlight). The blue frame selects all cells between the two clicks as if the shift key has been held down. Same issue when using keyboard arrows. I eventually stopped it after several reboots and clearing cache but can't figure out what I might be clicking on to make it start doing that in the first place. Thanks for your help.

Andrée Starå

@Leonie Hammill

Thanks for the clarification.

Happy to help!