How to Prevent Merged Cells from Unmerging When Copying in Excel
Question details
The user needs to maintain merged cells and conditional formatting when copying data from an Excel file attachment to another workbook.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Copying spreadsheet content from an email preview and pasting it into a protected destination worksheet.
- Observed behavior
- Merged cells automatically unmerge and conditional formatting rules are lost during the paste operation, despite the destination sheet being protected.
Ensure you have a desktop spreadsheet application installed, as lightweight email web viewers automatically strip out advanced formatting elements like merged cells and conditional rules.
Download and Copy from the Desktop Application
Avoid copying data directly from an email preview interface, as these web viewers do not support or transfer advanced spreadsheet formatting.
When you copy data from an email file preview, you are copying basic HTML tables rather than native spreadsheet data. The clipboard cannot capture merge structures or conditional formatting from a web viewer, which is why they are lost when pasted. To preserve the structure, you must download the file and use the desktop application.
Click the download icon on the Excel attachment in your email client to save the file to your local computer.
Locate the downloaded file on your computer and open it directly using your desktop spreadsheet application.
Select the required range containing your merged cells and conditional formatting, then press Ctrl+C to copy it from the actual workbook.
Navigate to your destination workbook, select the target cell, and press Ctrl+V to paste the data with its original structure intact.
Use Paste Special to Preserve Source Formatting
If you are copying from the desktop app but still losing formatting, utilize the Paste Special tool to force the destination sheet to adopt the original layout.
Copy the Entire Worksheet
If the layout must remain absolutely identical and you want to avoid selecting individual ranges, duplicate the entire worksheet into the new workbook.
Preserve Advanced Formatting Easily with WPS Spreadsheet
WPS Office fully supports advanced cell formatting, merged cells, and conditional formatting. You can easily open email attachments directly in the lightweight desktop app to ensure your copy-pasting retains perfect layout fidelity.
- 1. Download the file: Save the email attachment to your local drive instead of previewing it in the browser.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded file directly.
- 3. Copy the formatted data: Highlight the range containing your merged cells and conditional formatting, then press Ctrl+C.
- 4. Paste with source formatting: Switch to your destination sheet, right-click the target cell, and select 'Keep Source Formatting' from the paste options.
Frequently Asked Questions
Why does copying from an email preview alter my Excel formatting?
Email clients use lightweight web viewers designed to display file contents quickly. These web-based previews do not support complex spreadsheet features like merged cells or conditional formatting, so they are stripped out and converted to plain tables when you copy the text.
Can worksheet protection preserve my merged cells when pasting?
No. Worksheet protection is designed to lock specific cells in the destination sheet to prevent edits. It has no ability to retrieve or recreate formatting structures that were already lost in the clipboard during an improper copy action.
How do I ensure conditional formatting transfers when copying between workbooks?
You must open both the source and destination files in a desktop spreadsheet application. Copy the data, then right-click in the destination workbook and use the 'Paste Special' > 'Keep Source Formatting' option to transfer the conditional rules along with the data.
