Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel Data Validation
I created a LIST Data Validation (I typed the entries into the window) for an
entire column. When I paste into the column or download data into the column, the Data Validation "goes away" (is removed by the resulting paste or download. Anyway to "keep" the Data Validation? MUCH THANKS! Happy Holidays! Gene:) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel Data Validation
No, the data validation is designed to check entries as you type them
into a cell. Unfortunately, you can paste or download invalid data into the cells. Gene wrote: I created a LIST Data Validation (I typed the entries into the window) for an entire column. When I paste into the column or download data into the column, the Data Validation "goes away" (is removed by the resulting paste or download. Anyway to "keep" the Data Validation? MUCH THANKS! Happy Holidays! Gene:) -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel Data Validation
THANKS! :-(
"Debra Dalgleish" wrote: No, the data validation is designed to check entries as you type them into a cell. Unfortunately, you can paste or download invalid data into the cells. Gene wrote: I created a LIST Data Validation (I typed the entries into the window) for an entire column. When I paste into the column or download data into the column, the Data Validation "goes away" (is removed by the resulting paste or download. Anyway to "keep" the Data Validation? MUCH THANKS! Happy Holidays! Gene:) -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation in Excel 2007 - Input Message | Excel Worksheet Functions | |||
Data validation in Excel 2007 | Excel Discussion (Misc queries) | |||
Data validation in Excel 2007 | Excel Discussion (Misc queries) | |||
Data validation Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 and Drop Down List via Data Validation | Excel Discussion (Misc queries) |