<autoFilter> (AutoFilter Settings)

AutoFilter temporarily hides rows based on a filter criteria, which is applied column by column to a table of data in the worksheet. This collection expresses AutoFilter settings.

<autoFilter ref="B3:E8">
  <filterColumn colId="1">
      <customFilter operator="greaterThan" val="0.5"/>

Parent Elements

<customSheetView>; <filter>; <table>; <worksheet>

Child Elements


<extLst> (Future Feature Data Storage Area)


<filterColumn> (AutoFilter Column)


<sortState> (Sort State)




<ref> (Cell or Range Reference)

Reference to the cell range to which the AutoFilter is applied.

The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_AutoFilter">
	<element name="filterColumn" minOccurs="0" maxOccurs="unbounded" type="CT_FilterColumn"/>
	<element name="sortState" minOccurs="0" maxOccurs="1" type="CT_SortState"/>
	<element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
	<attribute name="ref" type="ST_Ref"/>