Add and Delete Columns and Rows in Excel

Add and Delete Columns and Rows in Excel - Sometimes we need additional rows and columns in an excel worksheet that we use. Likewise, when certain emerging desire to remove some of the columns and rows in Excel. And it turns out how to add and delete columns and rows in Excel is very easy, even without reading the article even this fact you may already be. Only by using the click of a mouse on your computer.

Adding Rows and Columns

ADD ROW

1. To insert a row into the spreadsheet with the mouse pointer, right click on the header row below where you want the new row is added.
2. Select "Insert"
3. The new line will be inserted at the top of the line that you choose.
4. To add more than one new row, select more than one line in the header row.
5. On the header row, pull the number of lines to be added to the spreadsheet.
6. Right-click on the selected row.
7. Select Insert from the menu.
8. The new line will be inserted at the top of the first line that you select.

ADD COLUMN

1. To add a column to the spreadsheet with the mouse pointer, right click on the column header where you want the new column is added.
2. Select "Insert"
3. The new column will be inserted to the left of the selected column.
4. To add more than one new column, we select more than one column in the column header.
5. In the column header, drag select the number of columns you want to add to the spreadsheet.
6. Right-click on the selected column.
7. Select "Insert"
8. The new column will be inserted to the left of the selected column.

Deleting Rows and Columns

Before you remove, it is important to note that any data that is located in the deleted row or column, will be deleted as well. If you make a mistake, use the Undo from the Edit menu to get your data back or by pressing Ctrl + Z.

1. To delete a row from a spreadsheet, right-click on the row header row you want to delete and then select "Delete"
2. To remove a few rows of the spreadsheet In the header row, select the row you want to delete. Right-click on the selected row, and then select Delete.
3. To delete a column of the spreadsheet, right click on the column you want to delete. Select Delete.
4. To remove some of the columns of a spreadsheet, In the column header, select the column you want to delete. Right-click on the selected column. Select Delete.

What changes occur

When you add or delete columns or rows, the cell references in functions and formulas will usually update automatically. For example, if you have a cell reference in the formula A11 and then add a line at the top of this, the formula will change the reference from A11 to A12 to reflect the fact that the line 11 is driven down into 12 rows after a new row is added.