• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Drop-down lists in Excel

by on
in Excel Training,Office Technology

Q. How can I create a drop-down list in Excel?

A. You can accomplish this a couple of ways. If you have a specific set of choices you’d like work sheet users to choose from, and you want it restrictive (only these values), use the Data Validation tool (on the Data tab, Data tools group). Choose the List selection from the Allow: field. From here, you can type your values separated by a comma (like Yes, No, NA) or refer to a cell range or named range for your choices. 

To help users, complete the Input Message and Error Alert tabs, too. Alternatively, if you just want users to select from entries already entered in the column, all they have to do is right-click and choose Pick from Drop-down List.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/28241/drop-down-lists-in-excel "

Leave a Comment