Blue Flower

Insert or Delete Cells, Columns, Rows, Sheet in Excel

In Excel 2013, we can insert or add cells, rows and columns, and so we can only delete cells, rows or columns. At Home in the toolbar group commands Cells are two buttons that serve to insert or delete cells, rows or columns.

Insert the button

  • Insert Cells
  • Insert Sheet Rows
  • Insert Sheet Columns
  • Insert Sheet

Delete the button 

  • Delete Cells
  • Delete Sheet Rows
  • Delete Sheet Columns
  • Delete Sheet

Notice in the figure below which all commands containing the buttons to insert or delete cells, rows or columns.

Insert or Delete Cells, Rows, Columns, Sheet in Excel

Inserting New Rows in Excel

If you want to insert a row in your table then it can be done in several ways:

  1. Inserting rows via the Insert button on the Home toolbar and command Insert Sheet Rows
  2. There is still the possibility to set the Insert Row the button to the Quick Access Toolbar in Excel 2013 (arrow 2a)
  3. Inserting a row by clicking on a cell, right-click mouse over which we want to insert a new row and click the Insert command from the pop-up menu, and then turn on the radio button Entire Row. Now we have inserted a new row and also a new cell in the column.
  4. Inserting a row by clicking on the number of rows (row header), right-click over the row which you want to insert a new row and click the Insert command from the pop-up menu, and then turn on the radio button Entire Row. Now we have inserted a new row and also a new cell in the column.

Inserting Rows in Excel using the right mouse button

Inserting New Cells in Excel column

If you have more information or a table with data, we want to insert a new cell but to the rest of the data in other columns do not move then we have the ability to insert one or more cells in one column and the others remain in place. As for inserting rows and insertion cells we have the Insert Cells command on the Home toolbar.

Inserting the a Cells can do and clicking the right mouse button on a cell and command the pop-up menu.

  1. Right-click mouse on the cell that you want to insert a new cell above
  2. Opens a pop-up menu to select which command Insert
  3. In the dialog box, turn on the radio button Shift cells down

Now you have inserted a new cell in the same column and the data in the other columns can be found at his former place and not to have moved. Notice in the image below in a Column 'A' after inserting new cells have a cell of excess.

Insert one cell only in the column and the other cells remain in place

Deleting a Cell in Excel column

If you want to delete one or more cells then we can do this via the Insert button located on the Home toolbar and command Delete Cells

  1. We can also right-click on the cell you want to delete the column.
  2. On the pop-up menu, choose the Delete command
  3. In the dialog box, turn on the Shift cells up

Now we have a new situation where all the cells below shifted upward by one cell.

Deleting a single Excel cell in the column and move the other up

In case if you use the steps as I wrote above I would note that there is a possibility that the inclusion of the option radio buttons Shift cell left you can delete one or more cells and adjacent cells with that found in the right column will move to the left column to place of deleted cells (see figure below).

Deleting a cell in Excel and move the adjacent cells to the left

Delete a Row in Excel

To delete a row in an Excel 2013 worksheet, then proceed the same as for deleting cells but with the difference that you select an row by clicking on the number row (header row).

So, row in Excel you can delete via the Insert Button on the toolbar Home and the command Delete Sheet Row.

Row in a worksheet Excel 2013 you can also delete it by clicking the right mouse button on the number row (row header) and then the pop-up menu, choose the Delete command. Now the respective selected row deleted.

Deleting rows by selecting the number of rows or columns by selecting letters

Deleting Multiple Rows in Excel

If you want to delete multiple rows in a worksheet Excel, proceed the same way as in the previous instructions but first you please select multiple rows.

Deleting multiple rows or columns by selecting multiple in Excel 2013

Insert and Delete Columns in Excel

All instructions that are listed above also apply to the Columns in the worksheet Excel 2013