Change a spreadsheet's locale, time zone, recalculation, and language

You can change the locale, time zone, recalculation, and function language of a spreadsheet in Google Sheets.

Note: When you make a change, it changes across 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 and date and number formatting.

  1. Open a spreadsheet.
  2. Click File > Spreadsheet settings.
  3. Click the "Locale" and "Time zone" drop-down menus to change your settings.
  4. Click Save settings.

Note: Changing the locale doesn't change your language setting in Google Sheets. You can set your language preference by changing your Google Drive settings.

Change recalculation settings

To change how often some Google Sheets functions update:

  1. Open a spreadsheet.
  2. Click File > Spreadsheet settings.
  3. Under "Recalculation," choose a setting from the drop-down menu.
  4. Click Save settings.

Note: External data functions recalculate at the following intervals:

  • ImportRange: 30 minutes
  • ImportHtml, ImportFeed, ImportData, ImportXml: 1 hour
  • GoogleFinance: 2 minutes
Change the language for functions

You can change the language of Google Sheets functions between English and 21 other languages by following these steps:

  1. Open a spreadsheet.
  2. Click File > Spreadsheet settings.
  3. Under "General settings," if your display language is not English, you can click the box to the left of "Always use English function names" to see functions in English.
  4. Click Save settings.

Language options

Here are the 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.

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

Was this article helpful?