Set a spreadsheet’s location and calculation settings

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 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.

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 Spreadsheet settings  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.

1. Open a spreadsheet in Google Sheets.
2. Click File Spreadsheet settings 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