Formatting Issues

Prevent Extra Line Breaks When Linking Excel Data to Word

Olivia MillerOlivia Miller Oct 28, 2026 872 views

Question details

The user wants to stop unwanted line breaks and formatting changes from appearing when inserting linked Excel data into a Word document.

How to Prevent Extra Line Breaks When Linking Excel to Word
Product
Word, Excel
Device & OS
not provided
Scenario
Pasting or linking data from an Excel spreadsheet into a Word document while maintaining proper line formatting.
Observed behavior
Extra line breaks or unwanted formatting, such as extra quotation marks, appear in the Word document when using a standard paste or Excel's CHAR(10) line breaks.
Before you start

Ensure both your source Excel spreadsheet and destination Word document are saved to a permanent location before establishing data links to prevent syncing errors.

Solution 1Recommended

Use Paste Special with Unformatted Text

This method creates a clean link field that adopts Word's destination formatting and prevents Excel's cell structure from adding extra line breaks.

1
Copy the Excel data

Open your Excel spreadsheet, select the cell or range of cells you want to link, and press Ctrl + C to copy the data.

2
Open the Paste Special menu in Word

Open your Word document and place the cursor where you want the data to appear. Go to the Home tab, click the drop-down arrow under the Paste button, and select Paste Special.

3
Select Paste Link and Unformatted Text

In the Paste Special dialog box, select the Paste link radio button on the left. Then, choose Unformatted Text from the 'As:' list and click OK.

Use Paste Special with Unformatted Text
Formatting Preserved: By pasting as unformatted text, the linked data will automatically match the font and paragraph settings of your Word document without carrying over Excel's cell borders or hidden line breaks.
Seamless Office Integration

Manage Spreadsheets and Documents seamlessly with WPS Office

WPS Office provides a unified, tabbed workspace where you can easily link spreadsheet data directly into your documents without unexpected formatting issues or extra line breaks.

  1. 1. Open both files in WPS Office: Launch WPS Office and open both your Spreadsheet and Writer document in the same tabbed workspace.
  2. 2. Copy the spreadsheet data: Select the required cells in WPS Spreadsheet and press Ctrl + C.
  3. 3. Use Paste Special in WPS Writer: Switch to the Writer tab, click the arrow under the Paste icon on the Home tab, and choose Paste Special.
  4. 4. Link as Unformatted Text: Select 'Paste Link', choose 'Unformatted Text', and click OK to insert the data seamlessly.
All-in-one suite to manage Word, Excel, and PDF files in a single windowHighly compatible with Microsoft Office formats (.docx, .xlsx)Advanced paste special options to easily control linked data formattingLightweight, fast, and completely free to use
microsoft office alternative - wps office

Frequently Asked Questions

Why do quotation marks appear when I paste Excel data into Word?

Extra quotation marks usually appear when Excel cells contain internal line breaks (created with Alt+Enter or CHAR(10)). When pasted or linked into Word, the data is treated as a single text string wrapped in quotes. Using Paste Special > Unformatted Text or changing CHAR(10) to CHAR(11) in your formula resolves this.

How do I update the linked Excel data in my Word document?

Right-click the linked text or value in your Word document and select 'Update Link'. Word will immediately pull the latest data from the source Excel file.

Will using CHAR(11) affect how my data looks in Excel?

Yes, Excel does not recognize CHAR(11) as a standard line break. It may appear as a special character (like a small box or space) in the spreadsheet itself, but it will format correctly as a line break when linked into Word.

What is the keyboard shortcut for Paste Special in Word?

You can press Ctrl + Alt + V on your keyboard to quickly open the Paste Special dialog box in Word after copying your Excel data.