User Interface

Format

Control Elements:

Sort & Filter
Sort and filter items
Menu:
- Auto Filter...
  Sort and filter items
- Reset Filter
  Removes all filters on the worksheet
- Advanced Filter Options
  Selects advanced filter and sorting criteria for the list
- Sort Smallest to Largest
- Sort Largest to Smallest
- Filter
- Apply Filter Again
  Activates the last defined filter again
- Filter: Parameters
  Show parameter items only
- Filter: System
  Show system elements only
- Filter: All
  Show items of all types
- Filter: Constraints
  Show or hide items marked as constraints
- Filter: Empty
- Filter: Related
- Filter: Knowledge State
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
Highlight Priority
Highlights cells that have a priority
Highlight Knowledge
Highlights cells according to its knowledge state
Highlight Conditional Formats
Shows the colors according to conditional formatting rules
Set Focus
Sets the focus on the selected item or releases the focus again
Format
Format