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

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.

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.

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?

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.

4. 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

down arrows

What kind of down arrows？

Can you share your file？