1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Insert Rows into Excel Worksheets

Insert Rows into a Worksheet Using the Mouse


Insert Rows into an Excel Worksheet

Insert Rows into an Excel Worksheet

© Ted French

As with all things Microsoft, there is more than one way to add rows to an Excel worksheet. These instructions show you how to insert rows by right clicking on the row header.

The row header is the gray bar along the left edge of the worksheet containing the row numbers.

Insert Rows to an Excel Worksheet

When you insert a row to a worksheet, the rows of data below the insertion point are pushed down.

To insert more than one row, select more than one row in the row header. For example, if you want to add two rows, select two rows in the row header.

To insert a single row

  1. Right click on the row header below where you want the new row added to open the right click context menu.
  2. Choose Insert from the menu.
  3. The new row will be inserted above the row you selected.

To insert multiple rows

  1. In the row header, select the number of rows you want added to the worksheet.
  2. Right click on the selected rows.
  3. Choose Insert from the context menu.
  4. The new rows will be inserted above the rows you first selected.

©2014 About.com. All rights reserved.