Apple Numbers | Advanced Drop Down Menus

▼This video will show you how to ▼
▻ Create an advanced Popup menu in Apple Numbers
▻ In all of my tutorials, I try and show you ways of doing various things using alternatives to what has already been demonstrated. There are always many ways of creating effects in all of the applications used. ▼
▼ ▬▬▬▬ Don't forget to: ▬▬▬▬▬▬▬▬▬ ▼
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
▼ Music (with thanks) ▼
License - Soundstripe.Com

[@ascolletti]

really doesn't solve the problem - the problem is I don't want to duplicate the list - I want to have a tab which controls the list and reference the list from other cells in other tabs

[@petrinusnigrum4096]

Yes, this is very easy to do in Excel but I have not found the way to do it either and it seems essential to me.

[@SanjaySinghChauhan007]

You want to link the any sheet to other sheet ...?

[@Vessekx]

@@SanjaySinghChauhan007 People want to link the contents of a dropdown list to a set of cells (row or column), such that adding/removing values from that set is dynamically reflected in the dropdown list. While the technique shown here is somewhat useful for spreadsheets where the list of potential values is fixed, or rarely changes, it doesn't really work if the lis of potential values is dynamic, such as being sourced from a database.

[@smlambert2]

@@Vessekx Anyone have anything on this? I am trying to make it dynamic as well. HR adds/Removes names and I add it to the schedule.

[@hugorefu]

Thanks Matt! Im having trouble seeing the values of a range of cells within one sheet in another sheet popup menu. Do you have a video showing that?

[@HasanBasriy]

Thanks for this tutorial. Have a question: if the initial list, from which you are creating the pop-up menu has several repeating values, does Numbers automatically drop them out?

[@antoniapeace9472]

Hi, great video, many thanks! Is there a way to be able to select multiple items from the one drop down list please?

[@MrPiggy102]

Is there a way like in Excel where you would be able to type in that box if you choose to? It's too inconvenience to click on the drop down menu everything single entry.

[@benfohdo]

Hey mate, excellent video Can you explain if it is possible to assign a value to a different section/ sections of the spreadsheet based on the item you select in the pop up menu cell .. I’m creating a spreadsheet for my macros and would like to automatically populate my macros in the row next to my pop up cells ( meals )

[@pauls7056]

Thanks MattBlak. I only wanted to know how to do drop down options. But I had a list of countries. So your video was really helpful because I never even thought of how tedious it would be to type out 200 countries - so you were way ahead and solved my two problems: one I knew I had and the other I didn't know I had!! Thanks again. Great video. Liked and subscribed.

[@MattBlakPhoto]

Awesome - Really glad this helped

[@nounix]

can you make a link on Numbers that opens a video (and possibly choose vlc player to open it) or photo that's stored on your drive, rather than link a webpage?

[@outdoorlifecampground]

Nice clear and concise explanation.....I am a regular user of Numbers, and I learned something new....! Thanks!

[@MattBlakPhoto]

Thank you for the kind comment. 👊

[@visakanmurugesan6778]

Hi, Let me know how to create a dependent pop ups in numbers? is it possible?

[@WilliamCerniuk]

Generating a drop down menu from a list of items in the spreadsheet was way too easy. Been doing it the hard way (manually) for years. Kudos to you!

[@MattBlakPhoto]

Hope this saves you lots of time. 👍

[@simondimasb]

thank you!

[@felippearruda]

Is there a way to import the items to the pop up list from a different spreadsheet? As in I want the option in the pop up list from sheet 1 but the pop up list menu is on spreadsheet 2

[@khamisy]

thanks 😊

[@psfarr1]

Hi Matt, at my wits end.. I have created an expense sheet with drop down categories. How can I sort the categories and have totals display for each category?

[@MattBlakPhoto]

Hi Patricia - I would really need to see what you have set up and how.

[@ernestoditerribile]

Is there a way to clear certain cells on a form with 1 button on a form

[@sashadon]

Thank you Matt!

[@MattBlakPhoto]

Very welcome.

[@dheeladheel]

How do I add a drop down to select dates in a column?

[@Vessekx]

Is there a way to do this *dynamically*, based on the contents of the other table? Such that, if you add an additional row/column to the reference table, it automatically shows up in the drop-down?

[@cbebutuoy]

Brilliant. Thank you.

[@MattBlakPhoto]

Very welcome

[@u2ulifetripqueen185]

thank you very much for your video, it really help!😁

[@fabian8050]

Hey, thanks for showing how to create a drop down menu. This makes it easier if you have repeating values. It would be great to categorize cells by color instead of repeating words you use like Name 1, Name 2, Name 3.... Do you know if it's possible to set up different colors for single values in a drop down menu? Like working with a cell named status to have a faster look what status it is (open - red, in progress - yellow, done - green)

[@MattBlakPhoto]

Yes you can do this by Conditional formatting. 👊

[@fabian8050]

@@MattBlakPhoto thx

[@MattBlakPhoto]

@@fabian8050 Very Welcome.

[@troybordes6111]

Great info. If I want my pop up menu to reflect, in another cell, a different format dependent on which item I choose in pop up menu, can I do it? Pop up menu shows: package 1, package 2, package 3, package 4. I would like, In another cell, to populate different currency values specific to each package.

[@troybordes6111]

I’d like my other cell to be dependent on my pop up menu, but in a different format with different values.

[@MattBlakPhoto]

@@troybordes6111 Hey Troy - You would need to use the 'IF' statement.

[@oscarhaffmans3001]

Excellent. Much obliged.

[@MattBlakPhoto]

