Ho Do I create drop down menu? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Lu Roe 2/26/2005 1:55 PM PST   Question   I am doing invoices in Excel. Can I create a drop down menu for different categories in Excel?     Was this post helpful to you?         Reply |   Top           Debra Dalgleish 2/26/2005 2:27 PM PST   Answer   You can use Data Validation to create dropdown lists. There are instructions in Excel's help, and here: http://www.contextures.com/xlDataVal01.html Lu Roe wrote: > I am doing invoices in Excel. Can I create a drop down menu for different > categories in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html     Was this post helpful to you?         Reply |   Top           Lu Roe 2/28/2005 5:45 AM PST   Thank you Debra; I didn't know what to call it when I tried to look in "help". Lu "Debra Dalgleish" wrote: > You can use Data Validation to create dropdown lists. There are > instructions > in Excel's help, and here: > > http://www.contextures.com/xlDataVal01.html > > > Lu Roe wrote: > > I am doing invoices in Excel. Can I create a drop down menu for different > > categories in Excel? > > > -- > Debra Dalgleish > Excel FAQ, Tips & Book List > http://www.contextures.com/tiptech.html > >     Was this post helpful to you?         Reply |   Top           Diane 7/3/2009 7:40 AM PST   Thank you so much for the info & the link - very easy to following instructions!! "Debra Dalgleish" wrote: > You can use Data Validation to create dropdown lists. There are > instructions > in Excel's help, and here: > > http://www.contextures.com/xlDataVal01.html > > > Lu Roe wrote: > > I am doing invoices in Excel. Can I create a drop down menu for different > > categories in Excel? > > > -- > Debra Dalgleish > Excel FAQ, Tips & Book List > http://www.contextures.com/tiptech.html > >     Was this post helpful to you?         Reply |   Top           Debra Dalgleish 7/3/2009 6:25 PM PST   You're welcome! Glad the instructions helped. Diane wrote: > Thank you so much for the info & the link - very easy to following > instructions!! > > "Debra Dalgleish" wrote: > > >>You can use Data Validation to create dropdown lists. There are >>instructions >>in Excel's help, and here: >> >> http://www.contextures.com/xlDataVal01.html >> >> >>Lu Roe wrote: >> >>>I am doing invoices in Excel. Can I create a drop down menu for different >>>categories in Excel? >> >> >>-- >>Debra Dalgleish >>Excel FAQ, Tips & Book List >>http://www.contextures.com/tiptech.html >> >> > -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com     Was this post helpful to you?         Reply |   Top           Crayola 8/9/2009 7:20 AM PST   im curious as to how to create a drop down menu and display other information along side it. I have a list of movies which i want in a drop down menu, and when a movie is selected, it would along side it in other cell provide additional information to that selection ie: The Hulk when selected would provide additional information to the right of it, like size, etc.. "Debra Dalgleish" wrote: > You're welcome! Glad the instructions helped. > > Diane wrote: > > Thank you so much for the info & the link - very easy to following > > instructions!! > > > > "Debra Dalgleish" wrote: > > > > > >>You can use Data Validation to create dropdown lists. There are > >>instructions > >>in Excel's help, and here: > >> > >> http://www.contextures.com/xlDataVal01.html > >> > >> > >>Lu Roe wrote: > >> > >>>I am doing invoices in Excel. Can I create a drop down menu for different > >>>categories in Excel? > >> > >> > >>-- > >>Debra Dalgleish > >>Excel FAQ, Tips & Book List > >>http://www.contextures.com/tiptech.html > >> > >> > > > > > -- > Debra Dalgleish > Contextures > www.contextures.com/tiptech.html > Blog: http://blog.contextures.com > >     Was this post helpful to you?         Reply |   Top           T. Valko 8/9/2009 9:09 AM PST   See this: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Crayola" <Crayola@discussions.microsoft.com> wrote in message news:4521B85B-4448-41FF-AD20-259130E965A9@microsoft.com... > im curious as to how to create a drop down menu and display other > information > along side it. I have a list of movies which i want in a drop down menu, > and > when a movie is selected, it would along side it in other cell provide > additional information to that selection ie: The Hulk when selected would > provide additional information to the right of it, like size, etc.. > > "Debra Dalgleish" wrote: > >> You're welcome! Glad the instructions helped. >> >> Diane wrote: >> > Thank you so much for the info & the link - very easy to following >> > instructions!! >> > >> > "Debra Dalgleish" wrote: >> > >> > >> >>You can use Data Validation to create dropdown lists. There are >> >>instructions >> >>in Excel's help, and here: >> >> >> >> http://www.contextures.com/xlDataVal01.html >> >> >> >> >> >>Lu Roe wrote: >> >> >> >>>I am doing invoices in Excel. Can I create a drop down menu for >> >>>different >> >>>categories in Excel? >> >> >> >> >> >>-- >> >>Debra Dalgleish >> >>Excel FAQ, Tips & Book List >> >>http://www.contextures.com/tiptech.html >> >> >> >> >> > >> >> >> -- >> Debra Dalgleish >> Contextures >> www.contextures.com/tiptech.html >> Blog: http://blog.contextures.com >> >>     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies