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 spreadsheet:
1. Go to Format > Themes.
2. From the side pane, you can pick any desired theme from the list of options.
To customize the theme of your spreadsheet:
1. Go to Formats > Themes.
2. From the side pane, select any desired theme and click Customize.
3. To change the font, select any font from the Font drop-down.
4. To customize the theme colors, go to Colors, click the drop-down next to the preferred color name (Background2, Text2, Accent 1, etc.), and pick any color.
5. Click More Colors to customize any color of your choice and click OK.
Under Colors, Background2 lets you change the background color of a selected range (for which a theme color is already applied). Text2 represents the text color inside that selected cell range. Accent 1 to Accent 6 are categories of colors in different shades that are applied to tables, charts, etc. Hyperlink lets you apply any desired color to hyperlinks in your spreadsheet.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
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
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 Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
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 ...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 ...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, ...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.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 :
New to Zoho LandingPage?
Zoho LandingPage Resources