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 Tutorials

Make a Drop Down List Menu in a Cell in Excel
I'll show you how to make a drop down list menu in a cell in Excel.  This allows you to have a list appear when yo ...
Make Your Macros Available in All Workbooks in Excel
In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook. To do this we need t ...
How to Quickly Find Data Anywhere in Excel
Finding specific records and/or cells is easy when using the Find tool in Excel. It is located within the Find & ...
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as well as adding text to t ...

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!



Could someone please assist on how to format the drop down menus so that when a selection is made, it is no longer available in the other drop down menus? I've attached the sheet in question, and the idea is that, through limiting the selections as they are picked, the same team cannot be picked twice.


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 have drop down menus (on several sheets), all offering the same list of choices, and I would like to synchronize them, i.e. if I change the choice on any of the drop down menus, also the choices on all the other drop down menus should change accordingly.

How do I do that?

Thanks for any suggestions!



I'm still pretty inexperienced with Excel and I'm trying to figure out how if I change entries on a drop down menu it will clear out all other drop down menus based on that selection. IE, if I change the city from Houston to Dallas, the sub drop down menus would all be cleared out. I've attached a very dumbed down version of what I'm trying to accomplish. I'm pretty sure I will have to write something into macros and I have no idea how to do that. Any help would be greatly be appreciated. Thanks!

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

I'm New to excel and asking if its possible to insert drop down menus (to select different data) into individual cells?
Thanks for any advice.

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,

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.


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!

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

how do i create drop down menus on specific cells??

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?

I've created a table that features client details such as name, address, licences, Date of birth etc and 4 fields that have drop down menus - all feautring the same data. They list different jobs.

When filling in the form, client details are added and then people can select up to 4 different jobs from the drop down menus. This shows up in the table fine.

What im trying to do is create a query that shows a certain job.
It seemed to work by adding a particular job in the criteria field in the design view in query.

For example i added "Gardener" to the first column and only clients with the job Gardener show, which good. What i need is for it too read all 4 columns (4 drop down menus) and pick them out. Some people may add a certain job first, while others may put it 2nd, 3rd or 4th.

Is there a way to do this?

Im hoping to do it for every job and then create reports.

thank you for any help.

I tried searching but I couldn't find anything to address this.

I have a few drop down menu's on an excel spreadsheet. One of the drop down menus lists products. What I want to do is have another column next to that which inserts the price for the product selected in the drop down menu.

Is there an easy way to accomplish this task? How.

Thank you for taking the time to read my question.


I recently updated a rather complicated spreadsheet to include many drop down menus to eliminate the need for repetitive typing. The spreadsheet's formulas worked great across each worksheet, but since I've decided to add in these drop down menus all of the formulas do not update automatically. I have to go to each cell with a formula and refresh the cell for the formula to work, and this would take way too long to refresh each cell after each week. I also have MoreFunc installed, FYI. Please, any help on troubleshooting this problem would be great. Thanks.

I need to create a sheet that has drop down menus on it. I was wondering if
there was a way to link the drop down list to another workbook, because there
are going to be several different workbooks that use the same menus. I would
like to have it so that i need to only change one instance of the list rather
than going into each file and changing the list in there.