Formatting Issues

How to Copy Excel Worksheets While Keeping Row Heights and Margins

John WilsonJohn Wilson Nov 10, 2026 871 views

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.

How to Copy Excel Worksheets with Original Row Heights and 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 you start

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.

Solution 1Recommended

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.

1
Locate the Sheet Tab

Look at the bottom of your Excel window and find the tab containing the name of the worksheet you want to copy.

2
Open the Move or Copy Menu

Right-click the sheet tab and select 'Move or Copy...' from the context menu that appears.

3
Select the Destination

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.

4
Check the Copy Option

Ensure you check the box that says 'Create a copy'. If you skip this step, the worksheet will be moved instead of duplicated.

5
Confirm the Action

Click 'OK'. The new worksheet will be created with the exact same row heights, column widths, and margin settings as the original.

Duplicate the Entire Worksheet Tab
Preserved Layout: This method automatically retains print layouts, page setups, and specialized column or row adjustments without requiring any manual resizing.
WPS Spreadsheet Solution

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. 1. Open your Workbook: Launch WPS Office and open your existing spreadsheet file.
  2. 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. 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.
Retains 100% of the original row heights and page margins during copying.Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Intuitive tab management system for rapid workbook reorganization.
microsoft office alternative - wps office

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.