SOLVED

Automatically inserting row in bottom of table

%3CLINGO-SUB%20id%3D%22lingo-sub-2214256%22%20slang%3D%22en-US%22%3EAutomatically%20inserting%20row%20in%20bottom%20of%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2214256%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20my%20table%20to%20have%20an%20empty%20row%20below%20the%20data%20and%20above%20the%20summary%20where%20I%20can%20add%20information.%20When%20I%20add%20information%20to%20this%20row%20I%20would%20like%20excel%20to%20either%20automatically%20create%20a%20new%20empty%20row%20below%20the%20information%20or%20create%20a%20new%20row%20with%20the%20information%20above%20the%20row%20I%20entered%20the%20info%20and%20leave%20the%20current%20row%20empty.%20The%20empty%20row%20should%20have%20the%20same%20formatting%20and%20formulas%20as%20the%20row%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20to%20do%20and%20if%20so%2C%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20version%2016.46%3C%2FP%3E%3CP%3EMac%20OS%20Catalina%20v%2010.15.7%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2214256%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2214453%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20inserting%20row%20in%20bottom%20of%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2214453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999163%22%20target%3D%22_blank%22%3E%40ViktorDahllof%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2019%2F01%2F24%2Fadd-data-to-excel-table-with-total-row%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAdd%20Data%20to%20Excel%20Table%20with%20Total%20Row%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 (Occasional Visitor)