Forum Discussion
Pilot Logbook
A sample of your workbook would help (not your entire life history).
Meanwhile, I have attached a file that 'mocks up' a non-existent table type.
The body is a table which provides structured references that synchronise with the actual data.
The first record, comprising a row of zeros, is hidden. That ensures number formatting etc. is inherited by any inserted row. The table header row is reduced in size to a trim line under the totals row. That allows the user to select a column by hovering the mouse over the line until a down arrow appears. What appears to be a header row is no more than a copy of the hidden row. The totals row is not the inbuilt table feature because that can only appear at the foot of the table. Instead it contains a formula that references the appropriate column using structured referencing.
Perhaps you will find some useful ideas here.