Donate SIGN UP

Spreadsheet - Drop down menu

Avatar Image
muchlovex | 12:58 Wed 24th Oct 2007 | Technology
1 Answers
i am trying to create a drop down menu with days of the week in it, so i can click on a weekday.

Please could you tell me how to do this?
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by muchlovex. 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.
Create you list of Days (Monday - Sunday) in a column you do no use.

Click in the cell that you want to create the list and choose Data - Validation. In the settings Tab choose Allow --> List.

In Source type =$A$1:$A$7. Where A is the column you put the days in and 1 & 7 are the start and end rows.

You can then hide the column that you put your days in.

Only 1 answerrss feed

Do you know the answer?

Spreadsheet - Drop down menu

Answer Question >>

Related Questions