Microsoft KB Archive/41502

Mac Works: Maximum Number of Characters in Spreadsheet Column

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

2.0 3.0

MACINTOSH

=
========================================================= 2.00 3.00 MACINTOSH kbother

= SUMMARY =

The maximum column width in a Microsoft Works Spreadsheet is 40 spaces. The font and the font size determine the number of characters that fit in a given space, thereby determining the number of characters Works allows for a given column width.

= MORE INFORMATION =

The following table lists the maximum number of characters in a Works spreadsheet column using the Geneva font, which is a proportionally spaced ImageWriter font:

Font Height Maximum Width of Column ———– ———————–

9 point     40 characters 10 point 34 characters 12 point 30 characters 14 point 26 characters 18 point 20 characters 20 point 17 characters 24 point 15 characters

The following table lists the maximum number of characters in a Works spreadsheet column using the Monaco font, which is a monospaced ImageWriter font:

Font Height Maximum Width of Column ———– ———————–

9 point     40 characters 10 point 36 characters 12 point 34 characters 14 point 29 characters 18 point 20 characters 20 point 20 characters 24 point 17 characters

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 2.00 3.00 mwksss mwksdb =

Version : 2.0 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.