Excel - Insert or Delete Cells

Article Posted on 11/07/2019

If you want to insert or delete, cells, a row, or a column you'll use the insert button under the home tab.


Once you click insert or delete you will get the following options (delete will have the same options, and perform the same tasks, but will delete the cells instead of insert them):


Insert Cells will insert single cells, it will give you the option of how you would like to shift your cells to accommodate the new cells.

Insert Sheet Rows will insert an entire row

Insert Sheet Columns will insert an entire column

Insert Sheet creates a new worksheet which will appear as a tab on the bottom of your workbook**


**A quicker way to insert a new sheet is to click the + sign by the tabs on the bottom of your workbook, you can delete a sheet by right clicking and selecting "delete".


Kopsa Otte
  • kopsa otte CPAs & Advisors
  • 306 East Seventh Street
  • York, NE 68467
  • 1-402-362-6636