Drop down lists without having a range?

[nightracer]

Hi

Not used drop down lists before - is there a way to put a drop down on a cell without having the options as a range somewhere in the workbook?

i.e. need Monday, Tuesday, Wednesday etc as the options in the list, but without having them as a range somewhere else.

I'm sure its easy!

Many thanks

 

[jeffreybrown]

If you do not want to use a range of cells or a named range, then in the data validation box just hard code your requirements.

 

[nightracer]

thanks, nice to know there is a way, but where do i hard code it?
Am looking in data validation, which options do i select?

Thanks again

 

[RoryA]

List, then in the source box type your entries separated by commas. Note you are limited to 255 characters.

 

[GlennUK]

Data/Validation/List
Monday, Tuesday, Wednesday etc in the Source box.

 

[nightracer]

Magic, thanks, sorry for being so dumb!