#1
|
|||
|
|||
Sort Table Problem
I have an excel spreadsheet that is essentially an address list. It has 14 columns and about 400 rows. It has a header row with names like FNAME, LNAME, ADDRESS1, etc.
Now when I try to sort it even with the my data has headers checked the header row is treated as data. Also the sort criteria used to use the header values. Now it says Column A or (Column A). Every thing is data and the headers are centered. This data was saved as xls. This year I added a 4th sort level and was warned of an incompatibility. I then saved it as an xlsx. My office is Microsoft 365 and the Excel is version 2210. Any suggestions for fixing this. |
#2
|
|||
|
|||
Actually if I exclude the header row from the table range everything works fine.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort Filter Problem | PomDave | Excel | 3 | 01-27-2022 03:36 AM |
Problem with View>Sort... | billder99 | Project | 4 | 11-08-2021 08:02 AM |
Excel sort problem | jaz | Excel | 2 | 01-16-2011 04:24 AM |
Sort problem | Cpat | Excel | 1 | 09-19-2010 03:08 AM |
MS Outlook 2002 Address Book Sort Problem.... | blizzster | Outlook | 0 | 07-30-2009 07:52 AM |