Microsoft KB Archive/38644: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "&" to "&")
 
Line 15: Line 15:
For a chart, the header and footer are always in Geneva 12 point. This cannot be changed. If you print to a LaserWriter, the LaserWriter will print in Helvetica, due to font substitution.
For a chart, the header and footer are always in Geneva 12 point. This cannot be changed. If you print to a LaserWriter, the LaserWriter will print in Helvetica, due to font substitution.


However, the text in the header and footer can be changed to bold and/or italic by placing &B and/or &I, respectively, prior to the text in the header and/or footer.
However, the text in the header and footer can be changed to bold and/or italic by placing &B and/or &I, respectively, prior to the text in the header and/or footer.


For example, to print the name of the worksheet in bold at the top of the worksheet, place the following in the header:
For example, to print the name of the worksheet in bold at the top of the worksheet, place the following in the header:


<pre>    &amp;B&amp;F</pre>
<pre>    &B&F</pre>
|}
|}



Latest revision as of 14:14, 21 July 2020


Excel 1.00-1.50: Can't Change Font or Size of Header Text

Last reviewed: November 2, 1994
Article ID: Q38644

SUMMARY

In versions of Microsoft Excel prior to 2.20, you cannot change the font or font size in a header or footer. The header and footer appear in the same font and size as the rest of the Excel worksheet/macro sheet.

For a chart, the header and footer are always in Geneva 12 point. This cannot be changed. If you print to a LaserWriter, the LaserWriter will print in Helvetica, due to font substitution.

However, the text in the header and footer can be changed to bold and/or italic by placing &B and/or &I, respectively, prior to the text in the header and/or footer.

For example, to print the name of the worksheet in bold at the top of the worksheet, place the following in the header:

    &B&F

KBCategory: kbother

KBSubcategory:

Additional reference words: 1.00 1.03 1.06 1.50


Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.