Is it hard to make a drop down choice field

[XL Rookie]

I am creating a sheet and want to allow the user to choose from given fields in a drop down. How hard is this....I do not code but can copy and paste ;-}

thanks,
Kimberly

 

[T. Valko]

I am creating a sheet and want to allow the user to choose from given fields in a drop down. How hard is this....I do not code but can copy and paste ;-}

thanks,
Kimberly

Here are a couple of videos on how to setup a data validation drop down list.

Excel versions 2003 and earlier
http://youtube.com/watch?v=t2OsWJijrOM

Excel versions 2007 and later
http://www.youtube.com/watch?v=fI7XCv07AAg

 

[XL Rookie]

Bill, thank you SO much! I can't believe it is that easy!

KImberly

 

[sous2817]

Please don't share with people how easy it is, it lessens the mystic

 

[XL Rookie]

One question,can I add an option in the dropdown for them to type text if by chance an option wasn't mentioned?

THanks
Kimberly

 

[XL Rookie]

Ha! Don't worry Sous....they think I can work magic around here at work....I don't tell them about my dirty little secret...this forum!

Kimberly​

 

[T. Valko]

One question,can I add an option in the dropdown for them to type text if by chance an option wasn't mentioned?

THanks
Kimberly

In the setup process select the Error Alert tab.

If you uncheck where it says: Show error alert after...

Then you'll be able to type in items of your choice.

 

[XL Rookie]

sweet! thx !!
Kimberly

 

[XL Rookie]

it is working great. Just one more question, I was trying to create my list on a seperate tab and it didn't seem to let me. Can I do this?

Kimberly

 

[sous2817]

Put the list on another sheet and then name that range. In your data validation box, where you put in your range, press F3 and select the named range from that list.