Pop-up menu on IOS spreadsheet, doesn’t work?

Hello LoftyLady,

Formatting should transfer between files on your different devices. You can also add pop-up menus on iOS through the steps at Add controls to cells in Numbers on iPad - Apple Support

You can add a pop-up menu to a cell, then specify the items that appear in the pop-up menu.

Numbers recognizes menu items that are numeric values, including dates and durations, as well as text. Formulas can refer to cells where the pop-up menu is set to a numeric item.

1. Select a cell or range of cells, tap , then tap Format.
2. Tap  to the right of Pop-Up Menu (you may need to swipe up to see it).
3. If any of the cells you selected already contain data, the pop-up items are the values from the selected cells, for up to 100 cells (checkboxes are interpreted as “true” or “false” text, and star ratings are assigned their numeric value between 0 and 5). You can edit these options if you want. Repeated values in the cells are treated as a single pop-up menu item. The pop-up menu in each cell remains set to the cell’s original value.
4. If the cells you selected are empty, the pop-up items are placeholder items (“Item 1,” for example).
5. Tap an item in the list of options, then type the text that you want to appear in your pop-up menu.
6. Repeat this process for each item in the menu.
7. To add another item to the pop-up menu, tap , then type the text that you want to appear.
8. You can have up to 250 pop-up menu items.
9. Specify how the pop-up menu appears:

• Delete an item: Tap , then tap Delete.
• Rearrange the items: Drag  at the right of each item.
• Leave cells blank if no item has been chosen: Tap Blank.
• Display the first item in the pop-up menu as the default entry for cells in which no item has been chosen: Tap First Item.

10. When you’re finished editing the menu items, tap outside the list of pop-up options.

Thanks for using Apple Support Communities!