Copy from excel to another office program

If you want to use an Excel chart or Excel data in a PowerPoint presentation, a Word document, or an Outlook message, you can simply copy it in Excel, and then use the paste options in the other Office programs to insert the copied content in a number of ways.

Note: The tools for copying Excel data and charts are not available in Office Online. If you have a desktop version of Office, click Open in [Program Name] in your desktop program to open the document and follow the procedures described in this article. If you don't have a desktop version of Office, you can try or buy the latest version now.

What would you like to copy?

Copy an Excel chart

1. In Excel, click the chart that you want to copy to another Office program, and then press Ctrl+C.

2. Open the other Office program, click where you want to paste the chart, and then press Ctrl+V.

3. Click the Paste Options button that appears next to the bottom of the chart, and choose how you want to paste it:

   

   • Use Destination Theme & Embed Workbook This updates the chart formatting to match the destination formatting.

   • Keep Source Formatting & Embed Workbook This keeps the chart formatting exactly as is.

   • Use Destination Theme & Link Data This updates the chart formatting to match the destination formatting and keeps the chart linked to the original worksheet. (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. (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.

   • Picture This pastes the chart as a picture. The chart cannot be edited or updated, but you can replace it with another picture and apply picture formatting.

Copy Excel data

1. In Excel, select the data you want to copy, and then press Ctrl+C.

2. Open the other Office program, click where you want to paste the data, and then press Ctrl+V.

3. Click Paste Options next to the data, and choose how you want to paste it.

   

   • Keep Source Formatting This keeps the data formatting exactly as is.

   • Use Destination Styles This updates the data formatting to match the destination style. If you want to keep the gridlines this is usually the best way to do it.

   • Link & Keep Source Formatting This keeps the data formatting exactly as is and keeps the data linked to the original worksheet. (If you later decide that you want to unlink the data, you'll need to copy it and paste it again as unlinked data 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.

   • Link & Use Destination Styles This updates the data formatting to match the destination style and keeps the data linked to the original worksheet. (If you later decide that you want to unlink the data, you'll need to copy it and paste it again as unlinked data 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.

   • Picture This pastes the data as a picture. The data cannot be edited or updated.

   • Keep Text Only This pastes the data as text, with each row in a separate paragraph and with tab spaces separating the cell values.

See also

• Paste options

• Mail merge using an Excel spreadsheet

• Create a chart from start to finish

• Format elements of a chart

• Save a workbook in another file format