Search
Clear search
Close search
Google apps
Main menu

Set a spreadsheet’s location and calculation settings

You can change a spreadsheet’s locale, time zone, calculation settings, and functions language in Google Sheets.

When you make a change, it changes for the entire spreadsheet. Everyone working on it will see the changes, regardless of their location.

Change locale and time zone

When you change the locale and time zone of a spreadsheet, it changes the spreadsheet’s default currency, date, and number formatting.

  1. Open a spreadsheet in Google Sheets.
  2. Click File and then Spreadsheet settings.
  3. Under "General," click the "Locale" and "Time zone" menus to change your settings.
  4. Click Save settings.

Changing the locale doesn’t change your language settings in Google Sheets. You can set the language in Google Account settings.

Change the language for functions

You can change the language of Google Sheets functions between English and 21 other languages. You can only do this if your language in Google Account settings is not English.

  1. Open a spreadsheet in Google Sheets.
  2. Click File and then Spreadsheet settings and then General.
  3. Under “Display language,” uncheck "Always use English function names" to see functions in your display language.
  4. Click Save Settings.

Language options

Here are the 21 function languages you can choose from:

Czech, Danish, Dutch, Estonian, Finnish, French, German, Hungarian, Italian, Japanese, Malaysian, Norwegian, Polish, Portuguese (Portugal), Portuguese (Brazil), Russian, Slovenian, Spanish, Swedish, Turkish, and Ukrainian.

Choose how often formulas calculate
  1. Open a spreadsheet in Google Sheets.
  2. Click File and then Spreadsheet settings and then Calculation.
  3. Choose settings for:
    • Recalculation: Sets how often certain formulas are updated.
    • Iterative calculation: Sets the number of times a formula with a circular reference can take place.
  4. Click Save settings.

Functions that pull data from outside the spreadsheet recalculate at the following times:

  • ImportRange: 30 minutes
  • ImportHtml, ImportFeed, ImportData, ImportXml: 1 hour
  • GoogleFinance: 2 minutes

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?