Complete List
| xlAboveBelow | Specifies if the values are above or below average. |
| xlActionType | Specifies the action that should be performed. |
| xlAllocation | Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. |
| xlAllocationMethod | Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlAllocationValue | Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlApplicationInternational | Specifies country/region and international settings. |
| xlApplyNamesOrder | Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name. |
| xlArabicModes | Specifies spelling rules for the Arabic spelling checker. |
| xlArrangeStyle | Specifies how windows are arranged on the screen. |
| xlArrowHeadLength | Specifies the length of the arrowhead at the end of a line. |
| xlArrowHeadStyle | Specifies the type of arrowhead to apply to the line end. |
| xlArrowHeadWidth | Specifies the width of the arrowhead at the line end. |
| xlAutoFillType | Specifies how the target range is to be filled, based on the contents of the source range. |
| xlAutoFilterOperator | Specifies the operator to use to associate two criteria applied by a filter. |
| xlAxisCrosses | Specifies the point on the specified axis where the other axis crosses. |
| xlAxisGroup | Specifies the type of axis group. |
| xlAxisType | Specifies the axis type. |
| xlBackground | Specifies the background type for text in charts. |
| xlBarShape | Specifies the shape used with the 3-D bar or column chart. |
| xlBinsType | Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlBordersIndex | Specifies the border to be retrieved. |
| xlBorderWeight | Specifies the weight of the border around a range. |
| xlBuiltInDialog | Specifies which dialog box to display. |
| xlCalcFor | Specifies what should be calculated. |
| xlCalcMemNumberFormatType | Specifies the format of cell values that are based on the calculated member. |
| xlCalculatedMemberType | Specifies the type of a calculated member in a pivot table. |
| xlCalculation | Specifies the calculation mode. |
| xlCalculationInterruptKey | Specifies which key interrupts recalculation. |
| xlCalculationState | Specifies the calculation state of the application. |
| xlCategoryLabelLevel | Specifies the category labels for the category label levels. |
| xlCategorySortOrder | Specifies the sort order for the category. |
| xlCategoryType | Specifies the type of the category axis. |
| xlCellChangedState | Specifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed. |
| xlCellInsertionMode | Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query. |
| xlCellType | Specifies the type of cells. |
| xlChartElementPosition | Specifies the position of the chart element. |
| xlChartGallery | Specifies a chart gallery. |
| xlChartItem | Specifies the type of the chart item. |
| xlChartLocation | Specifies where to relocate a chart. |
| xlChartPicturePlacement | Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| xlChartPictureType | Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| xlChartSplitType | Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| xlChartType | Specifies the chart type. |
| XlCheckInVersionType | Specifies the type of version for the document checked in when using the CheckIn method. |
| xlClipboardFormat | Specifies the format of an item on the Windows clipboard. |
| xlCmdType | Specifies the value of the commandtext property. |
| xlColorIndex | Specifies the colour of the interior pattern as an index into the current colour palette. |
| xlColumnDataType | Specifies how a column is to be parsed. |
| xlCommandUnderlines | Specifies the state of the command underlines in Excel for the Macintosh. |
| xlCommentDisplayMode | Specifies the way cells display comments and comment indicators. |
| xlConditionValueTypes | Specifies the types of condition values that can be used. |
| xlConnectionType | Specifies the type of database connection. |
| xlConsolidationFunction | Specifies the subtotal function. |
| XlContainsOperator | Specifies the operator used in a function. |
| xlCopyPictureFormat | Specifies the format of the picture being copied. |
| xlCorruptLoad | Specifies the processing for a file when it is opened. |
| xlCreator | Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL). |
| xlCredentialsMethod | Specifies the type of credentials method used. |
| xlCubeFieldSubType | Specifies the subtype of the CubeField. |
| xlCubeFieldType | Specifies whether the OLAP field is a hierarchy, set, or measure field. |
| xlCutCopyMode | Specifies the status of the Cut Copy mode (Long). |
| xlCVError | Specifies the type of error you want to raise. |
| xlDataBarAxisPosition | Specifies the axis position for a range of cells with conditional formatting as data bars. |
| xlDataBarBorderType | Specifies the border of a data bar. |
| xlDataBarFillType | Specifies how a data bar is filled with color. |
| xlDataBarNegativeColorType | Specifies whether to use the same border and fill color as postive data bars. |
| xlDataLabelPosition | Specifies where the data label is positioned. |
| xlDataLabelSeparator | Specifies the separator used with data labels. |
| xlDataLabelsType | Specifies the type of data label to apply. |
| xlDataSeriesDate | Specifies the type of date to apply to a data series. |
| xlDataSeriesType | Specifies the data series to create. |
| xlDeleteShiftDirection | Specifies how to shift cells to replace deleted cells. |
| xlDirection | Specifies the direction in which to move. |
| xlDisplayBlanksAs | Specifies how blank cells are plotted on a chart. |
| xlDisplayDrawingObjects | Specifies how shapes are displayed. |
| xlDisplayUnit | Specifies the display unit label for an axis. |
| xlDupeUnique | Specifies whether duplicate or unique values shoud be displayed. |
| xlDVAlertStyle | Specifies the icon used in message boxes displayed during validation. |
| xlDVType | Specifies the type of validation test to be performed in conjunction with values. |
| xlDynamicFilterCriteria | Specifies the filter criterion. |
| xlEditionFormat | Specifies the format of the published edition. |
| xlEditionOptionsOption | This enumeration is for Macintosh only and should not be used. |
| xlEditionType | Specifies the type of edition to be changed. |
| xlEnableCancelKey | Specifies how Microsoft Excel handles Ctrl + Break (or Esc or Command + Period) user interruptions to the running procedure. |
| xlEnableSelection | Specifies what can be selected on the sheet. |
| xlEndStyleCap | Specifies the end style for error bars. |
| xlErrorBarDirection | Specifies which axis values are to receive error bars. |
| xlErrorBarInclude | Specifies which error bar parts to include. |
| xlErrorBarType | Specifies the range marked by error bars. |
| xlErrorChecks | Specifies the type of error object to be retrieved from the Errors collection. |
| xlFileAccess | Specifies the new access mode for the object. |
| xlFileFormat | Specifies the file format when saving the spreadsheet. |
| xlFileValidationPivotMode | Specifies how to validate the data caches for PivotTable reports. |
| xlFillWith | Specifies how to copy the range. |
| xlFilterAction | Specifies whether data is to be copied or left in place during a filter operation. |
| xlFilterAllDatesInPeriod | Specifies how dates should be filtered in the specified period. |
| xlFilterStatus | Specifies the status of the filter. |
| xlFindLookIn | Specifies the type of data to search. |
| xlFixedFormatQuality | Specifies the quality of speadsheets saved in different fixed formats. |
| xlFixedFormatType | Specifies the type of file format. |
| xlForecastAggregation | Specifies the type of aggregation to use for the forecast. |
| xlForecastChartType | Specifies the type of chart displayed for the forecast. |
| xlForecastDataCompletion | Specifies how data is completed for the forecast. |
| xlFormatConditionOperator | Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas. |
| xlFormatConditionType | Specifies whether the conditional format is based on a cell value or an expression. |
| xlFormatFilterTypes | Specifies the types of format filters. |
| xlFormControl | Specifies the type of the form control. |
| xlFormulaLabel | Specifies the formula label type for the specified range. |
| xlFormulaVersion | Specifies how you want formulas replaced when using Range.Replace. |
| xlGenerateTableRefs | Specifies the type of table references. |
| xlGeoMappingLevel | Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType | Specifies the geography projection type for a series within the chart group. |
| xlGradientFillType | Specifies the type of gradient fill. |
| xlGradientStopPositionType | Specifies the type of gradient stop position. |
| xlHAlign | Specifies the horizontal alignment for the object. |
| xlHebrewModes | Specifies the mode for the Hebrew spelling checker. |
| xlHighlightChangesTime | Specifies which set of changes is shown in a shared workbook. |
| xlHtmlType | Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive. |
| xlIcon | Specifies the icon for a criterion in an icon set conditional formatting rule. |
| xlIconSet | Specifies the type of icon set. |
| xlIMEMode | Specifies the description of the Japanese input rules. |
| xlImportDataAs | Specifies the format in which to return data from a database. |
| xlInsertFormatOrigin | Specifies from where to copy the format for inserted rows. |
| xlInsertShiftDirection | Specifies the direction in which to shift cells during an insertion. |
| xlLayoutFormType | Specifies the way the specified PivotTable items appear in table format or in outline format. |
| xlLayoutRowType | Specifies the type of layout row. |
| xlLegendPosition | Specifies the position of the legend on a chart. |
| xlLineStyle | Specifies the line style for the border. |
| xlLink | Specifies the type of link. |
| xlLinkedDataTypeState | Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlLinkInfo | Specifies the type of information to be returned. |
| xlLinkInfoType | Specifies the type of link. |
| xlLinkStatus | Specifies the status of a link. |
| xlLinkType | Specifies the type of link. |
| xlListConflict | Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet. |
| xlListDataType | Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site. |
| xlListObjectSourceType | Specifies the current source of the list. |
| xlLocationInTable | Specifies the part of the PivotTable report that contains the upper-left corner of a range. |
| xlLookAt | Specifies whether a match is made against the whole of the search text or any part of the search text. |
| xlLookFor | Specifies what to look for in searches. |
| xlMailSystem | Specifies the mail system that is installed on the host machine. |
| xlMarkerStyle | Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| xlMeasurementUnits | Specifies the measurement units. |
| xlModelChangeSource | Specifies the source of the change to the data model. |
| xlMouseButton | Specifies which mouse button was pressed. |
| xlMousePointer | Specifies the appearance of the mouse pointer in Microsoft Excel. |
| xlMSApplication | Specifies a Microsoft application. |
| xlOartHorizontalOverflow | Specifies the horizontal overflow setting for a text frame. |
| xlOartVerticalOverflow | Specifies the vertical overflow setting for a text frame. |
| xlObjectSize | Specifies the way a chart is scaled to fit on a page. |
| xlOLEType | Specifies the OLE object type. |
| xlOLEVerb | Specifies the verb that the server of the OLE object should act on. |
| xlOrder | Specifies the order in which cells are processed. |
| xlOrientation | Specifies the text orientation. |
| xlPageBreak | Specifies page break location in the worksheet. |
| xlPageBreakExtent | Specifies whether a page break is full screen or applies only within the print area. |
| xlPageOrientation | Specifies the page orientation when the worksheet is printed. |
| xlPaperSize | Specifies the size of the paper. |
| xlParameterDataType | Specifies the data type of a query parameter. |
| xlParameterType | Specifies how to determine the value of the parameter for the specified query table. |
| xlParentDataLabelOptions | Specifies the values passed to and returned from the Series.ParentDataLabelOption property. |
| xlPasteSpecialOperation | Specifies the operation you want to perform. |
| xlPasteType | Specifies the part of the range you want to paste. |
| xlPattern | Specifies the interior pattern of a cell or object. |
| xlPhoneticAlignment | Specifies the alignment for phonetic text. |
| xlPhoneticCharacterType | Specifies the type of phonetic text in a cell. |
| xlPictureAppearance | Specifies how the picture should be copied. |
| xlPictureConvertorType | Specifies how to convert a graphic. |
| xlPieSliceIndex | Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation | Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlPivotCellType | Specifies the PivotTable entity the cell corresponds to. |
| xlPivotConditionScope | Specifies the conditional formatting applied for filtering values from the PivotTable object. |
| xlPivotFieldCalculation | Specifies the type of calculation performed by a data PivotField when a custom calculation is used. |
| xlPivotFieldDataType | Specifies the type of data in the PivotTable field. |
| xlPivotFieldOrientation | Specifies the location of the field in a PivotTable report. |
| xlPivotFieldRepeatLabels | Specifies whether to repeat all field item labels in a PivotTable report. |
| xlPivotFilterType | Specifies the type of filter applied. |
| xlPivotFormatType | Specifies the type of report formatting to be applied to the specified PivotTable report. |
| xlPivotLineType | Specifies the type of the PivotLine. |
| xlPivotTableMissingItems | Specifies the maximum number of unique items per PivotField allowed. |
| xlPivotTableSourceType | Specifies the source of the report data. |
| xlPivotTableVersionList | Specifies the Excel version number. |
| xlPlacement | Specifies the way an object is attached to its underlying cells. |
| xlPlatform | Specifies the platform that a text file originated on. |
| xlPortugueseReform | Specifies the mode for checking the spelling of Portuguese. |
| xlPrintErrors | Specifies the type of print error displayed. |
| xlPrintLocation | Specifies the way comments are printed with the sheet. |
| xlPriority | Specifies the priority of a SendMailer message. |
| xlPropertyDisplayedIn | Specifies where to display the property. |
| xlProtectedViewCloseReason | Specifies how the protected view window was closed. |
| xlProtectedViewWindowState | Specifies the state of the protected view window. |
| xlPTSelectionMode | Specifies what may be selected in a pivottable during a structured selection. |
| xlPublishToDocsDisclosureScope | Specifies the disclosure type when publishing a workbook to a document. |
| xlPublishToPBINameConflictAction | Specifies the conflict action when publishing to Power BI. |
| xlPublishToPBIPublishType | Specifies the publishing type when publishing to Power BI. |
| xlQueryType | Specifies the type of query used to populate the query table or pivottable cache. |
| xlQuickAnalysisMode | Specifies which top level button the callout user interface is displayed. |
| xlRangeAutoFormat | Specifies the predefined format when a range is automatically formatted. |
| xlRangeValueDataType | Specifies the range value data type. |
| xlReferenceStyle | Specifies the reference style. |
| xlReferenceType | Specifies cell reference style when a formula is being converted. |
| xlRegionLabelOptions | Specifies the region labelling behavior for a series within the chart group. |
| xlRemoveDocInfoType | Specifies the type information to be removed from the document information. |
| xlRgbColor | Specifies the RGB color. |
| xlRobustConnect | Specifies how the PivotTable cache connects to its data source. |
| xlRoutingSlipDelivery | Specifies the routing delivery method. |
| xlRoutingSlipStatus | Specifies the status of the routing slip. |
| xlRowCol | Specifies whether the values corresponding to a particular data series are in rows or columns. |
| xlRunAutoMacro | Specifies the automatic macro to run. |
| xlSaveAction | Specifies during file close if the file will be saved. |
| xlSaveAsAccessMode | Specifies the access mode for the save as function. |
| xlSaveConflictResolution | Specifies the way conflicts are to be resolved whenever a shared workbook is updated. |
| xlScaleType | Specifies the scale type of the value axis. |
| xlSearchDirection | Specifies the search direction when searching a range. |
| xlSearchOrder | Specifies the order in which to search the range. |
| xlSearchWithin | Specifies the extent of the search for the range. |
| xlSeriesColorGradientStyle | Specifies the colour gradient style for a series. |
| xlSeriesNameLevel | Specifies the series labels for the series label levels. |
| xlSheetType | Specifies the type of sheet you can insert into a workbook. |
| xlSheetVisibility | Specifies whether the worksheet is visible. |
| xlSizeRepresents | Specifies what the bubble size represents on a bubble chart. |
| xlSlicerCacheType | Specifies the cache type to be used in the slicer. |
| xlSlicerCrossFilterType | Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
| xlSlicerSort | Specifies whether items displayed in the slicer are sorted. |
| xlSmartTagControlType | (Compatibility) Specifies the type of smart document control displayed in the document actions task pane. |
| xlSmartTagDisplayMode | (Compatibility) Specifies the display features for smart tags. |
| xlSortDataOption | Specifies how to sort text. |
| xlSortMethod | Specifies the type of sort. |
| xlSortMethodOld | Specifies how to sort when using East Asian sorting methods. |
| xlSortOn | Specifies the parameter on which the data should be sorted. |
| xlSortOrder | Specifies the sort order for the specified field or range. |
| xlSortOrientation | Specifies the sort orientation. |
| xlSortType | Specifies which elements are to be sorted in a pivottable report. |
| xlSourceType | Specifies the type of source object. |
| xlSpanishModes | Specifies the mode for checking the spelling of Spanish. |
| xlSparklineRowCol | Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
| xlSparkScale | Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
| xlSparkType | Specifies the type of sparkline. |
| xlSpeakDirection | Specifies the order in which the cells are spoken. |
| xlSpecialCellsValue | Specifies cells with a particular type of value to include in the result. |
| xlStdColorScale | Specifies the standard color scale. |
| xlSubscribeToFormat | Specifies the format to use when subscribing to a published edition. |
| xlSubtotalLocationType | Specifies where the subtotal will be displayed on the worksheet. |
| xlSummaryColumn | Specifies the location of the summary columns in the outline. |
| xlSummaryReportType | Specifies the location of the summary columns in the outline. |
| xlSummaryRow | Specifies the location of the summary rows in the outline. |
| xlTableStyleElementType | Specifies the table style element used. |
| xlTabPosition | Specifies the first or last tab position. |
| xlTextParsingType | Specifies the column format for the data in the text file that you are importing into a query table. |
| xlTextQualifier | Specifies the delimiter to use to specify text. |
| xlTextVisualLayoutType | Specifies whether the visual layout of the text being imported is left-to-right or right-to-left. |
| xlThemeColor | Specifies the theme color to be used. |
| xlThemeFont | Specifies the theme font to use. |
| xlThreadMode | Specifies the control over the multi-threaded calculation mode. |
| xlTickLabelOrientation | Specifies the text orientation for tick-mark labels. |
| xlTickLabelPosition | Specifies the position of tick-mark labels on the specified axis. |
| xlTickMark | Specifies the position of major and minor tick marks for an axis. |
| xlTimelineLevel | Specifies the time line to be used in the slicer. |
| xlTimeMoving | Specifies the period of time moving. (Removed in 2016) |
| xlTimePeriods | Specifies the time period. |
| xlTimeUnit | Specifies unit of time for chart axis and data series. |
| xlToolbarProtection | Specifies which properties of a toolbar are restricted. |
| xlTopBottom | Specifies the top 10 values from the top or bottom of a series of values. |
| xlTotalsCalculation | Specifies the type of calculation in the Totals row of a list column. |
| xlTrendlineType | Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
| xlUnderlineStyle | Specifies the type of underline applied to a font. |
| xlUpdateLinks | Specifies a workbook's setting for updating embedded OLE links. |
| xlVAlign | Specifies the vertical alignment for the object. |
| xlValueSortOrder | Specifies the sort order for the values. |
| xlWBATemplate | Specifies the type of workbook to create. |
| xlWebFormatting | Specifies how much formatting from a web page is applied when a web page is imported into a query table. |
| xlWebSelectionType | Specifies whether all the table(s) on an entire web page is imported into a query table. |
| xlWindowState | Specifies the state of the window. |
| xlWindowType | Specifies how the chart is displayed. |
| xlWindowView | Specifies the view showing in the window. |
| xlXLMMacroType | Specifies what type of macro a name refers to or whether the name refers to a macro. |
| xlXmlExportResult | Specifies the results of the save or export operation. |
| xlXmlImportResult | Specifies whether or not the first row contains headers. |
| xlXmlLoadOption | Specifies how Excel opens the XML data file. |
| xlYesNoGuess | Specifies whether or not the first row contains headers. |
| xlAboveBelow Specifies if the values are above or below average. |
| xlActionType Specifies the action that should be performed. |
| xlAllocation Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. |
| xlAllocationMethod Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlAllocationValue Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlApplicationInternational Specifies country/region and international settings. |
| xlApplyNamesOrder Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name. |
| xlArabicModes Specifies spelling rules for the Arabic spelling checker. |
| xlArrangeStyle Specifies how windows are arranged on the screen. |
| xlArrowHeadLength Specifies the length of the arrowhead at the end of a line. |
| xlArrowHeadStyle Specifies the type of arrowhead to apply to the line end. |
| xlArrowHeadWidth Specifies the width of the arrowhead at the line end. |
| xlAutoFillType Specifies how the target range is to be filled, based on the contents of the source range. |
| xlAutoFilterOperator Specifies the operator to use to associate two criteria applied by a filter. |
| xlAxisCrosses Specifies the point on the specified axis where the other axis crosses. |
| xlAxisGroup Specifies the type of axis group. |
| xlAxisType Specifies the axis type. |
| xlBackground Specifies the background type for text in charts. |
| xlBarShape Specifies the shape used with the 3-D bar or column chart. |
| xlBinsType Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlBordersIndex Specifies the border to be retrieved. |
| xlBorderWeight Specifies the weight of the border around a range. |
| xlBuiltInDialog Specifies which dialog box to display. |
| xlCalcFor Specifies what should be calculated. |
| xlCalcMemNumberFormatType Specifies the format of cell values that are based on the calculated member. |
| xlCalculatedMemberType Specifies the type of a calculated member in a pivot table. |
| xlCalculation Specifies the calculation mode. |
| xlCalculationInterruptKey Specifies which key interrupts recalculation. |
| xlCalculationState Specifies the calculation state of the application. |
| xlCategoryLabelLevel Specifies the category labels for the category label levels. |
| xlCategorySortOrder Specifies the sort order for the category. |
| xlCategoryType Specifies the type of the category axis. |
| xlCellChangedState Specifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed. |
| xlCellInsertionMode Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query. |
| xlCellType Specifies the type of cells. |
| xlChartElementPosition Specifies the position of the chart element. |
| xlChartGallery Specifies a chart gallery. |
| xlChartItem Specifies the type of the chart item. |
| xlChartLocation Specifies where to relocate a chart. |
| xlChartPicturePlacement Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| xlChartPictureType Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| xlChartSplitType Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| xlChartType Specifies the chart type. |
| XlCheckInVersionType Specifies the type of version for the document checked in when using the CheckIn method. |
| xlClipboardFormat Specifies the format of an item on the Windows clipboard. |
| xlCmdType Specifies the value of the commandtext property. |
| xlColorIndex Specifies the colour of the interior pattern as an index into the current colour palette. |
| xlColumnDataType Specifies how a column is to be parsed. |
| xlCommandUnderlines Specifies the state of the command underlines in Excel for the Macintosh. |
| xlCommentDisplayMode Specifies the way cells display comments and comment indicators. |
| xlConditionValueTypes Specifies the types of condition values that can be used. |
| xlConnectionType Specifies the type of database connection. |
| xlConsolidationFunction Specifies the subtotal function. |
| XlContainsOperator Specifies the operator used in a function. |
| xlCopyPictureFormat Specifies the format of the picture being copied. |
| xlCorruptLoad Specifies the processing for a file when it is opened. |
| xlCreator Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL). |
| xlCredentialsMethod Specifies the type of credentials method used. |
| xlCubeFieldSubType Specifies the subtype of the CubeField. |
| xlCubeFieldType Specifies whether the OLAP field is a hierarchy, set, or measure field. |
| xlCutCopyMode Specifies the status of the Cut Copy mode (Long). |
| xlCVError Specifies the type of error you want to raise. |
| xlDataBarAxisPosition Specifies the axis position for a range of cells with conditional formatting as data bars. |
| xlDataBarBorderType Specifies the border of a data bar. |
| xlDataBarFillType Specifies how a data bar is filled with color. |
| xlDataBarNegativeColorType Specifies whether to use the same border and fill color as postive data bars. |
| xlDataLabelPosition Specifies where the data label is positioned. |
| xlDataLabelSeparator Specifies the separator used with data labels. |
| xlDataLabelsType Specifies the type of data label to apply. |
| xlDataSeriesDate Specifies the type of date to apply to a data series. |
| xlDataSeriesType Specifies the data series to create. |
| xlDeleteShiftDirection Specifies how to shift cells to replace deleted cells. |
| xlDirection Specifies the direction in which to move. |
| xlDisplayBlanksAs Specifies how blank cells are plotted on a chart. |
| xlDisplayDrawingObjects Specifies how shapes are displayed. |
| xlDisplayUnit Specifies the display unit label for an axis. |
| xlDupeUnique Specifies whether duplicate or unique values shoud be displayed. |
| xlDVAlertStyle Specifies the icon used in message boxes displayed during validation. |
| xlDVType Specifies the type of validation test to be performed in conjunction with values. |
| xlDynamicFilterCriteria Specifies the filter criterion. |
| xlEditionFormat Specifies the format of the published edition. |
| xlEditionOptionsOption This enumeration is for Macintosh only and should not be used. |
| xlEditionType Specifies the type of edition to be changed. |
| xlEnableCancelKey Specifies how Microsoft Excel handles Ctrl + Break (or Esc or Command + Period) user interruptions to the running procedure. |
| xlEnableSelection Specifies what can be selected on the sheet. |
| xlEndStyleCap Specifies the end style for error bars. |
| xlErrorBarDirection Specifies which axis values are to receive error bars. |
| xlErrorBarInclude Specifies which error bar parts to include. |
| xlErrorBarType Specifies the range marked by error bars. |
| xlErrorChecks Specifies the type of error object to be retrieved from the Errors collection. |
| xlFileAccess Specifies the new access mode for the object. |
| xlFileFormat Specifies the file format when saving the spreadsheet. |
| xlFileValidationPivotMode Specifies how to validate the data caches for PivotTable reports. |
| xlFillWith Specifies how to copy the range. |
| xlFilterAction Specifies whether data is to be copied or left in place during a filter operation. |
| xlFilterAllDatesInPeriod Specifies how dates should be filtered in the specified period. |
| xlFilterStatus Specifies the status of the filter. |
| xlFindLookIn Specifies the type of data to search. |
| xlFixedFormatQuality Specifies the quality of speadsheets saved in different fixed formats. |
| xlFixedFormatType Specifies the type of file format. |
| xlForecastAggregation Specifies the type of aggregation to use for the forecast. |
| xlForecastChartType Specifies the type of chart displayed for the forecast. |
| xlForecastDataCompletion Specifies how data is completed for the forecast. |
| xlFormatConditionOperator Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas. |
| xlFormatConditionType Specifies whether the conditional format is based on a cell value or an expression. |
| xlFormatFilterTypes Specifies the types of format filters. |
| xlFormControl Specifies the type of the form control. |
| xlFormulaLabel Specifies the formula label type for the specified range. |
| xlFormulaVersion Specifies how you want formulas replaced when using Range.Replace. |
| xlGenerateTableRefs Specifies the type of table references. |
| xlGeoMappingLevel Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType Specifies the geography projection type for a series within the chart group. |
| xlGradientFillType Specifies the type of gradient fill. |
| xlGradientStopPositionType Specifies the type of gradient stop position. |
| xlHAlign Specifies the horizontal alignment for the object. |
| xlHebrewModes Specifies the mode for the Hebrew spelling checker. |
| xlHighlightChangesTime Specifies which set of changes is shown in a shared workbook. |
| xlHtmlType Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive. |
| xlIcon Specifies the icon for a criterion in an icon set conditional formatting rule. |
| xlIconSet Specifies the type of icon set. |
| xlIMEMode Specifies the description of the Japanese input rules. |
| xlImportDataAs Specifies the format in which to return data from a database. |
| xlInsertFormatOrigin Specifies from where to copy the format for inserted rows. |
| xlInsertShiftDirection Specifies the direction in which to shift cells during an insertion. |
| xlLayoutFormType Specifies the way the specified PivotTable items appear in table format or in outline format. |
| xlLayoutRowType Specifies the type of layout row. |
| xlLegendPosition Specifies the position of the legend on a chart. |
| xlLineStyle Specifies the line style for the border. |
| xlLink Specifies the type of link. |
| xlLinkedDataTypeState Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlLinkInfo Specifies the type of information to be returned. |
| xlLinkInfoType Specifies the type of link. |
| xlLinkStatus Specifies the status of a link. |
| xlLinkType Specifies the type of link. |
| xlListConflict Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet. |
| xlListDataType Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site. |
| xlListObjectSourceType Specifies the current source of the list. |
| xlLocationInTable Specifies the part of the PivotTable report that contains the upper-left corner of a range. |
| xlLookAt Specifies whether a match is made against the whole of the search text or any part of the search text. |
| xlLookFor Specifies what to look for in searches. |
| xlMailSystem Specifies the mail system that is installed on the host machine. |
| xlMarkerStyle Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| xlMeasurementUnits Specifies the measurement units. |
| xlModelChangeSource Specifies the source of the change to the data model. |
| xlMouseButton Specifies which mouse button was pressed. |
| xlMousePointer Specifies the appearance of the mouse pointer in Microsoft Excel. |
| xlMSApplication Specifies a Microsoft application. |
| xlOartHorizontalOverflow Specifies the horizontal overflow setting for a text frame. |
| xlOartVerticalOverflow Specifies the vertical overflow setting for a text frame. |
| xlObjectSize Specifies the way a chart is scaled to fit on a page. |
| xlOLEType Specifies the OLE object type. |
| xlOLEVerb Specifies the verb that the server of the OLE object should act on. |
| xlOrder Specifies the order in which cells are processed. |
| xlOrientation Specifies the text orientation. |
| xlPageBreak Specifies page break location in the worksheet. |
| xlPageBreakExtent Specifies whether a page break is full screen or applies only within the print area. |
| xlPageOrientation Specifies the page orientation when the worksheet is printed. |
| xlPaperSize Specifies the size of the paper. |
| xlParameterDataType Specifies the data type of a query parameter. |
| xlParameterType Specifies how to determine the value of the parameter for the specified query table. |
| xlParentDataLabelOptions Specifies the values passed to and returned from the Series.ParentDataLabelOption property. |
| xlPasteSpecialOperation Specifies the operation you want to perform. |
| xlPasteType Specifies the part of the range you want to paste. |
| xlPattern Specifies the interior pattern of a cell or object. |
| xlPhoneticAlignment Specifies the alignment for phonetic text. |
| xlPhoneticCharacterType Specifies the type of phonetic text in a cell. |
| xlPictureAppearance Specifies how the picture should be copied. |
| xlPictureConvertorType Specifies how to convert a graphic. |
| xlPieSliceIndex Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlPivotCellType Specifies the PivotTable entity the cell corresponds to. |
| xlPivotConditionScope Specifies the conditional formatting applied for filtering values from the PivotTable object. |
| xlPivotFieldCalculation Specifies the type of calculation performed by a data PivotField when a custom calculation is used. |
| xlPivotFieldDataType Specifies the type of data in the PivotTable field. |
| xlPivotFieldOrientation Specifies the location of the field in a PivotTable report. |
| xlPivotFieldRepeatLabels Specifies whether to repeat all field item labels in a PivotTable report. |
| xlPivotFilterType Specifies the type of filter applied. |
| xlPivotFormatType Specifies the type of report formatting to be applied to the specified PivotTable report. |
| xlPivotLineType Specifies the type of the PivotLine. |
| xlPivotTableMissingItems Specifies the maximum number of unique items per PivotField allowed. |
| xlPivotTableSourceType Specifies the source of the report data. |
| xlPivotTableVersionList Specifies the Excel version number. |
| xlPlacement Specifies the way an object is attached to its underlying cells. |
| xlPlatform Specifies the platform that a text file originated on. |
| xlPortugueseReform Specifies the mode for checking the spelling of Portuguese. |
| xlPrintErrors Specifies the type of print error displayed. |
| xlPrintLocation Specifies the way comments are printed with the sheet. |
| xlPriority Specifies the priority of a SendMailer message. |
| xlPropertyDisplayedIn Specifies where to display the property. |
| xlProtectedViewCloseReason Specifies how the protected view window was closed. |
| xlProtectedViewWindowState Specifies the state of the protected view window. |
| xlPTSelectionMode Specifies what may be selected in a pivottable during a structured selection. |
| xlPublishToDocsDisclosureScope Specifies the disclosure type when publishing a workbook to a document. |
| xlPublishToPBINameConflictAction Specifies the conflict action when publishing to Power BI. |
| xlPublishToPBIPublishType Specifies the publishing type when publishing to Power BI. |
| xlQueryType Specifies the type of query used to populate the query table or pivottable cache. |
| xlQuickAnalysisMode Specifies which top level button the callout user interface is displayed. |
| xlRangeAutoFormat Specifies the predefined format when a range is automatically formatted. |
| xlRangeValueDataType Specifies the range value data type. |
| xlReferenceStyle Specifies the reference style. |
| xlReferenceType Specifies cell reference style when a formula is being converted. |
| xlRegionLabelOptions Specifies the region labelling behavior for a series within the chart group. |
| xlRemoveDocInfoType Specifies the type information to be removed from the document information. |
| xlRgbColor Specifies the RGB color. |
| xlRobustConnect Specifies how the PivotTable cache connects to its data source. |
| xlRoutingSlipDelivery Specifies the routing delivery method. |
| xlRoutingSlipStatus Specifies the status of the routing slip. |
| xlRowCol Specifies whether the values corresponding to a particular data series are in rows or columns. |
| xlRunAutoMacro Specifies the automatic macro to run. |
| xlSaveAction Specifies during file close if the file will be saved. |
| xlSaveAsAccessMode Specifies the access mode for the save as function. |
| xlSaveConflictResolution Specifies the way conflicts are to be resolved whenever a shared workbook is updated. |
| xlScaleType Specifies the scale type of the value axis. |
| xlSearchDirection Specifies the search direction when searching a range. |
| xlSearchOrder Specifies the order in which to search the range. |
| xlSearchWithin Specifies the extent of the search for the range. |
| xlSeriesColorGradientStyle Specifies the colour gradient style for a series. |
| xlSeriesNameLevel Specifies the series labels for the series label levels. |
| xlSheetType Specifies the type of sheet you can insert into a workbook. |
| xlSheetVisibility Specifies whether the worksheet is visible. |
| xlSizeRepresents Specifies what the bubble size represents on a bubble chart. |
| xlSlicerCacheType Specifies the cache type to be used in the slicer. |
| xlSlicerCrossFilterType Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
| xlSlicerSort Specifies whether items displayed in the slicer are sorted. |
| xlSmartTagControlType (Compatibility) Specifies the type of smart document control displayed in the document actions task pane. |
| xlSmartTagDisplayMode (Compatibility) Specifies the display features for smart tags. |
| xlSortDataOption Specifies how to sort text. |
| xlSortMethod Specifies the type of sort. |
| xlSortMethodOld Specifies how to sort when using East Asian sorting methods. |
| xlSortOn Specifies the parameter on which the data should be sorted. |
| xlSortOrder Specifies the sort order for the specified field or range. |
| xlSortOrientation Specifies the sort orientation. |
| xlSortType Specifies which elements are to be sorted in a pivottable report. |
| xlSourceType Specifies the type of source object. |
| xlSpanishModes Specifies the mode for checking the spelling of Spanish. |
| xlSparklineRowCol Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
| xlSparkScale Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
| xlSparkType Specifies the type of sparkline. |
| xlSpeakDirection Specifies the order in which the cells are spoken. |
| xlSpecialCellsValue Specifies cells with a particular type of value to include in the result. |
| xlStdColorScale Specifies the standard color scale. |
| xlSubscribeToFormat Specifies the format to use when subscribing to a published edition. |
| xlSubtotalLocationType Specifies where the subtotal will be displayed on the worksheet. |
| xlSummaryColumn Specifies the location of the summary columns in the outline. |
| xlSummaryReportType Specifies the location of the summary columns in the outline. |
| xlSummaryRow Specifies the location of the summary rows in the outline. |
| xlTableStyleElementType Specifies the table style element used. |
| xlTabPosition Specifies the first or last tab position. |
| xlTextParsingType Specifies the column format for the data in the text file that you are importing into a query table. |
| xlTextQualifier Specifies the delimiter to use to specify text. |
| xlTextVisualLayoutType Specifies whether the visual layout of the text being imported is left-to-right or right-to-left. |
| xlThemeColor Specifies the theme color to be used. |
| xlThemeFont Specifies the theme font to use. |
| xlThreadMode Specifies the control over the multi-threaded calculation mode. |
| xlTickLabelOrientation Specifies the text orientation for tick-mark labels. |
| xlTickLabelPosition Specifies the position of tick-mark labels on the specified axis. |
| xlTickMark Specifies the position of major and minor tick marks for an axis. |
| xlTimelineLevel Specifies the time line to be used in the slicer. |
| xlTimeMoving Specifies the period of time moving. (Removed in 2016) |
| xlTimePeriods Specifies the time period. |
| xlTimeUnit Specifies unit of time for chart axis and data series. |
| xlToolbarProtection Specifies which properties of a toolbar are restricted. |
| xlTopBottom Specifies the top 10 values from the top or bottom of a series of values. |
| xlTotalsCalculation Specifies the type of calculation in the Totals row of a list column. |
| xlTrendlineType Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
| xlUnderlineStyle Specifies the type of underline applied to a font. |
| xlUpdateLinks Specifies a workbook's setting for updating embedded OLE links. |
| xlVAlign Specifies the vertical alignment for the object. |
| xlValueSortOrder Specifies the sort order for the values. |
| xlWBATemplate Specifies the type of workbook to create. |
| xlWebFormatting Specifies how much formatting from a web page is applied when a web page is imported into a query table. |
| xlWebSelectionType Specifies whether all the table(s) on an entire web page is imported into a query table. |
| xlWindowState Specifies the state of the window. |
| xlWindowType Specifies how the chart is displayed. |
| xlWindowView Specifies the view showing in the window. |
| xlXLMMacroType Specifies what type of macro a name refers to or whether the name refers to a macro. |
| xlXmlExportResult Specifies the results of the save or export operation. |
| xlXmlImportResult Specifies whether or not the first row contains headers. |
| xlXmlLoadOption Specifies how Excel opens the XML data file. |
| xlYesNoGuess Specifies whether or not the first row contains headers. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top