Cannot sort a table containing text

Joined
Oct 17, 2017
Messages
1
Reaction score
0
In Word 2016 I created a table with no headers. The data is all text, although one column contains mostly numbers with hyphens, to be sorted as text. The document has headers and footers but no other text besides the table.

No matter which column I attempt to sort, the sort fails. I select a column, then Table Tools > Layout > Sort, then "OK" in the Sort dialog. This error dialog opens:

"This entry is not valid for sorting. Please type or select another entry from the list."

I did not select an "entry"; I selected a column.

What's more, I am able to trick Word into sorting by the left column. In the Sort dialog I select "Options..." and then "OK" in the next dialog. I then select "OK" in the Sort dialog and the table is sorted.

This only works on the left column, however. If I try to sort by another column, selecting "Options..." does let me skip the "This entry is not valid for sorting...." dialog. But nothing is sorted.

Clearly the app is not behaving as it's supposed to. Any ideas?
 

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
578
Reaction score
50
Provided your insertion point is in the table, there is no need to select anything. That said, I've never seen that error message and can find no reference to it.

Have you tried repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair)?
 
Joined
Dec 3, 2019
Messages
1
Reaction score
0
I had this problem. It was solved by adding a repeat headers row. Then the sort command worked exactly as it is supposed to. As an experiment, I then deleted the header row. My table stayed sorted, but again, the sort command didn't work. Header rows aren't a bad thing, and I always want to sort my tables. Therefore my tables will always have to have them!

And by the way, I don't intend this in a mean way, but you can tell that a comment is coming from a point of not having a *real* answer when the suggestion is to repair or reinstall the software! Bless your heart, macropod!
 

als

Joined
Mar 15, 2021
Messages
1
Reaction score
0
I solved this by going into "Option" in the "Sort" dialogue box that comes up when you press the "Sort" button on Word's Table Design Layout Ribbon. I changed "Separate fields at" from from "commas" to "Tabs" and everything sorted as expected.
 
Joined
Mar 30, 2022
Messages
1
Reaction score
0
I had this problem. It was solved by adding a repeat headers row. Then the sort command worked exactly as it is supposed to. As an experiment, I then deleted the header row. My table stayed sorted, but again, the sort command didn't work. Header rows aren't a bad thing, and I always want to sort my tables. Therefore my tables will always have to have them!

And by the way, I don't intend this in a mean way, but you can tell that a comment is coming from a point of not having a *real* answer when the suggestion is to repair or reinstall the software! Bless your heart, macropod!
Completely agree regarding the "reinstall the software" comment. What a lazy response. If you don't have an answer ... just be quiet. By the way, the header row thing worked for me, too. Thanks!
 

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
578
Reaction score
50
Without wanting to place too fine a point on it, I gave no "reinstall the software" advice. Do some basic reading.

And you needed to resurrect a post from 2017 just to say I gave "a lazy response"? How infantile.

Moreover, it seems the OP omitted to say that the table had merged cells - hence the need for the 'header row' treatment referred to in post #3.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top