Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert drop down values at the top of a column in Excel
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert drop down values at the top of a column in E
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. "Ron Coderre" wrote: 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 ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert drop down values at the top of a column in Excel
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "pebunn" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a drop down list button from an excel worksheet? | Excel Worksheet Functions | |||
How do I choose multiple values in an excel drop down box? | Excel Discussion (Misc queries) | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
Can you insert a vertical scrolling field in excel? Not a drop dow | Excel Worksheet Functions | |||
How do u insert a drop down menu in a Excel | Excel Worksheet Functions |