copy word table to excel keep formatting

If you want to keep the data formatting from Excel to word, the Convert to Text feature in Word also can help you to finish this job. You may have to format the cells to wrap text.Ĭopy excel data to word without table by using Convert to Text function. Click Options > and make sure that the 'Match entire cell contents' check box is clear. Enter (or whatever you used in Word) in the Find what box. Press Ctrl+H to activate the replace dialog.

When you copy data from a Word table into an Excel worksheet, the data in each Word table cell is pasted in an individual cell on the worksheet.Ĭopy / paste the table into Excel. More When you want to move data from a Word table to Excel, you can avoid having to retype that data by copying it from Word directly. To enter an Alt code, hold down the Alt key as you type the digits on the numeric keypad.Ĭopy a Word table into Excel. In the 'Find what' field, enter the following Alt code: Alt + 0182. With the tabular data selected, open the 'Find and Replace' dialog (again, Ctrl + H works). Paste your table in the desired location in Excel.

How do i copy word tables into excel without splitting cells

Copy word table to excel keep formatting