You might find that you need to add or delete rows or columns after you've already entered data into your worksheet. You can easily insert rows or columns between existing data—the data is simply shifted over to make room for the new columns or rows you insert. You can delete rows or columns just as easily—whether or not they contain data. When you delete rows or columns, existing data is shifted back to fill the gap created by the deleted cells. If you have written formulas that calculate across the table, the formulas adjust themselves automatically after you add or delete rows or columns.
Select the Row or Column
To insert a row, select the row under the location in which you want the inserted row to appear (click the row number to select it). The inserted row will appear above the row you select. To insert a column, select the column to the right of the place where you want the new column to appear (click the column letter to select it). The inserted column will appear to the left of the column you choose.
Select Adjacent Rows or Columns
To insert or delete several adjacent rows or columns at one time, drag over their headings to select the rows or columns. Right-click the selection and choose Insert or Delete. An equal number of rows or columns is inserted, or the selected rows or columns are deleted.