Announcement: Announcing the newest addition to Apple Support Communities, Apple Arcade!

If you have a question or knowledge to share with the community, we want to hear from you.

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

Question:

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

Reply
Question marked as Helpful

Jan 28, 2017 1:11 PM in response to supermanssandles 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

There’s more to the conversation

Read all replies
Question marked as Helpful

Jan 28, 2017 1:11 PM in response to supermanssandles 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

Jan 28, 2017 1:11 PM

Reply Helpful (6)
User profile for user: supermanssandles

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