Microsoft KB Archive/28192

Excel Worksheet Formatting Not Saved PSS ID Number: Q28192 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

After you perform the following procedure and open your Excel worksheet, you may discover you have lost all of your formatting:


 * 1) Load a file from another program into Excel.
 * 2) From the File menu, choose Save As and change the sheet’s extension to .XLS so that it is changed to the Excel file format.
 * 3) Change some formatting on the sheet.
 * 4) Save and close the sheet.

To save an imported file in Excel normal format, do the following:


 * 1) From the File menu, choose Save As.
 * 2) Choose the Options button from the Save As dialog box.
 * 3) Select Normal for the file format.
 * 4) Enter the filename desired and choose OK.
 * 5) Close the sheet and then reopen it.

Reference(s):

“Microsoft Excel User’s Guide,” version 3.0, pages 56-61, 138-140

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.