Delete Dropdown Option in Numbers

A cell has two options in a drop down list. How can I remove one so that I don't have to keep re-selecting the one I want? Thank you.


MacBook Air, macOS 13.6

Posted on Nov 5, 2023 6:35 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 6, 2023 4:58 AM

Judging from your screenshot that may not be Pop-Up Menu.


Instead you may have 'Show suggestions when editing table cells' selected at Numbers > Settings.


If so, then the suggestions shown in your screenshot are automatically generated from the values in the cells in the same column (both above and below the cell you are editing).


To fix the problem go through the column and find the value that you don't want. Edit it to the correct value.


Then you won't get the "wrong" suggestion any more.


You can, of course, format the cells in the column as Pop-Up Menu to more carefully control the values that you input. But the automatic suggestions are a handy feature, often all that you need, and they require no work to set up.


SG


4 replies
Question marked as Top-ranking reply

Nov 6, 2023 4:58 AM in response to CM C

Judging from your screenshot that may not be Pop-Up Menu.


Instead you may have 'Show suggestions when editing table cells' selected at Numbers > Settings.


If so, then the suggestions shown in your screenshot are automatically generated from the values in the cells in the same column (both above and below the cell you are editing).


To fix the problem go through the column and find the value that you don't want. Edit it to the correct value.


Then you won't get the "wrong" suggestion any more.


You can, of course, format the cells in the column as Pop-Up Menu to more carefully control the values that you input. But the automatic suggestions are a handy feature, often all that you need, and they require no work to set up.


SG


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Delete Dropdown Option in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.