Formatting your spreadsheet
How to highlight the entire row with conditional formatting
Conditional formatting in Zoho Sheet allows you to highlight the entire row either using formulas or without formulas. To highlight the entire row with a formula: Navigate to Format > Conditional Formatting > Classic > Formula. Enter the desired ...How to create & use a structured reference to refer to a table
A structured reference is used to refer to an existing table that can be used in formulas to refer to that particular array. Syntax: =TableName[[ItemSpecifier];[ColumnSpecifier]] where, TableName: Denotes the name of the table. ItemSpecifier: Lets ...Apply and customize Themes
Themes are one of the formatting options that allows you to change the color, font, and effect of your spreadsheet. Themes are applicable for charts, tables, sparklines, hyperlinks, text, etc in your spreadsheet. To apply any theme to your ...Delete a table
To delete a table: 1. Select the table you wish to delete from your sheet. 2. Go to the side pane and click 3. Click Remove Table. 4. Select either Remove Table and Keep Formats or Remove Table and Formats. Choosing Remove Table and Keep Formats will ...Change the table style
To change the table style: 1. Select the table for which you wish to change the style. 2. Go to the side pane and click 3. In the side pane, you can pick any table style and color from the available options. You can even customize the color of your ...Edit the source range of a table
To edit the source range: 1. Select the table for which you wish to edit the cell range. 2. Go to the side pane and click 3. In the side pane, click Edit besides Source. The header of the new table must remain in the same row of the existing table ...Change the name of a table
To change the name of a table: 1. Select the table for which you wish to change the name. 2. Go to the side pane and click , from where you can make the necessary edits. 3. Click the Name field in the table side pane and update the new name. Press ...Create a table
What is a Table? Table is one of the best spreadsheet tools to group and analyze data swiftly. Format your data into tables for better visualization! To create a table: Go to Format > Table. Select a table style from the list of options. Mention the ...Changing the font family
The default font style in a spreadsheet is Roboto. To change the font style of text in a cell: Select the cell/cell range you want to change the font style for. Click on the font style drop-down menu in the Toolbar. Select your desired font style ...Formatting different parts of the content or text in a cell
Zoho Sheet now lets you format different parts of the contents in a cell separately. To do this, Double click on a cell and enter edit mode. Select the part of the content you want to format. From the contextual short cut menu that appears above the ...Group and ungroup columns or rows
Grouping rows or columns together and choosing to expand or collapse them can make spreadsheets organized and concise. Here's how you can group and ungroup columns or rows. How to group rows or columns? 1. Select the rows/columns you'd like to group ...What are all the cell formats available in Zoho Sheet?
Zoho Sheet supports the following cell formats: General Number Accounting Currency Date Time Percentage Fraction Scientific Text Regional And custom made formats.Rotate the text in a cell
To rotate text, Select the cell/cell range you want to rotate the text in. Click on the cell rotation icon on the tool bar. Choose how much you want to rotate the text.Increase/decrease the indent of the values in a cell
To increase/decrease the indentation, select the cell or cell range you want to make the changes to, and click on the Indent icon on the tool bar.Apply conditional formatting to your cells
What is conditional formatting? With conditional formatting, you can predefine the format that you want your cells to have, based on a few criteria. Zoho Sheet lets you format your cells with four different types of conditional formatting. They are, ...Wrap text
Select the cells in which you want the content to be wrapped. Click on the Wrap Text icon on the quick access tool-bar. Alternatively, click on the Format menu and select Wrap Text.Adjust Grid Spacing
Click on the Grid Spacing icon on the bottom toolbar. Toggle between the Classic view, Cozy View and Comfort view.Customize borders
To apply borders with customized colors and line styles: Click on the border icon on the tool bar. In the drop down displayed, select the desired color, line style and the required border option to be applied. The customization can also be performed ...Change/edit the conditional formats already present in a sheet
To manage conditional formatting: On the menu bar, click Format > Conditional Formatting > Manage Rules. View a rule that has been created in an expanded or a collapsed mode. Choose to edit, copy or clear the rules that have been set and listed under ...Remove or clear the formatting from cells
To clear the formatting of a cell: Select the cell you want to clear the formatting of. Click on the Clear icon in the tool bar. You can then choose to clear only the formats from the cell. Alternatively, right click on the cell you want to clear the ...Copy the formats from one cell to another
Format Painter can be used to copy the formatting present in a particular cell to other cells in the sheet. To use Format Painter Select the cell you want to copy the format from. Click on the Format Painter icon from the toolbar. The format of the ...Change the format of cells
To apply formatting that suits you: Choose Format > Format Cells. The Format Cells dialog box appears. Select the format in which you want the cells to be in. You can also create customized cell formats. Click OK to apply the format. Alternatively, ...Apply borders to cells
To apply borders for cells: Select the cell(s) you want to apply borders for. Click the Borders icon from the toolbar. Choose from a range of border types that are available. These are the types that you can choose from :Change the alignment of data in cells
You can change both the horizontal and the vertical alignment of data entered into the cell. To change the alignment of data inside the cells: Select the cells to be aligned. On the default toll bar, click on Alignment icon. Choose to align left, ...Change a cell's background color
To change the cell color Select the desired cell(s). Choose Fill Color icon from the default tool bar. Click on the required color. The color is applied to the chosen cell.Change the text color
To change text color Select the cells for which you want to color the font. On the tool bar, click the Text Color icon . Choose the required color. The selected font color is applied to the selected text. To get a preview of the colors, hover over ...
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?