Did you mean to attach a file? It didn't quite make it.

You can right-click the row header and select "Insert" from the context menu to insert a new row in a spreadsheet.

If your data is formatted as a table (using Insert Ribbon > Table) then all formulas and formatting will automatically be applied to the new row, as well as to any row of data that is added at the bottom of the table.