Personalize your spreadsheet experience with My Preferences
My Preferences, a settings feature, lets you customize your spreadsheet experience across all spreadsheets you create. It brings together personalization settings like style, locale, appearance, accessibility controls and more in one place.
Most settings in My Preferences are also available separately across the product. My Preferences brings them together in a single place for easier access and customization. Refer to the respective help guides to learn more about individual features.
How to access My Preferences
- Click on the profile icon at the top-right corner.
- Select My Preferences from the side pane that appears.
- Alternatively, you can click on Tools > My Preferences.
How to configure general settings
- Style: Configure your preferred settings like themes, font family, size, color, and more.
- Locale: Configure your preferred regional formats like language, time zone, country, currency, and more.
- Calculation: Configure your preferred formula behavior and workbook calculation settings.
Changes made to the general settings will apply by default to all new spreadsheets you create. They will also appear in each spreadsheet's settings. If you want these changes reflected in your current spreadsheet, click Apply.
How to configure display settings
- Appearance: Select your preferred appearance between dark, light and default mode.
- Editor: Personalize spreadsheet interface elements like headers, formula bars, sheet tabs, and other editor settings.
- Cell: Customize paste options and other cell-level preferences.
How to configure accessibility controls
Accessibility controls are designed to improve readability and visibility while working with spreadsheets, in line with the Web Content Accessibility Guidelines (WCAG).
- Increased Contrast: Adjust contrast levels to make text and interface elements easier to see.
- Reading Mask: Focus on specific areas of spreadsheet content and reduce visual distractions while reading.
- Spreadsheet Zoom: Set your preferred spreadsheet zoom level for a comfortable viewing experience.
- Text Spacing: Adjust text spacing settings to improve readability and visual comfort while working with spreadsheet content.
- Toast Notification: Control how notification messages appear and how long they remain visible on the screen.
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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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
Share spreadsheet for collaboration
To share a spreadsheet with others: Go to ••• > Add People in the listing page or spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access permission, and tap Share. If you are using Zoho ...Locate your spreadsheet's Resource ID
A Resource ID, or an RID of the spreadsheet is an alphanumeric string that forms part of the spreadsheet's URL. The RID always follows the 'open/' part of the URL. For instance, in this URL, ...Create a new blank spreadsheet
To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.Export or download a spreadsheet
To download or export a spreadsheet: Go to ... > Download As in the editor. Choose the file format in which you want to export the spreadsheet. Select the location to save or send the spreadsheet. Note: To download from the file listing screen, use ...Open a spreadsheet from Dropbox/Box
To open a spreadsheet from Dropbox, or Box: Go to Places using the option in the bottom bar of the file listing page. Choose the desired place from which you wish to open the file. For Dropbox and Box, you will need to authenticate your account. Pick ...
New to Zoho LandingPage?
Zoho LandingPage Resources