Make a Pop-Up Menu from Existing Values in Apple Numbers

Quick answer: Select the existing values, click Format in the toolbar, then open the Cell tab in the Format sidebar. Change Data Format to Pop-Up Menu. Numbers uses the selected values as choices, combines repeated values, and keeps each cell’s current selection. You can then add choices that are valid but not yet used. This is a cell control; you do not need an Excel-style Data Validation dialog. Apple’s control documentation describes this conversion.

Before you start

This walkthrough targets Numbers for Mac, using the 15.4 guide checked on October 15, 2026. Find your installed version under Numbers → About Numbers. The click paths below are for Mac, not Numbers for iCloud or the touch interface on iPad/iPhone. The current Mac guide identifies the documentation version.

Work on a copy of important data. The useful distinction is between existing records and the complete list of permitted choices. An option can be legitimate even when no current record uses it. For example, a new project tracker might have no completed projects yet, but still need a Done choice.

Practice with a small status column

Create a table named Projects, with one header row and two columns. Enter these values in A1:B9. Leave B7 genuinely empty; do not type the word “blank.” You can also download the synthetic status CSV. CSV contains the values only, so the menu must still be created in Numbers.

Task	Status
P-01	New
P-02	In progress
P-03	New
P-04	Blocked
P-05	Done
P-06
P-07	In progress
P-08	Done

Your starting inventory is two New, two In progress, one Blocked, two Done, and one unanswered status. Keeping that inventory unchanged is your first verification check.

Convert the existing values

1. Select B2:B9, excluding the Status header.
2. Click Format in the toolbar, open the Cell tab in the Format sidebar, then choose Pop-Up Menu from Data Format. If the sidebar is hidden, the toolbar button opens it; this is separate from the Format menu in the menu bar. Apple explains the sidebar controls.
3. Check the options list. It should contain the four project states, without a second New, In progress, or Done entry.
4. Choose Start with Blank below the list. Check P-06 remains unanswered and the other seven records retain their original status. If P-06 acquired a default, use the blank-menu recovery below for B7 only before continuing. Do not clear the whole status column.
5. Open P-01’s menu and choose Blocked. Its status should change; P-03 should still be New.
6. Choose New again for P-01 to restore the starting data before continuing.

The Status header should never appear as a choice. If it does, undo the conversion and repeat with only the body cells selected. For a real dataset, inspect values before converting: In progress and an accidentally space-padded label should not become two business categories. A helper using TRIM can help investigate ordinary extra spaces, but review cleaned values before replacing records.

Add a choice that no record uses yet

Suppose the team now needs On hold as a fifth state.

1. Select the same menu cells together.
2. In the options list, use + to add On hold.
3. Drag it to the preferred position, such as between Blocked and Done.
4. Check menus in both the first and last task rows. Each should offer the added choice.
5. Set P-06 to On hold. There should now be no unanswered status in the sample.

Do not type On hold over all eight cells to add an option. That would change your records rather than just the list of choices.

For ongoing maintenance, keep a written list of the allowed states beside the tracker or in its instructions. Treat “rename a choice” and “change historical records” as separate changes: after a rename or deletion, review affected records rather than assuming their meaning was migrated correctly. If Blocked is being replaced by Waiting for supplier, that narrower meaning may not fit every old blocked project.

Create a blank menu or recover an unwanted default

For a new empty task row, build its status menu explicitly. Use the same procedure to recover B7 if the earlier conversion gave that unanswered practice cell a default:

1. Select only the destination status cell. If recovering B7, choose Edit → Clear All from the menu bar to remove that cell’s data and formatting. Do this only because the sample specifies that B7 should be unanswered. A new, genuinely empty cell needs no clearing step. Apple documents Clear All.
2. Click Format in the toolbar and open the Cell tab in the Format sidebar. Set Data Format to Pop-Up Menu.
3. Replace the placeholder items with the reviewed choices: New, In progress, Blocked, and Done. Use + to add any missing items. Include On hold if you have already added that state to the rest of the tracker.
4. Choose Start with Blank below the list. Check that the destination is unanswered and offers the intended choices before entering a real status.

This deliberately rebuilds the control instead of assuming a clearing shortcut preserves it. Clear All also removes styling, so restore any desired fill or border afterwards. For the original sample, the other seven statuses should remain unchanged and the Done count should still be 2.

A normal copy-and-paste also copies the current value and can replace a legitimate existing status. When updating a populated column, select its menu cells together and edit their options instead of pasting one record across the column. Keep a backup before a large change.

This setup does not create a formula reference to a separate options table. If you later change a source list elsewhere in the spreadsheet, do not assume every existing menu has synchronized with it. Inspect and maintain the actual menu cells. UNIQUE can help prepare an inventory of values, but an inventory and a maintained menu are different things.

Check blanks, counts, and limits

For the original sample, a separate summary cell with =COUNTIF(Projects::B2:B9,"Done") should return 2. After changing P-06 to On hold, that result should still be 2. See COUNTIF for more examples. This count is a useful regression check: configuring a menu should not accidentally mark every task done.

• Blank versus default: Start with Blank is useful when an answer is required from a person. Start with First Item supplies a default for cells without a selection; use it only when that first state is genuinely appropriate.
• Two 250 limits: Apple documents seeding choices from up to 250 selected cells, and a maximum of 250 menu items. Do not select a huge imported column and assume every possible value was collected. Prepare a short, reviewed options list first.
• Numbers and dates: Numeric, date, and duration choices are supported. Avoid adding currency symbols or units as text when later formulas need a number.
• Missing option in one row: Compare that row’s menu with the cells you updated. It may not have been included in your selection or may have a different format.
• All blank cells show sample labels: If the original selection was entirely empty, replace the placeholder choices with your real list.

Verification and sources

The sample counts and row-by-row outcomes were checked independently. Apple documentation was checked on October 15–16, 2026. This tutorial was not tested in Apple Numbers, and no application screenshots were captured.

• Add controls to cells
• Copy, move, or delete cell content
• Numbers User Guide for Mac
• COUNTIF function reference