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.

Choose Insert

Right-click the selected row or column and choose Insert from the shortcut menu.

A New Row or Column Is Inserted

A new row is inserted above the row you selected. A new column is inserted to the left of the column you selected. To select whether formatting is applied to the row or column you inserted, click the arrow on the Paste Options button and make a selection.

Select the Row or Column

To delete a row or column, select its heading.

Delete the Row or Column

Right-click the selected column or row and choose Delete from the shortcut menu. As soon as you select the command, the column or row is immediately deleted. Adjacent data is shifted up or to the left to fill the gap.

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.