Hide

Adding new rows to the worksheet

You can download here the worksheet from this video to practice it by yourself!

Why and when is it useful?

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.

How do you add new rows?

Very Simple! Right click the row number and select “Insert” from the context menu. This row (including everything below it) will be pushed down, and a new blank row will appear.