Copy an Excel Formula Table to Multiple Sheets Without Input Data
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.
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.
Copy the worksheet and clear input constants
Use a copied worksheet as a reusable blank template while preserving its formulas and layout.
Right-click the worksheet tab, select Move or Copy, check Create a copy, choose where to place it, and select OK.
On the copied sheet, select the input range or ranges you want to clear. Exclude headings and fixed values that must remain.
Press Ctrl+G, select Special, choose Constants, and select OK. If appropriate, limit the selection to specific value types before confirming.
Press Delete to clear the selected constants. Check that the table headings, fixed values, and formulas remain.
Right-click the cleared sheet tab and use Move or Copy with Create a copy selected for each additional worksheet.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 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. 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. 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.

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.




