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

  • Thread starter Thread starter StargateFan
  • Start date Start date
S

StargateFan

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. :)
 
I don't understand what you mean by:

<<<"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.">>>

If Row1 contains Text headers,
and Row2 contains totaling formulas,
*AND* Rows 1 & 2 are "Frozen Panes",
all the rest of the screen is available to display the entire rest of the
sheet when you scroll.
You're *only* losing 2 rows of screen display.

What am I missing, or what are you leaving out?
 
I don't understand what you mean by:

<<<"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.">>>

If Row1 contains Text headers,
and Row2 contains totaling formulas,
*AND* Rows 1 & 2 are "Frozen Panes",
all the rest of the screen is available to display the entire rest of the
sheet when you scroll.
You're *only* losing 2 rows of screen display.
Click to expand...

Yes, I suppose I could lose 1 more row to totals of some kind. I
don't total in the way this colution suggests, but put a couple of
global total at the very end of the the print area at row A.

But adding a 2nd "header" row that isn't a header row but that shows
totals, well, that might work. The cell merges might not always work
out but I'd gain extra info. Hmmm, thanks. Must mull this one over.
:)
 
Back
Top