Microsoft KB Archive/26759

PowerPoint: Text Imported from Excel Loses Formatting PSS ID Number: Q26759 Article last modified on 08-31-1992 PSS database name: M_PowerPt

1.00 1.01 2.00 2.01 3.00

MACINTOSH

Summary:

When you import text from a Microsoft Excel spreadsheet into a text box in Microsoft PowerPoint, the tabular formatting may be lost.

This occurs when the columns of information are imported from Excel as plain text separated by tabs, using the Copy and Paste commands. To get the columns to line up, set tab stops on the PowerPoint ruler. Please note that there is a limit of ten tabs per word processing object in PowerPoint.

The Excel spreadsheet information can also be copied as a picture (graphic) so that it appears exactly as it did in Excel. However, the information is no longer editable when it is pasted into PowerPoint.

To make the information into a graphic, do the following:


 * 1) In Excel, highlight the desired area in the worksheet.
 * 2) Hold down the SHIFT key and choose Copy Picture from the Edit menu.
 * 3) Quit Excel.
 * 4) Open PowerPoint and choose Paste from the Edit menu.

Copyright Microsoft Corporation 1992.