View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Sorting large worksheets

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



"Desmonda" wrote:

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?