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 Best 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

There are no replies.

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 ID.