Formula Errors

Copy an Excel Formula Table to Multiple Sheets Without Input Data

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

The user needs to duplicate a table across worksheets while retaining its structure and formulas but removing existing input data.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Create multiple worksheets with the same formula table and empty input cells.
Observed behavior
Each copied sheet should retain the table layout and formulas without the original input values.
Before you start

Identify the input cells you want to empty and any fixed values or headings that must stay. The Constants selection can include text, numbers, and other non-formula values, so avoid selecting cells you need to keep.

Solution 1Recommended

Copy the worksheet and clear input constants

Use a copied worksheet as a reusable blank template while preserving its formulas and layout.

1
Copy the worksheet

Right-click the worksheet tab, select Move or Copy, check Create a copy, choose where to place it, and select OK.

2
Select input cells

On the copied sheet, select the input range or ranges you want to clear. Exclude headings and fixed values that must remain.

3
Select constants

Press Ctrl+G, select Special, choose Constants, and select OK. If appropriate, limit the selection to specific value types before confirming.

4
Clear the inputs

Press Delete to clear the selected constants. Check that the table headings, fixed values, and formulas remain.

5
Make additional copies

Right-click the cleared sheet tab and use Move or Copy with Create a copy selected for each additional worksheet.

Formula results may change: Formulas remain in place, but their displayed results may change when the input cells are cleared. Review formulas that refer to other sheets or depend on the removed values.
Work with formula tables

Create blank formula-table copies in WPS Spreadsheets

Copy a worksheet in WPS Spreadsheets, clear its input cells, and use the cleared sheet to create additional copies with the same formulas and layout.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Copy the sheet: Right-click the worksheet tab and choose Move or Copy Sheet. Select the option to create a copy and confirm.
  3. 3. Clear input cells: On the copied sheet, select only the cells containing input values and press Delete. Leave formula cells, headings, and fixed values unselected.
  4. 4. Create more sheets: Right-click the cleared sheet tab and use Move or Copy Sheet to create additional copies. Save the workbook in your desired Excel format.
Reuse a formula table across multiple worksheetsOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Will clearing constants also remove my table headings?

It can. Headings typed as text are constants, so exclude them from the selected range before using Ctrl+G > Special > Constants.

Will Delete remove formulas after I select Constants?

No. Go To Special > Constants selects non-formula values, so pressing Delete clears those selected values rather than formula cells. Check the selection before deleting.

How do I make several blank copies without clearing each one?

First copy the original sheet and clear its input constants. Then right-click that cleared sheet tab and use Move or Copy with Create a copy selected for each new sheet.

Why do formula results change after I clear the inputs?

The formulas still calculate, but they no longer have the original input values. Check the formula bar and any references to other sheets to confirm that the results are appropriate.