• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Using Excel > Task 6 How to Insert and Delete Columns and Rows

Task 6 How to Insert and Delete Columns and Rows

You might find that you need to add or delete rows or columns after you've already entered data into your worksheet. You can easily insert rows or columns between existing data—the data is simply shifted over to make room for the new columns or rows you insert. You can delete rows or columns just as easily—whether or not they contain data. When you delete rows or columns, existing data is shifted back to fill the gap created by the deleted cells. If you have written formulas that calculate across the table, the formulas adjust themselves automatically after you add or delete rows or columns.

  1. Select the Row or Column

    To insert a row, select the row under the location in which you want the inserted row to appear (click the row number to select it). The inserted row will appear above the row you select. To insert a column, select the column to the right of the place where you want the new column to appear (click the column letter to select it). The inserted column will appear to the left of the column you choose.



  2. Choose Insert

    Right-click the selected row or column and choose Insert from the shortcut menu.



  3. A New Row or Column Is Inserted

    A new row is inserted above the row you selected. A new column is inserted to the left of the column you selected. To select whether formatting is applied to the row or column you inserted, click the arrow on the Paste Options button and make a selection.



  4. Select the Row or Column

    To delete a row or column, select its heading.



  5. Delete the Row or Column

    Right-click the selected column or row and choose Delete from the shortcut menu. As soon as you select the command, the column or row is immediately deleted. Adjacent data is shifted up or to the left to fill the gap.



  6. Select Adjacent Rows or Columns

    To insert or delete several adjacent rows or columns at one time, drag over their headings to select the rows or columns. Right-click the selection and choose Insert or Delete. An equal number of rows or columns is inserted, or the selected rows or columns are deleted.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint