File Format & Compatibility

How to Fix Excel Cell Borders Not Pasting into WordPad

Huda QurayshiHuda Qurayshi Nov 4, 2026 869 views

Question details

The user needs to retain cell borders when copying data from Excel and pasting it into WordPad or a RichTextEdit control.

Fix Excel Cell Borders Not Pasting into WordPad
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.
Before you start

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.

Solution 1Recommended

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.

1
Select Target Cells

Open your Excel spreadsheet and highlight the cells or table you wish to copy.

2
Change Border Color

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'.

3
Apply the New Borders

With the color selected, click the 'Borders' dropdown again and select 'All Borders' to apply the explicitly colored lines to your cells.

4
Copy and Paste

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.

Apply Explicit Border Colors in Excel Before Pasting
Formatting Preserved: Manually colored borders use explicit rich-text color codes, bypassing the limitations of WordPad's automatic format interpretation.
Free Microsoft Office alternative

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. 1. Download the Suite: Visit the official WPS website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the installer to set up WPS Writer, Spreadsheet, and Presentation in one unified application.
  3. 3. Enjoy Seamless Pasting: Open your files and copy-paste tables freely between Spreadsheet and Writer without losing any border formatting.
Free, lightweight, and incredibly fast to installPerfect compatibility with Microsoft Excel (.xlsx) and Word (.docx) formatsSeamless copy-pasting of complex tables with 100% border and format retentionFamiliar user interface with zero learning curve
microsoft office alternative - wps office

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.