How to Copy Excel Worksheets While Keeping Row Heights and Margins
Question details
The user needs to copy data from one Excel worksheet to another while retaining worksheet-level settings such as row heights and page margins.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Duplicating worksheet data for a new project or report while maintaining the exact original print layout and formatting dimensions.
- Observed behavior
- Standard cell-level copying fails to transfer worksheet-level properties, resulting in lost row heights, page setup, and margin settings in the pasted area.
Before duplicating your worksheet, ensure you have saved the current workbook. If you plan to copy the sheet to a completely different file, make sure the destination workbook is currently open in the same Excel window.
Duplicate the Entire Worksheet Tab
The most reliable method to preserve all worksheet-level formatting, including row heights and page margins, is to use the Move or Copy feature directly on the sheet tab.
Instead of highlighting cells and using Ctrl+C, manipulating the worksheet tab ensures that Excel copies the underlying structure of the page, not just the data contained within the grid.
Look at the bottom of your Excel window and find the tab containing the name of the worksheet you want to copy.
Right-click the sheet tab and select 'Move or Copy...' from the context menu that appears.
In the 'To book' drop-down list, choose whether to copy the sheet to the current workbook, a new workbook, or another currently open workbook.
Ensure you check the box that says 'Create a copy'. If you skip this step, the worksheet will be moved instead of duplicated.
Click 'OK'. The new worksheet will be created with the exact same row heights, column widths, and margin settings as the original.

Duplicate Worksheets Perfectly in WPS Office
WPS Spreadsheet allows you to effortlessly duplicate worksheets while retaining all complex formatting, page setups, and cell dimensions with just a few clicks.
- 1. Open your Workbook: Launch WPS Office and open your existing spreadsheet file.
- 2. Right-click the Tab: Locate the worksheet tab at the bottom of the screen, right-click it, and select 'Move or Copy Sheet'.
- 3. Create the Copy: Tick the 'Create a copy' checkbox, choose your desired destination book and position, then click OK to perfectly duplicate the sheet.

Frequently Asked Questions
Why do my row heights change when I copy and paste cells?
Standard copy and paste functions (like Ctrl+C and Ctrl+V) only copy cell contents and specific cell formats (such as fonts, borders, and colors). They do not capture worksheet-level properties like row heights or page margins. To keep these, you must copy the entire worksheet tab.
Can I copy a worksheet with its margins to another workbook?
Yes. When you right-click the sheet tab and select 'Move or Copy', you can select a different open workbook from the 'To book' dropdown menu. As long as 'Create a copy' is checked, the sheet will transfer along with all its margin settings.
Is there a fast shortcut to duplicate a worksheet in the same file?
Yes. You can hold down the 'Ctrl' key on your keyboard, then click and drag the worksheet tab to the left or right. Release the mouse button to instantly create a duplicate sheet with all formatting intact.
How do I fix column widths if I already pasted the data normally?
If you already pasted the cells, you can click the small 'Paste Options' clipboard icon that appears next to the pasted data and select 'Keep Source Column Widths'. However, note that this option only adjusts columns and does not fix row heights or page margins.




