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
Hi
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.
HTH
Jacob
