Sorting large worksheets

[Guest]

I am able to sort the information in the workbook, but some of the
information after the sort has been mixed up.

Example: The data that I had in Column B no longer matches up with the data
in Column A etc.

What am I doing wrong?

 

[Guest]

Sounds like you are selecting one column to do the sorting on, rather than
the entire range.......try only selecting one cell in the range, rather than
an entire column and then doing the sort. Note tho, that if you have any
totally empty columns before the end of your range, Excel sort will not jump
the gap.....

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

A couple of possibilities that I can think of:

Blank columns in between data (although your query suggests not) or
Highlighting the area to be searched (in some versions of excel if you
highlight a column it will only sort that column, not the data in the columns
next to it. If this is the problem you just need to click on 1 cell in the
column you wish to sort by.