Insert or delete cells, rows, and columns

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

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. To insert a column, select the column, select Home > Insert >  Insert Sheet Columns.

2. To delete a column, select the column, select Home > Insert > Delete Sheet Columns.

   Or, right-click the top of the column, and then select Insert or Delete.

Insert or delete a row

1. To insert a row, select the row, select Home > Insert > Insert Sheet Rows.

2. To delete a row, select the row, select Home > Insert > Delete Sheet Rows.

   Or, right-click the selected row, and then select Insert or Delete.

Insert a cell

1. Select one or more cells. Right-click and select Insert.

2. From the Insert box, select a row, column or cell to insert.

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