HOW DO I SHOW A EXCEL FORMULA IN MY POWERPOINT PRESENTATION?

[LORENAJARU]

I'M WORKING ON A POWERPOINT PRESENTATION. I WANT TO BE ABLE TO CLICK ON A
CELL OF A EXCEL SPREADSHEET AND SHOW THE FORMULA. I HAVE THE SPREADSHEET IN
MY PRESENTATION ALREADY, BUT I CAN'T GET TO SHOW FORMULAS IN IT. HOW DO I DO
IT?

 

[Echo S]

I'M WORKING ON A POWERPOINT PRESENTATION. I WANT TO BE ABLE TO CLICK
ON A CELL OF A EXCEL SPREADSHEET AND SHOW THE FORMULA. I HAVE THE
SPREADSHEET IN MY PRESENTATION ALREADY, BUT I CAN'T GET TO SHOW
FORMULAS IN IT. HOW DO I DO IT?

First you need to fix your Shift key, as it seems to be stuck. Typing in all
caps implies shouting, which is not the best way to get help.

That said, here's what you do.

Insert/Object/From File
Navigate to the Excel file and click OK to insert
Right-click the object and choose custom animation
Click Add Effect and choose Object Actions/Edit

Now when you click the spreadsheet in the presentation, Excel will open and
you can show the formula.

These instructions are for PPT 2003.

 

[Brian Reilly, MS MVP]

In addition to Echo's advice, you can do this ahead of time in Excel
before you copy and paste into PPT. Set the Excel worksheet to show
formulas and then copy and paste.

Brian Reilly, PowerPoint MVP