Excel Table Not Pasting Into Outlook? Fixes That Work

If an Excel table is not pasting into Outlook, copy the cells again, click in the message body, and press Ctrl+V; then use the paste options to keep the source formatting if needed. If the result is plain text or badly arranged, check that the message is in HTML format and try a smaller selection or paste the range as a picture.

Why an Excel table can look different in Outlook

Copying cells from Excel does not usually transfer an interactive Excel worksheet into an email. Excel places the copied content on the Windows clipboard in formats that other apps can interpret, and Outlook chooses a format it can use in the message editor. Depending on the available clipboard formats and the editor, the result may look like a formatted table, plain text, or content with altered fonts, borders, and spacing.

The email also has different layout rules from a worksheet. Excel displays cells in a grid with adjustable column widths, while an email must fit within the message reading area and may be viewed on a phone or in a different mail program. A wide range can therefore be squeezed, wrapped, or clipped even when the paste itself succeeds. Outlook’s version, the message format, and whether you are composing in the desktop app or a browser can all affect the result.

One useful distinction: the pasted content is generally a representation of the selected cells, not a live link to the workbook. Editing a value in Excel later will not update the email automatically. If recipients need to work with formulas, filters, or the complete dataset, attach or share the workbook instead.

Try this basic copy-and-paste sequence

In Excel, select the exact cells you want to include. Check that the selection outline covers the intended rows and columns.
Press Ctrl+C on Windows. The moving border around the selection indicates that Excel has copied it.
Open the Outlook message and click in the body where the table should appear. Make sure the cursor is not in the To, Cc, or Subject field.
Press Ctrl+V. Wait briefly for a large selection to render, then inspect the first and last rows and columns.
If Outlook shows a paste-options button, open it and choose the option that preserves the source formatting or matches the destination, depending on which appearance you want.

On a Mac, use Command+C and Command+V. The paste-option labels and available controls can vary by Outlook version. If nothing appears, copy the range again rather than repeatedly pressing Paste: the clipboard may no longer contain the Excel selection if another app or a later copy action replaced it.

Check the Outlook message format

Plain Text messages cannot preserve the same rich formatting as an HTML message. If the pasted content becomes lines of tab-separated text, or loses its colors and borders, check the message format before changing the Excel cells. In classic Outlook for Windows, open the message, select the Format Text tab, and choose HTML. The available format controls differ in new Outlook and Outlook on the web; use the message’s formatting controls and avoid composing in Plain text when you need a formatted table.

HTML is generally the suitable format for a table in an email, but it cannot guarantee identical appearance in every recipient’s mail app. Different apps may handle fonts, widths, borders, and spacing differently. If the recipient must see a precise layout, a picture or attached workbook is more predictable than relying on an editable email table.

Also check whether you are replying to a message that uses plain text. A reply’s format and the editor’s available controls can be affected by the message or account settings. Start a new HTML message as a comparison: if the same Excel range pastes correctly there, the issue is likely related to the reply or its format rather than the worksheet.

Fix plain text, missing borders, or changed formatting

When the table appears but does not look right, try these checks in order. Changing one thing at a time makes it easier to identify the cause.

Choose a different paste option. Keep Source Formatting is useful when Excel’s fonts, fills, and borders matter. Merge Formatting may make the pasted content fit the email’s style, though it can change its appearance. Keep Text Only removes most formatting and is not the right choice when you need a visual table.
Confirm that the range itself is formatted. Excel’s worksheet gridlines are not the same as cell borders. If you want visible lines in an email, apply actual borders to the cells before copying.
Reduce unusual formatting. Very small fonts, conditional formatting, complex fills, and elaborate number formats may not translate exactly. Try a small, simple range to see whether the issue is tied to formatting complexity.
Check merged cells. Merged headings can make rows and columns difficult to align after pasting. If possible, unmerge cells in a copy of the data and use a simple heading row.
Paste into a clean spot. Try a new message or a blank area below the signature. Pasting over existing text or inside another table can create unexpected nesting or spacing.

Excel and Outlook may also disagree about column widths. A broad table can wrap headings or make columns appear compressed. This is not necessarily a clipboard failure: the content may have pasted, but the email’s available width is narrower than the worksheet.

When the paste does nothing or only part of the table appears

First make sure Excel is still the app that supplied the copied range. If you copied a cell and then copied something else, the clipboard now contains the newer item. Return to Excel, select the range, copy it again, and paste immediately into the message body. If you are using Outlook in a browser, confirm that the browser window has focus and that the cursor is visible in the compose area.

Next, test with a small range, such as a heading and two rows. If that works but a larger range does not, the size or complexity of the selection may be contributing. Split a very large table into sections, remove columns the recipient does not need, or attach the workbook. A selection containing many rows is harder to read in an email even when it pastes successfully.

