Sort rows by colums

[Guest]

I copied and pasted a table from word into excel. I put a header on the
information, but when I go to sort, it only sorts the colum selected. I went
into sort options and the headers are listed, but it still only sorts the
column highlighted, not all the rows...help!

 

[gls858]

I copied and pasted a table from word into excel. I put a header on the
information, but when I go to sort, it only sorts the colum selected. I went
into sort options and the headers are listed, but it still only sorts the
column highlighted, not all the rows...help!

click on the small square above the column numbers. This will highlight
the entire sheet. Now go to data > sort and follow the prompts.

gls858

 

[Guest]

Yes that works for the entire sheet, but to sort the sheet by using 1 column
must be by just using the header for that column and not the entire column?
I think this works.

 

[gls858]

Yes that works for the entire sheet, but to sort the sheet by using 1 column
must be by just using the header for that column and not the entire column?
I think this works.

:

Yes if you click on just the header for the col then go to Data > Sort
Excel 2003 will highlight all the columns for you. I don't think it was
always worked like that. I got into the habit of highlighting the area
to be sorted a long time ago.

gls858