There is no worksheet function to either add/insert or delete a row/column on
a worksheet. This type of thing has to be done with VBA (a macro). One
could be tied to a particular column in the Worksheet_Change() event handler
to do this - gets a bit complex in copying the format and formulas, but still
doable.

"aeddave" wrote:

Hi,

Is there a function or formula to automatically insert a new line in Excel.

In this instance, I have a spreadsheet with three sections (top to bottom).
As a new line (record) is entered, I need a new line (with the same
formatting / formulas) to be created below to enter another record if needed.

The effect would be to increase the size of that section by one line witout
running into the next section.

Thanks