copy word table to excel keep formatting

Picture This pastes the chart as a picture. (If you later decide that you want to unlink the chart, you'll need to copy it and paste it again as an embedded chart or as a picture.) With the data linked to the original worksheet, the data in the Word document will update when the source Excel worksheet is updated. Keep Source Formatting & Link Data This keeps the chart formatting exactly as is and keeps the chart linked to the original worksheet. Use Destination Theme & Link Data This updates the chart formatting to match the destination formatting and keeps the chart linked to the original worksheet. Keep Source Formatting & Embed Workbook This keeps the chart formatting exactly as is. Use Destination Theme & Embed Workbook This updates the chart formatting to match the destination formatting.

Open the other Office program, click where you want to paste the chart, and then press Ctrl+V.Ĭlick the Paste Options button that appears next to the bottom of the chart, and choose how you want to paste it: In Excel, click the chart that you want to copy to another Office program, and then press Ctrl+C.

Copy word table to excel keep formatting