Unlocking Collumns

**stuart3** · 11-05-2011, 02:58 AM

I am having trouble with excel.
When I click on a column to sort ascending it seems two of the columns have locked and all the rows stay in the same position.
So what happens is when sort ascending is used in every row changes so order except the rows in two columns. Now my data is everywhere and all mixed up.

I hope I have explained this ok.
Thank you very much for your help

**royUK** · 11-05-2011, 03:37 AM

Have you got empty columns within the data?

**stuart3** · 11-05-2011, 03:39 AM

Yes there are some empty collumns would removing them help?

**stuart3** · 11-05-2011, 03:48 AM

It worked I deleted the empty columns there had been hidden so I couldn't see it.
Thank you very much!
Very helpful

**royUK** · 11-05-2011, 03:53 AM

To use Excels Data Function you should have no completely empty rows or columns

Glad it helped

**royUK** · 11-05-2011, 03:53 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save