How do I sort a Spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple spreadsheet with multiple rows and columns. Columns contain:
Date, Text, and numbers.

The information in the rows must be the same after sorting.

How do I sort the spreadsheet by the column(s): dates, text, and/or numbers
and insure that the original information in the rows stays the same?
 
Select the whole range before you invoke the sort. Don't leave Excel to
guess which rows & columns you wish to use.
 
I too have a simple spread sheet, not generated by myself though. I did
highlight the cells that I wanted to alphabetize, all but one did so? What
is the problem?
 
Sort can use the first row as labels or as data. When you open the sort
dialog there is a box to check indicating what you want. Let us know if this
helps
best wishes.
 
Garrette said:
I have a simple spreadsheet with multiple rows and columns. Columns contain:
Date, Text, and numbers.

The information in the rows must be the same after sorting.

How do I sort the spreadsheet by the column(s): dates, text, and/or numbers
and insure that the original information in the rows stays the same?
Click to expand...
 
Garrette said:
I have a simple spreadsheet with multiple rows and columns. Columns contain:
Date, Text, and numbers.

The information in the rows must be the same after sorting.

How do I sort the spreadsheet by the column(s): dates, text, and/or numbers
and insure that the original information in the rows stays the same?
Click to expand...
 
Back
Top