How do I sort a Spreadsheet?
 

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?

How do I sort a Spreadsheet?
 

Select the whole range before you invoke the sort. Don't leave Excel to
guess which rows & columns you wish to use.
--
David Biddulph

"Garrette" wrote in message
...
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?

How do I sort a Spreadsheet?
 

"David Biddulph" wrote:

Select the whole range before you invoke the sort. Don't leave Excel to
guess which rows & columns you wish to use.
--
David Biddulph

"Garrette" wrote in message
...
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?

How do I sort a Spreadsheet?
 

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?
--
Carol :)


"Garrette" wrote:

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?

How do I sort a Spreadsheet?
 

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.

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Carol" wrote in message
...
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?
--
Carol :)


"Garrette" wrote:

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?

How do I sort a Spreadsheet?
 

"Garrette" wrote:

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?

How do I sort a Spreadsheet?
 

"Garrette" wrote:

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?