How to Insert or delete rows, and columns in Excel

  Excel tutorials

In this post, we will show how to Insert and delete rows and columns to organize your worksheet better in Excel.

Insert or delete a column in Excel

  1. Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
  2. Alternatively, right-click the top of the column, and then select Insert or Delete

Insert or delete a row in Excel

  1. Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.
  2. Alternatively, right-click the row number, and then select Insert or Delete.

Formatting options in Excel

When you select a row or column that has formatting applied, that formatting will be transferred to a new row or column that you insert. If you don’t want the formatting to be applied, you can select the Insert Options button after you insert, and choose from one of the options as follows:

Image of the Insert Options button that's displayed after inserting rows or columns.

If the Insert Options button isn’t visible, then go to File > Options > Advanced > in the Cut, copy and paste group, check the Show Insert Options buttons option.

Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall.