How to lock cells from excel sort function

**Ace of Clubs** · 07-19-2009, 07:53 PM

Hey,

I have a table in which the first row of cells are headings for each column and can sort data from all the columns. On the second row are the totals of all the columns with formulas.

Every time i sort the table the totals row gets sorted with all the other data messing up the table.

Is there anyway to lock or protect a row from the sort function in excel?

Thank you for your time

**martindwilson** · 07-19-2009, 08:28 PM

dont sort the first 2 rows!
select from row 3 down and sort with no header row

**Ace of Clubs** · 07-19-2009, 08:36 PM

Originally Posted by martindwilson

dont sort the first 2 rows!
select from row 3 down and sort with no header row

Thanks.

That does work

Although not exactly what i was looking for. Is there really no way to completely lock a row of cells from use (without using sheet protection)?

**martindwilson** · 07-19-2009, 08:53 PM

record a macro doing the sort as i said then assign it to a button. then you only have to click button to do sort.

**protonLeah** · 07-19-2009, 09:04 PM

If the calculated totals are not used elsewhere, you can use a formula in row one cells to combine the header string and the totals. E.g., given:

A1: MyHeader
A2: =SUM(MyRange)
.
.
Try:
A1: ="MyHeader xTotal is: " & SUM(MyRange)

Note that the "x" indicates where you would press Alt-Enter to force a new line for the total string. That way you can eliminate the current A2:.... rows