- Click a cell in the column to the right of where you want to insert a new column or in the row below where you want to insert a new row.
If you want to insert multiple rows or columns, select multiple cells. For example, to insert three rows, select three cells in a column.
- Right-click the cell or selection, point to Insert on the shortcut menu, and then click Rows or Columns.
Delete rows or columns- Click a cell in the column or row you want to delete.
If you want to delete multiple rows or columns, select multiple cells. For example, to delete three rows, select three cells in a column.
- Right-click the cell or selection, point to Delete on the shortcut menu, and then click Rows or Columns.