Reply
 
Thread Tools Display Modes
  #1   Report Post  
Holden
 
Posts: n/a
Default How to sort multiple columns in a table ascending text?

I have a simple table with three columns containing straight text - a single
word in each cell. I would like to sort the contents of across all the
columns alphbetically.

Under TableSort Columns are listed individually cannot select all three.
Under TableSortOptions Sort Column Only is ticked & greyed out - have
not been able to unselect this option.

Any help appreciated.


  #2   Report Post  
Jezebel
 
Posts: n/a
Default

You can sort the table by one or optionally two columns. If I understand you
rightly you want to sort the rows (is that what you mean by 'across all the
columns'?) -- in which case, you can't do it in Word. Copy the table to
Excel, manipulate it there as you need, then copy it back.




"Holden" wrote in message
news
I have a simple table with three columns containing straight text - a
single
word in each cell. I would like to sort the contents of across all the
columns alphbetically.

Under TableSort Columns are listed individually cannot select all
three.
Under TableSortOptions Sort Column Only is ticked & greyed out - have
not been able to unselect this option.

Any help appreciated.




  #3   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

You can't sort all three columns as a single list. For that you would need
newspaper-style columns. You could use Table | Convert | Table to Text,
separating with a paragraph mark, which would put the contents of each cell
in a separate paragraph. You can then use Table | Sort to sort the
paragraphs.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Holden" wrote in message
news
I have a simple table with three columns containing straight text - a

single
word in each cell. I would like to sort the contents of across all the
columns alphbetically.

Under TableSort Columns are listed individually cannot select all

three.
Under TableSortOptions Sort Column Only is ticked & greyed out - have
not been able to unselect this option.

Any help appreciated.



  #4   Report Post  
Holden
 
Posts: n/a
Default

Hi Jezebel, I have a table which has 3 columns and contains plain text in
each cell. Currently each column is sorted A to Z. I would the sort to go
alphabetically across the 3 columns, ie: Column 1 starts with letter A and
Column 3 ends with letter Z with everything in between sorted alphabetically.
So sort would start down column 1, continue at top of column 2 and down,
then continue at top of column 3 and down. Hope this explains it a bit
better.

Have copied tabled into excel and am coming up against same problem.

Regards.

"Jezebel" wrote:

You can sort the table by one or optionally two columns. If I understand you
rightly you want to sort the rows (is that what you mean by 'across all the
columns'?) -- in which case, you can't do it in Word. Copy the table to
Excel, manipulate it there as you need, then copy it back.




"Holden" wrote in message
news
I have a simple table with three columns containing straight text - a
single
word in each cell. I would like to sort the contents of across all the
columns alphbetically.

Under TableSort Columns are listed individually cannot select all
three.
Under TableSortOptions Sort Column Only is ticked & greyed out - have
not been able to unselect this option.

Any help appreciated.





  #5   Report Post  
Jezebel
 
Posts: n/a
Default

You're right. Excel won't do that either. However, moving cells around is
very easy. Put it all into one column, sort, split it back into three.


"Holden" wrote in message
...
Hi Jezebel, I have a table which has 3 columns and contains plain text in
each cell. Currently each column is sorted A to Z. I would the sort to
go
alphabetically across the 3 columns, ie: Column 1 starts with letter A
and
Column 3 ends with letter Z with everything in between sorted
alphabetically.
So sort would start down column 1, continue at top of column 2 and down,
then continue at top of column 3 and down. Hope this explains it a bit
better.

Have copied tabled into excel and am coming up against same problem.

Regards.

"Jezebel" wrote:

You can sort the table by one or optionally two columns. If I understand
you
rightly you want to sort the rows (is that what you mean by 'across all
the
columns'?) -- in which case, you can't do it in Word. Copy the table to
Excel, manipulate it there as you need, then copy it back.




"Holden" wrote in message
news
I have a simple table with three columns containing straight text - a
single
word in each cell. I would like to sort the contents of across all the
columns alphbetically.

Under TableSort Columns are listed individually cannot select all
three.
Under TableSortOptions Sort Column Only is ticked & greyed out -
have
not been able to unselect this option.

Any help appreciated.







Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I hide table columns with text in them, in Word 2000 KGZ Tables 3 May 7th 05 01:04 AM
Table AutoFormats vs. Table Styles confusion Tony Jollans Tables 5 March 6th 05 07:18 PM
Table Sort - Sort only 3 of 4 columns KGlennC Microsoft Word Help 2 February 26th 05 04:20 PM
Can't sort table alphabetically Tiffany Microsoft Word Help 1 January 21st 05 10:17 PM
How to create multiple pages with newpaper columns DBodell Page Layout 3 January 4th 05 07:35 PM


All times are GMT +1. The time now is 09:58 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"