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