I want to sort everything but my validation list
I created a couple validation lists on my worksheet and when I try to sort
the data in the worksheet, the validation data gets sorted, too, so the
drop-down lists refer to cells that have different data than prior to the
sort. I want to set up the worksheet to that I can protect the lists from
sorting with the rest of the worksheet. Is this possible?
|