Series in
Rows
Columns
Type
Linear
Growth
Date
AutoFill
Date unit
Day
Weekday
Month
Year
Trend
Step Value
Stop Value
Add Level
Delete Level
Copy Level
Options...
SortBy
SortOn
SortOrder
Orientation
Sort top to bottom
Sort left to right
General
ScrollBars
Calculation
Tab Strip
Clipboard
Custom Lists
Settings
Allow Drag and Drop
Allow Drag and Fill
Allow Undo
Allow Drag and Merge
Row Resize Mode
normal
split
Column Resize Mode
normal
split
Allow User to Enter Formulas
Allow Zoom
Allow Overflow
Allow DynamicArray
Pixel Scrolling
Scroll by <pixels>
Visibility
Vertical ScrollBar
ScrollBar ShowMax
Horizontal ScrollBar
ScrollBar MaxAlign
Setting
Tab Strip Visible
New Tab Visible
Tab Strip Editable
Tab Strip Ratio(as percentage)
%
Settings
Allow Copy Paste Excel Style
Allow Paste Extend Range
Header Options:
No Headers
All Headers
Row Headers
Column Headers
Custom Lists:
List entries:
Add
Delete
Reference Style:
A1
R1C1
General
Grid Lines
Headers
SheetTab
Column Count:
Row Count:
Frozen Column Count:
Frozen Row Count:
Trailing Frozen Column Count:
Trailing Frozen Row Count:
Selection Policy
Single Select
Range Select
MultiRange Select
Protect
Horizontal GridLine
Vertical GridLine
GridLine Color:
Column Headers
Row Headers
Column Header Row Count:
Column Header Auto Text:
Blank
Numbers
Letters
Column Header Auto Index:
Default Row Height:
Column Header Visible
Row Header Column Count:
Row Header Auto Text:
Blank
Numbers
Letters
Row Header Auto Index:
Default Column Width:
Row Header Visible
Sheet Tab Color:
Settings
Input Message
Error Alert
Highlight Style
Validation criteria
Allow:
Any value
Whole number
Decimal
List
Date
Text length
Custom
Data:
between
not between
equal to
not equal to
greater than
less than
greater than or equal to
less than or equal to
Ignore blank
In-cell dropdown
Show input message when cell is selected
When cell is selected, show this input message:
Title:
Input message:
Show error alert after invalid data is entered
When user enters invalid data, show this error alert:
Style:
Stop
Warning
Information
Title:
Error message:
Style
Circle
Dogear
Icon
Color
Position:
Top Left
Top Right
Bottom Right
Bottom Left
Position:
Outside Left
Outside Right
Icon:
Select Icon
Direction
Summary rows below detail
Summary columns to right of detail
showcol
showrow
Magnification
200%
100%
75%
50%
25%
Fit selection
Custom:
%
Choose the data that you want
Data Range:
Choose where you want the sparkline to be placed
Location Range:
IsFormulaSparkline
Select a cell state type
:
select a cell state type
hover
invalid
edit
readonly
active
selected
Choose the range that you want set
Range:
Set the style you want
Preview:
No Format Set
Format...
Cell state set list:
Add Cell State
Remove Select Cell State
Range
Style
State Type
Enter the Sparkline weight(pt)
Negative Points:
Markers:
High Point:
Low Point:
First Point:
Last Point:
Percentage
Line 1:
Line 2:
Minimum Value:
Maximum Value:
Points:
Positive Color
Negative Color
Points1
Points2
MinX
MinY
MaxX
MaxY
HLine
VLine
XMinZone
YMinZone
XMaxZone
YMaxZone
Color 1:
Color 2:
Tags
Draw Symbol
Draw Lines
Dash Line
Data
Data:
DataOrientation:
Vertical
Horizontal
DateAxisData:
DateAxisOrientation:
Vertical
Horizontal
DisplayEmptyCellsAs:
Gaps
Zero
Connect
Show First
Show Last
Show High
Show Low
Show Negative
Show Markers
RightToLeft
Negative:
Markers:
Axis:
Series:
High Marker:
Low Marker:
First Marker:
Last Marker:
Line Weight:
Measure:
Target:
Maxi:
Forecast:
Good:
Bad:
Tickunit:
ColorScheme:
Vertical
Points:
Style:
Stacked
Spread
Jitter
Poles
StackedDots
Stripe
ScaleStart:
ScaleEnd:
ColorScheme:
ShowAverage
Vertical
Points:
ColorRange:
LabelRange:
Maximum:
TargetRed:
TargetGreen:
TargetBlue:
TargetYellow:
Color:
HighlightPosition:
TextOrientation:
Horizontal
Vertical
TextSize:
px
Vertical
Value:
ColorScheme:
Variance:
Reference:
Mini:
Maxi:
Mark:
TickUnit:
ColorPositive:
ColorNegative:
Legend
Vertical
Points:
BoxPlotClass:
5NS
7NS
Tukey
Bowley
Sigma3
ScaleStart:
ScaleEnd:
AcceptableStart:
AcceptableEnd:
ColorScheme:
Style:
Classical
Neo
Show Average
Vertical
PointsRange:
PointIndex:
Minimum:
Maximum:
ColorPositive:
ColorNegative:
LabelsRange:
Vertical
Points:
PointIndex:
ColorRange:
HighlightPosition:
Target:
Target2:
Label:
None
Single
Cumulate
Vertical
Data Range:
Empty Color:
Location Range:
Start Color:
Year:
Middle Color:
Month:
End Color:
Range Color
Location Reference:
value:
Barcode Type:
QRCode
EAN-13
EAN-8
Codabar
Code39
Code93
CODE128
GS1_128
CODE49
PDF417
DataMatrix
Color:
Background Color:
quietZoneLeft:
quietZoneRight:
quietZoneTop:
quietZoneBottom:
Where is the data for your table?
Name:
Table Element:
Format
Clear
Preview
Select the new data range for your table:
Note: The headers must remain in the same row,
and the resulting table range must overlap
the original table range.
Style Name:
Format...
Copies:
1
2
3
4
5
Scaling Type:
Duplex Mode:
Choose paper source by pdf page size
Print ranges
Index:
Count:
Add
Remove
Index
Count
Font
Alignment
Colors and Lines
Size
Protection
Properties
Text alignment
Horizontal:
Left
Center
Right
Automatic size
Internal margin
Automatic
Left:
Top:
Right:
Bottom:
Fill
Transparency
%
Line
Color:
Style:
None
Dotted
Dashed
Solid
Double
Groove
Ridge
Inset
Outset
Width:
Height:
Width:
Locked
Lock text
Object positioning
Allow all users of this worksheet to:
Source Name:
Column
Name:
Header
Display header
Caption:
Item Sorting and Filtering
Ascending(A to Z)
Descending(Z to A)
Hide item with no data
Visually indicate items with no data
Show items with no data last
Name:
Table Element:
Format
Clear
Preview
POSITION AND LAYOUT
SIZE
PROPERTIES
Position
Horizontal:
Vertial:
Disable resizing and moving
Layout
Number of columns:
Button Height:
Button Width:
Height
Width
Scale Height
%
Scale Width
%
Move and size with cells
Move and don't size with cells
Don't move and size with cells
Locked