Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists
I am filling text into a cells by using
Data--Validation--Lists. This won't let me enter anything in the cell that is not on the list. Is there any way to just write something different right in the cell (that is not on the list)? OR is there a better way to accomplish fby using a different procedure thanks Raymond. -- dzierzekr |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Lists
On the 'Error Alert' tab, uncheck the 'Show error after invalid data is
entered' button -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dzierzekr" wrote in message ... I am filling text into a cells by using Data--Validation--Lists. This won't let me enter anything in the cell that is not on the list. Is there any way to just write something different right in the cell (that is not on the list)? OR is there a better way to accomplish fby using a different procedure thanks Raymond. -- dzierzekr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists display bottom vs top | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |