File Format & Compatibility

Why Excel Merged Cells Lose Formatting When Copied to OneNote

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 868 views

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.

Why Excel Merged Cells Lose Formatting When Copied to OneNote
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the merged-cell range in Excel

Open the Excel workbook, select the worksheet range that contains the merged cells, and click Home > Copy or press Ctrl+C.

2
Open the destination OneNote page

Switch to OneNote 2016 or OneNote for Windows 10 and click the page where you want to place the copied worksheet.

3
Paste as Picture or Printout

Click Home > Paste in OneNote, then choose Picture or Printout. Alternatively, right-click and select Picture under Paste Options.

Paste the Excel Worksheet as a Picture or Printout in OneNote to Preserve Formatting
Appearance preserved: The pasted image or printout keeps the merged-cell formatting, but it cannot be edited directly in OneNote.
Free Microsoft Office alternative

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.

Opens and edits Excel XLSX files while preserving merged-cell formattingFree to download and use with no subscriptionCompatible with Microsoft Excel XLS and XLSX file formatsFamiliar ribbon interface for easy migration from Microsoft Office
microsoft office alternative - wps office

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.