spreadsheets

[booboo67]

i'm ok with spreadsheets and have managed so far to set them up as i want them to. but i am just wondering how i would do the following......... i have a coloum of cells where i have to type where a certain job was ie. london. is there a way that i could assign say london as 1 reading as 2 bournemouth as 3 exeter as 4 etc. so that i dont need to type the place name just the pre assigned number and then the place name comes up?
thanks

[Bushwhacker]

Why not just put a dropdown list in each cell that contains the options London, Bournemouth & Exeter ??

In a new column create a list of what is required in the dropdown (London, Bournemouth & Exeter)

In the cell/s you require the dropdown, go to the top menu : Data then Validation.

In the Allow section, select List and complete the source data field with your list.

With OK, the dropdown should appear when the cell is selected.

Good Luck - Give me a shout if you are stuck

BW

[booboo67]

thanks for the quick answer...........
however, i've created a list in a new column, ive gone to the cells i require the drop down in, but i cant see data in any of the top menu.........
i am using microsoft works spreadsheet.......... would that be why?
thanks

[booboo67]

thought it may be because of the word spreadsheet, so have just installed open office and moved my spreadsheet to there. your instructions were brilliant........... thankyou
i'm all sorted now!
thanks v much