Spreadsheet Editor

Program interface

• Collaboration tab
• Data tab
• Draw tab
• File tab
• Formula tab
• Home tab
• Insert tab
• Introducing the user interface of the Spreadsheet Editor
• Layout tab
• Pivot Table tab
• Plugins tab
• Protection tab
• View tab

Basic operations

• Adding external links to cells
• Creating a new spreadsheet or opening an existing one
• Cutting/copying/pasting data
• Undoing/redoing your actions

Cell text formatting

• Adding hyperlinks
• Clearing text, formatting in a cell, copying cell format
• Setting font type, size, style, and colors

Collaboration

• Co-editing spreadsheets in real time
• Commenting spreadsheets
• Communicating in real time
• Managing sheet view presets
• Version history

Editing cell properties

• Adding cell background and borders
• Aligning data in cells
• Changing number format
• Merging cells

Editing rows / columns

Helpful hints

• About Spreadsheet Editor
• Accessibility of ONLYOFFICE editors
• Keyboard shortcuts
• Supported formats of spreadsheets

Math equations

• Inserting equations

Operations on objects

Operations with sheets

• Inserting headers and footers
• Inserting page breaks
• Managing sheets

Protecting a spreadsheet

• Protecting a sheet
• Protecting a spreadsheet
• Protecting a workbook
• Protecting ranges
• Protecting spreadsheets with a password

Tools and settings

• Advanced settings of the Spreadsheet Editor
• AutoCorrect features
• Enabling dark theme
• Getting data from TXT/CSV file
• Saving/printing/downloading your spreadsheet
• Scaling a worksheet
• Search and Replace functions
• Spell checking
• View settings and navigation tools
• Viewing spreadsheet information

Work with functions