Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

Insert or Delete Cells, Columns and Rows in Excel 2013

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.

How to insert or delete a cell, row, or column 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 new rows in Excel

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 toolbar Home.

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.

How to insert a new cell in the column and to other cells and columns do not move

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.

How to delete a single cell and to other cells in the worksheet Excel moves the upward
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).
How to delete multiple cells and adjacent cells move into place Deleted Excel cells

How to 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 command Delete. Now the respective selected row deleted.

How to remove the line from the right-click

Deleting multiple rows in Excel 2013

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.

How to delete multiple rows in Excel - for beginners

Insert and Delete Columns in Excel

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