Paste From Word Document Into Excel Missing Bottom Rows of Data

Question

When I paste data from a Word document to an Excel sheet, it is missing a bunch of rows on the bottom, even though they successfully copied from the Word document. Is there any way to force Excel to paste all the rows? If I do it using paste special: text, then it gets all the rows. But I want to keep the objects that are copied as well, such as pictures (I have a mixture of data and pictures to be placed into Excel). Because the data is heterogeneous, I can't afford to go and format every single cell to match the source formatting (not that I could ever figure out what the source formatting is anyway).

Answer 1

Hello Miles,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

When you paste data from a Word document into an Excel sheet, it is possible that some rows may be missing at the bottom. One way to ensure that all rows are pasted is to use the “Paste Special” option and select “Text” as the format. This will paste all the rows, but it will not preserve any objects such as pictures that were copied from the Word document.

If you want to keep the objects that were copied, you can try the following steps:

Select the table in Word. Replace ^p (the code for a paragraph mark in Word) with some text that doesn’t occur in the document, for example %%%%. Copy and paste the table into Excel. In Excel, replace %%%% with Ctrl+J (the code for a line feed in Excel)1. This should allow you to paste all the rows from the Word document into the Excel sheet while preserving any objects such as pictures. However, since your data is heterogeneous, you may still need to format individual cells to match the source formatting.

I hope this helps.

Best Regards, IBHADIGHI