Formatting Issues

How to Fix Missing Excel Lines After Pasting a Spreadsheet into Word

Olivia Miller Oct 10, 2026 873 views

Question details

Users experience disappearing or missing gridlines and borders when pasting an Excel spreadsheet or screenshot into a Word document.

How to Fix Missing Excel Lines After Pasting a Spreadsheet into Word

Product: Microsoft Excel and Word
Device & OS: not provided
Scenario: Pasting an Excel spreadsheet or a screenshot of a spreadsheet into a Word document.
Observed behavior: Thin lines in the pasted spreadsheet disappear at certain zoom levels or when positioned between screen pixels. The lines may temporarily reappear when scrolling or changing the zoom percentage.

Before you start

Ensure you have both the source Excel spreadsheet and the destination Word document open, and check that your monitor scaling isn't set to an irregular percentage, which can exacerbate rendering issues.

Solution 1Recommended

Increase Line Thickness in Excel Before Pasting

Increasing the border thickness in Excel ensures that the lines are thick enough to render correctly in Word, preventing them from falling between screen pixels.

Very thin horizontal or vertical lines can sometimes disappear on screen due to pixel rendering limitations at specific zoom levels. Thickening the borders in the source document is the most reliable way to ensure they remain visible when pasted.

Select the target cells

Open your Excel spreadsheet and highlight the entire range of cells you intend to copy.

Modify border thickness

Navigate to the Home tab on the ribbon, click the Borders dropdown arrow, and select 'More Borders'. Increase the line weight (thickness) to at least 1.5 points.

Copy the formatted range

Press Ctrl+C or right-click and select 'Copy' to copy the newly formatted data range.

Paste and adjust zoom in Word

Switch to your Word document and paste the table. Use the zoom slider at the bottom right corner of the Word window to change the zoom level and verify that all lines are now consistently visible.

Increase Line Thickness in Excel Before Pasting

Printing Check: Even if lines occasionally disappear on your screen due to zoom levels, they will typically print correctly if the borders were applied properly in Excel.

Solution 2

Paste as a Picture and Modify Wrapping Options

Pasting the spreadsheet as an image and locking its layout properties can prevent lines from vanishing due to document reflow and rendering conflicts.

Seamlessly Paste Spreadsheets in Documents

Use WPS Office to Paste Spreadsheets Without Losing Formatting

WPS Office offers a unified suite where copying data from WPS Spreadsheet to WPS Writer retains perfect formatting, border thickness, and gridlines without pixelation or missing line issues.

1. Open your files in WPS Office: Launch WPS Office and open your source spreadsheet and destination document within the same tabbed workspace for easy access.
2. Copy the spreadsheet data: Highlight the desired cells in WPS Spreadsheet, right-click, and select 'Copy'.
3. Paste with original formatting: Switch to your WPS Writer document tab, right-click the desired location, and select the 'Keep Source Formatting' paste option to insert the table seamlessly.
4. Adjust table properties easily: If you need to make visual tweaks, right-click the inserted table to easily adjust borders, shading, and cell dimensions directly within WPS Writer.

Highly compatible with Microsoft Excel and Word formatsRetains cell borders and formatting perfectly when pasting between appsLightweight, unified office suite architecture with tabbed viewingAdvanced table adjustment tools built directly into the word processor

microsoft office alternative - wps office

Frequently Asked Questions

Why do the lines in my pasted Excel table disappear only at specific zoom levels?

This is typically a display rendering artifact. When lines are very thin (like default gridlines or 0.5 points), they may fall between the physical pixels on your monitor at certain zoom percentages, making them temporarily invisible on your screen.

Will the missing lines appear when I print the Word document?

Yes, usually the lines are still preserved in the document's data. If they are only disappearing due to monitor pixelation or specific zoom levels, printing the document or saving it as a high-quality PDF will typically show all the lines perfectly.

Does locking the image anchor help prevent lines from disappearing?

Locking the anchor and setting the object to 'Move with text' ensures the image stays in a fixed position relative to your paragraph. While its primary function is preventing formatting chaos during text edits, stabilizing the object's position can occasionally help mitigate screen rendering artifacts in Word.

Document & File Issues