Formatting Issues

Paste Excel Cells into Outlook Without Losing Formatting

Khadija KhanKhadija Khan Nov 12, 2026 868 views

Question details

The user needs to copy a formatted range from Excel into an Outlook email without changing its appearance.

Product
Microsoft Excel and Microsoft Outlook
Device & OS
not provided
Scenario
The user is preparing an Outlook message and wants an Excel cell range to retain its original formatting after pasting.
Observed behavior
The pasted range may lose its Excel formatting or appear garbled in the Outlook message body.
Before you start

Select the complete Excel range, including the borders, fonts, colors, and alignment you want to preserve. In Outlook, open a new message and verify that the message format is set to HTML before pasting.

Solution 1Recommended

Paste the Excel range with Keep Source Formatting in an HTML Outlook message

Use this method when you need the pasted cells to remain editable while retaining their Excel appearance.

Outlook uses different paste behaviors depending on the message format and the paste option selected. HTML format and Keep Source Formatting give the Excel range the best chance of retaining its original fonts, borders, colors, and alignment.

1
Copy the Excel cells

In Excel, select the range you want to insert, then press Ctrl+C or choose Home > Copy.

2
Open an HTML Outlook message

In Outlook, select New Email. In the compose window, open the Format Text tab and choose HTML if another message format is active.

3
Paste using the source format

Click in the message body, right-click, and select Keep Source Formatting under Paste Options. If the option appears after pressing Ctrl+V, choose the clipboard icon for Keep Source Formatting.

4
Check the pasted range

Review the email for borders, fonts, colors, column widths, and alignment. Adjust the table or cell content in the message body if necessary.

Best result: Keep Source Formatting works most reliably when the Outlook message is composed in HTML rather than Plain Text.
Free Microsoft Office alternative

Use WPS Spreadsheet for reliable Excel-format editing and sharing

WPS Office provides a free, lightweight spreadsheet experience with a familiar interface and strong Microsoft Office compatibility. Open and edit XLSX workbooks in WPS Spreadsheet, then share or export them when Outlook formatting is difficult to control.

Edit and format spreadsheet ranges in a lightweight Office-style interface.Open, save, and share Microsoft Excel XLSX files with broad format compatibility.Use familiar tools for borders, fonts, colors, alignment, and cell layout.Move between WPS Office and Microsoft Office with minimal workflow changes.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel cells lose their formatting when pasted into Outlook?

The message may be using Plain Text or Rich Text instead of HTML, or Outlook may be using a default paste option. In a new message, open Format Text, select HTML, then right-click in the body and choose Keep Source Formatting.

How can I keep Excel borders and colors in an Outlook email?

Copy the formatted range in Excel, compose the Outlook message in HTML format, and use the Keep Source Formatting paste option. Check the pasted range before sending because some complex styles may still require manual adjustment.

What should I do if the pasted Excel range looks garbled?

Undo the paste, confirm that the message format is HTML, and paste again with Keep Source Formatting. If the layout still changes, use Paste Special as a picture to preserve the visual appearance.

Can recipients edit Excel cells pasted into an Outlook email?

A normal HTML paste may create an editable table, but it is not the same as attaching an Excel workbook. A pasted picture cannot be edited as cells, so attach the original XLSX file when spreadsheet editing is required.