Microsoft Office How-to: Incorporate a Spreadsheet in PowerPoint

Status
Not open for further replies.

Osiris

Golden Master
Messages
36,817
Location
Kentucky
Microsoft Office How-to: Incorporate a Spreadsheet in PowerPoint


When you need stronger formatting and mathematical capabilities than PowerPoint builds in to its own tables, you can use Excel instead. Move to the slide where you want the table added. Switch to Excel and copy the data range you want to use.

Switch back to PowerPoint and use the Edit/Paste Special command, then choose the "Paste link" radio button. From the "As" box, choose "Microsoft Excel Worksheet Object."

To edit a cell, double-click on the range once to open the cell range in original Excel file. When you are done editing in Excel, use Excel's File/Close command, save the file, then switch back to PowerPoint.
 
Status
Not open for further replies.
Top