Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to paste big excel spreadsheet into powerpoint 1

Status
Not open for further replies.

wiesbaden

Technical User
Feb 20, 2002
7
DE
Hello everybody,

I would like to insert an excel spreadsheet into powerpoint as object. Unfortunately if I copy and paste powerpoint displays only half of the inserted columns.
The spreadsheet has 72 columns and 40 rows.
Got anyone a clue?
Thanx
Michael
 
Have you tried this yet?

Copy Excel data into a presentation

In Microsoft Excel, select the range of cells you want to copy, and then click Copy .

Switch to Microsoft PowerPoint, and then click the slide or notes page where you want to insert the cells.

On the Edit menu in PowerPoint, click Paste Special.
Make sure the Paste option is selected.

Do one of the following:

To paste the cells so that you can size and position them as you would a picture, click Picture.

To paste the cells as an embedded object that you can edit in Microsoft Excel, click Microsoft Excel Worksheet Object
 
Yes I have done both of it already. Both hasn't the wanted effect. It work only with insert as bitmap but that is not what I want. Do you know the maximum number of columns that are possible to insert in powerpoint?

If I insert the spreadsheet in powerpoint as excel worksheet object I can still work on it but isn't displayed in the entire extension.

Thanx anyway for the clue
 
Bitmap is the only way, because of the way in which the bitmap is formed. Picture implies certain screen boundaries, whilst bitmap allows much more manipulation (streching etc).

I can't ascertain why this is not an acceptable solution from your comments above. Can you clarify?

 
If you open PowerPoint on a blank presentation and select Insert, Table, it will only allow 25 columns and 25 rows.
 
bgauntt´s post was the right tip! First you create an excel-spreadsheet in powerpoint (which is BTW not limited to 25 cells) . Then you copy and paste the content of the original large spreadsheet into this new, embedded spreadsheet. In contrast to a pasted spreadsheet-object you can enlarge the embedded object so that one can see more than the first 20 coloums.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top