Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/HBKh/~3/toEeXXHtbx4/189479If you filter a list in-place in Microsoft Excel, the status bar may display the following message: Filter Mode This message is incorrect. Instead, the status bar should display ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/toEeXXHtbx4" height="1" width="1"/>http://support.microsoft.com/kb/189479http://feedproxy.google.com/~r/microsoft/HBKh/~3/-_KpZRIeve4/microsoft.office.interop.excel.range.autofilter(office.11).aspxFilters a list using the AutoFilter.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/-_KpZRIeve4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.autofilter(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/Y9_4V0jaK0g/aa213704(office.11).aspxRepresents autofiltering for the specified worksheet. Using the AutoFilter Object. Use the AutoFilter property to return the AutoFilter object. Use the Filters method to return a ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Y9_4V0jaK0g" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa213704(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/2OHBoLk_mIY/152215When you apply an AutoFilter, Microsoft Excel displays the number of records that are filtered in the lower-left corner of the status bar. This article contains a sample Microsoft ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/2OHBoLk_mIY" height="1" width="1"/>http://support.microsoft.com/kb/152215http://feedproxy.google.com/~r/microsoft/HBKh/~3/xWZSOgr1a00/microsoft.office.tools.excel.worksheet.autofilter(VS.80).aspxGets a Microsoft.Office.Interop.Excel.AutoFilter if filtering is on. Gets if filtering is off.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/xWZSOgr1a00" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.autofilter(VS.80).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/GUTb1JOwo_g/bb210085.aspxRepresents autofiltering for the specified worksheet. Example. Use the AutoFilter property to return the AutoFilter object. Use the Filters property to return a collection of ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/GUTb1JOwo_g" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb210085.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/ik_tV6DwaMY/bb242013.aspxFilters a list using the AutoFilter.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/ik_tV6DwaMY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb242013.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/EtEYWNMw524/aa221844(office.11).aspxFilters a list using the AutoFilter. Variant. Note Apply the > AutoFilter property to a Worksheet object to return an AutoFilter object. expression.AutoFilter(Field, Criteria1 ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/EtEYWNMw524" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa221844(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/y9NKfEOgDWs/141770In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. This article contains several sample Microsoft Visual Basic for Applications ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/y9NKfEOgDWs" height="1" width="1"/>http://support.microsoft.com/kb/141770http://feedproxy.google.com/~r/microsoft/HBKh/~3/Gsj0283F5cQ/213628In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. This article contains several sample Microsoft Visual Basic for Applications ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Gsj0283F5cQ" height="1" width="1"/>http://support.microsoft.com/kb/213628http://feedproxy.google.com/~r/microsoft/HBKh/~3/51HWJp0QHzc/aa194940(office.11).aspxReturns the AutoFilter object for the specified worksheet. expression. AutoFilter. expression An expression that returns a Worksheet object. Remarks<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/51HWJp0QHzc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa194940(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/CV9dYbAWsLA/213733In Microsoft Excel 2000, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the Visual Basic for Applications ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/CV9dYbAWsLA" height="1" width="1"/>http://support.microsoft.com/kb/213733http://feedproxy.google.com/~r/microsoft/HBKh/~3/8B7Z2Te9ziU/aa155440(office.10).aspxusing Office 2000 ... This article may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/8B7Z2Te9ziU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa155440(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/cqR_BvAnKdc/aa141039(office.10).aspxDisplays or hides the AutoFilter drop-down arrows. You typically use this method to turn on the AutoFilter and add one or more criteria to it; you can then use the Apply method to ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/cqR_BvAnKdc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa141039(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/rnH-g-R_HyQ/bb148832.aspxReturns an AutoFilter object if filtering is on. Read-only. ... Returns an AutoFilter object if filtering is on. Read-only. Syntax. expression.AutoFilter<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/rnH-g-R_HyQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb148832.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/LJBLkU16SuU/295971When you use the AutoFilter command in Microsoft Excel, the AutoFilter list may not display all the unique visible items in a column as expected. In the products that are listed in ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/LJBLkU16SuU" height="1" width="1"/>http://support.microsoft.com/kb/295971http://feedproxy.google.com/~r/microsoft/HBKh/~3/m-xhiXr3pC4/213627In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. For example, if you have a list of salespeople that has a column of names and a ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/m-xhiXr3pC4" height="1" width="1"/>http://support.microsoft.com/kb/213627http://feedproxy.google.com/~r/microsoft/HBKh/~3/Q36klfM_y-o/119257In Microsoft Excel, when you use the Custom AutoFilter dialog box to filter number values that have been entered as text, and you select the <> comparison operator, all of the ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Q36klfM_y-o" height="1" width="1"/>http://support.microsoft.com/kb/119257http://feedproxy.google.com/~r/microsoft/HBKh/~3/I_sDt-Irz4g/141771In Microsoft Excel, you can use the AutoFilter feature to filter a list based on simple criteria. For example, if you have a list of salespeople that has a column of names and a ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/I_sDt-Irz4g" height="1" width="1"/>http://support.microsoft.com/kb/141771http://feedproxy.google.com/~r/microsoft/HBKh/~3/AnVB93vx5zk/162049In Microsoft Excel 97, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/AnVB93vx5zk" height="1" width="1"/>http://support.microsoft.com/kb/162049http://feedproxy.google.com/~r/microsoft/HBKh/~3/NlOWkURWviI/213886If you filter a list in-place in Microsoft Excel, the status bar may display the following message: Filter Mode This message is incorrect. Instead, the status bar should display ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/NlOWkURWviI" height="1" width="1"/>http://support.microsoft.com/kb/213886http://feedproxy.google.com/~r/microsoft/HBKh/~3/ZPAqDITGfRw/115310In Microsoft Excel, when you use a single character as the criteria in the Custom AutoFilter dialog box to filter data, you receive different results than you do when you use a ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/ZPAqDITGfRw" height="1" width="1"/>http://support.microsoft.com/kb/115310http://feedproxy.google.com/~r/microsoft/HBKh/~3/qZfNMc_PzAw/documentformat.openxml.spreadsheet.autofilter(office.14).aspxAutoFilter. Namespace: DocumentFormat.OpenXml.Spreadsheet Assembly: DocumentFormat.OpenXml (in documentformat.openxml.dll)<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/qZfNMc_PzAw" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.autofilter(office.14).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/jT_13r5ZqIQ/213923This step-by-step article describes how to use the AutoFilter feature of Microsoft Excel to filter records in a database based on cell formatting in certain fields. Filter Based on ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/jT_13r5ZqIQ" height="1" width="1"/>http://support.microsoft.com/kb/213923http://feedproxy.google.com/~r/microsoft/HBKh/~3/A4vFiMLR1d0/151449This article describes how to use the AutoFilter feature of Microsoft Excel to filter records in a database where a particular field has been formatted to a bold font.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/A4vFiMLR1d0" height="1" width="1"/>http://support.microsoft.com/kb/151449http://feedproxy.google.com/~r/microsoft/HBKh/~3/_pTEHIKKOKo/aa199190(office.10).aspxexpression An expression that returns a Worksheet object. Remarks. Do not confuse this property with the AutoFilter method. This property returns the AutoFilter object for a given ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/_pTEHIKKOKo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa199190(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/ba_FhNcZ4aY/188816In Microsoft Project 98, when you apply the Next Month AutoFilter, you may not see the expected tasks listed. This behavior occurs when you apply the Next Month AutoFilter in the ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/ba_FhNcZ4aY" height="1" width="1"/>http://support.microsoft.com/kb/188816http://feedproxy.google.com/~r/microsoft/HBKh/~3/y5RkGqdmUFw/aa160525(office.10).aspxexpression Required. An expression that returns one of the objects in the Applies To list. Field Optional Variant. The integer offset of the field on which you want to base ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/y5RkGqdmUFw" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa160525(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/W8mGeKMxL74/105412In Microsoft Excel, you cannot drag, cut and paste, or copy and paste the drop-down lists that are created when you use the AutoFilter to sort a list.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/W8mGeKMxL74" height="1" width="1"/>http://support.microsoft.com/kb/105412http://feedproxy.google.com/~r/microsoft/HBKh/~3/hWsxENiroMc/aa612939(office.10).aspxRepresents autofiltering for the specified worksheet. Using the AutoFilter Object. Use the AutoFilter property to return the AutoFilter object. Use the Filters method to return a ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/hWsxENiroMc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa612939(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/58xm8tQJ8eo/aa480727.aspxHaving an AutoFilter column type is particularly useful to enable users to add the AutoFilter feature to their applications by using the Windows Forms Designer, as described ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/58xm8tQJ8eo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa480727.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/DNjJXVhTK0U/aa272898(office.10).aspxFilters a list using the AutoFilter. Note Apply the AutoFilter property to a Worksheet object to return an AutoFilter object. Syntax. expression.AutoFilter(Field, Criteria1 ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/DNjJXVhTK0U" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa272898(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/vjx9U8-HEQc/microsoft.office.tools.excel.worksheet.autofilter.aspxGets a AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets null if filtering is off.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/vjx9U8-HEQc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.autofilter.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/K5mH9xLfqyU/excelmanagedautofiltering.aspx_range.AutoFilter(3, "=Petras", Excel.XlAutoFilterOperator.xlAnd, vk_missing, true); _range.AutoFilter(5, "<>Jonas", Excel.XlAutoFilterOperator.xlAnd, vk_missing, true);<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/K5mH9xLfqyU" height="1" width="1"/>http://blogs.msdn.com/erikaehrli/archive/2005/10/27/excelmanagedautofiltering.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/kPUbmBEuR-c/bb255835.aspxRepresents autofiltering for the specified worksheet. ... Name Description; Application: When used without an object qualifier, this property returns an Application object that ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/kPUbmBEuR-c" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb255835.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/sT70TJUKEVM/dd907578.aspxThis record specifies an AutoFilter. An Lbl record where the Name field has a value of 0x0D (_FilterDatabase) MUST exist for the current sheet. The rgce.rgce field of the Lbl ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/sT70TJUKEVM" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd907578.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/75eIvQdesOo/bb178108.aspxMakes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/75eIvQdesOo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb178108.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/FMniJc7aODs/microsoft.office.tools.excel.worksheet_properties(VS.80).aspxAutoFilter: Gets a Microsoft.Office.Interop.Excel.AutoFilter if filtering is on. Gets a null reference (Nothing in Visual Basic) if filtering is off.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/FMniJc7aODs" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet_properties(VS.80).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/v-EHNdx0cD0/248235When running a recorded macro that uses the AutoFilter feature, a date that meets the filter criteria is not properly filtered, either appearing when it shouldn't or not appearing ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/v-EHNdx0cD0" height="1" width="1"/>http://support.microsoft.com/kb/248235http://feedproxy.google.com/~r/microsoft/HBKh/~3/y1tsACUIk0Y/dd773925.aspx<s:complexType name="Autofilter"> <s:sequence> <s:element name="item" type="Item" minOccurs="0" maxOccurs="16384" /> </s:sequence> <s:attribute name="ID" type="s:int ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/y1tsACUIk0Y" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd773925.aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/6rRsV00mBDM/documentformat.openxml.spreadsheet.autofilter.autofilter(office.14).aspxInitializes a new instance of the AutoFilter with the specified child elements.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/6rRsV00mBDM" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.autofilter.autofilter(office.14).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/G-QTdS2cKS0/microsoft.office.interop.excel.autofilter(office.11).aspxRepresents autofiltering for the specified worksheet.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/G-QTdS2cKS0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.autofilter(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/Ry_LG7RCCSs/244789The AutoFilter displays all the records that contain Bird in the Animal field. Because one record is now displayed, the subtotal value in cell C8 is now 1.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Ry_LG7RCCSs" height="1" width="1"/>http://support.microsoft.com/kb/244789http://feedproxy.google.com/~r/microsoft/HBKh/~3/Wjua6eTF2pY/documentformat.openxml.spreadsheet.autofilter_members(office.14).aspxName Description ChildElements Gets all the child nodes of this element. (inherited from OpenXmlElement)<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Wjua6eTF2pY" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.autofilter_members(office.14).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/oDeqUabuG0U/215770When running a recorded macro that uses the AutoFilter feature, a date that meets the filter criteria is not properly filtered, either appearing when it shouldn't or not appearing ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/oDeqUabuG0U" height="1" width="1"/>http://support.microsoft.com/kb/215770http://feedproxy.google.com/~r/microsoft/HBKh/~3/pYmEVyaOFZA/microsoft.office.interop.excel._worksheet.autofilter(office.11).aspxReturns an AutoFilter object if filtering is on. Returns Nothing if filtering is off. Read-only.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/pYmEVyaOFZA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._worksheet.autofilter(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/71GULxVt0PA/aa205153(office.11).aspxActivates or deactivates the AutoFilter for the active project. Syntax. expression.AutoFilter. expression Optional. An expression that returns an Application object.<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/71GULxVt0PA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa205153(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/044w5EIAoRU/204061In Microsoft Excel for Mac, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/044w5EIAoRU" height="1" width="1"/>http://support.microsoft.com/kb/204061http://feedproxy.google.com/~r/microsoft/HBKh/~3/Qx16nws0FVA/aa174830(office.10).aspxDisplays or hides the AutoFilter drop-down arrows. Syntax. expression. AutoFilter. expression An expression that returns a Range object. Remarks. Do not confuse this method with ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/Qx16nws0FVA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa174830(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/HBKh/~3/7hncWN7Ds08/aa203669(office.10).aspxReturns an AutoFilter object if filtering is on. Returns Nothing if filtering is off. Read-only. Remarks. To create an AutoFilter object for a worksheet, you must turn ...<img src="http://feeds.feedburner.com/~r/microsoft/HBKh/~4/7hncWN7Ds08" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa203669(office.10).aspx