Thank you.

[@leilannybosch2609]

@MattBlak this is great, I'm a fairly new to Numbers and still learning my way. In Excel, you can reference a List, which is nice because you can update that list separately and your dropdown is automatically updated. Is there something like that for numbers that you are aware of?

[@MattBlakPhoto]

You can (ish) but not as you would in Excel. You would need to create a list of your pop-ups and add to it. You would then get the option to merge.

[@Terracotta_Me]

Could you do a video on this please? I’m hoping to have a file where I can have a dropdown in one sheet reference a list in another sheet that I can change and update to update the dropdown rather than having to go into the dropdown interface

[@WhiteSuburbanite]

Is there a rule so each item on the menu can only be selected once? So that once I've selected "Item 1" it no longer appears as an option on subsequent menus?

[@jackcruickshanks]

Hi, great video as always.I can't seem to find an answer for my question anywhere, but I'm sure if it's possible you'll know. I'm making a budget spreadsheet and want to track my finances by month. I have made a pop up menu with the items being each month of the year to differentiate and save space. Below the pop up menu table I have three more larger tables, with my income, expenses and savings. What I would like to know is this - is it possible for me to select each month within the pop up menu and have different tables appear underneath with the relevant data for each month. I'm sure it would be an if function but I'm struggling and would be grateful for your help. Show less

[@chrisheath5233]

This is great, thanks. If only I found this before I manually added each option (around 150) to a pop-up list. Is it possible to reverse the process so I don't have to manually build the list in a spreadsheet for comparison with another list?

[@MattBlakPhoto]

Hi Chris - I'm not certain what you are asking? Maybe copy and paste your pop up options into another list?

[@chrisheath5233]

@@MattBlakPhoto Thanks Matt. In the end I recreated/replaced the popup menu using you method.

[@ComunidadeAtman]

thankkkkkkkksssssss

[@MattBlakPhoto]

Very welllcoommeeeee

[@Nassi415]

Hi, I am looking to make a drop down menu that then automates a price for each item if chosen in the list... For example> Drop down menu you choose 1 bottle of shampoo> the price will automatically show in the next box. Help?

[@MattBlakPhoto]

Conditional Formatting. I have a video on how to do it I think.

[@emmabinns2316]

Hi once you have created a drop don list can you format them to if you have a yes or no for example could you format them to different colours? thanks

[@MattBlakPhoto]

Hi Emma - This video will show you how: kzbin.info/www/bejne/jIe5pWOPpJWbaNU

[@emmabinns2316]

@@MattBlakPhoto Thank you, i found it, great help, while i am here dont suppose you have a video about using a pen on macbook or any reviews which one would be good ?

[@MattBlakPhoto]

@@emmabinns2316 Very welcome.

[@nounix]

Why can you not right-click on a cell in Numbers and just add a hyperlink to a file on your hard disk, just like you can do in Excel?? In Excel (even in a very old 2011 version..) I can just right click on a cell, and add a hyperlink to a file anywhere on my disk (and if it's a video, for example, the video files is opened with VLC player which is the default player I have selected to open videos. Simple.). Is it possible that in the year 2020 Numbers is still so far behind Excel?? Or is this function "hidden" somewhere Numbers and I just can't find it??

[@MattBlakPhoto]

You can - Highlight the text or contents of the cell... Hit Cmd+K You're welcome. 👍

[@nounix]

MattBlak thanks but I don’t think you read the question... cmd+k for Mac or cntr+k for windows is the universal shortcut to add a hyperlink. We all know that. As I wrote in Numbers there is no way to add a hyperlink TO A FILE STORED ON THE MAC whereas in Excel you can. Numbers only gives you an option to link to a url on the internet - NOT to a file on your disk like Excel can and could...

[@mdhondt1703]

How do you add a value to each of the pop up section? Thanks M

[@MattBlakPhoto]

Hi - You just highlight the option in the inspector window. Hope this is what you meant?

[@MiPromotordeSalud]

How do you protect the cell so the drop down menu is accessible in a shared file, but users are NOT able to delete the drop down menu and use the cell as free text?

[@kentshook3840]

FWIW, if you want a single popup, you'll need to copy and paste first, make all of the list items into popups, and then copy and paste a single one to where you want it before deleting the rest of them. I had tried selecting the items and copying them, then going to where I wanted my popup and still got Item 1, Item 2, Item 3. Making all the items into popups, and then copy and pasting one of those to where you want it works.

[@brealtorealestatebrokerage2404]

How to create a dropdown menu with image?

[@ScottTaylors]

The drop-down list only works when it’s in edit mode. How do I correct that?

[@syahrudin-rudi-7804]

How to make this, if I choose name 1 there will be show table a, and if I choose name 2 there will be show table b. sorry if my english bad

[@bionic909]

Can you have a pop up menu for borders?

[@MattBlakPhoto]

For borders or with borders?

[@bionic909]

@@MattBlakPhoto for borders

[@lisabrackenridge6022]

Hi is it possible for Numbers to have a dependent drop down list?

[@MattBlakPhoto]

Yes - Create your list then in the other cell type =then click in the cell with the required list. 👍

[@kingznqueenztv]

I need the transcript please

[@ajchieflc]

Great explanation but so many redundant extra steps

[@googooproof]

good info but the music is distracting

[@MattBlakPhoto]

Thanks for the feedback - I just got the audio levels wrong. Aplogies.

[@seth.miller]

Apple Numbers is not as smart as Microsoft Excel regarding this issue.

[@MattBlakPhoto]

Totally agree.

[@andriyivanov4810]

To complicate!