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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top