Row & columns

Insert or delete cells, rows, and columns

Insert or delete cells, rows, and columns

Insert and delete rows, columns, and cells 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. 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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.

×