LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 457
Default Drop Down Menu

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" wrote in message
...
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
Drop Down Menu TJAC Excel Discussion (Misc queries) 2 February 1st 06 03:01 PM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM
Drop Down Menu srf1030 Excel Discussion (Misc queries) 5 June 16th 05 07:49 PM
Drop down menu Pong Excel Discussion (Misc queries) 12 March 22nd 05 08:34 PM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"