How to sort entire spreadsheet by one column sort

  • Thread starter Thread starter jbclem
  • Start date Start date
J

jbclem

I just downloaded a spreadsheet, and it's(the entire spreadsheet) currently
sorted alphabetically by column C. I'd like to sort it by the items in
column A, but I don't want to just sort column A, I want the sort to include
each row (headed by the word in column A) that stretches across columns A-H.

Could someone show me how this is done...

Thanks,

jc
 
Just to clarify, I've also frozen (freeze panes) the headings so they
wouldn't be involved in the sort.
 
Select Columns A to H and Data>Sort

In the "sort by" pick Column A or its title and ascending or
descending.

No need to Freeze Panes................just specify that "my data has
a header"

If you don't get what you want, just Undo.............do not save


Gord
 
Freezing Panes does not guarantee the headings won't sort.

You must also have "my data range has header row" checkmarked.


Gord
 
Do I just select the column headers (A to H), or do I select the entire
spreadsheet below those headers also?
 
Selecting the column headers will select the entire columns so no need
to do any more than that.


Gord
 
Back
Top