My problem occurred when I Inserted a column before D then sorted my sheet by
column B. Problem was the sort didn't include the whole sheet and did not go
past the newly inserted column. Can anyone tell me why this happened?
When I highlighted Column B His the sort az button told me to expand
selection and I did, but it did not include whole sheet. Any explanation
would be helpful.

You should always select the range (rows and columns) before sorting.
--
David Biddulph

"Kevin" wrote in message
...
My problem occurred when I Inserted a column before D then sorted my sheet
by
column B. Problem was the sort didn't include the whole sheet and did not
go
past the newly inserted column. Can anyone tell me why this happened?
When I highlighted Column B His the sort az button told me to expand
selection and I did, but it did not include whole sheet. Any explanation
would be helpful.

Hi,

For more information, please refer to "Sort a Range" in he Microsoft Excel
2003 online help.


Follow the procedure below to sort a range of data.


Sort a range


Sort rows in ascending order (A to Z, or 0 to 9) or descending order (Z to
A, or 9 to 0)

1. Click a cell in the column you would like to sort by.
2. Click Sort Ascending or Sort Descending .

Note In a PivotTable report, Microsoft Excel uses the selected field to
sort.

Sort rows by two or three criteria (columns)

For best results, the range you sort should have column labels, or headers.

1. Click a cell in the range you want to sort.
2. On the Data menu, click Sort.
3. In the Sort by and Then by boxes, click the columns you want to sort,
starting with the most important.
4. Select any other sort options you want, and then click OK.

Challa Prabhu


"Kevin" wrote:

My problem occurred when I Inserted a column before D then sorted my sheet by
column B. Problem was the sort didn't include the whole sheet and did not go
past the newly inserted column. Can anyone tell me why this happened?
When I highlighted Column B His the sort az button told me to expand
selection and I did, but it did not include whole sheet. Any explanation
would be helpful.

It is not wise to rely on Excel to decide on what range it thinks you want
to sort. Much better to select the range before invoking the sort.
--
David Biddulph

"challa prabhu" wrote in message
...
Hi,

For more information, please refer to "Sort a Range" in he Microsoft Excel
2003 online help.


Follow the procedure below to sort a range of data.


Sort a range


Sort rows in ascending order (A to Z, or 0 to 9) or descending order (Z to
A, or 9 to 0)

1. Click a cell in the column you would like to sort by.
2. Click Sort Ascending or Sort Descending .

Note In a PivotTable report, Microsoft Excel uses the selected field to
sort.

Sort rows by two or three criteria (columns)

For best results, the range you sort should have column labels, or
headers.

1. Click a cell in the range you want to sort.
2. On the Data menu, click Sort.
3. In the Sort by and Then by boxes, click the columns you want to sort,
starting with the most important.
4. Select any other sort options you want, and then click OK.

Challa Prabhu


"Kevin" wrote:

My problem occurred when I Inserted a column before D then sorted my
sheet by
column B. Problem was the sort didn't include the whole sheet and did not
go
past the newly inserted column. Can anyone tell me why this happened?
When I highlighted Column B His the sort az button told me to expand
selection and I did, but it did not include whole sheet. Any explanation
would be helpful.