Font Sizes in Excel

The Font Size tool on the Formatting toolbar lists sizes from 8 to 72, but Excel isn't limited to those sizes. You can specify a Font Size property from 1 to 127 using VBA. For instance, to change a work font size, you'd use code similar to

Set myDocument = Worksheets(1)
myDocument.Shapes(1).TextEffect.FontSize = 24

Just because you specify a font size doesn't mean Excel or your printer can accommodate that size with the specified font. You must have the appropriate font installed and the font itself must be able to accommodate the size you choose. If it can't, Excel will substitute a similar font if possible.

Office Index

Main Index