Formatting Issues

Fix Extra Paragraph Marks When Pasting Excel Data into Word

Huda QurayshiHuda Qurayshi Nov 20, 2026 870 views

Question details

The user needs to paste Excel data into a Word table without unwanted paragraph spacing or increased row height.

Fix Extra Paragraph Marks When Pasting Excel Data into Word
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.
Before you start

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.

Solution 1Recommended

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.

1
Copy the source cells

In Excel, select the cells you want to use and choose Home > Copy.

2
Open Paste Special

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.

3
Choose a link and format

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.

4
Adjust the Word formatting

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.

Paste the Excel data as linked, unformatted text
Check the result: A linked paste may behave differently from ordinary table text. If the data is pasted as tab-delimited text, select it and use Insert > Table > Convert Text to Table; verify the link afterward because converting the text may affect it.
Free Microsoft Office alternative

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.

Copy spreadsheet data into WPS Writer and adjust table and paragraph formatting.Open and edit common Microsoft Office formats, including XLSX and DOCX.Use a familiar interface for a smoother transition from Microsoft Office.Work with documents and spreadsheets in a lightweight office suite.
microsoft office alternative - wps office

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.