Column Inserting and sorting problem

[Kevin]

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.

 

[David Biddulph]

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

 

[challa prabhu]

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

 

[David Biddulph]

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.