Sorting Question

[HunterN]

Hello,

In my wksht I have a column whose header is Project Number. Under this is the word Total and then the list of Project Numbers. I want to sort this worksheet by rows, using the Project Number. This all works fine BUT the row that has the totals in it now ends up at the bottom. I don't want the Totals row to move, just the other rows. I thought I was doing it right but it always takes the Total row to the bottom. Can anyone help?

Thanks in advance, you guys are great!

 

[Ivan F Moala]

On 2002-05-10 05:39, HunterN wrote:
Hello,

In my wksht I have a column whose header is Project Number. Under this is the word Total and then the list of Project Numbers. I want to sort this worksheet by rows, using the Project Number. This all works fine BUT the row that has the totals in it now ends up at the bottom. I don't want the Totals row to move, just the other rows. I thought I was doing it right but it always takes the Total row to the bottom. Can anyone help?

Thanks in advance, you guys are great!

Hi Hunter....am I missing something ??
Why not just select the cell under Totals
onwards and sort ??
If There is something I'm missing then please
clarify ad hopefully we can help you further.

 

[crimlet]

You could merge the cells in row 1 & 2, and re-enter the column heading so that Project number total becomes one cell