Microsoft Excel - How to Turn Off Auto-Selection of Multiple Cells

Anonymous
2020-11-13T00:09:21+00:00

Hello Microsoft Community,

I have Excel for my iPad Air 3. I’ve come across this problem that seems to randomly show itself when I am working on a spreadsheet. When using my apple pencil or fingers, I can click and move around no problem. Yet, sometimes, it then starts to auto-select multiple cells when I click a new cell. I need this to stop! I don’t know if I keep pressing some button? Searching through Google hasn’t revealed anything. I can’t get it to stop unless i restart Excel or turn off/on my ipad. But the problem keeps showing up.

As an example, let’s say I was working on B4. Once this wonky setting takes ahold, a new selection of cells is highlighted using B4 as its starting point if I click any other cell in the Excel spreadsheet.

Please help! Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

65 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-07T15:33:27+00:00

    I’ve been having this issue as well and it’s been driving me insane. I use my ipad with a keyboard and have just come across a fix. If you hold down shift and select a cell then the next time you select a cell it should revert back to normal. It appears Excel keeps getting stuck in its extended selection mode. If you use a keyboard it makes the bug vastly more manageable until Microsoft fix it!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-02-06T13:21:50+00:00

    I’m having the same problem. I see this has been going on for months. I only noticed it a few weeks ago (over the holidays, I believe) and it is maddening. Now, getting out of Excel and coming back in is no longer clearing the problem like I think it was weeks ago. 

    In any event, whoever said this is tied to a recent release is absolutely correct. It is not sufficient to continue to say “Next Level is working on it”. Let’s have a status: how many people are working on this and has it been escallated to a level above “Next Level”?

    This is a nightmare.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-02-04T10:54:59+00:00

    I have just done a full reboot of my iPad (5th gen) and the problem has gone away. I know this is a temporary fix but it is quite some time since it last happened to me. A fix would be much appreciated.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-02-01T03:02:58+00:00

    Hi, please add me on the loop wating for the asnwer from Microsoft.

    Thanks

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-01-31T11:39:40+00:00

    Hello, i would like to be added to this aswell.

    Please get this sorted

    thanks

    Was this answer helpful?

    0 comments