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" function to format this configuration. When I attempt to format the sheet as a table with headers, it places the header in the row 3, which is where my data should start, and my intended header rows do not become the header. Please reference the attached file. How is this supposed to be done?
I need a row to sum each of the columns as rows are added to the table.
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.
- Thank you. The colored coding means red right and blue left. So, I can use that to distinguish
wcstarks Indeed you can't . Table headers are just texts. You can't reference to a "red header" or a "blue header".
I see that each column header needs a unique name, so I adopted your suggestion (R-250, etc.)
The data are numbers. minus numbers indicate reducing the db (loudness) and positive indicates increasing db for each frequency. I would like to have row 2 sum each column as rows are add to the table to provide a net db change for each frequency. I am not sure how to do that when the summation row is situated before the the regular data rows. Is this possible? See attachment.
wcstarks You simply can't have a structured table with two header rows. Just call the headers R-250, R-500 etc. and L-250, L-500 etc. or something similar.
