Insert an Excel Row with the Same Formatting and Formulas
Question details
The user wants to insert a worksheet row that matches a neighboring row's formatting, formulas, and layout.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding a row to an existing worksheet while preserving the appearance and calculations of nearby rows.
- Observed behavior
- The new row should have matching formatting and any required formulas, with an appropriate row height.
Identify the neighboring row that has the formatting and formulas you want to reuse. Check whether it contains values that should not be copied into the new row.
Insert a row and copy the neighboring row's formatting and formulas
Use Excel's Insert command, then apply formatting or copy formulas from the row above or below.
Right-click the row number below the desired insertion point and select Insert. Excel inserts a blank row above it.
If the Insert Options button appears beside the new row, click it and choose Format Same As Above or Format Same As Below. Alternatively, copy the source row, select the new row, and choose Home > Paste > Paste Special > Formats.
Select and copy the formula cells in the neighboring row, then paste them into the corresponding cells in the new row. Check the pasted formulas to make sure their cell references are correct.
If the new row's height differs, drag the boundary below its row number to match the neighboring row. Column widths apply to the whole column, so they already match.

Insert a matching spreadsheet row in WPS Office
Use WPS Spreadsheets to insert a row, apply a neighboring row's formatting, and copy the formulas you need.
- 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and find the row below the desired insertion point.
- 2. Insert a row: Right-click that row's number and select Insert to add a blank row above it.
- 3. Copy the formatting: Copy the neighboring source row, select the new row, and use Home > Paste > Paste Special > Formats to apply its cell formatting.
- 4. Add formulas and adjust height: Copy the source formula cells and paste them into the corresponding cells in the new row. Check the references, then drag the row boundary if you need to adjust its height.

Frequently Asked Questions
Does inserting a row automatically copy formulas in Excel?
Not always. Copy the formula cells from a neighboring row and paste them into the new row, then check the cell references. Excel tables may automatically extend calculated-column formulas.
How do I copy formatting without copying values?
Copy the source row, select the destination row, and choose Home > Paste > Paste Special > Formats.
Why is the new row a different height?
Cell formatting and row height are separate settings. Drag the boundary below the new row's number, or set its height using Excel's Home > Format > Row Height command.
Can I make the new row use the same column widths?
Column widths apply to entire columns, not individual rows. A new row in the same worksheet automatically uses the existing column widths.




