Add Rows to an Excel Worksheet

By Ted French, About.com Guide

Add Rows to a Worksheet

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

In Excel, there is often more than one way to accomplish a task and adding rows is no different.

This tutorial covers how to add rows to an Excel worksheet 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. If necessary, open the worksheet saved in the previous step of the tutorial.


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


3. Right click on the selected rows.


4. Choose Insert from the drop down menu.


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


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


7. Save your worksheet.

Return to Index page