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
Tab Strip
Clipboard
Settings
Allow Drag and Drop
Allow Drag and Fill
Allow Undo
Allow Drag and Merge
Allow User to Enter Formulas
Allow Zoom
Allow Overflow
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
General
Grid Lines
Calculation
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:
Reference Style:
A1
R1C1
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
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:
Direction
Summary rows below detail
Summary columns to right of detail
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
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