You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I create a drop down list in numbers 4.0.5?

Hi struggling trying to work with numbers, bit of a novice with numbers so bare with me...


How do I create a drop down list in numbers 4.0.5?


Urgently need this for a project.


Thanks in advance!

MacBook Air (13-inch Mid 2013), macOS Sierra (10.12.3)

Posted on Jan 28, 2017 12:09 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 28, 2017 1:11 PM

Do this:


User uploaded file

List the items to be on the pop-up menu in one column of a table.

Select the cells containing the item list.

Click the Format brush and choose Cell

Use the pop-up menu showing Automatic to change the cell format to Pop-up menu.

If you want the menus to include a "blank" rather than display the first item make that change with the pop-up menu below the item list in the Inspector. The 'blank' choice will be seen as "None" when the menu is opened, but will display as an empty cell when the menu is not active.

All of the cells are now pop-up menu cells.

User uploaded file

To place the same menu anywhere in the document,

select the cell, press option-command-C to copy the format,

select the target cell, press option-command-V to paste the format.


Regards,

Barry

4 replies
Question marked as Top-ranking reply

Jan 28, 2017 1:11 PM in response to supermanssandles

Do this:


User uploaded file

List the items to be on the pop-up menu in one column of a table.

Select the cells containing the item list.

Click the Format brush and choose Cell

Use the pop-up menu showing Automatic to change the cell format to Pop-up menu.

If you want the menus to include a "blank" rather than display the first item make that change with the pop-up menu below the item list in the Inspector. The 'blank' choice will be seen as "None" when the menu is opened, but will display as an empty cell when the menu is not active.

All of the cells are now pop-up menu cells.

User uploaded file

To place the same menu anywhere in the document,

select the cell, press option-command-C to copy the format,

select the target cell, press option-command-V to paste the format.


Regards,

Barry

How do I create a drop down list in numbers 4.0.5?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.