InfoHub, Technology

7 simple steps to insert MS Excel worksheet into MS Word document

In this article, we give you easy steps to help you insert MS Excel worksheet into MS Word document. This is important when you have data in an Excel spreadsheet that you want to include in something like a report.

Because some people do not know how to insert Excel sheet into Word document, they choose to copy paste. Copy pasting will mess up with your formatting.

How to insert MS Excel worksheet into MS Word document

  1. Put the cursor where you want to insert the Excel sheet.
  2. Click on the Insert tab on your current document.
insert excel spreadsheet into word document

3. Click on the object icon on the far right, just near the Text Box icon.

insert excel spreadsheet into word document

4. After clicking on the object icon, the dropdown arrow should bring you the two options: Object and Text from File. Select Object

insert excel spreadsheet into word document

5. A new dialogue box showing the various types of objects you can insert appears. Choose Microsoft Excel Worksheet and click OK.

insert excel spreadsheet into word document

This option will insert a blank Excel Worksheet object in your Word Document.

6. Now open the Microsoft Excel Worksheet you want to insert into the Word Document. Click in the first cell, then press CTRL + A to select All. This will ensure you only select the necessary cells and not the dataless cells of the Excel document. For instance, in our case, we have clicked in the cell with Name in English. Once we press CTRL + A, only cells with data will be selected. Once the data is selected, press CTRL + C to copy the selected data to dashboard.

ALSO READ  KEBS list of banned second hand car spare parts
insert excel spreadsheet into word document

7. Now go back to your Excel object in the MS Word Document you were working on. Click in the first cell of the Excel object. Then press CTRL + V to paste the copied data. That’s it. You can now format your object to appear decent, for instance stretching the pasted data area so that it fits.

This process of inserting an MS Excel sheet into a Word document should fairly work for any other program. Follow the same process to insert a word document into another word document, a PDF into a word document, and all the options in the dialogue box in point 5. You can also insert a text from another Word document or Excel worksheet by choosing the correct options.