How to Insert Multiple Rows in Excel 2007

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Email

The Microsoft Office Excel 2007 spreadsheet application allows you to create and use a worksheet composed of cells. You can add data to these cells to create lists or make graphs. When working with a group of cells, you can insert more rows or columns at any time. Using the "Insert Sheet Rows" option, you can insert multiple rows into your worksheet. After you have inserted your new rows, you can then format the rows to meet your preferences.

Skill level:


  1. 1

    Open the appropriate Microsoft Excel 2007 worksheet on your computer.

  2. 2

    Use your mouse to highlight the number of rows below the area where you want to insert new rows. For example, highlight five rows if you want to insert five more rows above that group.

  3. 3

    Click on the "Home" tab and then click on the arrow next to the "Insert" field in the "Cells" group.

  4. 4

    Click on the "Insert Sheet Rows" option and then multiple rows will be inserted above your highlighted cells.

  5. 5

    Click on the "Microsoft Office" button from the top toolbar ribbon menu and then click on the "Save" option so that your new changes are saved.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.