Deleting rows or columns

To insert an entire row of blank cells, click on a row heading, which selects an entire row. Then choose Rows from the Insert menu. A new row will be inserted above the row you selected. (Insertion occurs above or to the left of the selected row or column, respectively.) Multiple rows or columns can be inserted in a similar fashion, by selecting as many rows or columns as you want to insert. 

When inserting partial rows or columns, take care that other parts of the worksheet do not become mis-aligned. 

Complete rows or columns are deleted in a similar manner. Click on the row or column header to select the rows or columns to be deleted, then choose Delete from the Edit menu. To delete cells within a row or column, select them with the mouse, then choose Delete. You will be asked whether the cells should be moved up or to the left. When deleting partial rows or columns, take care that other parts of the worksheet do not become mis-aligned. 

---

Cell references are adjusted when you Insert or Delete rows or columns, too. If you Insert a new column to the left of column A in the preceding example, the formula in cell B2, which used to be cell A2, will read =B1+1. 

---