With Spreadsheet.com, you can quickly add new empty rows to your worksheets. Insert rows to add new data to your table, create rows in-between others to paste new data in, or move data around in your worksheet.
How to Insert a New Row
There are a few ways to insert a new row above or below a current row. To insert a row, first choose where in your worksheet you want to add a row and select the row above or below that spot. For instance, in the animation below, we want to add a row between rows 7 and 8, so select row 7. Then, right-click on the row header or a cell in that row and select Insert 1 row above or Insert 1 row below from the options.
Alternatively, you can select the row header or cell in a row and select Insert 1 row above or Insert 1 row below from the Insert menu options.
To insert more than one row at a time, select the number of rows you'd like to enter and then right-click the row header or navigate to the Insert menu. The number of rows inserted defaults to 1, but is also based on the number of rows you have selected.
The cell styling for the new row will be taken from the row from where the insert action was initiated. For instance, in the animation below, we add a new row 7 and the new data we enter matches the data types of the previous row 7.
Most formulas should automatically remap cell references even after you insert a row or rows. However, some formulas may be impacted by inserting a new row and may need to be adjusted. For more details, see our article on Formula Readjustment.
This article only covers adding a new row to the worksheet you have open. With related rows, you can also add new rows to related worksheets. For more information, check out our article on the Related Row Data Type. Or, for more on how to working with rows check out our corresponding articles, including how to copy rows or reorder rows.