How do you insert drop down values at the top of a column in Excel

R

Ron Coderre

If you want to set up an AutoFilter

Try this:
Select the data list

From the Excel Main Menu:
<data><filter><autofilter>

That will put drop-down arrows at the top of each column that can be used to
filter the data.

To remove them....repeat the process<data><filter><autofilter>

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
P

pebunn

Ron,

You answered my question but I wasn't clear what I need. After further
research, what I need to understand is how to do validations - that is, force
the user to only use one of four choices from a select list. I think that I
know how to do validations but in a clumsy way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Move Drop Down List to the Top of the Cell 0
Drop down in Graph (excel 2003) 2
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Print Macro w/drop down list 1
Missing information in autofilter drop down Excel 97 2
Drop down/data validation list 5
Utilizng full AutoFilter features while specific cells are protect 0

Top