PowerPoint Tips: Add a live spreadsheet to your PowerPoint

crop pictures in PowerPoint

By Ellen Finkelstein

Insert a live spreadsheet into PowerPoint

You can insert a live Excel spreadsheet onto a slide so that you can use Excel while in Slide Show view.

There are other ways to get Excel data onto a slide, so why would you want an active Excel spreadsheet? Let’s say that you’re presenting some results of your financial analysis and your boss asks, “How did you get those results? Show me the spreadsheet.” You could switch to Excel, but it might be more slick to have it available in your PowerPoint presentation.

Slick? What does that mean? It just means that the process is less disruptive and more continuous, so it looks more professional. Try out this unusual technique and see if you like it.

Here are the steps:

1. Choose Insert (tab)> Object> From File. In the Insert Object dialog box, choose the Create from File option.

2. Click Browse, navigate to the Excel file, and double-click it. Click OK. You now see the spreadsheet on your slide. You may see all of it or part of it, but when you show it in Slide Show view, you’ll be able to pan and zoom to display what you want.

Steps continued here

This excerpt is shared with permission from ellenfinkelstein.com.

636 total views, 3 views today

(Visited 341 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.