1. Computing

Basic Excel Formulas Tutorial

By , About.com Guide

3 of 9

Insert Rows to the Worksheet
Insert Rows in Excel

Insert Rows in Excel

© Ted French

Insert Rows to the Worksheet

There are times when you need to alter the appearance of a worksheet by inserting additional rows or columns of data.

This tutorial covers how to insert rows using the mouse.

Tutorial Steps:

We will add two new rows to the worksheet so that we have room to add the date.

For help on these steps, refer to the image above.

  1. In the row header, use the mouse to drag select rows three and four.

  2. Right click on the selected rows.

  3. Choose Insert from the drop down menu.

  4. Two new rows will be inserted above the rows you first selected.

  5. If done correctly, the heading Deduction Rate should now be in row five.

  6. Save your worksheet.

Return to Index page

©2013 About.com. All rights reserved.