How to Embed Microsoft Excel Objects in Other Microsoft Office Products

From EG1003 Lab Manual
Jump to: navigation, search
  1. Create the object (graph, chart, etc.) in a Microsoft Excel file.
    Figure 1: Excel file with data.
  2. Highlight the object you want to embed in another file.
    Figure 2: Excel data highlighted.
  3. Right click the object and click on copy (or CTRL+C).
    Figure 3: Context dialog menu open.
  4. Open the file (PPT or Word) you want to embed the object into and click where you want to put it.
  5. On the top Ribbon click home and click on the drop down menu for paste.
  6. Click on paste special, a pop-up window will appear.
    Figure 4: PowerPoint paste dialog menu.
  7. Click on "Microsoft Excel Worksheet Object" and then OK.
    Figure 5: PowerPoint Paste Special dialog box.
  8. The Object will appear in the document and maybe moved around and edited.
    Note: To keep a link between the original Excel file and the file the object was embedded in, click on "paste link". This will update changes to the embedded object when they are changed in the original Excel file.
    Figure 6: Location of Paste link option.