Formatting Issues

Insert an Excel Row with the Same Formatting and Formulas

Adam DavisAdam Davis Nov 18, 2026 871 views

Question details

The user wants to insert a worksheet row that matches a neighboring row's formatting, formulas, and layout.

Insert an Excel Row with the Same Formatting and Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Insert the row

Right-click the row number below the desired insertion point and select Insert. Excel inserts a blank row above it.

2
Match the formatting

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.

3
Copy formulas if needed

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.

4
Adjust the row height

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 row and copy the neighboring row's formatting and formulas
Formatting does not copy formulas: Paste Special > Formats copies appearance, not formulas or values. Use a regular paste when you also want to copy cell contents, and remove any values you do not need.
Work with spreadsheets in WPS Office

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. 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and find the row below the desired insertion point.
  2. 2. Insert a row: Right-click that row's number and select Insert to add a blank row above it.
  3. 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. 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.
Insert rows and reuse neighboring cell formattingCopy formulas into the corresponding cells of a new rowOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for free
microsoft office alternative - wps office

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.