Row & columns

Insert or delete rows, and columns

Insert or delete rows, and columns

Insert and delete rows and columns to organize your worksheet better.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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

Insert or delete a column

  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

  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

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.

For example, to insert a cell between “Summer” and “Winter”:

  1. Click the cell “Winter.”

  2. On the Home tab, click the arrow under Insert, and then click Insert Cells & Shift Down.

add a cell in a spreadsheet

A new cell is added above the cell “Winter” and looks like this:

New cell added

Insert rows

To insert a single row   : Right-click the whole row above which you want to insert the new row, and then click Insert Rows.

Add new rows

To insert multiple rows:    Select the same number of rows above which you want to add the new ones. Right-click the selection and click Insert Rows.

Insert columns

To insert a single new column:    Right-click the whole column to the right of where you want to add the new column. For example, to insert a column between columns B and C, right-click column C, and click Insert Columns.

Add new column

To insert multiple columns:    Select the same number of columns to the right of which you want to add new ones. Right-click the selection and click Insert Columns.

Delete cells, rows, or columns

If you don’t need any of the existing cells, rows or columns, here’s how to delete them:

  1. Select the cells, rows, or columns that you want to delete.

  2. On the Home tab, click the arrow under Delete, and then click the appropriate delete option.

Options on the ribbon for deleting cells, rows or columns

When you delete rows or columns, other rows or columns automatically shift up or to the left.

Tip: If you change your mind right after you deleted a cell, row or column, no problem, just press Ctrl+Z to restore it.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Basic tasks in Excel

Overview of formulas in Excel

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×