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

Lesson 13. Inserting and Removing Cells,... > Inserting Rows and Columns

Inserting Rows and Columns

Inserting entire rows and columns in your worksheet is easy. Here's what you do:

  1. To insert a single row or column, select the cell to the left of which you want to insert a column, or above which you want to insert a row.

    To insert multiple columns or rows, select the number of columns or rows you want to insert. To insert columns, drag over the column letters at the top of the worksheet. To insert rows, drag over the row numbers. For example, select three column letters or row numbers to insert three rows or columns.

  2. Open the Insert menu.

  3. Select Rows or Columns. Excel inserts the row(s) or column(s) and shifts the adjacent rows down or the adjacent columns right. The inserted rows or columns contain the same formatting as the cells you selected in step 1. Figure 13.3 simulates a worksheet before and after two rows were inserted.

    Figure 13.3. Inserting two rows in a worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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