Ask Your Question

create floating footer with =sum() equations?

asked 2018-07-17 08:52:16 +0100

germzx gravatar image

I'd like to create a floating footer (a single row at the bottom of my calc document) which is bound to the very bottom of the scrolling screen. If I'm looking at row 1-10 it would hover over row 10, if i scroll down to rows 26-36, it floats over row 36 at the bottom, but the footer always shows whatever sum equation for the respective columns.

I'm using calc to do a day by day data entry for money profits and losses from various sources (each source a column) and want my net profit for each column to be easily accessible, even while entering a new row (new day) in.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-07-17 09:01:23 +0100

pierre-yves samyn gravatar image


AFAIK there is no way to fix a total line. A common way (workaround) to do this is to create this total row at the top of the sheet (just above or below the column headers) and then fix that row with the headers.

HTH - Regards

edit flag offensive delete link more

answered 2018-07-17 11:07:36 +0100

updated 2018-07-17 11:14:46 +0100

To have it stay at top, and/or at left, from pull down... View / Freeze Cell

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-17 08:52:16 +0100

Seen: 319 times

Last updated: Jul 17 '18