Close Help Center ONLYOFFICE Docs Spreadsheet Editor Calendar Creating a recurring event Portal notifications: manageable notifications Assigning a color to your calendar Get a panoramic picture of multitask activities User guides ONLYOFFICE Workspace ONLYOFFICE Groups ONLYOFFICE Docs Mail Server Talk Module ONLYOFFICE Groups Documents Module People Module Commmunity Module CRM Module Projects Module Mail Module Calendar Module ONLYOFFICE Docs Document Editor Program interface Introducing the Document Editor user interface File tab Home tab Insert tab Layout tab References tab Collaboration tab Plugins tab Basic operations Create a new document or open an existing one Copy/paste text passages, undo/redo your actions Change color scheme Page formatting Set page parameters Show/hide nonprinting characters Insert section breaks Insert headers and footers Insert date and time Insert page numbers Insert footnotes Add bookmarks Add watermark Paragraph formatting Align your text in a paragraph Set up paragraph outline level Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert page breaks Add borders Set tab stops Create lists Text formatting Apply formatting presets Set font type, size, and color Apply font decoration styles Copy/clear text formatting Add hyperlinks Insert a drop cap Operations on objects Insert tables Use formulas in tables Insert images Insert autoshapes Insert charts Insert text objects Add caption Insert symbols Align and arrange objects on a page Change text wrapping Insert content controls Create a Table of Contents Mail Merge Use Mail Merge Math equations Insert equations Use Math AutoCorrect Document co-editing Collaborative document editing Document Review Compare documents Plugins Edit an image Include a video Insert highlighted code Insert references Translate text Extract text from an image Read the text out loud Replace a word by a synonym Upload a document to Wordpress Tools and settings View document information Save/download/print your document Advanced settings of Document Editor View settings and navigation tools Search and replace function Spell-checking Helpful hints About Document Editor Supported formats of electronic documents Keyboard shortcuts How to use plugins 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 Plugins Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym 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 Presentation Editor Program interface Introducing the Presentation Editor user interface File Tab Home Tab Insert Tab Collaboration Tab Plugins Tab Basic operations Create a new presentation or open an existing one Copy/paste data, undo/redo your actions Working with slides Manage slides Set slide parameters Apply transitions Insert footers Preview your presentation Text formatting Insert and format your text Add hyperlinks Create lists Copy/clear formatting Operations on objects Insert and format autoshapes Insert and adjust images Insert and edit charts Insert and format tables Insert symbols and characters Fill objects and select colors Manipulate objects on a slide Align and arrange objects on a slide Math equations Insert equations Use Math AutoCorrect Presentation co-editing Collaborative presentation editing Plugins Edit an image Include a video Insert highlighted code Translate text Replace a word by a synonym Tools and settings View presentation information Save/print/download your presentation Advanced settings of Presentation Editor View settings and navigation tools Search and Replace Function Spell-checking Helpful hints About Presentation Editor Supported formats of electronic presentations Keyboard shortcuts How to use plugins Editors User Guides 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 Create a new spreadsheet or open an existing one operations with files Create a new document or open an existing one Create a new presentation or open an existing one Create a new spreadsheet or open an existing one Save/download/print your document Save/print/download your presentation Save/print/download your spreadsheet View document information View file information More articles View presentation information Manage files Open or create new files and folders Share files and folders View document information Change application settings Use the Find and Replace function Save/export/print your document View spreadsheet information Change application settings Use the Find and Replace function Save/export/print your spreadsheet View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Manage files Open or create new files and folders Share files and folders View document information Use the Find and Replace function Download and print your document Macros settings View spreadsheet information Use the Find and Replace function Download and print spreadsheet Macros settings View presentation information Use the Find and Replace function Download your presentation Print presentation Macros settings Manage files Open or create new files and folders Share files and folders Use the Find and Replace function Change application settings Download and print your document View document information Macros settings Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Macros settings Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Macros settings Manage files Open or create new files and folders Share files and folders Use the Find and Replace function Change application settings Download and print your document View document information Macros settings Use the Find and Replace function Change spreadsheet settings Change application settings Download and print your spreadsheet View spreadsheet information Macros settings Use the Find and Replace function Change presentation settings Change application settings Download your presentation Print your presentation View presentation information Macros settings create documents Coordinate all aspects of your activities using the online office Create a new document or open an existing one Create a new presentation or open an existing one Create a new spreadsheet or open an existing one Document collaboration made easy in the online office Documents Documents module troubleshooting Co-editing documents online More articles Embedding a document into a blog Manage your documents with the online office ONLYOFFICE Demonstration Project documents Getting started with ONLYOFFICE Desktop Editors To create a new spreadsheet In the online editor click the File tab on the top toolbar, select the Create New option. In the desktop editor in the main program window, select the Spreadsheet menu item from the Create new section of the left sidebar - a new file will open in a new tab, when all the necessary changes are made, click the Save icon in the upper left corner or switch to the File tab and choose the Save as menu item. in the file manager window, select the location of the file, specify its name, choose the required format (XLSX, Spreadsheet template (XLTX), ODS, OTS, CSV, PDF or PDFA) and click the Save button. To open an existing document In the desktop editor in the main program window, select the Open local file menu item on the left sidebar, choose the necessary spreadsheet from the file manager window and click the Open button. You can also right-click the necessary spreadsheet in the file manager window, select the Open with option and choose the required application from the menu. If documents are associated with the required application, you can also open spreadsheets by double-clicking the file name in the file explorer window. All the directories that you have accessed using the desktop editor will be displayed in the Recent folders list so that you can quickly access them afterwards. Click the necessary folder to select one of the files stored in it. To open a recently edited spreadsheet In the online editor click the File tab on the top toolbar, select the Open Recent... option, choose the required spreadsheet from the list of recently edited documents. In the desktop editor in the main program window, select the Recent files menu item on the left sidebar, choose the required spreadsheet from the list of recently edited documents. To open the folder, where the file is stored , in a new browser tab in the online version or in the file explorer window in the desktop version, click the Open file location icon on the right side of the editor header. Alternatively, you can switch to the File tab on the top toolbar and select the Open file location option. Return to previous page Try now for free Try and make your decision No need to install anything to see all the features in action