How to make drop-down menus in MS Excel?

[Reephdweller]

Sometimes when I'm working on spreadsheets that get passed around through my company for data entry there will be fields in the spreadsheet with drop down menus to common entries in the tables.

Does anyone know how to do this? I have lots of repetetive entries I make that would probably be much easier if I could create a drop down list to just click something and move on.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
<B>Horde King Forever!! <strike>The Oracle Never!!</strike></B></center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[jocefus]

tools drop down menu -select options- click on the edit tab - and check the box that says "enable auto complete for cell values - then click OK... this should work for ya cuz i have to do the same thing at work and this saves so much time



http://scripts.cgispy.com/image.cgi?u=jocefus



Big ups to amy, aggie, satcam,adf and fluff for the sigs..

hey my man, what it look like

This message was edited by jocefus on 12-15-03 @ 3:39 PM

[jocefus]

did it work?

http://scripts.cgispy.com/image.cgi?u=jocefus



Big ups to amy, aggie, satcam,adf and fluff for the sigs..

hey my man, what it look like