How to Insert a New Row & Copy Formulas in Excel
- 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."
