• 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 right of where you want to insert a column, or below where 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 and select Rows or Columns. Excel inserts row above your selection; column to the left of your selection. The inserted rows or columns contain the same formatting as the cells you selected in step 1. Figure 13.1 simulates a worksheet before and after two rows were inserted.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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