Format data in your spreadsheet
Clear data and formats
To clear data or formats in a cell: Select the cell or range of cells in which you wish to clear data/formats. Tap under the Home menu. Select from one of the various clear options. Alternatively, you can tap on the desired cell(s), and select Clear ...
Customize the cell size
To customize the cell size: Select the desired range of cells. Tap under the Home menu. From the drop-down, select the desired option, and further input the values for height and width. Alternatively, you can also drag the row/column headers to ...
Merge cells
To merge cells in your spreadsheet: Select the desired range of cells you wish to merge. Go to the Home menu and tap Select any desired merging option from the available options.
Apply conditional formats
Conditional formatting is all about highlighting data that are based on certain conditions. Zoho Sheet supports three types of conditional formatting, namely, Classic, Color Scale and Icon Set. To apply classic: Select the range of cells you wish to ...
Wrap text
The Wrap Text option allows you to select the way your data/values need to be wrapped around. By default, the text you enter, if exceeds the cell's limit, will overflow to the adjacent cell. The 3 types of text wraps include: Wrap- The text will be ...
Rotate text/data
To rotate text or data in a cell: Select the Text Rotation option under the Home menu. Choose the desired rotation option from the available options. You can also tap on the Custom option to customize the tilt angle.
Fill colors
To highlight your cells with different colors: Select a cell you wish to apply colors to. Tap from the Home menu. Choose any color from the available options or customize the color of your choice.
Apply borders
To apply border to a cell: Select a cell you wish to apply borders to. Tap under the Home menu. From Borders dialog, you can select the border type, line type and line color.
Align your data
To align your data: Choose the desired cells. Under the Home menu, tap for horizontal alignment and for vertical alignment options. Tap the desired alignment from the available options.
Add RichText
To add RichText to any value inside a cell: Tap any desired cell. Select the values inside the cell you wish to apply rich-text to. Tap the Home menu to select and apply Font family, Font color, Font size, Bold, Italics, Underline, Strikethrough, ...
Format cells
To format data in a cell: Select the cell or the range of cells you wish to format. Tap the Home menu and select any type of formatting options like Bold, Italics, Underline, Strikethrough, Font family, Font size, Color, etc.