Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel is only sorting some columns - please help
Hello,
I have a database of contact info we need to use for a mass mailing. I'm trying to sort it by address so I can delete the entries that we don't have addresses for. However, when I select a cell in the "Address" column and hit the sort button, it doesn't sort the first three colums, so the data is all messed up. I can tell this is the case because the first three columns stay the same, while the rest of the columns are sorted according to address. I tried using smart filters and the same thing happens. I tried selecting all columns and the same thing happens. If I choose a cell in one of the first three columns then it will sort all data including those columns, but if its the 4th 5th 6th etc column then the first three are ignored and not sorted. If anyone knows how I can get Excel to sort ALL the data that would be a great help. Thanks! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Complicated List by Two Columns - Excel 2003 | Excel Discussion (Misc queries) | |||
can I ignore words when sorting excel columns? | Excel Worksheet Functions | |||
Sorting columns in Excel | Excel Discussion (Misc queries) | |||
Sorting Excel columns in several worksheets at once. | Excel Discussion (Misc queries) | |||
Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) |