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

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

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?

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?

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

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