select range for data validation in numbers

Unfortunately you cannot populate a Pop-Up Menu automatically from a range of cells using Data Validation the way you can in Excel.

You can, however list all your values in column, select them, and set the Data Format to Pop-Up Menu. This will create a Pop-up Menu in each cell. You can copy-paste one anywhere you like.

However, there is a limit to the number of items you can have in a Pop-Up Menu. Over 10-15 or so starts to get unwieldy anyway.

SG

You can have 250 items in a pop up menu. You can have many different pop up menus or many of the same pop up menu in the document. "Many" = thousands or millions, I don't think there is a limit.

The major drawback of pop up menus vs data validation is when you need to change an item in the menu. With data validation, you change/add the item in the list in the table and all cells that use that range for data validation will get the new item. With pop up menus, none of the existing popups get the new value. You have to create a new pop up menu and copy/paste it where the new one is needed. I hope one day they design "dynamic" pop up menus that create themselves dynamically from a range in a table, similar to data validation.

Hi **,

Badunit wrote:

The major drawback of pop up menus vs data validation is when you need to change an item in the menu. With data validation, you change/add the item in the list in the table and all cells that use that range for data validation will get the new item. With pop up menus, none of the existing popups get the new value. You have to create a new pop up menu and copy/paste it where the new one is needed. I hope one day they design "dynamic" pop up menus that create themselves dynamically from a range in a table, similar to data validation.

Please see Maintaining Multiple Common Drop down lis… - Apple Community

Kind regards,

Ian.