Total Field Always Visible
 

I currently have a sheet that has values in D1-D10. I would not only
like to show the total of those cells, but I would like the amount to
appear directly below the last value which is easy enough by placing
the total in D11. I would however rather it function similar to a
frozen pane where the total value may be in row 200 but still appears
under row 10 so a user doesn't have to insert a new row. I already
have pane freezing activated to display column headers and it seems you
can only apply it in one location.

If this makes no sense I'd be glad to rephrase it.

If anyone has any thoughts before I pull the rest of my hair out it is
greatly appreciated.

Brad


--
brandolph

"brandolph" wrote...
I currently have a sheet that has values in D1-D10. I would not only
like to show the total of those cells, but I would like the amount to
appear directly below the last value which is easy enough by placing
the total in D11. I would however rather it function similar to a
frozen pane where the total value may be in row 200 but still appears
under row 10 so a user doesn't have to insert a new row. I already
have pane freezing activated to display column headers and it seems you
can only apply it in one location.

If this makes no sense I'd be glad to rephrase it.

If anyone has any thoughts before I pull the rest of my hair out it is
greatly appreciated.

Excel doesn't work like that. Frozen panes can only be top or left panes,
not the bottom-right pane. If you want your totals to appear all the time,
put them *above* your date and in a frozen *top* pane.