Insert formula automatically with new entry

[Clare]

Hi
Is there a way you can copy formulas to the next line when a new entry is automatically added to a spreadsheet via a form?

Thanks

[smb_146]

Hi
Is there a way you can copy formulas to the next line when a new entry is automatically added to a spreadsheet via a form?

Thanks

Convert your range to a Table. You can do this by Selecting the range and then pressing CTRL+T on keyboard or by Clicking on FORMAT AS TABLE option on the HOME TAB. Now every time you insert a new row the table will Autofill all the formulas.