How to Copy an Excel Worksheet Without Changing Column Widths in WPS Spreadsheets
Question details
The user needs to duplicate an Excel worksheet while preserving the original column widths, row heights, formatting, formulas, and layout.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user wants to copy an entire worksheet tab to another workbook or reuse the same layout repeatedly without losing column width and formatting settings.
- Observed behavior
- The copied worksheet retains the original column widths, row heights, formulas, and formatting when the entire sheet tab is duplicated.
Open the source workbook in WPS Spreadsheets and make sure the destination workbook is open or created. If you plan to reuse the layout, decide whether to duplicate the sheet now or save it as a template.
Use Move or Copy to Duplicate the Worksheet Tab
Use this when you need an exact copy of a worksheet within the same workbook or into another workbook while preserving column widths, row heights, formatting, formulas, and layout.
Copying the entire worksheet tab preserves the sheet structure more reliably than copying and pasting cell contents.
Open the workbook that contains the worksheet you want to copy and, if needed, open or create the destination workbook.
Right-click the sheet tab at the bottom of the window, then choose Move or Copy from the context menu.
In the dialog box, select the destination workbook and the position where the copied sheet should appear, then enable Create a copy.
Click OK. The new worksheet appears with the original column widths, row heights, formulas, and formatting unchanged.
Save the Workbook as an Excel Template for Reuse
Use this when you need to reuse the same worksheet layout repeatedly without manually copying it each time.
Copy an Excel Worksheet Without Changing Column Widths in WPS Spreadsheets
In WPS Spreadsheets, use the Move or Copy command to duplicate the entire worksheet tab. This keeps column widths, row heights, formulas, and formatting intact, and works seamlessly with Microsoft Excel .xlsx files.
- 1. Open WPS Spreadsheets: Launch WPS Office, then open the workbook that contains the worksheet you want to copy.
- 2. Right-click the worksheet tab: Right-click the source sheet tab at the bottom of the window and choose Move or Copy.
- 3. Choose destination and enable Create a copy: Select the destination workbook and sheet position, then check Create a copy.
- 4. Click OK: Click OK to create a duplicate worksheet with the same column widths and layout.
Frequently Asked Questions
Will this method preserve formulas and row heights as well as column widths?
Yes. When you right-click the worksheet tab and choose Move or Copy with Create a copy enabled, WPS copies the entire sheet object, including column widths, row heights, formulas, cell formatting, and layout.
Can I copy a worksheet from one workbook to another in WPS Spreadsheets?
Yes. Open both workbooks, right-click the source sheet tab, choose Move or Copy, select the destination workbook from the To book dropdown, choose a position, enable Create a copy, and click OK.
Why does copying and pasting a range sometimes change column widths?
Pasting a cell range into a new location may use the destination worksheet’s column widths or require manual resizing. Copying the entire sheet tab duplicates the source sheet structure, so widths are preserved automatically.
How do I reuse the same worksheet layout without copying it every time?
Create an Excel template: go to File > Save As, choose Excel Template (*.xltx), and then start new workbooks from that template. The template stores the same column widths, formatting, and layout.
Does this work with Microsoft Excel files?
Yes. WPS Spreadsheets is fully compatible with Microsoft Excel formats, including .xlsx and .xltx, so you can open, copy, save, and share these files without changing column widths.
