Can you lock a drop-down cell so that it sorts with the row?
 

I have created drop-down cells (type of business) for my client contact list
but when I sort that list alphabetically or by last contacted date the
drop-down cells don't sort with it. How can I solve that issue?

Thanks for the responses!

Can you lock a drop-down cell so that it sorts with the row?
 

Are these Data Validation dropdown lists?

Where is the list range located?

i.e. =$A$2:$A$20

If inside your sort area the lists should change to whatever is in A2:A20
after the sort.

Tested in 2003 and 2007


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 13:19:01 -0800, Lisa in Victoria <Lisa in
wrote:

I have created drop-down cells (type of business) for my client contact list
but when I sort that list alphabetically or by last contacted date the
drop-down cells don't sort with it. How can I solve that issue?

Thanks for the responses!