Deleting columns or rows
  1. Select the column(s) or row(s) you want to delete.

  2. In the action bar, click Range.

  3. In the pop-up menu, click Delete Selected Column(s) or Delete Selected Row(s).



Details

When you delete columns, the columns to the right move left to take the place of what you deleted. When you delete rows, the rows below move up to take the place of what you deleted.



How deleting columns or rows affects formulas

If you delete a column or row containing a range that a formula refers to, the formula results in ERR. Any other formulas that depend on this formula also result in ERR.



How deleting columns or rows affects named ranges

If you delete columns or rows containing cells that are part of a named range, the named range shrinks by the number of columns or rows you deleted.

If you delete an entire named range, the name is no longer associated with that range. To maintain that association, you must name the range again.



See also
Inserting columns or rows
Sizing columns
Sizing rows
Hiding columns or rows
More power with formulas
Naming a range