Paste an Excel Table Into Outlook Without Breaking It

Which Outlook you are pasting into decides the answer. In classic Outlook for Windows, press Ctrl+V, click the Paste Options button that appears next to the table and choose Keep Source Formatting; if that is not the default, set it under File > Options > Mail > Editor Options > Advanced > Pasting from other programs. In new Outlook for Windows and Outlook on the web, those paste settings do not exist, so a pasted table often comes back with changed widths, missing borders or added gridlines; for a table that must look exact there, paste it as a picture (Home > Copy arrow > Copy as Picture in Excel) or attach the file. On a Mac, Outlook offers Keep Source Formatting, Match Destination Formatting and Keep Text Only from the paste control. Whatever the route, tidy the range in Excel first, because the paste can only carry what is already in the cells.

That is the whole fix for most people. The reason the same question keeps getting contradictory answers is that people answering it are using different Outlooks and don't say so. A setting that works perfectly in one is simply not there in another. So start by finding out which one you have.

Which Outlook are you actually using?

Microsoft now ships four different mail clients under the same name, and they handle a pasted table in four different ways. Microsoft's own guide to telling Outlook versions apart gives the quickest tells:

Classic Outlook for Windows has a File tab on the ribbon. If you see File, you are in classic. This is the one built on the Word editing engine, and it gives you the most control over pasting.
New Outlook for Windows has no File tab. It shows Home, View and Help tabs and a Settings gear at the top right. It looks and behaves much more like the web version.
Outlook on the web runs in a browser tab. For work and school accounts the address is outlook.office.com or outlook.office365.com; personal accounts use outlook.live.com.
Outlook for Mac is its own app. Open Outlook > About Outlook from the menu bar to confirm it.

If your company switched you to new Outlook recently and pasting "suddenly broke", that is almost certainly why. Nothing changed in Excel. The editor on the receiving end changed.

Why do column widths collapse when you paste?

When you copy a range, Excel puts several versions of it on the clipboard at once: a rich HTML table, plain tab-separated text, and a picture. The program you paste into picks one of those and rebuilds the table in its own editor. Column widths are the first casualty because an HTML table has no reliable notion of "this column is 14 characters wide". The receiving editor recalculates widths to fit the content and the window, and each Outlook does that calculation differently.

What that means in practice:

Classic Outlook keeps widths, fonts, fills and borders well when Keep Source Formatting is in effect, because its Word based editor understands Office's own table markup. If widths still shift, right-click the pasted table, choose AutoFit, then Fixed Column Width to stop the table resizing to the window, and drag the column edges to where you want them.
New Outlook and Outlook on the web rebuild the table with their own browser style editor. Microsoft's community forums hold long threads of users reporting that column sizes change and borders disappear on paste in the web version, and Microsoft has described missing table paste options in new Outlook as a known design limitation, with the classic paste setting absent. Some users also see gridlines appear on a table that had none in Excel. As of September 2026, check the current release notes, since new Outlook is still gaining features.
Outlook for Mac usually keeps the table when you choose Keep Source Formatting, and Match Destination Formatting is the fix when the font size jumps on paste.

