Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Ribbon tab

Section

Notes

FILE

New

Create a new workbook

Import

  • SpreadSheet File(JSON)

  • Excel File

  • CSV File

Export

  • SpreadSheet File(JSON)

  • Excel File

  • CSV File

  • PDF File

HOME

Undo

Undo/Redo

Clipboard

Fonts

Configure text styles

Alignment

Align text in the cell

Numbers

Cell Type

  • Cell Type

  • Cell Dropdowns

Styles

  • Conditional Format

  • Format Table

  • Cell Styles

  • Cell States

Cells

Insert/Delete/Format

Editing

Sum/Fill/Clear/Sort/Filter/Find

INSERT

Table

PivotTable

Chart

Column / Line / Pie / Bar / Area / Scatter / Stock / Radar / Sunburst / TreeMap / Funnel / Combo

Illustration

Picture

Shapes

Lines / Rectangles / Basic Shapes / Block Arrows / Equation Shapes / Flowchart / Starts and Banners

Camera

Barcode

Hyperlink

Sparklines

Line / Column / Win-Loss / Pie / Area / Scatter / Spread / Stacked / BoxPlot / Cascade / Pareto / Bullet / Hbar / Vbar / Variance / Month / Year / RangeBlock / Histogram / GaugeKPI / Image

Formulas

Functions

Functions Library

AutoSum / Financial / Logical / Text / Date&Time / Lookup&Reference / Math&Trig / More Functions

Names

Variable management

Formula Auditing

Show Formulas instead of values

DATA

Sort & Filter

Data Tools

Data validation

Outline

Group / Ungroup / Subtotal

Jira field mapping

  • Field to cell

  • Cell to field

  • Clear mapping

View

Show / Hide

Settings for views

Zoom

Zoom / 100% / Zoom To Selection

Viewport

Freeze Pane / Unfreeze Pane

Settings

Spread Settings

Settings for a workbook

Sheet Settings

Settings for current sheet

...