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
| xl3DBar | xlChartType (-4099) |
| xl3DEffects1 | 13 |
| xl3DEffects2 | 14 |
| xl3DSurface | -4103 |
| xlAbove | 0 |
| xlAccounting1 | 4 |
| xlAccounting2 | 5 |
| xlAccounting3 | 6 |
| xlAccounting4 | 17 |
| xlAdd | 2 |
| xlAll | -4104 |
| xlAllExceptBorders | 7 |
| xlAutomatic | xlCalculation (-4105) |
| xlBar | 2 |
| xlBelow | 1 |
| xlBidi | -5000 |
| xlBidiCalendar | 3 |
| xlBoth | 1 |
| xlBottom | -4107 |
| xlCascade | 7 |
| xlCenter | -4108 |
| xlCenterAcrossSelection | 7 |
| xlChart4 | 2 |
| xlChartSeries | 17 |
| xlChartShort | 6 |
| xlChartTitles | 18 |
| xlChecker | 9 |
| xlCircle | 8 |
| xlClassic1 | 1 |
| xlClassic2 | 2 |
| xlClassic3 | 3 |
| xlClosed | 3 |
| xlColor1 | 7 |
| xlColor2 | 8 |
| xlColor3 | 9 |
| xlColumn | 3 |
| xlCombination | -4111 |
| xlComplete | 4 |
| xlConstants | 2 |
| xlContext | -5002 |
| xlCorner | 2 |
| xlCrissCross | 16 |
| xlCross | 4 |
| xlCustom | -4114 |
| xlDebugCodePane | 13 |
| xlDefaultAutoFormat | -1 |
| xlDesktop | 9 |
| xlDiamond | 2 |
| xlDirect | 1 |
| xlDistributed | -4117 |
| xlDivide | 5 |
| xlDoubleAccounting | 5 |
| xlDoubleClosed | 5 |
| xlDoubleOpen | 4 |
| xlDoubleQuote | 1 |
| xlDrawingObject | 14 |
| xlEntireChart | 20 |
| xlExcelMenus | 1 |
| xlExtended | 3 |
| xlFill | 5 |
| xlFirst | 0 |
| xlFixedValue | 1 |
| xlFloating | 5 |
| xlFormats | -4122 |
| xlFormula | 5 |
| xlFullScript | 1 |
| xlGeneral | 1 |
| xlGregorian | 2 |
| xlGrid | 15 |
| xlGridline | 22 |
| xlHigh | -4127 |
| xlHindiNumerals | 3 |
| xlIcons | 1 |
| xlImmediatePane | 12 |
| xlInside | 2 |
| xlInteger | 2 |
| xlJustify | -4130 |
| xlLast | 1 |
| xlLastCell | 11 |
| xlLatin | -5001 |
| xlLeft | -4131 |
| xlLeftToRight | 2 |
| xlLightDown | 13 |
| xlLightHorizontal | 11 |
| xlLightUp | 14 |
| xlList1 | 10 |
| xlList2 | 11 |
| xlList3 | 12 |
| xlLocalFormat1 | 15 |
| xlLocalFormat2 | 16 |
| xlLong | 3 |
| xlLotusHelp | 2 |
| xlLow | -4134 |
| xlLTR | -5003 |
| xlMacrosheetCell | 7 |
| xlManual | xlCalculation.xlCalculationManual (-4135) |
| xlMaximum | 2 |
| xlMinimum | 4 |
| xlMinusValues | 3 |
| xlMixed | 2 |
| xlMixedAuthorizeScript | 4 |
| xlMixedScript | 3 |
| xlModule | -4141 |
| xlMultiply | 4 |
| xlNarrow | 1 |
| xlNextToAxis | xlTickLabelPosition (4) |
| xlNoDocuments | 3 |
| xlNone | xlLineStyle (-4142) |
| xlNotes | -4144 |
| xlOff | -4146 |
| xlOn | 1 |
| xlOpaque | 3 |
| xlOpen | 2 |
| xlOutside | 3 |
| xlPartial | 3 |
| xlPartialScript | 2 |
| xlPercent | 2 |
| xlPlus | 9 |
| xlPlusValues | 2 |
| xlReference | 4 |
| xlRight | -4152 |
| xlRTL | -5004 |
| xlScale | 3 |
| xlSemiautomatic | xlCalculation.xlCalculationSemiautomatic (2) |
| xlSemiGray75 | 10 |
| xlShort | 1 |
| xlShowLabel | xlDataLabelsType (4) |
| xlShowLabelAndPercent | xlDataLabelsType (5) |
| xlShowPercent | xlDataLabelsType (3) |
| xlShowValue | xlDataLabelsType (2) |
| xlSimple | -4154 |
| xlSingle | 2 |
| xlSingleAccounting | 4 |
| xlSingleQuote | 2 |
| xlSolid | 1 |
| xlSquare | 1 |
| xlStar | 5 |
| xlStError | 4 |
| xlStrict | 2 |
| xlSystem | 1 |
| xlTextBox | 16 |
| xlTiled | 1 |
| xlTitleBar | 8 |
| xlToolbar | 1 |
| xlToolbarButton | 2 |
| xlTop | -4160 |
| xlTopToBottom | 1 |
| xlTransparent | 2 |
| xlTriangle | 3 |
| xlVeryHidden | 2 |
| xlVisible | 12 |
| xlVisualCursor | 2 |
| xlWatchPane | 11 |
| xlWide | 3 |
| xlWorkbookTab | 6 |
| xlWorksheet4 | 1 |
| xlWorksheetCell | 3 |
| xlWorksheetShort | 5 |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext