I need help with Excel 2013, setting up drop down menu's

I need Excel 2013 help. Attached is a picture of what I'm asking for help with. The picture shows a column of items w/ a drop down menu. This is an existing worksheet and it has the drop down with check boxes. I need I need help to set this up on a new worksheet. I can't seem to set this up. I appreciate any help that someone can provide. Thanks!! Chris
DropQuestion.jpg
clynch1330Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Those dropdowns and checkboxex are inserted automatically when you apply a filter to your data set.
On any worksheet where you want to setup the same dropdown with checkboxex, follow these steps...

1) Select any cell in the header row.
2) Go to Data Tab --> Click on Filter and this will apply the same dropdown options within your column headers.


OR

1) Select any cell in the header row.
2) Press Ctrl+Shift+L. It's a shortcut key to apply filter on a data set.

Note: Remember that pressing Ctrl+Shift+L again will remove the filter you applied to the data set.
0
 
Omar SoudaniSystem Support EngineerCommented:
There is no attachment. Can you re upload?
0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
Please try this
dropdown.png
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Answered the original question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.