HOW TO Insert or delete cells, rows, and columns IN EXCEL

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
Open chat
Would you like to get published on this Popular Blog? You can now email Sande Kennedy any breaking news, Exposes, story ideas, human interest articles or interesting videos on: Videos and pictures can be sent to +254 791890826 here on WhatsApp by clicking this send button
Powered by