Prevent Extra Line Breaks When Linking Excel Data to Word
Question details
The user wants to stop unwanted line breaks and formatting changes from appearing when inserting linked Excel data into a Word document.

- 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.
Ensure both your source Excel spreadsheet and destination Word document are saved to a permanent location before establishing data links to prevent syncing errors.
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.
Open your Excel spreadsheet, select the cell or range of cells you want to link, and press Ctrl + C to copy the data.
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.
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.

Adjust Excel Line Break Formulas to Word Standards
Word interprets Excel's standard line break (CHAR(10)) differently. Replacing it with Word's line break character (CHAR(11)) fixes spacing and quotation mark issues.
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. Open both files in WPS Office: Launch WPS Office and open both your Spreadsheet and Writer document in the same tabbed workspace.
- 2. Copy the spreadsheet data: Select the required cells in WPS Spreadsheet and press Ctrl + C.
- 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. Link as Unformatted Text: Select 'Paste Link', choose 'Unformatted Text', and click OK to insert the data seamlessly.

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.




