excel spreadsheet

[paulz]

I wanted to create a 'drop down list' on an excel spreadsheet that you use to select an option. Can't find how you do it in Help. Any ideas? I know the list[s] of data needs to be on the same sheet.

[rinkytink]

Create the list that you want to appear in the drop down box - with each list item in a different cell. Then select a new empty cell and go to the toolbar and select data then validation. You will be presented with a data validation window. From the data validation drop down select list. Then click the 'button' at the end of the source box. Highlight the cells that contain the list you created earlier and click the 'button' again. Then click okay. Your previously blank cell should now have a drop down containing the contents of your listed cells.

[paulz]

rinkytink - top answer, so easy & quick. Why on earth couldn't I find it in Help? Thanks again for that ;+))

[rinkytink]

As with most microsoft applications Excel help does tend to be rather cr*p !!