Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

copying spreadsheets powerpoints

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying spreadsheets to powerpoints

Copying spreadsheets to powerpoints

ResolvedVersion 2007

Copying spreadsheets to powerpoints

What's the best way to copy excel spreadsheets to powerpoint?

RE: Copying spreadsheets to powerpoints

You might find this useful, although it requires an additional step in Excel. I have used it for years and I am sure that it produces the clearest and most versatile 'picture' in PowerPoint. Within PowerPoint the picture of the data can be resized with no problems, but it is a picture, there is no dynamic link to excel.

As follows:

Within Excel - select and copy the data (or chart) that you wish to copy to PowerPoint.

Still within Excel - click on a blank cell and then press [Shift]+[Edit] and you will find an additional option 'Paste Picture Link' on the drop menu. Select this option and the area that you copied will be pasted as a picture link. This is dynamically linked to the original Excel selection, and any changes will be reflected in the linked picture.

Still within Excel - right click on the picture and select copy from the drop menu.

Move to PowerPoint - and paste (no need to

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.