How to insert Excel into a Word Document

You may need to insert Excel data into your Word document. This could be a chart or a spreadsheet. Word allows you to do this in two ways.

2 ways to insert Excel into a Word Document

  • Embedding the Excel data
    • Using Keyboard Shortcuts
    • Using Menu Entries
  • Linking the Excel data

We will explain both methods in simple steps.

Let us begin.


Method #1: Embedding the Excel data using keyboard shortcuts

Step #1: Copy the Excel worksheet

Open the Excel worksheet from which you want to embed data.

Select the rows and columns you want to copy

Press CTRL+C on your keyboard to copy the data to the clipboard.

Step #2: Paste the data into the Word document

Open the Word document where you want to embed the Excel data.

Position the pointer at the insertion point.

Press CTRL+V on your keyboard to paste the data into the document.

The Excel data appears in the document.


Method #2: Embedding the Excel data using Menu entries

Step #1: Copy the Excel worksheet

Open the Excel worksheet from which you want to embed data.

Select the rows and columns you want to copy

Press CTRL+C on your keyboard to copy the data to the clipboard.

Step #2: Paste the data into the Word document

Open the Word document where you want to embed the Excel data.

Position the pointer at the insertion point.

Click on the Home tab on the top menu bar to change the ribbon.

In the section Clipboard, click on the small triangle below the Paste icon to open the Paste Options menu.

Click on Paste Special to open the Paste Special dialog.

Click on Paste and ensure a dot appears in the circle on the left.

In the section As: select HTML Format.

Click on OK to close the dialog.

The Excel data appears in the document.


Method 3: Link the Excel data

Step #1: Copy the Excel worksheet

Open the Excel worksheet from which you want to embed data.

Select the rows and columns you want to copy

Press CTRL+C on your keyboard to copy the data to the clipboard.

Step #2: Link the data into the Word document

Open the Word document where you want to embed the Excel data.

Position the pointer at the insertion point.

Click on the Home tab on the top menu bar to change the ribbon.

In the section Clipboard, click on the small triangle below the Paste icon to open the Paste Options menu.

Click on Paste Special to open the Paste Special dialog.

Click on Paste Link and ensure a dot appears in the circle on the left.

In the section As:, select Microsoft Excel Worksheet Object.

Click on OK to close the dialog.

The Excel data appears in the Word document.

You may edit the Excel Worksheet. The changes will automatically appear in your Word document after you have saved the worksheet.


Conclusion

Follow our step-by-step instructions to insert Excel data into your Word document. We have shown you three methods, select the one most suitable.

Leave a Comment