Microsoft KB Archive/23561

Mac Works: How to Display Long Formulas from a Spreadsheet

PSS ID Number: Q23561 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SUMMARY =

To display the full contents of cells that contain long formulas, either increase the column width (up to 40 characters wide), copy and paste the information into a word processing document, or use the following steps:

Works 1.x and 2.x

 * 1) From the File menu, choose Save As.
 * 2) Give the file a new name and select the Export File option.
 * 3) Select the Text option and choose Save.
 * 4) From the File menu, choose Open and click the Word Processor icon.
 * 5) Click the Import File option.
 * 6) Locate the new text document and click Open.

Works 3.x and 4.0

 * 1) From the File menu, choose Save As.
 * 2) Give the file a new name and select Text from the File Format drop down list
 * 3) Choose Save
 * 4) From the File menu, choose Open and click the Word Processor icon.
 * 5) Locate the new text document and click Open.

The new word processing document will display all the formulas in their entirety. The tabs may need adjustment.

KBCategory: kbother kbprob KBSubcategory: macworkskb

= Additional reference words: 1.00 1.10 2.0 3.0 4.0 mwksss =

Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.