Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jane
 
Posts: n/a
Default Sort columns by content

The document contains eight columns. Want to sort on one column for eight
different strings of text. This column typically contains one paragraph of
text.
  #2   Report Post  
DaveB
 
Posts: n/a
Default

Use Data-Sort. You can pick which column to sort on and excel will copy the
respective cells along with the sort.

--
Regards,

DaveB


"Jane" wrote:

The document contains eight columns. Want to sort on one column for eight
different strings of text. This column typically contains one paragraph of
text.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I sort several columns in excel race510 Excel Worksheet Functions 1 August 6th 05 12:39 AM
Sort - max number of columns? KarenF Excel Discussion (Misc queries) 4 July 30th 05 01:24 AM
How do I sort using text located in different columns? Neil Excel Discussion (Misc queries) 4 May 2nd 05 07:32 PM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
Organize and sort columns J Excel Discussion (Misc queries) 1 March 1st 05 12:17 AM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"