United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Office and SharePoint development

Office client development

Office 2007

Excel 2007

Excel 2007 Developer Reference

Excel Object Model Reference

Enumerations

XlAboveBelow Enumeration

XlActionType Enumeration

XlApplicationInternational Enumeration

XlApplyNamesOrder Enumeration

XlArabicModes Enumeration

XlArrangeStyle Enumeration

XlArrowHeadLength Enumeration

XlArrowHeadStyle Enumeration

XlArrowHeadWidth Enumeration

XlAutoFillType Enumeration

XlAutoFilterOperator Enumeration

XlAxisCrosses Enumeration

XlAxisGroup Enumeration

XlAxisType Enumeration

XlBackground Enumeration

XlBarShape Enumeration

XlBordersIndex Enumeration

XlBorderWeight Enumeration

XlBuiltInDialog Enumeration

XlCalcFor Enumeration

XlCalculatedMemberType Enumeration

XlCalculation Enumeration

XlCalculationInterruptKey Enumeration

XlCalculationState Enumeration

XlCategoryType Enumeration

XlCellInsertionMode Enumeration

XlCellType Enumeration

XlChartElementPosition Enumeration

XlChartGallery Enumeration

XlChartItem Enumeration

XlChartLocation Enumeration

XlChartPicturePlacement Enumeration

XlChartPictureType Enumeration

XlChartSplitType Enumeration

XlChartType Enumeration

XlCheckInVersionType Enumeration

XlClipboardFormat Enumeration

XlCmdType Enumeration

XlColorIndex Enumeration

XlColumnDataType Enumeration

XlCommandUnderlines Enumeration

XlCommentDisplayMode Enumeration

XlConditionValueTypes Enumeration

XlConnectionType Enumeration

XlConsolidationFunction Enumeration

XlContainsOperator Enumeration

XlCopyPictureFormat Enumeration

XlCorruptLoad Enumeration

XlCreator Enumeration

XlCredentialsMethod Enumeration

XlCubeFieldSubType Enumeration

XlCubeFieldType Enumeration

XlCutCopyMode Enumeration

XlCVError Enumeration

XlDataLabelPosition Enumeration

XlDataLabelSeparator Enumeration

XlDataLabelsType Enumeration

XlDataSeriesDate Enumeration

XlDataSeriesType Enumeration

XlDeleteShiftDirection Enumeration

XlDirection Enumeration

XlDisplayBlanksAs Enumeration

XlDisplayDrawingObjects Enumeration

XlDisplayUnit Enumeration

XlDupeUnique Enumeration

XlDVAlertStyle Enumeration

XlDVType Enumeration

XlDynamicFilterCriteria Enumeration

XlEditionFormat Enumeration

XlEditionOptionsOption Enumeration

XlEditionType Enumeration

XlEnableCancelKey Enumeration

XlEnableSelection Enumeration

XlEndStyleCap Enumeration

XlErrorBarDirection Enumeration

XlErrorBarInclude Enumeration

XlErrorBarType Enumeration

XlErrorChecks Enumeration

XlFileAccess Enumeration

XlFileFormat Enumeration

XlFillWith Enumeration

XlFilterAction Enumeration

XlFilterAllDatesInPeriod Enumeration

XlFindLookIn Enumeration

XlFixedFormatQuality Enumeration

XlFixedFormatType Enumeration

XlFormatConditionOperator Enumeration

XlFormatConditionType Enumeration

XlFormatFilterTypes Enumeration

XlFormControl Enumeration

XlFormulaLabel Enumeration

XlGenerateTableRefs Enumeration

XlGradientFillType Enumeration

XlHAlign Enumeration

XlHebrewModes Enumeration

XlHighlightChangesTime Enumeration

XlHtmlType Enumeration

XlIconSet Enumeration

XlIMEMode Enumeration

XlImportDataAs Enumeration

XlInsertFormatOrigin Enumeration

XlInsertShiftDirection Enumeration

XlLayoutFormType Enumeration

XlLayoutRowType Enumeration

XlLegendPosition Enumeration

XlLineStyle Enumeration

XlLink Enumeration

XlLinkInfo Enumeration

XlLinkInfoType Enumeration

XlLinkStatus Enumeration

XlLinkType Enumeration

XlListConflict Enumeration

XlListDataType Enumeration

XlListObjectSourceType Enumeration

XlLocationInTable Enumeration

XlLookAt Enumeration

XlLookFor Enumeration

XlMailSystem Enumeration

