Share via

Android, excel. Some cells have down arrows in them. How to get rid of these arrows?

Anonymous
2023-11-20T22:12:04+00:00

Some cells have down arrows in them. How to get rid of them?

Microsoft 365 and Office | Excel | For home | Android

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 No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2023-12-20T13:50:57+00:00

    I'm also experiencing a problem where dropdown arrows suddenly appeared on each cell of a row in my excel document while I was using Excel on an Android device. I cannot find the Data Validation options on my version of Excel. From what I have read, they probably do not exist in my version of Excel. How did this bogus data validation dropdown setting get set on my row if my version of Excel doesn't even support data validation? I never open this file on anything but my phone.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-11-21T11:45:54+00:00

    down arrows

    What kind of down arrows?

    Can you share your file?

    Hi peiyezhu.

    If this page told me how to include an attachment, then I could send a screenshot.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-11-21T11:08:20+00:00

    Hi Shalom.

    Thank you for your detailed response.

    I can follow your instructions down to clicking on "Edit". However, this simply opens the window at the bottom of the screen, containing the fx ribbon/box and the on-screen keyboard. (Just like clicking on any cell). I cannot see a "data validation rule". Where should I look for this?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-11-21T01:02:34+00:00

    Hello Caerbryn,

    I'm Shalom and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    To remove these arrows, you can follow these steps:

    1. Select the Cell: Tap on the cell containing the down arrow to select it.
    2. Edit the Cell: After selecting the cell, tap on the formula bar or the cell itself to enter edit mode.
    3. Remove Data Validation:
    • Once in edit mode, look for the data validation rule that is causing the down arrow. This could be a drop-down list, date picker, or some other validation.
    • Delete the existing data validation rule or modify it as needed.
    1. Finish Editing:
    • After removing or modifying the data validation rule, press "Enter" on your keyboard or tap outside the cell to finish editing.

    If you have multiple cells with the same data validation rule, you might need to repeat these steps for each affected cell.

    Best Regards, Shalom

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2023-11-21T00:51:42+00:00

    down arrows

    What kind of down arrows?

    Can you share your file?

    Was this answer helpful?

    0 comments No comments