Sorting a worksheet with drop list

R

rabbit

I've created a worksheet with a drop list (i used data validation) but I need
to sort the names by alpha, when I do this the corresponding drop lists don't
"follow" I don't think I have any hidden columns or rows. Any ideas?
 
D

Debra Dalgleish

Select a cell in the Names column
Press Ctrl + * to select the current region for the selected cell
Check that all the cells you want sorted have been selected, including
the column with data validation dropdowns
Choose Data>Sort
Select the options for your sort, click OK
 
Top