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.
There are a few ways to insert a new row above or below a current row. To insert a row, right-click on a row and select "Insert 1 row above" or "Insert 1 row below" from the dropdown.
Or, click on a row or cell, open the document menu, and navigate to Insert > Insert row.
How to Access the Document Menu
To access the document menu,
- Open the document dropdown by clicking the arrow to the right of the document name
- Select "Menu..." from the dropdown
By selecting multiple rows at once, you can insert as many new rows as you have selected. To do so, select your desired number of new rows and follow either of the steps described above.
You can also insert multiple new rows at the bottom of your workbook. Click the + button to add one new row, or specify a number of new rows and click Add.
The cell styling and data types for the new row are inherited from the row from where the insert action was initiated. 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.
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 read on through the rest of our articles on rows, including how to copy rows and reorder rows.