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