Full-featured Table
- Kenichi Abe (Deactivated)
- Raziman Dom
To use full-featured Excel-like Tables, click “Open Editor”.
Ribbon menu details
Ribbon tab | Section | Notes |
|---|---|---|
FILE | New | Create a new workbook |
| Import |
|
| Export |
|
HOME | Undo | Undo/Redo |
| Clipboard |
|
| Fonts | Configure text styles |
| Alignment | Align text in the cell |
| Numbers |
|
| Cell Type |
|
| Styles |
|
| Cells | Insert/Delete/Format |
| Editing | Sum/Fill/Clear/Sort/Filter/Find |
INSERT | Table |
|
| 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 |
| Barcode |
|
| Hyperlink |
|
| Sparklines | Line / Column / Win-Loss / Pie / Area / Scatter / Spread / Stacked / BoxPlot / Cascade / Pareto / Bullet / Hbar / Vbar / Variance / Month / Year / RangeBlock |
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 |
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 |