Fix Extra Paragraph Marks When Pasting Excel Data into Word
Question details
The user needs to paste Excel data into a Word table without unwanted paragraph spacing or increased row height.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting Excel cells into a Word table with a link and merged formatting.
- Observed behavior
- Extra paragraph marks appear in the pasted content, increasing line spacing and table row height.
In Word, select Home > Show/Hide ¶ to make paragraph marks visible. Check whether the extra height comes from empty paragraphs, paragraph spacing, or a fixed table row height.
Paste the Excel data as linked, unformatted text
Use Paste Special to reduce inherited formatting while keeping a link to the Excel source when that combination is available.
Available Paste Special formats depend on the copied content and Office version. Unformatted text may be tab-delimited and may not preserve the original table layout.
In Excel, select the cells you want to use and choose Home > Copy.
In Word, place the cursor where the data should appear, then choose Home > Paste > Paste Special. On Windows, you can also press Ctrl+Alt+V.
Select Paste Link and, if available, choose Unformatted Text, then select OK. If that combination is unavailable, choose another linked format or use Paste with Unformatted Text without a link.
Select the pasted content and open Home > Paragraph settings. Set Before and After spacing to 0 and choose Single line spacing, then check the table layout.

Remove empty paragraphs and correct table spacing in Word
Use this method when the data is already in a Word table and the extra marks or spacing can be edited.
Troubleshoot persistent Word and Office formatting problems
Try these checks if the same paste behavior occurs in new files or after changing the paste format.
Work with spreadsheet data and documents in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative for working with spreadsheets and documents. Its familiar interface and support for Microsoft Office formats make it easier to move existing files and format pasted data.

Frequently Asked Questions
Why are Word table rows taller after I paste from Excel?
The pasted content may contain empty paragraphs or paragraph spacing, or the row may have a fixed height. Turn on Home > Show/Hide ¶, check Home > Paragraph settings, and inspect Table Layout > Properties > Row.
Can I paste Excel data into Word without keeping Excel formatting?
Yes. Copy the cells, then in Word choose Home > Paste > Paste Special and select Unformatted Text. The result may be tab-delimited text rather than a formatted table.
Can I keep the Excel link when pasting unformatted text?
In Paste Special, select Paste Link and check whether Unformatted Text is available. If it is not, you must choose another linked format or paste unformatted text without a link.
Should I delete every paragraph mark in a Word table cell?
No. Delete unwanted empty paragraphs, but leave the required end-of-cell marker. Use Home > Show/Hide ¶ to inspect the cell before editing.




