Editing Pop-Up Menus in Numbers

A frequently asked question in the Numbers forum is: "Why can't I create a list of items that will automatically allow Drop Downs (Excel Speak) to change the menu items in a Numbers Pop-Up Menu (Numbers Speak), just as we can in Excel".

We can. But the list is not in a separate table; the list is within every Pop-Up Menu.

Select all the Pop-Ups that you want to edit (Column A in this example). You will see something like this:

Suppose that we want to delete Bananas from that list of Pop-Ups.

In the Format Panel on the right, click on the menu item Bananas, then click on the minus ("-") symbol.

Goodbye to 'Bananas'.

Hello to 'Choose a fruit' (the default 'Start with first item'... or 'Start with Blank')

Now add a fruit.

Click on the plus ("+") symbol to see New Item

Type a name (Lemons) and it will appear in every selected Pop-Up.

Hello Lemons!

And the good news is that other cells retain their chosen value.

Note: the selected Pop-Ups need not be selected all at once. You can Merge:

In My Humble Opinion, the list of Menu Items in Numbers > Format Panel > Pop-Up Menu is the equivalent of a list somewhere in an Excel Sheet.

All comments welcome.

Regards,

Ian.