How to sort entire spreadsheet by one column sort

[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

 

[jbclem]

Just to clarify, I've also frozen (freeze panes) the headings so they
wouldn't be involved in the sort.

 

[Gord Dibben]

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

 

[Gord Dibben]

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

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


Gord

 

[jbclem]

Do I just select the column headers (A to H), or do I select the entire
spreadsheet below those headers also?

 

[Gord Dibben]

Selecting the column headers will select the entire columns so no need
to do any more than that.


Gord