Difference between revisions of "How to Embed Microsoft Excel Objects in Other Microsoft Office Products"
From EG1004 Lab Manual
(2014-07-03 Navjot Kaur) |
|||
| Line 1: | Line 1: | ||
# Create the object (graph, chart, etc.) in | # Create the object (graph, chart, etc.) in a Microsoft Excel file. | ||
#: [[Image:embedexcel1.png|frame|center|Figure 1: Excel file with data.]] | |||
# Highlight the object you want to embed in another file. | # Highlight the object you want to embed in another file. | ||
#: [[Image:embedexcel2.png|frame|center|Figure 2: Excel data highlighted.]] | |||
# Right click the object and click on copy (or CTRL+C). | # Right click the object and click on copy (or CTRL+C). | ||
#: [[Image:embedexcel3.png|frame|center|Figure 3: Context dialog menu open.]] | |||
# Open the file (PPT or Word) you want to embed the object into and click where you want to put it. | # Open the file (PPT or Word) you want to embed the object into and click where you want to put it. | ||
# On the top Ribbon click home and click on the drop down menu for paste. | # On the top Ribbon click home and click on the drop down menu for paste. | ||
# Click on paste special, a pop-up window will appear. | # Click on paste special, a pop-up window will appear. | ||
#: [[Image:embedexcel4.png|frame|center|Figure 4: PowerPoint paste dialog menu.]] | |||
# Click on "Microsoft Excel Worksheet Object" and then OK. | # Click on "Microsoft Excel Worksheet Object" and then OK. | ||
#: [[Image:embedexcel5.png|frame|center|Figure 5: PowerPoint Paste Special dialog box.]] | |||
# The Object will appear in the document and maybe moved around and edited. | # 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. | #: 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. | ||
#: [[Image:embedexcel6.png|frame|center|Figure 6: Location of ''Paste link'' option.]] | |||
Revision as of 18:06, 6 July 2014
- Create the object (graph, chart, etc.) in a Microsoft Excel file.
Figure 1: Excel file with data.
- Highlight the object you want to embed in another file.
Figure 2: Excel data highlighted.
- Right click the object and click on copy (or CTRL+C).
Figure 3: Context dialog menu open.
- Open the file (PPT or Word) you want to embed the object into and click where you want to put it.
- On the top Ribbon click home and click on the drop down menu for paste.
- Click on paste special, a pop-up window will appear.
Figure 4: PowerPoint paste dialog menu.
- Click on "Microsoft Excel Worksheet Object" and then OK.
Figure 5: PowerPoint Paste Special dialog box.
- 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.
