Close Help Center User guides ONLYOFFICE Workspace General questions ONLYOFFICE Groups ONLYOFFICE Docs ONLYOFFICE Mail ONLYOFFICE Talk ONLYOFFICE Personal ONLYOFFICE Groups Documents Module People Module Community Module CRM Module Projects Module Mail Module Calendar Module Feed Tool ONLYOFFICE Docs All Editors Document Editor Spreadsheet Editor Presentation Editor PDF Editor ONLYOFFICE Mobile Apps ONLYOFFICE Documents for iOS ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Projects for Android ONLYOFFICE Web Editors ONLYOFFICE DocSpace Glossary Video FAQ General Technology Pricing Workspace Enterprise Edition Docs Enterprise Edition Docs Developer Edition ONLYOFFICE Groups Connectors Trial period User Guides Watch video The Telegram messenger for conversations in ONLYOFFICE Docs Grammalecte in ONLYOFFICE Docs: spellchecker for French texts Translate texts in ONLYOFFICE Docs with Google, DeepL, and Apertium HTML plugin for ONLYOFFICE Docs Correct grammar with LanguageTool in ONLYOFFICE Docs ONLYOFFICE Spreadsheet Editor 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, XLTM, PDF/A, OTS, PNG, JPG/JPEG file. Program interface Introducing the Spreadsheet Editor user interface File tab Home tab Insert tab Draw tab Layout tab Formula tab Data tab Pivot Table tab Collaboration tab Protection tab View tab Plugins tab Basic operations Create a new spreadsheet or open an existing one Cut/copy/paste data Undo/redo your actions Add external links to cells Operations with sheets Manage sheets Insert headers and footers Insert breaks 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 Add cells Insert or delete cells, rows, and columns Freeze rows and columns Split cells Sort and filter data Use formatted tables Create and edit pivot tables Create slicers for tables Group data Remove duplicates Conditional formatting Data validation Work with functions Insert functions Insert array formulas Use named ranges Watch window Goal Seek Calculate percentages Insert time Switch between languages in a table Operations on objects Insert images Insert charts Insert sparklines Insert and format autoshapes Insert text objects Wrap text Insert SmartArt objects Draw freehand on a spreadsheet Insert symbols and characters Manipulate objects Math equations Insert equations Collaboration Sharing files and folders Co-editing spreadsheets in real time Managing sheet view presets Communicating in real time Commenting spreadsheets Version history Protecting a spreadsheet Protecting a spreadsheet Protecting ranges Protecting your spreadsheets with a password Protecting a sheet Protecting a workbook Plugins Plugin manager Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Communicate while editing Host and schedule Zoom meetings Use AI to write text Add pictures 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 AutoCorrect features Get data from TXT/CSV file Helpful hints About Spreadsheet Editor Supported formats of spreadsheets Keyboard shortcuts