SOLVED

Automatically inserting row in bottom of table

Copper Contributor

Hi, 

 

I would like my table to have an empty row below the data and above the summary where I can add information. When I add information to this row I would like excel to either automatically create a new empty row below the information or create a new row with the information above the row I entered the info and leave the current row empty. The empty row should have the same formatting and formulas as the row above.

 

Is this possible to do and if so, how?

 

Excel version 16.46

Mac OS Catalina v 10.15.7

1 Reply
best response confirmed by ViktorDahllof (Copper Contributor)
1 best response

Accepted Solutions
best response confirmed by ViktorDahllof (Copper Contributor)