Results 1 to 2 of 2

Thread: How to group multiple lines for sorting in excel

  1. #1
    Join Date
    Dec 2011
    Posts
    40

    How to group multiple lines for sorting in excel

    I am putting a correspondence review in a big project. There are 7 columns: Date, Form, From, To, , Comments, Pages. Information in some of the columns contains multiple lines. What I want to do is, I want to put the information in and finally sort them according to dates. How do I group all information for a specific correspondence so that when I sort all information will be attached to the date? Thank you.

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    Re: How to group multiple lines for sorting in excel

    Seems like you have the date in the first column. If not, it should be Then select all cells: A2:G100 assuming your first date entry starts in A2 and is 100 rows down by 7 columns wide select the "sort -Ascending or Descending- icon" on the toolbar ( A over Z with an arrow to its right).

Similar Threads

  1. Sorting by Surname in Excel
    By Ojsuta in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 04:56 PM
  2. How to avoid cell reference changes after sorting in Excel
    By Wisaal in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:23 PM
  3. how to enable Autofilter and Sorting in Protected Excel Sheet
    By ChittiBabu in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:38 PM
  4. Sorting and filtering Microsoft Excel
    By CLONEOPS in forum Windows Software
    Replies: 2
    Last Post: 09-01-2009, 11:52 AM
  5. Array sorting in Excel
    By Kelsey in forum Software Development
    Replies: 3
    Last Post: 08-11-2008, 04:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,047,701.62190 seconds with 17 queries