Formatting Issues

How to Keep Excel Table Borders When Pasting into Apple Mail

Rana GarciaRana Garcia Oct 26, 2026 871 views

Question details

The user needs a way to preserve cell border formatting when copying data from an Excel spreadsheet and pasting it into an Apple Mail message.

How to Keep Excel Table Borders When Pasting into Apple Mail
Product
Microsoft Excel, Apple Mail
Device & OS
not provided
Scenario
Copying a standard range of cells in an Excel spreadsheet and pasting them directly into an Apple Mail composition window to share data via email.
Observed behavior
Apple Mail fails to interpret the standard border formatting from the copied Excel range, resulting in the cell borders disappearing completely after pasting.
Before you start

Ensure that your data does not contain overly complex custom formatting, as plain borders are the most universally supported format across different email clients.

Solution 1Recommended

Convert the Cell Range to an Excel Table

By officially defining your cell range as an Excel Table, the formatting metadata becomes standard HTML, allowing Apple Mail to correctly interpret and display the borders.

Apple Mail typically struggles to read the proprietary clipboard formatting of standard Excel cell ranges. Converting the data range to a formal Excel Table resolves this by applying standardized HTML table formatting that email clients can easily interpret.

1
Select the Data Range

Open your Excel spreadsheet and highlight the specific range of cells you wish to copy.

2
Insert an Excel Table

Navigate to the 'Insert' tab on the top ribbon and click on 'Table', or use the keyboard shortcut Ctrl+T (Windows) or Cmd+T (Mac). Confirm your data range in the popup dialog.

3
Adjust the Table Style

If you do not want colored backgrounds or banded rows, go to the 'Table Design' tab and select a blank or plain table style from the gallery. Apply borders as needed using the Home tab.

4
Copy and Paste

Highlight the newly created table, press Ctrl+C (or Cmd+C) to copy it, open your Apple Mail message, and press Ctrl+V (or Cmd+V) to paste. The borders will now remain intact.

Convert the Cell Range to an Excel Table
Formatting Retained: Your data should now appear in Apple Mail with all cell borders and table structure perfectly preserved.
Seamless Data Copying

Easily Copy and Paste Formatted Tables with WPS Spreadsheet

WPS Office offers highly optimized clipboard compatibility. You can format your data as a table in WPS Spreadsheet and paste it directly into email clients like Apple Mail without losing your borders or layout.

  1. 1. Open Your Spreadsheet in WPS: Launch WPS Office and open the document containing the data you want to email.
  2. 2. Apply Table Formatting: Select your data range, go to the 'Home' tab, and click 'Format as Table' to quickly apply a clean border style.
  3. 3. Copy and Paste: Highlight the formatted table, copy the data, and paste it right into your Apple Mail composition window with all borders beautifully preserved.
100% compatible with Microsoft Excel formats (.xlsx and .xls)Preserves rich formatting, including cell borders and backgrounds, when copying to third-party appsFree, lightweight, and features an intuitive interface similar to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why do standard cell borders disappear when pasted into emails?

Standard cell borders in Excel are copied to the clipboard using specific XML formatting that many email clients, including Apple Mail, do not fully support. Converting the data to a formal Table embeds standard HTML table tags that email clients can easily read and render.

How do I remove the alternating row colors when converting to a table?

After inserting the table, select any cell inside it to reveal the 'Table Design' tab on the ribbon. Uncheck the box labeled 'Banded Rows', or simply select a plain, uncolored table style from the Quick Styles gallery.

Will this method work for pasting Excel data into Gmail or Outlook?

Yes, converting your data range to an Excel Table before copying is a universal best practice that greatly improves formatting retention across almost all web-based and desktop email clients, including Gmail and Microsoft Outlook.