Microsoft KB Archive/62683

Information Imported from Excel Loses Columnar Formatting PSS ID Number: Q62683 Article last modified on 09-25-1991 PSS database name: W_PowerPt

2.00

WINDOWS

Summary:

When importing text from an Excel spreadsheet into a text box in PowerPoint, the columnar formatting is lost.

The columns of information imported from Excel are plain text separated by tabs. To get the columns to line up, set tab stops on the PowerPoint ruler. Please note that you are limited to 20 tabs per text block.

You can also import the Excel spreadsheet information as a graphic so that it appears exactly as it did in Excel. However, you will not be able to edit the information in 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 from the Edit menu choose Copy Picture. Chose Copy As Shown On Screen.
 * 3) Open PowerPoint and from the Edit menu choose Paste.

Copyright Microsoft Corporation 1991.