Microsoft KB Archive/285303

= PPT2002: PowerPoint Does Not Display Full Width and Height of Embedded Excel Worksheet =

Article ID: 285303

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft PowerPoint 2002 Standard Edition

-



This article was previously published under Q285303





SYMPTOMS
When you use the Paste Special command or the Excel Table smart tag option to paste a large range of cells as a Microsoft Excel worksheet object from an Excel worksheet into a Microsoft PowerPoint presentation, only a portion of the cells copied from the workbook may be visible.



CAUSE
This behavior occurs because the size of the Excel worksheet, which varies according to the number and width of rows and columns and the font size used, exceeds the default frame size for the pasted object.



WORKAROUND
To display all the rows and columns of the Excel worksheet in the PowerPoint presentation, try any of the following workarounds. These workarounds do not correct the issue 100 percent of the time, depending upon the amount of Excel information that you are trying to paste into PowerPoint.

Method 1: Reduce the Font Size, Column Size, and Row Size
In Excel, reduce the font size, column widths, and row heights to the minimum size acceptable; doing so reduces the overall size of the worksheet.

Method 2: Use Paste, Not Paste Special
On the Edit menu, click Paste instead of Paste Special, and then use the default format when you paste.

Method 3: Make the PowerPoint Slide Bigger
Increase the size of the PowerPoint slide. To do so, follow these steps:
 * 1) In PowerPoint, on the File menu, click Page Setup.
 * 2) Use the UP ARROW key to change the width and height of the slide.
 * 3) Select the slide to which this size applies, and then click OK.

Method 4: Paste the Cells in Sections
If you still cannot paste the whole range of cells that you want, paste the range of cells in multiple sections. To do so, follow these steps:
 * 1) In Excel, select a range of cells that is small enough to copy into PowerPoint.
 * 2) On the Edit menu, click Copy.
 * 3) On the PowerPoint Edit menu, click Paste.
 * 4) Select the remainder of the range of cells in Excel.
 * 5) On the Edit menu, click Copy.
 * 6) On the PowerPoint Edit menu, click Paste. Note: You can align the sections inside PowerPoint so that they appear contiguous.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: PPT cut off crop cropped missing truncated gone small excel xl spreadsheet range

Keywords: kbbug kbnofix KB285303

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.