Q: Dynamic Pop-up Menus
Part 1: Is it possible to have a pop-up menu reference a group of cells on a different table? I want the pop-up menu to get populated with the values in the other cells. Let me give you an example:
A1 = Banana
A2 = Orange
A3 = Apple
I would like to have a pop-up menu (on a different sheet) read:
Banana
Orange
Apple
Part 2: If Part 1 was possible, is it also possible to have the pop-up menu update itself automatically? Let's say I add A4 = Pineapple to my table. Could I get my pop-up menu to automatically have "Pineapple" as an option or must I manually type it in as a selection?
Thank you so much for your help. I have tried to find this answer but have had no luck. Have a good day.
MacBook Air, OS X Mavericks (10.9.4)
Posted on Aug 12, 2014 7:51 PM
Hi GW,
Creating a Pop-Up Menu in Numbers 3 is very easy.
In a spare table or column, enter the values that you want to populate the Pop-up.
Select those cells.
Format Panel > Cell > Data Format > Pop-Up Menu
Done. They are now Pop-Up menus
Click on the upside-down triangle to show the menu items
I would like to have a pop-up menu (on a different sheet) read:
Banana
Orange
Apple
You can now copy and paste any one of those cells to another table (on the same or a different sheet). The menu choices will be carried over.
is it also possible to have the pop-up menu update itself automatically? Let's say I add A4 = Pineapple to my table. Could I get my pop-up menu to automatically have "Pineapple" as an option or must I manually type it in as a selection?
No. Not automatically. Numbers does not allow dynamic update from a table to a Pop-Up Menu.
(Apologies to quinn. I misread the original question).
To add an item to a Pop-Up, use the add button:
Or start from scratch with a new list
Regards,
Ian.
Posted on Aug 13, 2014 6:22 AM








