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

L

Lisa in Victoria

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!
 
G

Gord Dibben

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
 

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

Drop Down List Contains the List Header Row 1
Need a drop-down field that automatically sorts ascending 2
Change drop down list in one cell based on values in other cells 2
How can I add to a drop down list after I have selected it? 4
Vloolup help with drop down lists 3
Filter a Drop List ? 1
Creating drop downs in a cell contingent on another drop down 1
Sorting cells: a list behind the cells do not move with the cell 2

Top