How to Fix Excel Cell Borders Not Pasting into WordPad
Question details
The user needs to retain cell borders when copying data from Excel and pasting it into WordPad or a RichTextEdit control.

- Product
- Microsoft Excel / WordPad
- Device & OS
- not provided
- Scenario
- Copying spreadsheet data from Excel and pasting it into a basic rich-text editor using standard clipboard functions.
- Observed behavior
- Automatic Excel cell borders disappear completely during the paste operation, while manually colored borders are successfully retained.
Verify whether you are pasting your table into a basic rich-text editor like WordPad or a full-featured word processor, as clipboard compatibility for automatic table borders varies significantly between applications.
Apply Explicit Border Colors in Excel Before Pasting
By explicitly setting a border color instead of using the 'Automatic' setting, you can force WordPad to recognize and retain the grid lines.
WordPad and RichTextEdit ActiveX controls have limited clipboard support for advanced Excel attributes, including the default 'Automatic' border color. Changing the border to a definitive color applies standard formatting tags that these basic text editors can process correctly.
Open your Excel spreadsheet and highlight the cells or table you wish to copy.
Navigate to the 'Home' tab, click the 'Borders' dropdown menu in the Font group, and select 'Line Color'. Choose Black (or any specific color) instead of 'Automatic'.
With the color selected, click the 'Borders' dropdown again and select 'All Borders' to apply the explicitly colored lines to your cells.
Press Ctrl+C to copy the formatted cells, switch to WordPad (or your RichTextEdit application), and press Ctrl+V to paste. The borders will now be visible.

Paste Data as a Picture
If you do not need to edit the table data after pasting, pasting it as an image will perfectly preserve all visual formatting, including automatic borders.
Use WPS Office for Seamless Table and Data Formatting
WordPad's limitations often disrupt complex spreadsheet tables. WPS Office provides a robust, lightweight suite including WPS Spreadsheet and WPS Writer, guaranteeing 100% format preservation when moving data between applications without the high costs of MS Office.
- 1. Download the Suite: Visit the official WPS website and download the free installer for your operating system.
- 2. Install WPS Office: Run the installer to set up WPS Writer, Spreadsheet, and Presentation in one unified application.
- 3. Enjoy Seamless Pasting: Open your files and copy-paste tables freely between Spreadsheet and Writer without losing any border formatting.

Frequently Asked Questions
Why do automatic Excel borders disappear in WordPad?
WordPad and standard RichTextEdit controls lack advanced clipboard formatting support. They fail to interpret Excel's 'Automatic' border color tag, rendering the borders as transparent or non-existent when pasted.
Does this issue happen when copying from Excel to Microsoft Word?
No. Microsoft Word, like WPS Writer, is a full-featured word processor with comprehensive clipboard support. It accurately interprets Excel's automatic borders and translates them into fully formatted text tables.
Can I edit the table in WordPad after pasting it as a picture?
No. When you use Paste Special to paste Excel data as a picture, it converts the table into a static image file. You will retain the visual borders, but you will not be able to modify the text or numbers inside WordPad.




