View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default How do you insert drop down values at the top of a column in Excel

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)

"pebunn" wrote in message
...