Quizzes & Puzzles5 mins ago
spreadsheets
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
thanks
Answers
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
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