View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gene Gene is offline
external usenet poster
 
Posts: 100
Default 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