Excel.Font(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Font object (Excel)	vbaxl10.chm558072	vbaxl10.chm558072	Excel.Font	f4788ba4-1c4c-2f03-4d73-194bc9316825	03/29/2019	medium

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 of the Range object 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

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

See also

• Excel Object Model Reference

[!includeSupport and feedback]