When you are building a spreadsheet, you may discover that you need to insert new cells, columns or rows.
To insert cells, select the cells where you want the new cells to go. Next, select Cells from the Insert menu (or by right clicking your mouse). The "Insert Cells" dialog will appear. Choose whether you want the selected cells and their contents to be shifted down or right. Click on OK to insert the new cells.
To insert a row, click on the row bar to select where you want the inserted row to appear. The whole of the row is selected, rather than a range of cells. Select Cells from the Insert menu (or by right clicking your mouse). The new row will be inserted, and the selected row and all rows beneath the selected row will be shifted one row down. Note that the "Insert Cells" dialog does not appear when inserting rows.
To insert a column, click on the column bar to select where you want the inserted column to appear. The whole of the column is selected, rather than a range of cells. Select Cells from the Insert menu (or by right clicking your mouse). The new column will be inserted, and the selected column and all columns to the right of the selected column will be shifted one column to the right. Note that the "Insert Cells" dialog does not appear when inserting columns.
It is possible to insert several rows or columns at once by selecting the required number of row or column bars.
Note: Spreadsheet readjusts formulas and range references to compensate for inserted rows and columns.
See also: