In this tutorial, we’ll show you how to insert an Excel spreadsheet into a Word document and how to work with it later. You will also learn how to insert files into Microsoft Excel.
- Select a range of data in Excel.
- Right click on it and select Copy (Copy) or press the key combination Ctrl + C.
- Open a Word document.
- On the Advanced tab Home (Home) select a team paste (Insert) > paste Special (Special insert).
- Click on paste (Insert), and then select Microsoft Excel Worksheet Object (Microsoft Office Excel Sheet Object).
- Press OK.
- To start working with an object, double-click on it. Now you can, for example, format a table or insert a function SUM (SUM).
- Click anywhere else in the Word document.
Result:
Note: An embedded object is part of a Word file. It does not contain a link to the original Excel file. If you don’t want to embed an object, and you just need to create a link, then step 5 select paste Link (link) and then Microsoft Excel Worksheet Object (Microsoft Office Excel Sheet Object). Now, if you double-click on the object, the associated Excel file will open.
To insert a file into Excel, on the tab Insertion (Insert) in a command group Text (Text) select Object (An object).