Two things in the Excel range make collapse much worse in every version: wrapped text (the editor has no fixed width to wrap against, so it widens the column instead) and merged cells (HTML tables and Excel merges don't map neatly, so rows shift). Both are covered below in the prep section.

Keep Source Formatting or paste as a picture: which is right?

There are really four routes, and each one trades something away. Microsoft's article on copying from Excel to another Office program lists the paste options available in the Word based editors (classic Outlook and Word): Keep Source Formatting, Use Destination Styles, Link & Keep Source Formatting, Link & Use Destination Styles, Picture and Keep Text Only. The linked options matter less in email, since the recipient doesn't have your workbook.

Here is how the four practical routes compare:

Route	Keeps column widths	Survives recipient dark mode	Numbers copyable	Readable on mobile
Keep Source Formatting (live table)	Classic Outlook: mostly. New Outlook and web: often not	Partly: light fills may be recolored	Yes	Only if narrow (about five columns or fewer)
Paste as picture	Yes, exactly	Usually, since images are not recolored, but a white block stands out on a dark screen	No	Shrinks to fit, so small text gets hard to read
Paste via Excel for the web in a browser	Varies by browser and editor	Partly	Yes	Same as a live table
Attach the file	Yes	Yes (opens in Excel or a viewer)	Yes, fully	Needs a tap to open

Use Keep Source Formatting when the recipient needs to copy numbers out of your table, reply inline with comments, or when the table is small. It is the right default in classic Outlook. To make it stick, go to File > Options > Mail > Editor Options > Advanced and set Pasting from other programs to Keep Source Formatting. Microsoft's reference for Outlook's advanced editing options documents the three choices there (Keep Source Formatting, Merge Formatting, Keep Text Only) and the Show Paste Options button when content is pasted setting, which gives you the per-paste override. Those settings apply to classic Outlook only.

Paste as a picture when the table has to look exactly as it does in Excel and nobody needs to copy from it: a status summary, a price sheet, a chart-like grid for an executive. In Excel, select the range, go to Home > Clipboard, click the arrow next to Copy and choose Copy as Picture. Pick As shown on screen and Picture for the sharpest result, then paste into the email. Microsoft notes that the picture is pasted at 100% of its original size regardless of your zoom level, so a very wide range produces a very wide image. In classic Outlook you can also paste normally and pick Picture from the Paste Options button. If you are in new Outlook or on the web, a screenshot (Windows + Shift + S on Windows, Cmd + Shift + 4 on a Mac) pasted into the message works the same way.

The cost of a picture is real: the numbers can't be selected, screen readers get nothing unless you add alt text, and some recipients' mail settings block images until they click to load them. Put the one or two key figures in a sentence above the image so the message still works without it.

Paste via a browser is the workaround people reach for when new Outlook strips formatting: open the workbook in Excel for the web, copy from there, and paste into Outlook on the web. It sometimes carries borders and fills that a desktop paste loses, but results vary by browser, and Microsoft notes that its Office Online tools for copying Excel data into other programs are not available the way they are on the desktop. Treat it as something to try, then check the result, not as a guaranteed fix.

Attach the file is covered in the last section.

What happens to your table in the recipient's dark mode?

This is the one nobody checks, because you compose in light mode and never see what the other person sees. Outlook and most phone mail apps now recolor messages in dark mode. Microsoft's dark mode documentation for Outlook describes how the reading pane goes dark in new Outlook and on the web (with a Turn on the lights button to switch a single message back to light), and how classic Outlook uses sun and moon buttons to flip the message background between white and black.

Clients don't all recolor the same way. Litmus, which tests email rendering across clients, groups them in its dark mode guide for email into three behaviors: no change, partial invert (only light backgrounds are darkened) and full invert (light and dark areas both flipped). Its table puts Outlook.com and the Outlook phone apps in the partial invert group and classic Outlook 2021 on Windows and the Gmail iPhone app in the full invert group.

What that does to a pasted table:

A light fill you used for the header or for highlighted rows may be turned dark, while the text color is adjusted separately. Pale yellow "look here" highlights can become muddy and lose their meaning.
Colored text on white (red for negatives, green for positives) may be lightened or shifted, and the contrast you checked on your screen is gone.
A pasted picture is generally left alone, so it stays readable, but it now sits as a bright white rectangle in a dark message. That is ugly but legible, which is often the better trade.

The fix is to not let color carry meaning on its own. Show negatives in parentheses as well as red, mark the highlighted row with a word or symbol, and keep header fills subtle. The same discipline that makes a sheet survive a greyscale printer makes it survive dark mode, and our guide to conditional formatting that actually helps makes the same case for on screen rules.

How should the range be prepared before copying?

Every route above copies what is already in the cells, so ten minutes in Excel saves most of the cleanup in Outlook. Work through this before you press Ctrl+C:

Copy only what the reader needs. Hide or delete helper columns and select just the summary block, not the whole sheet. A table with five or six columns fits a phone screen; fifteen does not.
Unmerge cells. Replace merged headers with Center Across Selection or a single header row. Merges are the most common reason rows shift after pasting. Our post on alternatives to merged cells walks through the swap.
Turn off Wrap Text in the range and set real column widths instead, so the email editor has nothing to reflow. The column widths and row heights guide covers how to size them.
Use a common font. A font the recipient doesn't have gets substituted and changes every width. Calibri, Aptos, Arial or Segoe UI are safe choices; our spreadsheet font guide explains why aligned figures matter for tables of numbers.
Apply number formats, so the pasted values read 12,450.00 or $12.5K and not 12450.3333333. The paste carries the displayed value, so what you see is what they get. The number formatting guide covers the codes.
Add real borders where structure matters. Gridlines are not copied as borders, so a table that relied on them arrives as floating numbers. A thin rule under the header and above the total is usually enough.
Keep fills light and meaning redundant, for the dark mode reasons above.
Send yourself a test and open it on your phone, in dark mode, before it goes to anyone who matters.

If you are sending the table to senior readers, trim it further. Our post on presenting a spreadsheet to executives covers how many numbers belong in a summary at all.

When should you attach the file instead?

Paste into the body when the table is small, the reader needs it at a glance, and a phone is a likely place they'll read it. Attach the workbook when any of these are true:

The table is wider than about six columns or longer than a screen.
The recipient needs to filter, sort, recalculate or reuse the numbers.
Formulas, multiple tabs or hidden detail are part of the point.
You need it to look identical on every device, and a picture would be unreadable at phone width.

A common middle path works well: paste a small summary (or a picture of it) into the body so the message stands on its own, and attach the full workbook underneath. If the recipient shouldn't edit it, send a PDF instead, and our guide to exporting Excel to PDF without losing formatting covers the page setup that makes that clean.

Format the range once, then paste anywhere

Most of the prep list is formatting work that has nothing to do with Outlook: number formats, consistent fonts, sensible widths, a header row that reads without merged cells. That is exactly what SuperSheet's Excel formatter does. Drop an .xlsx or .csv on it, review the plan it proposes (number formats, a totals row, frozen headers, column widths and a theme), approve what you want and download the formatted file. Nothing is uploaded; the work happens in your browser. It deliberately does not unmerge cells or restructure a tab for you, so do step 2 yourself. Then copy the formatted range, and whichever Outlook you are in has far less to fix after the paste.

FAQ

Why does my Excel table shrink when pasted into Outlook?

The email editor rebuilds the table as HTML and recalculates column widths to fit the content and the message window. Classic Outlook with Keep Source Formatting keeps widths best; right-click the table, choose AutoFit, then Fixed Column Width to stop it resizing. New Outlook and Outlook on the web don't offer those paste settings, so a picture or an attachment is the reliable route there. Wrapped text and merged cells in the Excel range make shrinking much worse.

How do I paste an Excel table as a picture?

In Excel, select the range, then on the Home tab, in the Clipboard group, click the arrow next to Copy and choose Copy as Picture. Choose As shown on screen and Picture, click OK, then paste into the email with Ctrl+V. In classic Outlook you can also paste normally and pick Picture from the Paste Options button. In new Outlook or on the web, a screenshot pasted into the message does the same job.

Why does the table look different on the recipient's phone?

Two reasons. Phones are narrow, so a wide live table either scrolls sideways or gets squeezed, and a pasted picture gets scaled down until small text is hard to read. And most phone mail apps recolor messages in dark mode, which can darken your light fills and shift colored text. Keep the pasted table to about five or six columns, use subtle fills, and don't rely on color alone for meaning.

Can I paste an Excel table into Gmail with formatting?

Usually, yes. Gmail's compose window accepts the HTML table that desktop Excel places on the clipboard, and basic fills, borders and fonts generally come through, though widths and fonts can shift the same way they do in web Outlook. The same prep applies: unmerge cells, turn off wrap text, use a common font and apply number formats before copying. For a table that must look exact, paste it as a picture or attach the file, and send yourself a test first.