Excel for Office 365 Excel Online Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

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

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.