Sort rows by colums

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
spartanfans13 said:
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 to expand...

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
 
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.
 
spartanfans13 said:
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.

:
Click to expand...
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
 
Back
Top