Inserting Rows

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.

Insert-Row-Dropdown.jpg

Or, click on a row or cell, select Insert from the top menu bar, and select one of the insert options from the dropdown.

Insert-Row-Menu-Bar.jpg

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.

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.