Formatting Issues

How to Copy Excel Cells While Preserving Formatting and Column Widths

Algirdas Jasaitis Sep 30, 2026 871 views

Question details

The user needs to copy and paste blocks of cells while retaining the exact original layout, including formatting and column dimensions.

How to Copy Excel Cells While Preserving Formatting and Column Widths

Product: Excel
Device & OS: not provided
Scenario: Creating matching blocks of data on the same worksheet without manually readjusting column sizes after pasting.
Observed behavior: Standard copy-pasting transfers the text and cell styles but ignores the original column widths, causing the pasted data to look distorted in the destination cells.

Before you start

Ensure your target paste destination has enough empty space, as pasting will overwrite any existing data in those cells.

Solution 1Recommended

Use the Keep Source Column Widths Paste Option

This built-in paste feature allows you to seamlessly duplicate cell contents, formatting, and column widths in a single action.

This is the most efficient method for perfectly mirroring a table or data block elsewhere on your worksheet. It bypasses the default Excel behavior of adopting the destination column's width.

Copy the required cells

Highlight the block of cells you want to duplicate. Right-click the selection and choose Copy, or use the keyboard shortcut Ctrl+C (Cmd+C on Mac).

Select the destination cell

Click on the top-left cell of the blank area where you want the duplicated block to appear.

Open the Paste drop-down menu

Navigate to the Home tab on the top Excel ribbon. Instead of clicking the main Paste icon, click the small downward-facing arrow just below it.

Choose Keep Source Column Widths

In the drop-down menu, look for the 'Paste' section and click the icon labeled 'Keep Source Column Widths' (it typically looks like a clipboard with a column expansion symbol).

Use the Keep Source Column Widths Paste Option

Layout Preserved: Your pasted block will now exactly match the source, preventing any text from getting cut off by narrow columns.

Solution 2

Use Paste Special for Column Widths Only

This method is useful if you have already pasted your data normally and just need to correct the distorted column widths without repasting the data.

Seamless Spreadsheet Management

Easily Duplicate Complex Layouts with WPS Spreadsheet

If you frequently work with intricately formatted tables, WPS Office provides an intuitive and lightweight alternative. You can easily duplicate cell formatting, including source column widths, ensuring perfect layouts every time. It is completely free and seamlessly supports Excel files.

1. Copy your table: Highlight your data in WPS Spreadsheet and press Ctrl+C to copy.
2. Choose the destination: Click the starting cell where the new table should be pasted.
3. Paste with exact formatting: Right-click, hover over 'Paste Special' in the context menu, and select 'Keep Source Column Widths' to perfectly duplicate the layout.

Intuitive right-click menu with direct 'Keep Source Column Widths' options.100% compatibility with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight software that loads large datasets faster without lag.Free alternative with a familiar user interface for immediate productivity.

microsoft office alternative - wps office

Frequently Asked Questions

Why does standard pasting change my column widths?

By default, spreadsheet software pastes data into the destination cells without altering the existing column structure of the sheet. It adapts the data to fit the target column's preset width unless you explicitly instruct it to import the source widths using specific paste options.

Is there a keyboard shortcut to paste and keep source column widths?

Yes. After copying your cells, press Ctrl+V to paste normally. Immediately after pasting, a small 'Ctrl' clipboard icon appears. Press the Ctrl key to open this menu, then press the 'W' key to apply the 'Keep Source Column Widths' formatting.

Does this paste option also preserve custom row heights?

The 'Keep Source Column Widths' option specifically targets columns. To perfectly preserve both row heights and column widths, the most reliable method is to copy the entire rows (by clicking the row numbers on the left) and pasting them into new rows, rather than just copying a block of cells.

Document & File Issues