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
    2020-11-16T02:23:41+00:00

    I can not find an built-in recorder on my iPad. I understand that there is a Voice Memos app, but I have found nothing in my iPad nor an explanation on Google about a built-in screen recorder.

    This issue happens on more than one document.

    It’s just happened right now. If it is just from clicking and dragging, how do I get it to stop? I don’t think this is what is causing the problem, but if it is, how would I stop it from selecting more cells as I click around the excel document?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-01-08T15:50:52+00:00

    I’ve paid for the 365 subscription and have the same challenge.  I don’t recall this being a problem in prior years so it appears tied to some update to the app.  It’s so annoying.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-01-03T14:46:09+00:00

    Same issue here...very frustrating

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2021-01-03T09:22:07+00:00

    I have a ipad Pro, use Excel everyday, no problems until this morning.  Application selecting multiple cells a same time when I tap on a single cell.  I tried it with different file, same problem.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2020-11-23T03:45:44+00:00

    Hi Everyone,

    Thank you for bringing this to our attention.

    Your concern regarding the automatic selection of Multiple cells using Excel for iOS is under investigation and we are coordinating with our Internal support team to get this addressed as soon as possible. We will get back to you as soon as we’ve got updates from them.

    Please Standby.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments