Deleting a Column or Row

At some point in time, you may want to remove an entire column or row of data from a worksheet rather than deleting or editing individual cells . You can delete columns and rows just as easily as you insert them. Formulas will need to be checked in your worksheet prior to deleting a row or column, especially when referencing absolute cell addresses. Remaining columns and rows move to the left or up to join the other remaining data.

Delete a Column or Row

Select the column header button or row header button that you want to delete.

Click the Edit menu, and then click Delete.

See Also

See " Hiding and Unhiding a Column or Row " on page 81 for information on hiding data without deleting it.

Delete Multiple Columns or Rows

Select the columns header buttons or rows header buttons that you want to delete.

Click the Edit menu, and then click Delete.

Did You Know?

You can re-check your formulas . When deleting columns or rows that are referenced in a formula, it is important to adjust your formula for recalculations.