Forum Discussion
Solved
Create a Table with the top 2 rows as header
I have a new Excel sheet pre-formatted and ready to convert to a table. The top two rows are intended to be the header. The data is intended to start on the 3rd row. I can't get the "Insert table" fu...
wcstarks What if you put the Net Adj above the table? Using structured references will ensure that the total dynamically updates when you add rows to the table.
See attached.
Here is the table with a summation row below the table, with data in the first column. I was wondering if the summation row can be placed in row 2 instead of following the table. In row 2, it would need to sum all rows below it in the table and update as new rows are added. I suspect that is not possible, as the summation function naturally want to sum rows above it.
wcstarks What if you put the Net Adj above the table? Using structured references will ensure that the total dynamically updates when you add rows to the table.
See attached.
- That Works. Thanks.