Close Help Center ONLYOFFICE Documents Spreadsheet Editor Document Editor complete documentation ONLYOFFICE Documents for iOS Overview 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 Page formatting Set page parameters Insert page breaks Insert section breaks Insert page numbers 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 Tools and settings View document information Change application settings Use the Find and Replace function Save/export/print your document 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 Save/export/print your spreadsheet Presentation Editor Basic operations Mobile presentation viewer ONLYOFFICE Documents for Android Overview Common operations Glossary FAQ General Technology Pricing Enterprise Edition Integration Edition Developer Edition Community Server 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 Wrap text in a cell Merge cells Change number format Apply table styles align text Align data in cells Align your text in a line or paragraph Insert text objects Insert text objects Insert and format your text Align your text in a paragraph Apply formatting presets Change paragraph indents More articles Align data in cells Wrap text in a cell 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. Power up your iOS Create, edit and view documents, spreadsheets and presentations of all popular formats You Might Also Like This: Close