When you cut-and-paste a table from Word to Excel, the results are different in Excel 2007 than Excel 2010. The resulting table in Excel 2010 will split a table row into mutliple rows as if there is an embedded <CR> <LF> within a table
Moved bytonysoper_MSFTTuesday, July 05, 2011 3:34 PMwrong forum (From:TechNet Wiki Discussion)
Thank you for using
Microsoft Office for IT Professionals Forums.
From your description, If you want to use the formatting of the Word table, click Keep
In a Word document, select the rows and columns of the table that you want to copy to an Excel worksheet.
To copy the selection, press CTRL+C.
In the Excel worksheet, select the upper-left corner of the worksheet area where you want to paste the Word table.
NOTE Make sure that the paste area is empty before you paste the
data. Data in Word table cells will replace any existing data in worksheet cells in the paste area. If necessary, review the table first in Word to verify its dimensions.
On the Home tab, in the Clipboard group, click Paste Keyboard shortcut You can also press CTRL+V.
To adjust the formatting, click Paste Options next to the data that you pasted, and then do the following:
To use the formatting that is applied to the worksheet cells, click Match Destination Formatting.
To use the formatting of the Word table, click Keep Source Formatting.
More detailed information you can refer to the link to use the paste special option in excel:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.