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? |
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? |
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? |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com