Formatting Issues

Fix Excel Table Formatting Changes When Pasted Into Outlook

Bushra Parveen Oct 1, 2026 868 views

Question details

Users need a way to maintain their Excel table's original layout, colors, borders, and column widths when pasting it into an email draft.

Fix Excel Table Formatting Changes When Pasted Into Outlook

Product: Microsoft Excel and Outlook
Device & OS: not provided
Scenario: Copying a formatted table from a spreadsheet and pasting it into an email message body.
Observed behavior: The pasted table loses its original layout, and the column widths, borders, and colors change or disappear in the Outlook email.

Before you start

Make sure you are copying the exact cell range rather than the entire worksheet, and confirm that your email is set to HTML format (not Plain Text) so it can receive rich formatting.

Solution 1Recommended

Use the 'Keep Source Formatting' Paste Option

This is the most direct way to force Outlook to retain the original Excel colors, borders, and column widths.

By default, Outlook may try to merge the copied table with the email's destination styles. Manually selecting the correct paste option ensures the original Excel design is brought over.

Copy the Excel Table

Highlight the specific cells you want to copy in Excel, right-click the selection, and choose 'Copy' (or press Ctrl+C).

Open Outlook Email

Navigate to Outlook, open a new email message, and click inside the message body where you want the table to appear.

Select Paste Options

Right-click in the message body. Under the 'Paste Options' menu, click the icon for 'Keep Source Formatting' (usually the first icon with a paintbrush).

Tip: If column widths still adjust automatically, click inside the pasted table in Outlook, go to the 'Layout' tab under Table Tools, and adjust the 'AutoFit' settings to 'Fixed Column Width'.

Solution 2

Paste the Table as a Picture

Use this method if the table formatting is complex and you do not need the recipient to edit the data.

Solution 3

Run Outlook in Safe Mode and Disable Add-ins

Use this troubleshooting step if the paste options are missing or if third-party tools are interfering with your clipboard.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Integration

If you frequently encounter frustrating formatting bugs and clipboard errors between Microsoft applications, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets, documents, and presentations smoothly.

1. Download the Installer: Visit the official WPS Office website and click the free download button.
2. Install WPS Office: Run the downloaded setup file and follow the quick installation prompts.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel files with formatting fully preserved.

Fully compatible with Microsoft Excel (.xlsx) formatsLightweight architecture prevents system lag and clipboard freezingFree to use with a familiar, tabbed user interfaceBuilt-in PDF tools for easy file sharing and layout preservation

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel column widths change automatically in Outlook?

Outlook uses a Word-based HTML rendering engine that attempts to 'AutoFit' tables to the email window width. If the table is wider than the email pane, Outlook shrinks the columns to make it fit, altering your original Excel layout.

Can Excel settings affect how tables are copied to the clipboard?

Yes. If your Excel settings have been modified, it might affect clipboard behavior. You can check this by going to File > Options > Advanced in Excel, and ensuring that your 'Cut, copy, and paste' settings are configured to keep source formats.

How can I force the table to look exactly like Excel?

The most reliable way to preserve the exact visual appearance of an Excel table—including complex borders and exact column widths—is to paste it into Outlook as a Picture. However, the recipient will not be able to edit or copy the text from the image.

What should I do if 'Keep Source Formatting' is missing?

Ensure that your Outlook email is set to HTML format. Go to the 'Format Text' tab in your email draft and select 'HTML'. If your email is set to 'Plain Text', all formatting options will be disabled and the table will paste as unformatted text.

Document & File Issues