Sort by hidden column in Word

How to sort a list using a hidden or unseen list in Word.

Sometimes you want to sort a list in a way that isn’t apparent to the reader.

To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with the order they stepped onto the surface.

http://img.office-watch.com/ow/Sort%20by%20Hidden%20Column%20in%20Word%201.png image from Sort by hidden column in Word at Office-Watch.com

To put that list into the order of stepping on the moon is simple but what if you want to place them in that order but without the ‘Order’ column showing?

Windows 10 from people 'in the know'

A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.

Fully up-to-date with coverage of the Anniversary 2016 major update of Windows 10.

This 670 page book shows you important features and details for all serious Windows 10 users.

The beauty of this method is that you can go back to the table, add or change rows then re-sort the table. Probably a good idea to add an unpublished comment to the document reminding you and others to the presence of the hidden column and the reason for it.

The first step is the hide the column from view, which we’ve covered in a separate article.

Then select the table and choose Table | Layout | Data | Sort. The hidden column still appears in the ‘Sort by’ list, only without the header text, just the Column number. Choose the Column to Sort by and other options as usual. As you can see, the list is now in the arrival order but without that order showing.

http://img.office-watch.com/ow/Sort%20by%20Hidden%20Column%20in%20Word%202.png image from Sort by hidden column in Word at Office-Watch.com

Of course, the other option for a ‘one-off’ situation is to sort the table then delete the sorted column from the final document.