Insert or delete rows or columns
- In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
- Do one of the following:
- 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.
- 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.
Notes
- You can't delete rows or columns from a range that includes filtered rows. To delete these rows or columns, you must first turn off filtering by clicking AutoFilter
so that it is no longer selected.
- If you delete data that's used in a formula elsewhere on the spreadsheet, you'll see an error value such as #REF in that formula's cell.
- 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.