Software

Ask something
Discussion Locked

Drop Down Menu in Excel

0 helpful
5 replies

by shaundyc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

May I ask someone to provide me on how to make a drop down menu on each cell on Excel with choices such as letters A, B, C, D when click on that drop down menu.

Hoping someone can assist me.
Thanks in advance

5 replies

by dklippert

Pick an unused area on your spreadsheet, say cells M1000 to M1003. Enter A,B,C,D in those cells.
Go back to the active area of the worksheet. Choose the cell that you want to use for the drop down list.
On the Menu bar, go to Data>Validation.
On the Settings tab under Allow, choose List.
In the Source box enter =$M$1000:$M$1003
Click OK

This discussion is closed to new replies.