'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Paste Excel Mobile Data with Borders into Outlook Email
Question details
The user wants to keep table borders and formatting when copying data from the Excel Mobile app and pasting it into the Outlook Mobile app.
- Product
- Excel Mobile, Outlook Mobile
- Device & OS
- not provided
- Scenario
- Pasting formatted spreadsheet tables into an email message on a mobile device.
- Observed behavior
- Table borders and formatting are retained when pasting into Outlook on a desktop, but the formatting is lost when using the mobile versions of Excel and Outlook.
Ensure that both your Excel and Outlook mobile applications are updated to their latest versions, as clipboard formatting capabilities rely heavily on recent app updates.
Use Paste Options to Keep Source Formatting
Copy multiple cells and utilize the paste formatting options within the Outlook Mobile app to retain your table's borders.
Mobile operating systems often use a simplified clipboard that strips complex HTML or table formatting by default. To bypass this, you need to ensure you copy a multi-cell range and explicitly tell the destination app to keep the original formatting.
Open your spreadsheet in the Excel Mobile app. Tap and drag the selection handles to highlight the data table. You must select more than one cell to ensure it is recognized as a table.
Navigate to the formatting menu in Excel Mobile and apply your desired borders, such as a Thick Box Border or All Borders.
Tap the selected area and choose 'Copy' from the pop-up context menu.
Open the Outlook Mobile app and start a new email message. Tap the body of the email and select 'Paste'.
Immediately after pasting, tap the Paste Options tooltip that appears near the pasted text. Choose 'Keep Source Formatting' or 'Keep Original Table Formatting'.
Seamlessly Edit and Share Spreadsheets on Mobile with WPS Office
Avoid mobile clipboard formatting glitches by using WPS Office. It provides an all-in-one suite to easily edit spreadsheets and share perfectly formatted tables directly from your mobile device.
- 1. Download and Install: Get the free WPS Office app from the App Store or Google Play Store.
- 2. Open Your Spreadsheet: Open your existing .xlsx file directly in WPS Office without losing any formatting or borders.
- 3. Share with Ease: Use the built-in share feature to send your formatted data directly via email or export it as a high-quality image.
Frequently Asked Questions
Why do table borders disappear when I paste Excel data on my phone?
Mobile operating systems use simplified clipboards to save memory. This often strips complex HTML or table formatting, converting your data to plain text unless the destination app supports and you actively select 'Keep Source Formatting'.
Can I copy just one cell with a border into an email?
Usually, mobile email clients require you to copy at least two cells from a spreadsheet to recognize the clipboard data as a table. A single cell is typically treated and pasted as plain text.
Does this table formatting trick work for all email apps?
Formatting support varies significantly by platform and app. While Outlook Mobile often supports table formatting options, default native mail apps like Apple Mail or Gmail may handle pasted tables differently.
How can I guarantee my table looks exactly as it does in the spreadsheet?
If mobile copy-pasting continues to drop borders, the most reliable way to preserve perfect formatting is to take a screenshot of the table or export the spreadsheet as a PDF, then attach that file to your email.
