drop-down list
I've suddenly been told I need to maintain a large spreadsheet. The one
change I want to make is create a cell with a drop down list that doesn't allow any other values. I am so confused by all the options available. I did a =value("YES","NO","N/A") and this seems to drop down OK, but another value can be typed into the cell. I am probably overcomplicationg this issue, but how do I restrict to the above values? Is there a different method I should use? |
drop-down list
See Debra Dalgleish's website for really good instructions:
http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Nooby" wrote: I've suddenly been told I need to maintain a large spreadsheet. The one change I want to make is create a cell with a drop down list that doesn't allow any other values. I am so confused by all the options available. I did a =value("YES","NO","N/A") and this seems to drop down OK, but another value can be typed into the cell. I am probably overcomplicationg this issue, but how do I restrict to the above values? Is there a different method I should use? |
drop-down list
Excellent. Thank you.
|
All times are GMT +1. The time now is 11:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com