It's difficult to add a record at the end if you have to navigate through each record individually. Adding "first" and "last" buttons is essential. Furthermore, if the modified range is the data source of a pivot table, that data source should be modified if records are added or deleted.
Do: 1) Open Calc 2) Write cells in range A1:B13 Field1 Field2 A1 1 A2 2 A3 3 A4 4 A5 5 A6 6 A7 7 A8 8 A9 9 A10 10 A11 11 A12 12 3) Use menu Data - Form... 4) Add a new value at last: cells A14 and B14 Now) we need to press the "Next Record" button 12 times. I would like) to press a "Last Record" button to go to the last record and add a new one at the end.