Adding new rows

Adding a new row between other rows in your spreadhseet
Sometimes you need to insert new data in the middle of a table. For instance, when you add a new person into an alphabetically sorted list, or if you just forgot to insert a line of data or skipped it by mistake.

One way is to move a whole region of the table one row downwards by using cut-and-paste. This is not recommended, it will be complicated with big tables, especially if you wish to insert several new rows in different places.

The correct and simple way to do it, as can be seen in this video, is to use “Insert” to add a blank row exactly where you want. This way you will also keep the format and styling of the table intact.

Right click the row number and select “Insert”.