Sorting a table in word

  Abel 07:39 13 Dec 10
Locked

I have a table in a word document which has 4 columns. Its purpose is to have a list of individuals names sorted in alphabetical order. The surname is in column 1 followed by forename in column 2. Columns 3 and 4 are intended to be a continuation of columns 1 and 2, however, try as I might, I cannot get the whole table to sort alphabetically. Your help please.

Abel

  Batch 08:30 13 Dec 10

Don't know what you have tried, but I find the easiest way to sort by a single column is to select that column and go to Table, Sort and it all just follows on from there.

  Abel 09:16 13 Dec 10

Thanks Batch! Doesn't work I'm afraid.

Abel

  bremner 09:21 13 Dec 10

I have just tried it with a 4 column table and it worked fine.

Highlight column 1 and then do as batch said.

  VoG II 09:26 13 Dec 10

I think that you would have to append columns 3 and 4 to columns 1 and 2. Sort columns 1 and 2, then cut the second half of the sorted list and paste into column 3.

  Abel 09:37 13 Dec 10

Hi Bremner! I need to sort the forenames in column 2 with their surnames in column 1 so surely I need to highlight both columns to do this? Then there are further surnames in column 3 to sort with their forenames in column 4. Now, I can sort columns 1 and 2 perfectly but as soon as I try the same thing with columns 3 and 4 columns 1 and 2 loose their alphabetic order and 3 and 4 sort alphabetically.

Abel

  Abel 09:39 13 Dec 10

Hello VoG™! Sorry to be thick but I dont follow. Would you elucidate please?

Abel

  VoG II 09:45 13 Dec 10

Cut the names from columns 3 and 4 and paste them at the bottom of column 1.

Select columns 1 and 2 and sort.

Cut the bottom half of the sorted list and paste into column 3.

Delete the empty rows from the bottom of the table.

  Abel 10:39 13 Dec 10

Thanks VoG™! To use a Dolittleism, I've got it, by George I've got it.

Thanks again.

Abel

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…