Microsoft Office Tutorials and References
In Depth Information
3.2 Insert and format tables
To paste Excel data as a table
1. In the Excel worksheet, select and copy the data you want to display in the
PowerPoint table.
2. Switch to PowerPoint, display the destination slide, and then paste the data.
3. To change the default paste option (Use Destination Styles), click the Paste Options
button, and then click the option you want.
Toembedaneditableworksheet
1. In the Excel worksheet, select and copy the data you want to display on the
PowerPoint slide.
2. Switch to PowerPoint, display the destination slide, click the Paste Options button,
and then click Embed .
Or
1. In the workbook that contains the worksheet, ensure that the worksheet you want
to embed is the active worksheet, and then save and close the workbook.
2. On the Insert tab, in the Text group, click the Object button.
3. In the Insert Object dialog box, click Create from file , and then click Browse .
4. In the Browse dialog box, locate and double-click the workbook, and then click OK .
Toeliminateextraneouscolumnsandrows
1. Double-click the worksheet object.
2. When the worksheet opens in an Excel window within PowerPoint, size the frame
around the worksheet so that it is just big enough to contain the active part of the
worksheet.
3. Click outside the frame to return to PowerPoint.
To resize the worksheet
Point to any handle (the sets of dots) around the worksheet object, and then drag
to enlarge or shrink it.
Tomodifyanembeddedworksheet
1. Double-click the worksheet object.
2. Use Excel techniques to edit and format the embedded object.
Search JabSto ::




Custom Search