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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Good morning
I need some advice - expertise.
I need a drop down menu of names ( 50 ), and need to reference those names from a different sheet. I have several rows and want to pull those names into different cells, rather than type those names individually.
Your input and advise is greatly appreciated.
I am currently using Numbers 3.6.1 and OS X Yosemite.
Thank you.
Numbers has two main ways to provide a list of values when entering data.
One is the Pop-up Menu Data Format.
Another is auto-complete or auto-suggest (or various other names), which is activated by checking 'Show suggestions when editing table cell s' Numbers > Preferences:
Once that is checked, Numbers will suggest values when you enter data in a column of cells.
SG
Hi John,
Expanding on SG's first answer, this is what happens when you select a column that already has values in it and convert it to a popup format. Each cell is a popup containing all the values as choices. In my example I could copy the cell after name11 and paste it to my second table.
quinn
Drop down menu reference from another sheet
