Ask Your Question
1

create floating footer with =sum() equations?

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

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
2

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

pierre-yves samyn gravatar image

Hi

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
1

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

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

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

Stats

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

Seen: 53 times

Last updated: Jul 17 '18