Close Help Center ONLYOFFICE Docs Spreadsheet 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 Add hyphenation 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 field codes Insert SmartArt objects Insert text from file 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 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 Use AI to write text Insert definitions Add pictures 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 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 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 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 Change color scheme Working with slides Manage slides Use Slide Master Set slide parameters Apply transitions Insert headers and footers, notes and handouts 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 Use AI to write text Add pictures 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 PDF Editor Program interface Introducing the PDF Editor user interface File tab Home tab Insert tab Comment tab View tab Plugins tab Basic operations Open an existing PDF or create a new document Filling out a form Edit PDF Collaboration Sharing files and folders Communicating in real time Commenting PDFs Draw freehand on a PDF Plugins Edit HTML Count words Find a synonym Translate text Read the text out loud Communicate while editing Tools and settings View PDF information Save/print/download your PDF Advanced settings of PDF Editor View settings and navigation tools Search function Helpful hints About PDF Editor 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 Align data in cells cell formatting Add borders Align data in cells Clear text, format in a cell Merge cells Select cell background color Add cell borders Apply cell style Align data in cells More articles How to split cells How to add cells How to calculate percentages How to insert time Wrap text in a cell Merge cells Change number format Apply table styles Select cell background color Add cell borders Apply cell style Align data in cells Selective cell clear Change text orientation Wrap text in a cell Merge cells Change number format Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Select cell background color Add cell borders Apply cell style Align data in cells Change text orientation Wrap text in a cell Merge cells Change number format Wrapping text align text Insert text objects Insert text objects Insert and format your text Align data in cells Align your text in a line or paragraph Align your text in a paragraph Change paragraph indents Align data in cells More articles Wrap text in a cell Align your text in a text box Change text indents Align your text in a paragraph Change paragraph indents Align data in cells Wrap text in a cell Align your text in a text box Change text indents Align your text in a paragraph Change paragraph indents Align data in cells Wrap text in a cell Align your text in a text box Change text indents Align your text in a paragraph Change paragraph indents Align data in cells Wrap text in a cell Align your text in a text box Change text indents In the Spreadsheet Editor, you can align data horizontally and vertically or even rotate data within a cell. To do that, select a cell or a cell range with the mouse or the whole worksheet by pressing the Ctrl+A key combination. You can also select multiple non-adjacent cells or cell ranges holding down the Ctrl key while selecting cells/ranges with the mouse. Then perform one of the following operations using the icons situated on the Home tab of the top toolbar. Apply one of the horizontal alignment styles to the data within a cell, click the Align left icon to align the data to the left side of the cell (the right side remains unaligned); click the Align center icon to align the data in the center of the cell (the right and the left sides remains unaligned); click the Align right icon to align the data to the right side of the cell (the left side remains unaligned); click the Justified icon to align the data both to the left and the right sides of the cell (additional spacing is added where necessary to keep the alignment). Change the vertical alignment of the data within a cell, click the Align top icon to align your data to the top of the cell; click the Align middle icon to align your data to the middle of the cell; click the Align bottom icon to align your data to the bottom of the cell. Change the angle of the data within a cell by clicking the Orientation icon and choosing one of the following options: use the Horizontal Text option to place the text horizontally (default option), use the Angle Counterclockwise option to place the text from the bottom left corner to the top right corner of a cell, use the Angle Clockwise option to place the text from the top left corner to the bottom right corner of a cell, use the Vertical text option to place the text vertically, use the Rotate Text Up option to place the text from bottom to top of a cell, use the Rotate Text Down option to place the text from top to bottom of a cell. Indent text within a cell using the Indent section on the Cell Settings right sidebar. Specify the value (i.e. the number of characters) by which the contents will be moved to the right. If you change the orientation of the text, indents will be reset. If you change indents for the rotated text, the orientation of the text will be reset. Indents can only be set if the horizontal or vertical text orientation is selected. Rotate the text by an exactly specified angle, click the Cell settings icon on the right sidebar and use the Orientation. Enter the necessary value measured in degrees into the Angle field or adjust it using the arrows on the right. Fit your data to the column width by clicking the Wrap text icon on the Home tab of the top toolbar or by checking the Wrap text checkbox on the right sidebar. If you change the column width, data wrapping adjusts automatically. Fit your data to the cell width by checking the Shrink to fit checkbox on the right sidebar. The contents of the cell will be reduced in size to such an extent that it can fit in it. Return to previous page Try now for free Try and make your decision No need to install anythingto see all the features in action