Close Help Center ONLYOFFICE Docs Document Editor 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 All Editors Document Editor Program interface Introducing the Document Editor user interface File tab Home tab Insert tab Draw tab Layout tab References tab Forms tab Collaboration tab Protection tab View 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 line numbers Insert footnotes Insert endnotes Convert endnotes and 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 Create hanging indents Text formatting Apply formatting presets Set font type, size, and color Apply font decoration styles Copy/clear text formatting Add hyperlinks Insert cross-references Insert a drop cap Operations on objects Insert tables Use formulas in tables Insert images Insert autoshapes Insert charts Insert text objects Insert SmartArt objects Draw freehand on a document Add caption Insert symbols Align and arrange objects on a page Change text wrapping Insert content controls Create a table of contents Add and format a table of figures Insert videos Fillable forms Create fillable forms Filling out a form Mail Merge Use Mail Merge Math equations Insert equations Collaboration Sharing files and folders Co-editing documents in real time Communicating in real time Commenting documents Tracking changes Comparing and combining documents Version history Plugins Plugin manager Edit an image Create and insert diagrams Edit HTML Correct typography Count words Include a video Insert highlighted code Insert references Translate text Extract text from an image Read the text out loud Type via voice Replace a word by a synonym Upload a document to Wordpress Communicate while editing Make Audio and Video Calls Host and schedule Zoom meetings Use AI to write text Tools and settings View document information Save, download, print your document Advanced settings of Document Editor View settings and navigation tools ONLYOFFICE Document Viewer Search and replace function Spell-checking AutoCorrect features Protecting documents with a password Helpful hints About Document Editor Supported formats of electronic documents Keyboard shortcuts Spreadsheet Editor 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 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 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 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 Presentation Editor Program interface Introducing the Presentation Editor user interface File tab Home tab Insert tab Draw tab Transitions tab Animation tab Collaboration tab View 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 SmartArt objects Draw freehand on a slide Adding animations Creating a motion path animation 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 Collaboration Sharing files and folders Co-editing presentations in real time Communicating in real time Commenting presentations Version history 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 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 AutoCorrect features Protecting presentations with a password Enable support for video playback in ONLYOFFICE Desktop Editors Helpful hints About Presentation Editor Supported formats of electronic presentations Keyboard shortcuts 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 Trial period Advanced Settings of the Document Editor online editor settings Advanced settings of Document Editor Advanced settings of Presentation Editor Advanced Settings of Spreadsheet Editor Change application settings Change application settings Change application settings Protect documents with a password Protect spreadsheets with a password More articles Protect presentations with a password Change application settings Change spreadsheet settings Change application settings Change application settings Change presentation settings Change application settings Macros settings Change spreadsheet settings Change application settings Macros settings Change presentation settings Change application settings Macros settings Change application settings Macros settings Change spreadsheet settings Change application settings Macros settings Change presentation settings Change application settings Macros settings collaborative editing Advanced settings of Document Editor Advanced settings of Presentation Editor Advanced Settings of Spreadsheet Editor Collaborative document editing Communicating in real time Collaborative spreadsheet editing Co-editing documents online Sending for electronic signature More articles Open or create new files and folders Open or create new files and folders Collaborative document editing Collaborative spreadsheet editing Communicating in real time Open or create new files and folders Collaborative document editing Collaborative spreadsheet editing Communicating in real time Open or create new files and folders Collaborative document editing Collaborative spreadsheet editing Communicating in real time Sharing files and folders Integrating ONLYOFFICE with Nextcloud Integrating ONLYOFFICE with ownCloud Integrating ONLYOFFICE with Confluence Integrating ONLYOFFICE with Humhub Integrating ONLYOFFICE with Alfresco Integrating ONLYOFFICE with Liferay Integrating ONLYOFFICE with Mattermost Integrating ONLYOFFICE with SharePoint Integrating ONLYOFFICE with Plone Integrating ONLYOFFICE with Chamilo Integrating ONLYOFFICE with Jira Integrating ONLYOFFICE with Nuxeo Integrating ONLYOFFICE with Redmine How to integrate ONLYOFFICE with Nextcloud using the app from the official store How to integrate ONLYOFFICE with Nextcloud How to integrate ONLYOFFICE Docs with ownCloud How to integrate ONLYOFFICE with Nuxeo How to integrate ONLYOFFICE with Nuxeo with the official plugin How to integrate ONLYOFFICE Docs with SharePoint How to deploy ONLYOFFICE on DigitalOcean using One-Click App How to integrate ONLYOFFICE with Alfresco Share How to integrate ONLYOFFICE with Chamilo Configuring ONLYOFFICE connector for Nextcloud Configuring ONLYOFFICE connector for ownCloud How to integrate ONLYOFFICE with Redmine How to integrate ONLYOFFICE with Jira ONLYOFFICE 7.0: fillable forms, password protection and version history in spreadsheets Sharing documents add comments to documents Advanced settings of Document Editor Advanced Settings of Spreadsheet Editor Collaborative document editing Communicating in real time Collaborative spreadsheet editing The Document Editor allows you to change its advanced settings. To access them, open the File tab on the top toolbar and select the Advanced Settings option. The advanced settings are grouped as follows: Editing and saving Autosave is used in the online version to turn on/off automatic saving of changes you make while editing. Autorecover is used in the desktop version to turn on/off the option that allows automatically recovering documents in case the program closes unexpectedly. Show the Paste Options button when the content is pasted. The corresponding icon will appear when you paste content in the document. Make the files compatible with older MS Word versions when saved as DOCX. The files saved in DOCX format will become compatible with older Microsoft Word versions. Collaboration The Co-editing mode subsection allows you to set the preferable mode for seeing changes made to the document when working in collaboration. Fast (by default). The users who take part in the document co-editing will see the changes in real time once they are made by other users. Strict. All the changes made by co-editors will be shown only after you click the Save icon that will notify you about new changes. The Show track changes subsection allows you to choose how new changes will be displayed. Show by click in balloons. The change is shown in a balloon when you click the tracked change. Show by hover in tooltips. A tooltip appears when you hover the mouse pointer over the tracked change. The Real-time Collaboration Changes subsection allows you to choose how new changes and comments will be displayed in real time. View None. All the changes made during the current session will not be highlighted. View All. All the changes made during the current session will be highlighted. View Last. Only the changes made since you last time clicked the Save icon will be highlighted. This option is only available when the Strict co-editing mode is selected. Show changes from other users. This feature allows to see changes made by other users in the document opened for viewing only in the Live Viewer mode. Show comments in text. If you disable this feature, the commented passages will be highlighted only if you click the Comments icon on the left sidebar. Show resolved comments. This feature is disabled by default so that the resolved comments are hidden in the document text. You can view such comments only if you click the Comments icon on the left sidebar. Enable this option if you want to display resolved comments in the document text. Proofing The Spell Checking option is used to turn on/off the spell checking. Ignore words in UPPERCASE. Words typed in capital letters are ignored during the spell checking. Ignore words with numbers. Words with numbers in them are ignored during the spell checking. The AutoCorrect options... menu allows you to access the autocorrect settings such as replacing text as you type, recognizing functions, automatic formatting etc. Workspace The Alignment Guides option is used to turn on/off alignment guides that appear when you move objects. It allows for a more precise object positioning on the page. The Hieroglyphs option is used to turn on/off the display of hieroglyphs. The Use Alt key to navigate the user interface using the keyboard option is used to enable using the Alt / Option key in keyboard shortcuts. The Interface theme option is used to change the color scheme of the editor’s interface. The Same as system option makes the editor follow the interface theme of your system. The Light color scheme incorporates standard blue, white, and light gray colors with less contrast in UI elements suitable for working during daytime. The Classic Light color scheme incorporates standard blue, white, and light gray colors. The Dark color scheme incorporates black, dark gray, and light gray colors suitable for working during nighttime. The Contrast Dark color scheme incorporates black, dark gray, and white colors with more contrast in UI elements highlighting the working area of the file. The Turn on document dark mode option is used to make the working area darker when the editor is set to Dark or Contrast Dark interface theme. Check the Turn on document dark mode box to enable it. Note: Apart from the available Light, Classic Light, Dark, and Contrast Dark interface themes, ONLYOFFICE editors can now be customized with your own color theme. Please follow these instructions to learn how you can do that. The Unit of Measurement option is used to specify what units are used on the rulers and in properties of objects when setting such parameters as width, height, spacing, margins etc. The available units are Centimeter, Point, and Inch. The Default Zoom Value option is used to set the default zoom value, selecting it in the list of available options from 50% to 500%. You can also choose the Fit to Page or Fit to Width option. The Font Hinting option is used to select how fonts are displayed in the Document Editor. Choose As Windows if you like the way fonts are usually displayed on Windows, i.e. using Windows font hinting. Choose As OS X if you like the way fonts are usually displayed on a Mac, i.e. without any font hinting at all. Choose Native if you want your text to be displayed with the hinting embedded into font files. Default cache mode - used to select the cache mode for the font characters. It’s not recommended to switch it without any reason. It can be helpful in some cases only, for example, when an issue in the Google Chrome browser with the enabled hardware acceleration occurs. The Document Editor has two cache modes: In the first cache mode, each letter is cached as a separate picture. In the second cache mode, a picture of a certain size is selected where letters are placed dynamically and a mechanism of allocating/removing memory in this picture is also implemented. If there is not enough memory, a second picture is created, etc. The Default cache mode setting applies two above mentioned cache modes separately for different browsers: When the Default cache mode setting is enabled, Internet Explorer (v. 9, 10, 11) uses the second cache mode, other browsers use the first cache mode. When the Default cache mode setting is disabled, Internet Explorer (v. 9, 10, 11) uses the first cache mode, other browsers use the second cache mode. The Macros Settings option is used to set macros display with a notification. Choose Disable All to disable all macros within the document. Choose Show Notification to receive notifications about macros within the document. Choose Enable All to automatically run all macros within the document. To save the changes you made, click the Apply button. Return to previous page Try now for free Try and make your decision No need to install anythingto see all the features in action