Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting large worksheets
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting large worksheets
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. "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting protected worksheets | Excel Discussion (Misc queries) | |||
Reduced Sorting Capability In Excel Worksheets | Excel Discussion (Misc queries) | |||
i want to open large file 300 col, how to split between worksheets | Excel Discussion (Misc queries) | |||
Sorting Excel columns in several worksheets at once. | Excel Discussion (Misc queries) | |||
Updating multiple worksheets in a large workbook | Excel Discussion (Misc queries) |