XlMarkerStyle Enumeration

XlMeasurementUnits Enumeration

XlMouseButton Enumeration

XlMousePointer Enumeration

XlMSApplication Enumeration

XlObjectSize Enumeration

XlOLEType Enumeration

XlOLEVerb Enumeration

XlOrder Enumeration

XlOrientation Enumeration

XlPageBreak Enumeration

XlPageBreakExtent Enumeration

XlPageOrientation Enumeration

XlPaperSize Enumeration

XlParameterDataType Enumeration

XlParameterType Enumeration

XlPasteSpecialOperation Enumeration

XlPasteType Enumeration

XlPattern Enumeration

XlPhoneticAlignment Enumeration

XlPhoneticCharacterType Enumeration

XlPictureAppearance Enumeration

XlPictureConvertorType Enumeration

XlPivotCellType Enumeration

XlPivotConditionScope Enumeration

XlPivotFieldCalculation Enumeration

XlPivotFieldDataType Enumeration

XlPivotFieldOrientation Enumeration

XlPivotFilterType Enumeration

XlPivotFormatType Enumeration

XlPivotLineType Enumeration

XlPivotTableMissingItems Enumeration

XlPivotTableSourceType Enumeration

XlPivotTableVersionList Enumeration

XlPlacement Enumeration

XlPlatform Enumeration

XlPrintErrors Enumeration

XlPrintLocation Enumeration

XlPriority Enumeration

XlPropertyDisplayedIn Enumeration

XlPTSelectionMode Enumeration

XlQueryType Enumeration

XlRangeAutoFormat Enumeration

XlRangeValueDataType Enumeration

XlReferenceStyle Enumeration

XlReferenceType Enumeration

XlRemoveDocInfoType Enumeration

XlRgbColor Enumeration

XlRobustConnect Enumeration

XlRoutingSlipDelivery Enumeration

XlRoutingSlipStatus Enumeration

XlRowCol Enumeration

XlRunAutoMacro Enumeration

XlSaveAction Enumeration

XlSaveAsAccessMode Enumeration

XlSaveConflictResolution Enumeration

XlScaleType Enumeration

XlSearchDirection Enumeration

XlSearchOrder Enumeration

XlSearchWithin Enumeration

XlSheetType Enumeration

XlSheetVisibility Enumeration

XlSizeRepresents Enumeration

XlSmartTagControlType Enumeration

XlSmartTagDisplayMode Enumeration

XlSortDataOption Enumeration

XlSortMethod Enumeration

XlSortMethodOld Enumeration

XlSortOn Enumeration

XlSortOrder Enumeration

XlSortOrientation Enumeration

XlSortType Enumeration

XlSourceType Enumeration

XlSpeakDirection Enumeration

XlSpecialCellsValue Enumeration

XlStdColorScale Enumeration

XlSubscribeToFormat Enumeration

XlSubtototalLocationType Enumeration

XlSummaryColumn Enumeration

XlSummaryReportType Enumeration

XlSummaryRow Enumeration

XlTableStyleElementType Enumeration

XlTabPosition Enumeration

XlTextParsingType Enumeration

XlTextQualifier Enumeration

XlTextVisualLayoutType Enumeration

XlThemeColor Enumeration

XlThemeFont Enumeration

XlThreadMode Enumeration

XlTickLabelOrientation Enumeration

XlTickLabelPosition Enumeration

XlTickMark Enumeration

XlTimePeriods Enumeration

XlTimeUnit Enumeration

XlToolbarProtection Enumeration

XlTopBottom Enumeration

XlTotalsCalculation Enumeration

XlTrendlineType Enumeration

XlUnderlineStyle Enumeration

XlUpdateLinks Enumeration

XlVAlign Enumeration

XlWBATemplate Enumeration

XlWebFormatting Enumeration

XlWebSelectionType Enumeration

XlWindowState Enumeration

XlWindowType Enumeration

XlWindowView Enumeration

XlXLMMacroType Enumeration

XlXmlExportResult Enumeration

XlXmlImportResult Enumeration

XlXmlLoadOption Enumeration

XlYesNoGuess Enumeration

Minimize

This topic has not yet been rated - Rate this topic

XlPivotConditionScope Enumeration

Office 2007

This enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.

Version Information
Version Added: Excel 2007

Name	Value	Description
xlDataFieldScope	2	Based on the data in the specified fields.
xlFieldsScope	1	Based on the specified fields.
xlSelectionScope	0	Based on the specified selection criteria.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.