MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop-Down Menu

Posted by Michael on January 13, 2002 6:17 PM

I would like to lock a cell such that when I click on it, I must choose between 4 options (e.g. cash, check, atm, ax). I need the cell to be formatted normally so that my sum-if function still works.

How do I set this up and make it happen?

Posted by Jacob on January 13, 2002 6:57 PM


Put the accepted values in a range somewhere lets say Z1:Z4 for example
Then select the cells you want the drop down for and go to data|validation then select List and make sure "In cell drop down" is checked then select the data in this case Z1:Z4.