Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!


Free Excel Forum

Adding Drop Down Menus To A Spreadsheet

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

How do I add drop down menus at the top of each column that will both store
and allow for easy retrieval of any entries in the cells beneath?

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows yo
Remove All Data Validation from a Cell in Excel
- Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you need
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Highlight the Column of the Selected Cell
- This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid back
Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active cell w

Similar Topics

I am trying to force movement between multiple drop down menus. The menus are independent of one another. I want the user to only be able to select the information in the menus.

I put together a form with drop down menus in. No macro's in the workbook, just some drop down menus in a work book with a few hidden columns and some basic protection. The protection is not on the drop down menu cells.

I designed the workbook using Excel 2007, but have shared it with a number of people since who are using Office 2003, and Office 20007. No problems. Everyone can see the drop down menus and is able to populate them.

There's one colleague who opens the workbook and doesn't see any of the drop downs. The guy is using Office 2003 SP2. I have no idea why he doesn't see them. Does anyone have any thoughts?

Hi ya..
Got a quick question about Drop Down Menus.. I just learned how to create them thru Data validation. After making my own drop down menus i was wondering if there is a Keyboard shortcut to scroll down my options inside the dropdown menus without using the mouse but just the keyboard??
I hope that my question is understood.. Thanks for your time


Hi there,

I have a number of drop-down menus on my spreadsheet that I've drawn using the Forms toolbar. I currently have a macro that clears the sheet so that it's blank for the next user. Does anybody know how I can get the macro to clear these drop-down menus (or get them back to the first selection in the drop-down menu), as at the moment they still contain the selection that the last user made.

Many thanks!


I have a problem. I have in excel 07 created a document which contains drop-down menus, and they work perfectly. When i send the document to my collegue, who use excel 10, the drop-down menus (and everything else) works perfect, but when he makes changes and saves the document, some of the drop-down menus dissapear when i open it in 07.
The changes my collegue make are NOT in the drop-down menus.

Any ideas of what goes wrong?

I learnt how to do drop down menus for cells, but I would like the drop down
menu to display one word but enter in a different character in the cell when
it is selected.

I'm fairly new to Ecxel. I have to create a spreadsheet that will have 26 (possibly more) columns, with each cell on each row containing drop down menus. I was wondering if there was a way of bringing up a screen that summarises these columns, rather like the 'forms' option in the 'data' menu? It would have to include all the drop down menus and would have to populate the original spreadsheet with the contents of these menus as they are selected. Hope that makes sense!

I have three drop down boxes.

Is it possible that when they select a line in one of the menus it will show a number in the drop down box?

Also if the above worked. Would it be possible to then calculate the three numbers?

Thanks for your help

Hello all, this is my first post.

I am designing a form in excel, and one of the requirements is to have auto-populating drop down menus that get their data from external .xls documents. I've been able to create drop down menus, and I've figured out how to import data, but for the life of me I can't figure out how to make a drop down from the imported data without disconnecting the data from it's source. Does that make sense? does anybody have any ideas?

Thanks in advance.

I want to link 2 drop menus for example one cells is make of car, drop down menu consists of: Audi, BMW, Peugeot,Ford etc and depending on the selection I want the next drop down menu to change model ie if Audi selected the next cell will show: A2 A3 A4 A6 A8 TT etc. Any ideas???

Is there a way to restrict users from pasting into cells with drop down menus. I cannot lock the worksheet because I need to keep many functions available. Thanks

I have an excel sheet that is comprised of 20+ questions, each connected to a seperate drop down menu by an IF Statement. The drop down menus are sometimes connected to another question or they are connected to a solution (sort of like "Choose your own adventure" books).

