Why Excel Merged Cells Lose Formatting When Copied to OneNote
Question details
The user wants to know why merged-cell formatting is lost when copying a worksheet from Excel to OneNote and how to preserve the exact appearance.

- Product
- Microsoft Excel and Microsoft OneNote
- Device & OS
- Windows
- Scenario
- Copying a worksheet range with merged cells from Excel into an OneNote page.
- Observed behavior
- Merged-cell formatting is removed even when Keep Source Formatting is selected. OneNote does not reliably preserve editable merged-cell structures from Excel.
Open the Excel worksheet that contains the merged cells and the OneNote page where you want to paste it. Decide whether you need the pasted content to be editable or only visually accurate.
Paste the Excel Worksheet as a Picture or Printout in OneNote to Preserve Formatting
Use this when you need the exact visual appearance of merged cells and do not need to edit the pasted range in OneNote.
OneNote does not reliably preserve editable merged-cell structures copied from Excel. Picture and printout formats keep the appearance of merged cells, borders, and alignment, but the result is not editable.
Open the Excel workbook, select the worksheet range that contains the merged cells, and click Home > Copy or press Ctrl+C.
Switch to OneNote 2016 or OneNote for Windows 10 and click the page where you want to place the copied worksheet.
Click Home > Paste in OneNote, then choose Picture or Printout. Alternatively, right-click and select Picture under Paste Options.

Keep the Original Excel Worksheet for Editing and Recopy Updated Content
Use this when you need to continue making changes to the merged-cell data after pasting into OneNote.
Edit Excel Workbooks with Merged Cells in WPS Office Without OneNote Formatting Loss
WPS Office is a free, lightweight Microsoft Office alternative that opens and edits Excel XLSX/XLS workbooks with merged cells intact. It features a familiar ribbon interface and strong Microsoft Office format compatibility, so you can manage spreadsheet data without OneNote paste limitations.

Frequently Asked Questions
Why do Excel merged cells lose formatting when copied to OneNote?
OneNote does not reliably preserve editable merged-cell structures from Excel. It may remove merged borders, alignment, and spacing even when you select Keep Source Formatting.
Can I keep merged cells editable after pasting them into OneNote?
There is no reliable way to keep the merged-cell structure editable in OneNote. Keep the original Excel worksheet open for editing, then paste an updated copy when the data changes.
Does Keep Source Formatting prevent merged-cell formatting loss?
No. The issue still occurs in OneNote 2016 and the OneNote for Windows 10 app when Keep Source Formatting is selected.
Which paste option preserves the exact appearance of merged cells?
Paste the worksheet as a Picture or Printout. These options preserve the visual layout, but the pasted content will not be editable.
Can WPS Office help with Excel files that contain merged cells?
Yes. WPS Office opens and edits Excel XLS/XLSX workbooks, supports merged cells, and provides a free alternative with familiar spreadsheet tools.




