Drop Down Menu
in [Functions]
|
From: Alan D on 28 Apr 2010 12:34 I am having trouble with the drop down menu, I create a list called operations hit enter and then choose a cell like the instructions suggest, choose the list and hit save and I get my comments to show up but no drop down arrow, can someone help me? -- Best Regards Alan D "Can''t Cache Me" wrote: > I have list of people that I am constinly putting into different spreadsheets > for various reasons. I want to be able to set up a drop down menu that lists > everyones names that I usually use on my spreadsheets, and then, after I > press the enter button all of their contact info shows up in the cells either > below or next to the one that has the drop down menu. How do I go about > doing that?
From: Luke M on 28 Apr 2010 14:54 To create drop down, select the cell you want, then goto Data - Validation. Select List, and then type your list, or choose the range of cells containing your list. -- Best Regards, Luke M "Alan D" <AlanD(a)discussions.microsoft.com> wrote in message news:F10BA1B9-5D87-44A3-AF66-F39F052B27BC(a)microsoft.com... >I am having trouble with the drop down menu, I create a list called > operations hit enter and then choose a cell like the instructions suggest, > choose the list and hit save and I get my comments to show up but no drop > down arrow, can someone help me? > > > > -- > Best Regards > > Alan D > > > "Can''t Cache Me" wrote: > >> I have list of people that I am constinly putting into different >> spreadsheets >> for various reasons. I want to be able to set up a drop down menu that >> lists >> everyones names that I usually use on my spreadsheets, and then, after I >> press the enter button all of their contact info shows up in the cells >> either >> below or next to the one that has the drop down menu. How do I go about >> doing that?
|
Pages: 1 Prev: How do I get warpped data to auto fit in merged cells? Next: Pivot Table Comparison |