HOW TO Insert or delete cells, rows, and columns

1 min


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.

Like it? Share with your friends!

Sande Kennedy

Sande Kennedy is the founder and Editor in Chief of & He is a Kenyan-based Internetprenuer,blogger Political Activist & informer who has an interest in politics, governance, corporate-fraud and human-interest. Kindly drop me a note if you feel aggrieved on any matter that you would want to be highlighted  Twitter: @itssandekennedy , Instagram: @itssandekennedy WhatsApp: +254791890826 Read More about me here