Locale and calculation settings in your spreadsheet
To customize the gridline color and font of your spreadsheet:
- Go to File > Spreadsheet Settings.
- In the Spreadsheet Settings tab under General, select the preferred Font Name, Font Size, Text Color, and Gridline Color.
- Click OK.
To customize the locale settings of your workbook:
- Go to File > Spreadsheet Settings.
- In the Spreadsheet Settings tab under Locale, select the Language, Display Direction, Date Format, Time Zone, Currency Symbol, Decimal Separator, Digit Grouping, and Grouping Separator using the respective drop-downs.
- Click OK.
Changing a spreadsheet's locale will also change the spreadsheet's date, number format, and default currency. Any changes to the locale settings the author makes, gets reflected to the entire spreadsheet. Collaborators associated with the spreadsheet will also see the changes made by the author.
To change the calculation settings:
- Go to Calculation > Iterative Preferences, then either choose to turn on or off the iterative calculation.
- If you choose to turn on the iterative calculation, then under Maximum Iterations, specify the number of times the calculation needs to be iterated.
- To set a threshold for the iterations, under Threshold, specify the threshold number.
Iterative Calculation: Repetitive calculations until a certain condition is met. Can be used to apply circular references in formulas. If iterative calculation is turned off, using circular references in formulas will return error.
Maximum Iterations: The number of times the calculation needs to be repeated.
Threshold: Threshold refers to a minimum value; when the difference between the successive iterations is less than the given threshold value, the calculation stops.
4. Under Calculation > Lookup preference, select either Regular Expressions or Wildcards based on how you prefer to search for the
characters in your spreadsheet.
Regular expressions - An advanced search pattern that helps you find any text/value using single or multiple characters.
Wildcards - Wildcards use a special set of characters that can act as a substitute for the character in the word you're looking to find out.
5. Once you're done, click OK.
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 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?
Zoho DataPrep Resources
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
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, ...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 ...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 ...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.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