Article ID: 827109 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
When you paste a large range of cells from a Microsoft Excel worksheet into a Microsoft Office PowerPoint 2003 presentation, only a part of the cells that are copied from the workbook may be visible. This problem occurs when you use the Paste Special command or the Excel Table smart tag option to paste the cells as a Microsoft Office Excel 2003 worksheet object.
This behavior occurs because the size of the Excel worksheet exceeds the default frame size for the pasted object. The size of the Excel worksheet varies according to the number of the rows, the height of the rows, the number of the columns, the width of the columns, and the size of the font.
To display all the rows and all the columns of the Excel worksheet in the PowerPoint presentation, use one of the following workarounds. These workarounds do not always correct the behavior. The success of the workaround depends on the size of the information that you are trying to paste into the PowerPoint presentation.
Method 1: Reduce the font size, the column widths, and the row heightsIn Excel, reduce the font size, the column widths, and the row heights to the minimum size that is acceptable. This reduction reduces the size of the worksheet.
Method 2: Use the Paste command instead of the Paste Special commandOn the Edit menu, click Paste instead of Paste Special, and then use the default format when you paste.
Method 3: Increase the size of the slides in the presentationIncrease the size of the PowerPoint presentation slides. To do so, follow these steps.
Note You cannot change the size or the orientation of individual slides in a presentation. Any changes that you make in Page Setup affect the whole presentation.
Method 4: Paste the cells in sectionsIf 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:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.