Inserting and Deleting Columns or Rows

Inserting and Deleting Columns or Rows

You can insert one or more blank columns and rows on a worksheet between columns or rows that are already filled. The header buttons above each column and to the left of each row indicate the letter or number of the column or row. Inserted columns are added to the left of the selected columns. Inserted rows are added above the selected rows. Excel repositions existing cells to accommodate the new columns and rows and adjusts any existing formulas so that they refer to the correct cells. The Insert menu can change depending on the selection. When you select a column, only the Columns command appears on the Insert menu. When you select a row, only the Rows command appears.

Insert One or More Columns or Rows

To insert a column, click the column header button directly to the right of where you want to insert the new column.

To insert a row, click the row header button directly below where you want to insert the new row.

To insert multiple columns or rows, drag to select the header buttons for the number of columns or rows you want to insert.

Click the Insert menu, and then click Columns or Rows.

Delete One or More Columns or Rows

Select the columns or rows you want to delete.

Click the Edit menu, and then click Delete.