Font object (Excel)

Contains the font attributes (font name, font size, color, and so on) for an object.

Remarks

If you don't want to format all the text in a cell or graphic the same way, use the Characters property to return a subset of the text.

Example

Use the Font property to return the Font object. The following example formats cells A1:C5 as bold.

Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

Properties

Name
Application
Background
Bold
Color
ColorIndex
Creator
FontStyle
Italic
Name
Parent
Size
Strikethrough
Subscript
Superscript
ThemeColor
ThemeFont
TintAndShade
Underline

See also

Excel Object Model Reference