Layout

Font

Control Elements:

Font
Selects font for the current selection
Font Size
Shows the selected font size
Larger
Increases the text size
Smaller
Decreases the text size
Vertical
Changes the vertical text alignment
Toggle Orientation
Toggles the text orientation of the selected component
Formats the selected text bold\Bold
Formats the selected text bold\Bold
Italic
Formats the selected text italic
Underline
Underlines the selected text
Fill Color
Changes the background color
Font Color
Changes the selected text's color
Frame
Shows or hides the component frame or parts of it
Show Item Numbers
Shows or hides the list's item numbers
Horizontal
Changes the horizontal text alignment
Wrap text
Wraps the selected text

Lines && Bars

Control Elements:

Line Color
Changes the line color
Line Style
Changes the line style
Line Symbol
Changes the symbol of this line
Increase
Increases the size of a marker
Decrease
Decreases the size of a marker
Lines && Bars

Diagram

Control Elements:

Shape
Select a shape
Line Color
Changes the line color
Line Style
Changes the line style
Start
Changes the style of the line's start point
End
Changes the style of the line's end point
Diagram
Diagram
Align
Align
Menu:
- Bring to front
  Increases the z-order of the component
- One layer up
  Moves the component up one layer
- One layer down
  Moves the component One Layer Down
- Send to back
  Decreases the z-order of the component
- Align Left
- Align Right
- Align Top
- Align Bottom
- Center Horizontal
- Center Vertical
- Same Size
- Same Height
- Same Width
- Space Across
- Space Down
Space
Space

Numbers

Control Elements:

Percent
Show values as percent
Increase Decimal
Increase the number of decimal places
Decrease Decimal
Decrease the number of decimal places
Numbers
Opens the formatting property sheet

Conditional Formatting

Control Elements:

Conditional Formatting
Administrates the conditional formatting
Menu:
- Apply Formatting Here
  Show conditional formats on selected component
- Highlights Outliers
  - Color Gradient Red / Green
    Assigns items to one of two groups
  - Color Gradient Red - Amber - Green
  - Color Gradient 3 Steps (Shades of Blue)
  - Color Gradient 3 Steps (Shades of Green)
  - Color Gradient 3 Steps (Shades of Grey)
  - Color Gradient 4 Steps (Red to Blue)
  - Color Gradient 4 Steps (Shades of Blue)
  - Color Gradient 4 Steps (Shades of Green)
  - Color Gradient 4 Steps (Shades of Grey)
  - Color Gradient 5 Steps (Red to Blue)
  - Color Gradient 5 Steps (Shades of Blue)
  - Color Gradient 5 Steps (Shades of Green)
  - Color Gradient 5 Steps (Shades of Grey)
  - Highlight Cells Greater Than...
  - Highlight Cells Less Than...
  - Highlight Cells Between...
  - Highlight Cells Equal To...
  - Highlight Cells Text That Contains...
  - Highlight Top / Bottom Top N Items
  - Highlight Top / Bottom Top N % of Range Total
  - Highlight Top / Bottom Bottom N Items
  - Highlight Top / Bottom Bottom N % of Range Total
  - Highlight Top / Bottom Above Mean
  - Highlight Top / Bottom Above Median
  - Highlight Top / Bottom Below Mean
  - Highlight Top / Bottom Below Median
  - Highlight Top / Bottom Above Upper Quartile
  - Highlight Top / Bottom Below Lower Quartile
  - Highlights Outliers More Than N Std Dev Above Mean
  - Highlights Outliers More Than N Std Dev Below Mean
  - Highlights Outliers More Than 1.5 IQR Above Upper Quartile
  - Highlights Outliers More Than 1.5 IQR Below Lower Quartile
- Reset
  Removes all format definitions
Numbers
Opens the formatting property sheet

Print

Control Elements:

Print Preview
Displays full pages
Page Setup
Changes the page layout settings
Header / Footer
Opens the editor for page header and footer
Page Margins
Shows or hides the printing pages

Layout

Control Elements:

Join cells
Join the selected cells
Show Label
Toggles between the name and the value of the assigned symbol
Insert
Insert or remove columns / rows
Menu:
- Insert Row Before
  Insert a new row before selection
- Insert Row After
  Insert a new row after selection
- Insert Column Before
  Inserts a new column before selection
- Insert Column After
  Inserts a new column after selection
- Insert Sub Item
  Inserts a single item as subitem of the selected item
- Group Items
  Creates a new parent item for the selected items
- Delete Row
  Delete the selected row
- Delete Column
  Delete the selected column
Row Height
Sets the height of rows
Same Height
Sets the same height for all rows of the selected component
Split Cell
Split selected joined cell
Titles
Uses the format settings for the titles category
Delete
Delete
Menu:
- Delete Column
  Delete the selected column
- Delete Row
  Delete the selected row
Column Width
Sets the width of columns
Same Width
Sets the same width for all columns of the components
Layout
Layout

Mapping

Control Elements:

Columns
Select the dimension shown as the component's columns
Rows
Select the dimensions shown as the component's rows
Mapping
Defines column and row mapping

Tree Diagram

Control Elements:

Space
Space
Diagram
Diagram
Tree Diagram
Tree Diagram

Format

Control Elements:

Conditional Formatting
Administrates the conditional formatting
Menu:
- Apply Formatting Here
  Show conditional formats on selected component
- Highlights Outliers
  - Color Gradient Red / Green
    Assigns items to one of two groups
  - Color Gradient Red - Amber - Green
  - Color Gradient 3 Steps (Shades of Blue)
  - Color Gradient 3 Steps (Shades of Green)
  - Color Gradient 3 Steps (Shades of Grey)
  - Color Gradient 4 Steps (Red to Blue)
  - Color Gradient 4 Steps (Shades of Blue)
  - Color Gradient 4 Steps (Shades of Green)
  - Color Gradient 4 Steps (Shades of Grey)
  - Color Gradient 5 Steps (Red to Blue)
  - Color Gradient 5 Steps (Shades of Blue)
  - Color Gradient 5 Steps (Shades of Green)
  - Color Gradient 5 Steps (Shades of Grey)
  - Highlight Cells Greater Than...
  - Highlight Cells Less Than...
  - Highlight Cells Between...
  - Highlight Cells Equal To...
  - Highlight Cells Text That Contains...
  - Highlight Top / Bottom Top N Items
  - Highlight Top / Bottom Top N % of Range Total
  - Highlight Top / Bottom Bottom N Items
  - Highlight Top / Bottom Bottom N % of Range Total
  - Highlight Top / Bottom Above Mean
  - Highlight Top / Bottom Above Median
  - Highlight Top / Bottom Below Mean
  - Highlight Top / Bottom Below Median
  - Highlight Top / Bottom Above Upper Quartile
  - Highlight Top / Bottom Below Lower Quartile
  - Highlights Outliers More Than N Std Dev Above Mean
  - Highlights Outliers More Than N Std Dev Below Mean
  - Highlights Outliers More Than 1.5 IQR Above Upper Quartile
  - Highlights Outliers More Than 1.5 IQR Below Lower Quartile
- Reset
  Removes all format definitions
Format Component
Formats the selected component
Reset Formats
Clears local format settings and uses global profile instead
Format
Edit format and design settings

Page Setup

Control Elements:

Print Preview
Displays full pages
Page Setup
Changes the page layout settings
Header / Footer
Opens the editor for page header and footer
Page Margins
Shows or hides the printing pages

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know:

Welcome Back!

Login to manage your account

Forgot your password?

Not registered yet? Signup