Donate SIGN UP

spreadsheets

Avatar Image
booboo67 | 11:37 Mon 21st Jul 2008 | Computers
3 Answers
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
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by booboo67. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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



Question Author
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
Question Author
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

1 to 3 of 3rss feed

Do you know the answer?

spreadsheets

Answer Question >>