Keep data validation in cell even if I remove contents.

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

I have 3 columns with data validation lists. Frequently, I have to move the
three columns with data in them to another row (ie: A1:C1 move to A22:C22).
When I do that, the now empty cells don't have the data validation lists.
Is there a way to lock it so I only take the contents of the cells?
I want to keep the data validation in the empty cells, so I can enter new
information.
I've tries paste special, but doesn't work. Is a macro possible?
Any ideas would be great.
Joe
 
are you sure you are doing Paste Special and then Values.
i think it should work
 
You are right. It works when you copy/paste.
I want to cut/paste.

Joe
 
Joe

Don't "move" the cells, just Copy A1:C1 and Paste Special>Values at A22:C22

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation/Cell Protection Question 2
Filling Out Cells Based on Data Validation 1
Data Validation - Prevent delete 2
Data validation 3
data - validation - list question 2
multiple data validation 3

Back
Top