How to Insert Multiple Rows in Excel 2007

1. Open the appropriate Microsoft Excel 2007 worksheet on your computer.
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. Click on the 'Home' tab and then click on the arrow next to the 'Insert' field in the 'Cells' group.
4. Click on the 'Insert Sheet Rows' option and then multiple rows will be inserted above your highlighted cells.
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.