View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ufo_pilot
 
Posts: n/a
Default How do I group multiple lines of excel info for easy sorting

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 it's right).
HTH

"ericsayang" wrote:

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 contain 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.