Set a spreadsheet'south location & adding settings

You lot can alter a spreadsheet's locale, time zone, adding settings, and functions language in Google Sheets.

When you lot make a alter, it changes for the entire spreadsheet. Everyone working on information technology volition see the changes, regardless of their location.

Alter locale and fourth dimension zone

When you change the locale and fourth dimension zone of a spreadsheet, information technology changes the spreadsheet's default currency, date, and number formatting.

  1. On your figurer, open up a spreadsheet in Google Sheets.
  2. Click File and then Settings.
  3. Nether "General," click the "Locale" and "Time zone" menus to modify your settings.
  4. Click Relieve settings.

Changing the locale doesn't change your language settings in Google Sheets. Y'all can ready the language in Google Account settings.

Alter the language for functions

Y'all tin can change the language of Google Sheets functions between English and 21 other languages.

  1. Brand sure you're gear up to a non-English language language in Google Account settings.
  2. On your computer, open a spreadsheet in Google Sheets.
  3. Click File and then Settings.
  4. Nether "Display language," uncheck "Always use English language function names" to see functions in your display language.
  5. Click Save Settings.

Language options

Google Sheets supports functions in these languages:

  • Czech
  • Danish
  • Dutch
  • English
  • Estonian
  • Finnish
  • French
  • German
  • Hungarian
  • Italian
  • Japanese
  • Malaysian
  • Norwegian (Bokmal)
  • Shine
  • Portuguese (Portugal)
  • Portuguese (Brazil)
  • Russian
  • Slovenian
  • Spanish
  • Swedish
  • Turkish
  • Ukrainian

Choose how often formulas summate

  1. On your reckoner, open up a spreadsheet in Google Sheets.
  2. Click File and then Settings and then Calculation.
  3. Cull settings for:
    • Recalculation: Sets how often sure formulas are updated.
    • Iterative calculation: Sets the number of times a formula with a circular reference tin can occur.
  4. Click Salvage settings.

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

  • ImportRange: 30 minutes
  • ImportHtml, ImportFeed, ImportData, ImportXml: 1 60 minutes
  • GoogleFinance: may be delayed up to twenty minutes

Was this helpful?

How can we meliorate information technology?