Look for selection issues as well. Check that you copied the cells rather than a chart, an entire worksheet, or an unintended blank area. Hidden rows, filtered data, and cells outside the visible region can make the result surprising, so inspect the pasted rows before sending. If you need only visible records from a filtered list, verify the result carefully rather than assuming the email contains only what is currently shown.

If paste is blocked entirely, close and reopen the compose window and try again. In a browser, a temporary clipboard permission or editor issue can also interfere; refresh Outlook only after saving any unsent message content. Avoid refreshing or closing a draft before checking whether it has been saved.

Use a picture for a fixed visual layout

For a compact report that must look the same as it does in Excel, copying the range as a picture is a practical alternative. In Excel for Windows, select the range, go to Home > Copy > Copy as Picture, choose the available appearance options, and confirm. Then click in the Outlook message body and paste. The picture is static: recipients cannot edit individual cells, sort the data, or copy formulas from it as they could from a workbook.

A picture is not automatically the best choice for a large table. It may be difficult to read on a small screen, and people using assistive technology may not be able to access the data as text. Add a brief description in the message and consider attaching the workbook when the underlying figures matter. For a short summary, a picture can avoid unexpected column resizing and border changes.

Another fallback is to paste the cells into Word first, adjust the table there, and then copy it into Outlook. This can help when the email editor handles the original clipboard content poorly, but it adds another conversion step and does not guarantee identical formatting in every mail app. Check the final message before sending.

Choose between an email table, a picture, and an attachment

The best format depends on what the recipient needs to do with the information, not only on which paste method works.

Paste as a table when the reader needs selectable text and the range is small enough to fit comfortably in the message. Review it in the compose window and, if possible, send a test message to yourself.
Paste as a picture when appearance is the priority and readers only need to view a short summary. It is not suitable when the data must be edited or searched as ordinary text.
Attach the Excel workbook when formulas, multiple sheets, filters, or detailed data matter. Remove or review information that should not be shared before attaching it.
Share a cloud file when people need access to a current version rather than a one-time snapshot. Check the sharing permissions and confirm that the recipients can open the link.

An email table is convenient, but it is not a substitute for a source file when calculations need review. Pasted values do not carry working formulas, and later changes to the workbook will not revise a message already sent.

Differences between classic Outlook, new Outlook, and the web

Classic Outlook for Windows, new Outlook for Windows, and Outlook on the web do not have identical compose interfaces. The basic clipboard action is the same, but paste menus, formatting controls, and how the editor handles clipboard content can differ. In classic Outlook, the Format Text tab provides a direct way to choose HTML for a message. In new Outlook or the web app, look for the formatting controls in the compose toolbar and check the current message format if a table becomes plain text.

Excel for the web and Excel for Mac can also present different menus from Excel for Windows. If you are using either, select the range and use that version’s Copy command, then paste into the Outlook editor. Do not assume a Windows-only ribbon path will appear on those platforms. If a browser-based workflow fails, compare it with the desktop apps if available; that can help identify whether the problem lies with the selection or the browser editor.

For troubleshooting across any version, use the same diagnostic test: copy a small, simply formatted range into a new HTML message. If it works, add complexity gradually. If it does not, try another message or Outlook interface and verify that copying from Excel still works in another destination. This separates a range-specific issue from an Outlook editor or clipboard issue.

Frequently Asked Questions

Why does my Excel table paste into Outlook as plain text?
Plain Text message format or a Keep Text Only paste option can remove formatting. In classic Outlook for Windows, choose Format Text > HTML, then copy the range again and select a formatting-preserving paste option. Other Outlook versions have different controls.

How do I keep Excel column widths when pasting into Outlook?
Outlook may adjust a table to fit the message area, so exact worksheet widths are not guaranteed. Remove unnecessary columns, shorten headings, or use a picture for a fixed visual result. Attach the workbook if readers need the full worksheet layout.

Can I paste an Excel table into Outlook without losing borders?
Apply actual cell borders in Excel; worksheet gridlines alone may not transfer as borders. Then paste using Keep Source Formatting. Check the result in the message because mail apps can render borders differently.

Why does only part of my Excel selection appear in the email?
Confirm the selection outline in Excel, copy again, and check the pasted result for hidden, filtered, or unintended rows and columns. Test a smaller range to see whether selection size or formatting complexity is involved.

Can recipients edit an Excel table pasted into an Outlook email?
They can often select or copy pasted table content, but it is not a live Excel worksheet and does not retain working formulas or update when the original file changes. Send or share the workbook if recipients need to edit the underlying data.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.