You copy a table from Excel that has colored borders, but when you paste it into Word, the border colors disappear. This happens because Excel and Word handle table formatting differently. Excel stores border colors as cell-level formatting, while Word applies borders through table styles or direct formatting that can conflict with pasted content. This article explains the root cause of the lost border colors and provides step-by-step fixes to preserve or restore them.
Key Takeaways: Preserving Excel Table Borders When Pasting Into Word
- Paste Special > Keep Source Formatting (HTML): Retains Excel border colors by pasting the table as HTML, which includes all inline formatting.
- Paste Special > Keep Source Formatting (RTF): Retains Excel border colors by pasting the table as RTF, which preserves most formatting but may shift column widths.
- Table Design > Borders > Borders and Shading: Restore lost border colors after pasting by reapplying borders manually using the same color as Excel.
Why Excel Table Border Colors Are Lost When Pasting Into Word
Excel stores border formatting as part of the cell’s properties. Each cell can have its own border color, style, and weight. When you copy a range of cells, Excel copies these properties along with the data. Word, however, does not natively support the same cell-level border model. Word tables use a different structure where borders are applied to the entire table, to specific rows, or to individual cells through the Table Design tab.
The default paste action in Word (Ctrl+V) uses the Keep Source Formatting option, but this option does not always preserve Excel border colors. This is because Word interprets the pasted content as a Word table and re-applies its own default table style. The default Word table style often uses black or no borders, overwriting the Excel border colors. Additionally, if you paste using the Use Destination Styles option, Word discards all Excel formatting and applies the current document’s table style, which usually has no colored borders.
Another factor is the paste method. Pasting as plain text or as an image removes all border formatting. Pasting as HTML or RTF through Paste Special preserves the border colors because these formats carry inline style information that Word can interpret.
Steps to Preserve Excel Border Colors When Pasting Into Word
The most reliable way to keep Excel border colors is to use the Paste Special command with the correct format. Follow these steps in order. If one method does not work, try the next.
Method 1: Paste Special as HTML
- Copy the table in Excel
Select the cells that contain colored borders. Press Ctrl+C or right-click and choose Copy. - Open the Word document and place the cursor
Click where you want the table to appear. Make sure the cursor is in the main body of the document, not inside another table. - Open Paste Special
On the Home tab, click the arrow below Paste. Choose Paste Special from the menu. Alternatively, press Alt+Ctrl+V. - Select HTML Format
In the Paste Special dialog, choose HTML Format from the list. Click OK. The table appears with its Excel border colors preserved.
Method 2: Paste Special as RTF
- Copy the table in Excel
Select the cells and copy them using Ctrl+C. - Open Paste Special in Word
Press Alt+Ctrl+V to open the Paste Special dialog. - Choose RTF
Select Formatted Text (RTF) from the list. Click OK. The table retains its border colors, though column widths may shift slightly. You can adjust column widths after pasting.
Method 3: Paste as Picture
If you do not need to edit the table data, you can paste it as a picture. This method preserves the exact visual appearance including all border colors. Select the table in Excel, copy it, then in Word go to Home > Paste > Paste Special and choose Picture (Enhanced Metafile) or Bitmap. The table becomes a static image. You cannot edit the text or borders after pasting.
If Border Colors Are Still Lost After Pasting
If the Paste Special methods did not work or you already pasted the table and lost the borders, you can restore the border colors manually. This section covers the fix and related issues.
Restore Border Colors Manually Using Table Design
- Select the pasted table
Click anywhere inside the table. The Table Design tab appears on the ribbon. - Open Borders and Shading
On the Table Design tab, click the Borders button in the Borders group. Choose Borders and Shading from the drop-down menu. - Choose the border color
In the Borders and Shading dialog, go to the Borders tab. Select the color you used in Excel from the Color drop-down. Set the width and style to match. Then click the preset boxes (All, Grid, Inside, Outside) or click the diagram buttons to apply the borders to the desired cells. - Apply and close
Click OK. The border color appears on the selected cells. Repeat for other cell ranges if needed.
Pasted Table Has No Borders at All
If the pasted table appears without any borders, the paste method stripped all border formatting. This often happens when using the default Ctrl+V paste with Use Destination Styles. To fix this, undo the paste (Ctrl+Z) and re-paste using Paste Special as HTML or RTF. If you cannot undo, select the entire table, go to Table Design > Borders, and apply a border preset such as All Borders. Then set the color to your desired value.
Border Colors Appear Wrong or Mismatched
Sometimes border colors paste but appear different from the Excel original. This occurs when Word interprets the color palette differently. Excel uses an RGB color model, while Word may map colors to its theme palette. To fix this, after pasting, select the cells with the wrong color, open Borders and Shading, and choose the exact RGB color from the Color drop-down. Click More Colors to enter the RGB values from Excel if needed.
Table Layout Shifts After Pasting
When pasting as RTF, column widths may change. This happens because RTF carries font and spacing information that Word interprets with its own layout engine. To fix this, after pasting, select the table and go to Table Layout > AutoFit > Fixed Column Width. Then manually adjust column widths by dragging the column borders.
| Paste Method | Border Colors Preserved | Editable After Paste |
|---|---|---|
| Ctrl+V (Keep Source Formatting) | Sometimes — depends on default table style | Yes |
| Paste Special as HTML | Yes | Yes |
| Paste Special as RTF | Yes | Yes — column widths may shift |
| Paste as Picture | Yes | No — static image |
| Paste Special as Unformatted Text | No | Yes — data only, no borders |
Now you can paste Excel tables into Word without losing border colors. Use Paste Special as HTML or RTF to keep the formatting. If you already pasted the table, restore borders manually through the Table Design tab. For documents that require exact visual fidelity, consider pasting as a picture or using the HTML format with a fixed-width table layout.