...
In this example, there is content below the data marker row (a Grand Total row and a blue footer row). This will be pushed down as new rows are inserted.
Before:
After:
Formulas
- There are two formulas
- B4 contains a SUM formula that references a data marker cell. The lower boundary will expand to include new rows.
- C3 contains a formula that references a data marker cell. The row values will be updated for each new row.
Before:
After:
Formatting on the data marker row
- The italic and red font formatting will be applied for each row of data that is imported
...