Excel.DisplayFormat.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
DisplayFormat object (Excel)	vbaxl10.chm892072	vbaxl10.chm892072	Excel.DisplayFormat	c70b5d7f-adf1-e539-a32d-12c920af7c7e	03/29/2019	medium

DisplayFormat object (Excel)

Represents the display settings for an associated Range object. Read-only.

Remarks

Actions such as changing the conditional formatting or table style of a range can cause what is displayed in the current user interface to be inconsistent with the values in the corresponding properties of the Range object. Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.

Properties

• AddIndent
• Application
• Borders
• Characters
• Creator
• Font
• FormulaHidden
• HorizontalAlignment
• IndentLevel
• Interior
• Locked
• MergeCells
• NumberFormat
• NumberFormatLocal
• Orientation
• Parent
• ReadingOrder
• ShrinkToFit
• Style
• VerticalAlignment
• WrapText

See also

• Excel Object Model Reference

[!includeSupport and feedback]