If they go back to the beginning and choose a different adventure (I'll continue with that theme), the previous selections from the drop down menus are still there. I created a macro to clear the contents of the menus, but it is only if the user wants to start completely over. So if the user just wants to take a couple steps back, is there a macro to clear the contents of the drop down menu if the cell next to it is blank?

Thank you!

Hi there,
I'm stuck on a puzzling formula I'm creating for a client, and am in desperate need of help.
What I want to do (and have done) is set up 2 drop down menus.
My drop down menus are in column A, Row 1 and 2.

Drop down 1 - looks up a list of publications (Column C)
Drop down 2 - looks up months (Row 1, Column D-O)

What I want to do is when my client drops down the publication they want, and the month they want, it will tell me the cost of that publication in A3.

I have attached my example of what I'm trying to do.
All help would be greatly appreciated.
Kind regards,

Afternoon all,

Is it possible to look up data using drop down menus? I've attached an example of what i'm trying to achieve. I'd like to be able to change the drop downs in cells A1 and B1 and pull through the data from the relevant tab into cells B2 to B4.

Thanks in advance,


I am working on an excel spreadsheet that I got from some one else and I need some help. The document contains a couple of Data Entry Forms that contain drop down menus in them. I want to add a couple of more options to the drop down menus and I can't figure out how to do it. I can edit the cell that it inputs the data to but I can't figure out how to edit the drop down menus. Any help would be greatly appreciated.

Also, I am in no way an excel master so just that you know that you may have to keep it simple.


Hi, I am working on setting up some drop down menus, but the problem I am having is, I want to bring up a an address from multiple cells. I want to pull the company name from the drop down and then have their full address, phone, fax, contact, etc to show up. Is this possible, and if so, could someone please explain to me how to do this?

Thanks so much.


I need to create drop down menus based on the previous fields. So, for example, The first drop down would have the option for 1-8. Then, based on what they select there, the next field would have a drop down for a-y. Then to finalize it, based on what the user selects in the first two fields, a final drop down menu would appear with 1-99. The issue is I need it specific. So, for example, if a user selects 6 from the first drop down menu, they will only see m-p in the second drop down. If the user then selects o from the 2nd drop down, they will only see 80-84 in the last drop down.

To throw one more wrench into it, some selections for the a-y and 1-99 may be the same. So 1.b may be Operations-Invoices which also may be the same for 5.s but under a different preceding drop down selection like Customer Service-Invoices.

I am trying to make a series of drop-down menus wherein the list used for the
second drop-down changes based on what is selected in the first drop-down.
Because there are more than seven options in the first menu, I can't just do
an =IF() function. Is there any way to force the calculation of a reference
within another formula? For example, if I have named lists A, B, and C and
the first drop-down menu in A1 contains the options A, B, and C, how do I get
the drop-down menu in A2 to read A1 as a list name instead of a text item?

If there is no way to do this, does anyone have alternate ideas (other than
the obvious making one giant list that is sorted but not actually separated)?

-Lisa Fox

Good morning,
I have an excel worksheet that has a column of drop down menus. Each row has a drop down menu and the cell link is a cell in the same row but different column. Is there anyway I can copy the drop down menus down for each row and have the cell link change, as well, so it follows the rows down.

I hope I explained what I need well.
Thank you!


How do I add drop down menus to a field - so one can list options and
change them quickly?


Any good Excel Tutorial sites posted?



My apologies if I missed the threads containing the information I'm looking for.

In a nutshell, I am trying to have a cell (C1) output a certain value depending on the selections of the drop down menus in cells A1 and B1.

I have no experience with VB so I would like to avoid it if possible, but I will use it if I must.

For examples sake I would like my menus to each contain the numbers 1-4 (the easy part) and I would like C1 to output "Greater than", "Less than", or "Equal to".

I have a spreadsheet (attached) designed to calculate the savings a customer can make by using our energy saving lights compared to their existing lights. We have upgraded our range, and I would like to introduce some options which reflect this.

However, the drop down menus incorporating this information seem to be locked in some way, and I cannot access or modify the formulas or data that they refer to.

You will see that the first menu includes the kinds of lights that the customer already has, and the one below has details of our lights. The titles for the menus are located in cells X7 and onwards. But as I say, the formulas remain elusive. How can I reach them? Thank you for your time.

I was wondering if it is possible for a macro to get information from the
drop down menus; specifically the File-Save and SaveAs menus. I would like
to get the name of the file the spreadsheet is being saved as, without using
Workbook.FullName or GetSaveAsFilename. I have searched in Excel VBA help,
books and online, but haven't seen anything listed.
Paul S

Apologies firstly to the forum as i am not an excel expert at by any means, but have taken it upon myself to go about designing an estimate spreadsheet for my printing business, now I wish I hadn't.

The main problem is I have created alot of cells with drop down lists using data validation in them, to speed up the quoting process! Firstly i have to say the drop down menus work fine as they are.

These drop down lists include all the variants for the printing business ie: quantity, size, paper cost, printing cost, finishing costs etc...

Each of these drop down menus items needs a value and or the ability to store a formula so i can generate the final price, including profit margins. This is proving very hard. (i can do the formula) but each drop down item has a different value. i am stuck and a newbie, please help, i can email the file and even pay someone to do this for me, its taken me all weekend.

please help. or if somebody has a spreadsheet to work out printing companies estimates i would love to see it or anything similar.

thanks in advance

Can somebody please point me in the right direction, i can email the file

I have a cell with a possible 5 drop-down menus. I want this cell to display only one of the drop-downs depending on a code that was entered in another cell (another drop-down menu). Is this possible and how would one go about this?