Enumerations


Excel.Constants

Excel has many built-in constants that are referred to as intrinsic constants.
In addition to all the enumerations Excel also contains some global constants.
These can be accessed in two ways.

Excel.xlRight 
xlRight

Different to Word

Word does not have any global constants, everything comes from an enumeration.
In Word the approach taken is that all the miscellaneous constants have been put into their own enumeration called "wdConstants".
This is different to Excel.
In Excel the following two items exist but they are not enumerations for miscellaneous constants, they are infact just Global constants themselves.


Excel.xlConstant
Used for defining SQL/Query parameters.

Excel.xlConstant    // value 1 

Excel.xlConstants
Used for selecting hardcoded text/numbers (e.g., SpecialCells(xlCellTypeConstants, xlConstants)).

Excel.xlConstants   // value 2 

Using Enumerations

These can be accessed in three different ways.

Excel.XlChartType.xlPie 
Excel.xlPie
xlPie

Full List of the Miscellaneous Global Constants

xl3DBarxlChartType (-4099)
xl3DEffects113
xl3DEffects214
xl3DSurface-4103
xlAbove0
xlAccounting14
xlAccounting25
xlAccounting36
xlAccounting417
xlAdd2
xlAll-4104
xlAllExceptBorders7
xlAutomaticxlCalculation (-4105)
xlBar2
xlBelow1
xlBidi-5000
xlBidiCalendar3
xlBoth1
xlBottom-4107
xlCascade7
xlCenter-4108
xlCenterAcrossSelection7
xlChart42
xlChartSeries17
xlChartShort6
xlChartTitles18
xlChecker9
xlCircle8
xlClassic11
xlClassic22
xlClassic33
xlClosed3
xlColor17
xlColor28
xlColor39
xlColumn3
xlCombination-4111
xlComplete4
xlConstants2
xlContext-5002
xlCorner2
xlCrissCross16
xlCross4
xlCustom-4114
xlDebugCodePane13
xlDefaultAutoFormat-1
xlDesktop9
xlDiamond2
xlDirect1
xlDistributed-4117
xlDivide5
xlDoubleAccounting5
xlDoubleClosed5
xlDoubleOpen4
xlDoubleQuote1
xlDrawingObject14
xlEntireChart20
xlExcelMenus1
xlExtended3
xlFill5
xlFirst0
xlFixedValue1
xlFloating5
xlFormats-4122
xlFormula5
xlFullScript1
xlGeneral1
xlGregorian2
xlGrid15
xlGridline22
xlHigh-4127
xlHindiNumerals3
xlIcons1
xlImmediatePane12
xlInside2
xlInteger2
xlJustify-4130
xlLast1
xlLastCell11
xlLatin-5001
xlLeft-4131
xlLeftToRight2
xlLightDown13
xlLightHorizontal11
xlLightUp14
xlList110
xlList211
xlList312
xlLocalFormat115
xlLocalFormat216
xlLong3
xlLotusHelp2
xlLow-4134
xlLTR-5003
xlMacrosheetCell7
xlManualxlCalculation.xlCalculationManual (-4135)
xlMaximum2
xlMinimum4
xlMinusValues3
xlMixed2
xlMixedAuthorizeScript4
xlMixedScript3
xlModule-4141
xlMultiply4
xlNarrow1
xlNextToAxisxlTickLabelPosition (4)
xlNoDocuments3
xlNonexlLineStyle (-4142)
xlNotes-4144
xlOff-4146
xlOn1
xlOpaque3
xlOpen2
xlOutside3
xlPartial3
xlPartialScript2
xlPercent2
xlPlus9
xlPlusValues2
xlReference4
xlRight-4152
xlRTL-5004
xlScale3
xlSemiautomaticxlCalculation.xlCalculationSemiautomatic (2)
xlSemiGray7510
xlShort1
xlShowLabelxlDataLabelsType (4)
xlShowLabelAndPercentxlDataLabelsType (5)
xlShowPercentxlDataLabelsType (3)
xlShowValuexlDataLabelsType (2)
xlSimple-4154
xlSingle2
xlSingleAccounting4
xlSingleQuote2
xlSolid1
xlSquare1
xlStar5
xlStError4
xlStrict2
xlSystem1
xlTextBox16
xlTiled1
xlTitleBar8
xlToolbar1
xlToolbarButton2
xlTop-4160
xlTopToBottom1
xlTransparent2
xlTriangle3
xlVeryHidden2
xlVisible12
xlVisualCursor2
xlWatchPane11
xlWide3
xlWorkbookTab6
xlWorksheet41
xlWorksheetCell3
xlWorksheetShort5

© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext