Paste Excel Cells into Outlook Without Losing Formatting
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.
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.
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.
In Excel, select the range you want to insert, then press Ctrl+C or choose Home > Copy.
In Outlook, select New Email. In the compose window, open the Format Text tab and choose HTML if another message format is active.
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.
Review the email for borders, fonts, colors, column widths, and alignment. Adjust the table or cell content in the message body if necessary.
Paste the Excel range as a picture when visual accuracy matters most
Use this fallback when the range still becomes distorted and the recipient only needs to view the formatted cells.
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.

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.




