Close Help Center ONLYOFFICE Documents for iOS Spreadsheet Editor Document Editor complete documentation 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 Spreadsheet Editor Presenetation editor ONLYOFFICE Mobile Apps ONLYOFFICE Documents app for iOS Overview Changelog Manage files Open or create new files and folders Share files and folders Document Editor Basic operations Navigate through your document Select, cut, copy, paste text Undo/redo your actions Handwriting recognition Page formatting Set page parameters Insert page breaks Insert section breaks Insert footnotes and endnotes Insert page numbers Add hyphenation Paragraph formatting Align your text in a paragraph Apply formatting presets Select background color for a paragraph Change paragraph indents Set paragraph line spacing Insert line breaks Create lists Text formatting Set font type, size, and color Apply font decoration styles Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Adjust chart settings Change text wrapping Manipulate objects Fillable forms Filling out a form Tools and settings View document information Change application settings Use the Find and Replace function Save/export/print your document Protect documents with a password Spreadsheet Editor Basic operations Navigate through your spreadsheet Select, cut, copy, paste data Undo/redo your actions Operations with sheets Create or delete sheets Manage existing sheets Cell text formatting Set font type, size, and color Add hyperlinks Editing cell properties Select cell background color Add cell borders Apply cell style Align data in cells Wrap text in a cell Merge cells Change number format Apply table styles Editing rows/columns Manage data in rows/columns Add or remove rows/columns Hide or show rows/columns Resize rows/columns Sort and filter data Operations on objects Insert charts Insert images Insert formulas Insert autoshapes Manipulate objects Tools and settings View spreadsheet information Change application settings Use the Find and Replace function Set language and region Save/export/print your spreadsheet Protect spreadsheets with a password Presentation Editor Basic operations Mobile presentation viewer Navigate through your presentation Select, cut, copy, paste text and objects Undo/redo your actions Working with slides Manage slides Change presentation theme Change slide layout Apply transitions Change slide background Preview your presentation Text formatting Insert text Set font type, size, and color Apply font decoration styles Align your text in a text box Change text indents Set paragraph line spacing Create lists Add hyperlinks Operations on objects Insert tables Insert autoshapes Insert images Create charts Manipulate objects Tools and settings View presentation information Use the Find function Save and export your presentation Change application settings Print your presentation Protect presentations with a password ONLYOFFICE Documents for Android ONLYOFFICE Projects for iOS ONLYOFFICE Projects for Android 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 You can align your data within a cell horizontally and vertically. To do that: Select a cell, a range of cells or the whole worksheet. Open the Cell settings panel by tapping the icon at the top toolbar, or tapping the Cell option in the pop-up menu. Tap the icon to the right of the Text Format section. Select one of the horizontal or vertical alignment types: Tap the necessary horizontal alignment type to apply it: tap the Align Left menu item to line up the text by the left side of the cell (the right side remains unaligned). tap the Align Center menu item to line up the text by the center of the cell (the right and the left sides remains unaligned). tap the Align Right menu item to line up the text by the right side of the cell (the left side remains unaligned). tap the Justify menu item to line up the text by both the left and the right sides of the cell (additional spacing is added where necessary to keep the alignment). Tap the necessary vertical alignment type to apply it: tap the Align Top menu item to align your data to the top of the cell. tap the Align Middle menu item to align your data to the middle of the cell. tap the Align Bottom menu item to align your data to the bottom of the cell. Tap the Text Orientation menu item and tap the required option to adjust the angle of data within a cell: Horizontal Text to place the text horizontally (default option). Angle Counterclockwise to place the text from the bottom left corner to the top right corner of a cell. Angle Clockwise to place the text from the top left corner to the bottom right corner of a cell. Vertical Text to place the text vertically. Rotate Text Up to place the text from bottom to top of a cell. Rotate Text Down to place the text from top to bottom of a cell. Power up your iOS Create, edit and view documents, spreadsheets and presentations of all popular formats You Might Also Like This: Close