Home » FORUMS » Computers, Networking & other technologies » Microsoft Windows

Please help Excel!!!



sUnShyne
sUnShyne's picture
I'm Trusted Premium Member!I donated to The GuG !
GuGee Since: 2007-04-20
GuG-Points: 124
Last Seen: 09/06/2008 - 6:16pm
Location: California

I am: Luvin TheGuG

Submitted by sUnShyne on January 30, 2008 - 3:25pm.

I need to make one of the areas in excel in to a drop down menu but i cant remember how to do it. does any know?

‹ no calculator??? no.. .wordpad??? blocked websites ›


login or register to post comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Hot2na
I'm Trusted Premium Member!Hall-MonitorAwesome Member!Certifed Apple loverJob Well Done!!Looked at and admired by many!Mystery BadgeOMG Someone Bought Me This Badge!OMG someone ELSE paid $1 to put this badge on me!Someone Bought Me This Badge!Someone ELSE paid $1 to put this badge on me!Someone ELSE paid $1 to put this badge on me!Certified Member Helper
GuGee Since: 30-Jan-2007
GuG-Points: 5540
Last Seen: 09/06/2008 - 10:29pm
Location: In the Book of Legends!

I am: Legendary

Re: Please help Excel!!!
February 11, 2008 - 7:38am

Select the cell from which you want to create the drop down menu/list. Then go to:

Data, then click,

Validation, and then click the Settings tab.

In the Allow box click List.

Then click the range of cells you wish to be in that drop down menu/list.

 

 

 

Is this chicken, what I have, or is this fish? I know it's tuna, but it… it says "Chicken of the Sea".

--


login or register to post comments