Embedding a Microsoft Excel sheet into a Word document is easy – all you need to do is the copy and paste command. Use these steps.
- Select the section of your Excel sheet that you want to copy and paste with your mouse.
- Windows users can hold down Ctrl and press C to copy it to your clipboard. Mac users can select Command + C.
- Bring up your Word document and use the mouse to select where in the document you would like the Excel Sheet to appear.
- Windows users can hold the Ctrl key on the keyboard and press V to insert it into the Word document. Mac users can use Command + V.
- Your Excel sheet will copy across complete with the styling options that you applied in Excel.
This also works for charts – in fact, it works even better for them, because they can be updated easily if you make changes in Excel. All you have to do in order to update the chart in Word after copying it is to select the chart, then click first on Chart Design in the ribbon menu, then on Refresh Data to update things.
Tip: After pasting the chart or spreadsheet comment, you’ll see the same pasting options that you’re likely used to from pasting other content – with a twist. There are some additional options when it comes to pasting Excel content.
In order, the five options have the following effects:
- Match content to Word theme, content is no longer linked to the original, cannot be updated via Refresh Data.
- Keep Excel theme, content is no longer linked to the original, cannot be updated via Refresh Data.
- (Default) Match content to Word theme, content stays linked, can be updated.
- Keep Excel theme, content stays linked, can be updated.
- Content becomes a picture, data can no longer be edited in the chart, only some styling options remain.