Some cells of an Excel 2003 workbook do not appear pasted into a presentation in PowerPoint 2003

Article translations Article translations
Article ID: 827109 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

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.

CAUSE

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.

WORKAROUND

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 heights

In 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 command

On 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 presentation

Increase 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.
  1. In PowerPoint, click Page Setup on the File menu.
  2. Use the UP ARROW key to change the width and the height of the slide.
  3. 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 sufficiently small to copy into PowerPoint.
  2. On the Edit menu, click Copy.
  3. In PowerPoint, click Paste on the Edit menu.
  4. In Excel, select the remainder of the range of cells.
  5. On the Edit menu, click Copy.
  6. In PowerPoint, click Paste on the Edit menu. Note You can align the sections in the PowerPoint slide so that they appear contiguous.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

Properties

Article ID: 827109 - Last Review: September 12, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Office PowerPoint 2003
Keywords: 
kbdisplay kbprb KB827109

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com