Copy a revised cell
Select cell(s) that you want to change
Choose EditPaste Special
Select Validation, and click OK

Ashutosh wrote:
I revised my original dropdown list to include new data. I then tried to
apply it all cells with the same settings by checking the box in the Data
Validation dialog box. Most rows in the column got a blue autofill to show
that these were the rows to which the new dropdown list would get applied.
However, there were some rows (dispersed, not contiguous) which had no blue
autofill - however, these rows have data in them which has been derived from
the original dropdown list. How do I apply the new list to even these rows? I
could, obviously, Copy Paste from an 'applied' cell to an 'unapplied' cell,
but that means that I have to re-enter the data all over again. What should I
do ?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html