MrExcel Publishing
Your One Stop for Excel Tips & Solutions

locking cells during sorts


Posted by Kurt on July 10, 2001 6:46 PM

Is there a way I can lock some cells together so that I can sort a column of information but keep them next to their corresponding entries? If so, how?
Thank you,
Kurt


Posted by lurker on July 10, 2001 10:11 PM

the sort function (data menu)will do this for you. assuming the data you want to sort is in column a and the corresponding entries are in column b, select columns a and b and sort by column a.
:)