'%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 Fix Excel for the Web Losing Formatting When Copying to Outlook
Question details
The user needs to maintain cell formatting (such as colors, borders, and fonts) when copying table data from Excel for the Web and pasting it into Outlook desktop or other applications.
- Product
- Excel for the Web, Outlook Desktop
- Device & OS
- Windows
- Scenario
- Copying spreadsheet data from a browser-based Excel app and pasting it into a desktop email client.
- Observed behavior
- Cell formatting is lost during the paste operation from the web browser version, whereas copying from the Excel desktop application works correctly and preserves all formatting.
Verify if the issue persists across different web browsers, as clipboard management can vary significantly between browsers like Chrome, Edge, and Firefox.
Open the Workbook in Excel Desktop Application
Bypassing the web browser's clipboard limitations by utilizing the desktop application is the most reliable way to guarantee your formatting is retained.
Web browsers have strict security protocols regarding clipboard data, which often results in rich text formatting being stripped or simplified. The desktop version of Excel interacts directly with the system clipboard, preserving complex table structures, borders, and background colors.
While viewing your file in Excel for the Web, look at the top ribbon menu and click on 'Editing' or 'Viewing', then select 'Open in Desktop App'.
Allow your browser to open the Microsoft Excel application when prompted by the security popup.
Once the workbook opens in the desktop application, highlight your data, press Ctrl+C to copy, navigate to your Outlook email draft, and press Ctrl+V to paste with full formatting intact.
Force 'Keep Source Formatting' in Outlook
Sometimes the browser successfully copies the formatting, but the destination application defaults to plain text or matches the destination style.
Download a Local Copy of the Workbook
If you do not have a Microsoft 365 subscription linked to your desktop apps, downloading the file locally allows you to use offline spreadsheet tools.
Use WPS Office to Keep Table Formatting Intact
Since browser-based clipboards often strip rich formatting natively, switching to a lightweight desktop application like WPS Office ensures your tables retain their exact styles, colors, and borders when pasted into emails or other documents.
- 1. Download and Install: Get WPS Office for free from the official website and install the desktop suite.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your downloaded .xlsx file.
- 3. Copy Without Loss: Highlight your table, copy it, and paste it directly into your email client. All cell formatting will be perfectly preserved.
Frequently Asked Questions
Why does Excel for the Web lose formatting when copying?
Web browsers restrict clipboard access for security reasons. When you copy complex data from a web page (like Excel for the Web), the browser's clipboard API often simplifies the HTML or converts it to plain text, which results in dropped colors, borders, and font styles.
Can I fix this issue without installing the Excel desktop app?
You can try using a different web browser, as Chromium-based browsers (like Chrome or Edge) and Firefox handle clipboard data differently. Alternatively, downloading the file and opening it in a free desktop suite like WPS Office will completely bypass the browser's limitations.
Is this a bug in Outlook or Excel?
It is primarily an inherent limitation of how web browsers communicate with the Windows operating system clipboard, rather than a traditional bug in Outlook. Desktop applications have native system access, making them much more reliable for rich text transfers.
