How to Embed Microsoft Excel Objects in Other Microsoft Office Products

From EG1004 Lab Manual
Revision as of 17:38, 6 July 2014 by Admin (talk | contribs) (2014-07-03 Navjot Kaur)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  1. Create the object (graph, chart, etc.) in an Excel file.
  2. Highlight the object you want to embed in another file.
  3. Right click the object and click on copy (or CTRL+C).
  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.
  7. Click on "Microsoft Excel Worksheet Object" and then OK.
  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.