copying spreadsheets powerpoints

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

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

Copying spreadsheets to powerpoints

resolvedResolved · Low Priority · Version 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


 

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Server loaded in 0.11 secs.