How to Insert a New Row & Copy Formulas in Excel

The Paste Special feature lets you choose how you want your data pasted in Excel.

Microsoft Excel is a spreadsheet application. It allows you to input data and apply formulas. You can format your spreadsheet by inserting one or more cells in a worksheet. You can also copy formulas from one cell to another to save time. The Paste Special feature lets you choose how you want your data pasted in Excel. According to Microsoft Office, "You can paste only the formula results," so you should "Verify that the cell references in the formula produce the result that you want."

Instructions

1. Right-click on the row header where the new row will go, then click "Insert." To insert a number of rows, select them on your worksheet. Then right-click and select "Insert" from the pop-up.

2. Select the cell containing the formula you want to copy. Right-click and choose "Copy" from the pop-up.

3. Place your cursor in the cell the formula will go. Right-click and select "Paste Special."

4. Choose "Formulas" in the "Paste Special" dialog box. Then click "OK."

References

• Microsoft Office Online: Copying Excel Formulas
• Microsoft Office Online: Insert Rows in Worksheet