Possible to have a block of cells not affected by sorts or cursor movements, etc.

Giganews Newsgroups
Subject: Possible to have a block of cells not affected by sorts or cursor movements, etc.
Posted by:  StargateFan (IDon'tAcceptSp…@NoJunkMail.com)
Date: Sun, 20 Jul 2008

I don't know what to call what I'm trying to do so will try to briefly
explain.  All these years, I've placed 1 static results cells in the
header row so that freeze panes would always show them.  So, the
descriptive cell and "total" dollar or figure amounts for the sheet
would be located in 2 cells in this frozen header.

Needless to say, this is not ideal.  It works because I'm forced to
keep stats down to just showing a global total so only 2 cells
affected.  I lose so much valuable sheet real estate as it is for the
one totals formula since the rows below these 2 cells can't be used.
Yet creating a whole separate sheet to show results not ideal, either.
It would mean toggling back and forth all the time and would mean
wouldn't just get 1 sheet for both the main sheet and one that shows
totals and subtotals figures, etc., for various categories.

Was hoping that the experts here knew of something in Excel  that I
obviously don't to get the best of both worlds - that would allow me
to have show more totals somehow yet still be able to add rows as
needed and sort any rows yet when moving around sheet can still
everything all the time.

Thanks.  :)

Replies