Close Help Center User guides ONLYOFFICE Workspace General questions ONLYOFFICE Groups ONLYOFFICE Docs ONLYOFFICE Mail ONLYOFFICE Talk ONLYOFFICE Groups Documents Module People Module Commmunity Module CRM Module Projects Module Mail Module Calendar Module ONLYOFFICE Docs Document Editor Spreadsheet Editor Presenetation editor User Guides about Editors ONLYOFFICE Mobile Apps ONLYOFFICE Documents for iOS ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Web Editors Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors User Guides ONLYOFFICE Spreadsheet Editor Show documentation contents Hide documentation contents ONLYOFFICE Spreadsheet Editor is an online application that lets you edit your spreadsheets directly on the portal. Using ONLYOFFICE Spreadsheet Editor, you can perform various editing operations like in any desktop editor, print the edited spreadsheets keeping all the formatting details or download them onto your computer hard disk drive as XLSX, PDF, ODS, CSV, XLTX, PDF/A, OTS file. Spreadsheet Editor Program interface Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Layout tab Formula tab Data tab Pivot Table tab Collaboration tab Plugins tab Basic operations Create a new spreadsheet or open an existing one Cut/copy/paste data Undo/redo your actions Operations with sheets Manage sheets Insert headers and footers Cell text formatting Set font type, size, style, and colors Add hyperlinks Clear text, format in a cell Editing cell properties Add borders Align data in cells Merge cells Change number format Editing rows/columns Insert or delete cells, rows, and columns Sort and filter data Use formatted tables Create slicers for formatted tables Create and edit pivot tables Group data Remove duplicates Conditional Formatting Work with functions Insert function Use named ranges Operations on objects Insert images Insert chart Insert and format autoshapes Insert text objects Insert symbols and characters Manipulate objects Math equations Insert equations Use Math AutoCorrect Spreadsheet co-editing Collaborative spreadsheet editing Tools and settings View file information Save/print/download your spreadsheet Scale a worksheet Advanced settings of Spreadsheet Editor View settings and navigation tools Search and replace functions Spell-checking Helpful hints About Spreadsheet Editor Supported formats of spreadsheets Keyboard shortcuts How to use plugins