ONLYOFFICE Spreadsheet Editor learning centre

ONLYOFFICE Spreadsheet Editor Practical Tutorials

Choose a practical ONLYOFFICE Spreadsheet Editor task below. Check the guide’s version, prerequisites and verification notes before following the steps.

For individual formulas, browse the ONLYOFFICE Spreadsheet Editor function directory.

10 practical tutorials

Data entry and validation

Create and Update an ONLYOFFICE Drop-Down ListBuild a source-range status dropdown, reject invalid typing and extend the allowed choices without assuming automatic range growth.Beginner · ONLYOFFICE Spreadsheet Editor

Formatting

Highlight a Whole Row by Status in ONLYOFFICEApply a formula-based format across a row range, anchor the status column and check rule scope and precedence.Intermediate · ONLYOFFICE Spreadsheet Editor

Formula troubleshooting

Diagnose Excel Formula Errors in ONLYOFFICESeparate missing functions, names, input types, regional syntax and array-entry differences before replacing a formula.Intermediate · ONLYOFFICE Spreadsheet Editor

Import and data cleanup

Preserve CSV Product IDs and Date Text in ONLYOFFICEUse an untouched CSV original, a prefixed transport copy and text extraction checks instead of assuming an unavailable import type selector.Intermediate · ONLYOFFICE Spreadsheet Editor Remove Duplicate Rows Safely in ONLYOFFICEKeep an untouched copy, select the complete record range and distinguish exact duplicate records from repeated business keys.Intermediate · ONLYOFFICE Spreadsheet Editor Split One Column into Several Columns in ONLYOFFICEUse Text to Columns on a safe copy, preview delimiters and avoid overwriting neighboring data; handle quoted fields through the documented import route.Intermediate · ONLYOFFICE Spreadsheet Editor

Pivot tables and analysis

Create an ONLYOFFICE Pivot Table and Include New RowsBuild a checked sales pivot, expand its data source when rows are appended and refresh without confusing refresh with range growth.Intermediate · ONLYOFFICE Spreadsheet Editor

Sharing and collaboration

Filter a Shared ONLYOFFICE Sheet Without Disrupting CoworkersCreate and activate a separate Sheet View before filtering; understand shared presets, custom-filter permissions and edition limits.Intermediate · ONLYOFFICE Spreadsheet Editor

Sheet and cell protection

Protect ONLYOFFICE Formulas While Keeping Inputs EditableUnlock input cells before enabling sheet protection, then check formula preservation, allowed edits and protection limits.Beginner · ONLYOFFICE Spreadsheet Editor

What-if analysis

Find Break-Even Sales Quantity with ONLYOFFICE Goal SeekSolve a one-input profit model, inspect the proposed quantity and verify whole-unit break-even instead of trusting a fractional result.Intermediate · ONLYOFFICE Spreadsheet Editor