Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Spreadsheet Settings

Google Sheets: Spreadsheet Settings

google sheets spreadsheet settings

Check Your Settings

It’s probably not something you’ve given a lot of thought to, but there are settings in Google Sheets. As a rule of thumb, I recommend always looking through any program’s settings and considering each setting.

File Menu

Use the File menu to choose “Spreadsheet settings.”
Spreadsheet Settings

Time Zone

The setting on the General tab that is most relevant is probably “Time zone.” I have had people message me frustrated that some of the spreadsheet templates I have were calculating in Pacific time when they are not Pacific (I am!).
Time zone

Calculation Tab

Click on the “Calculation” tab to view more settings.
Calculation tab


I use =Rand() a lot in my spreadsheets. This allows me to assign each student a random number. Every time I make a change in the spreadsheet, the random number is updated (changed).
equals rand

You can change the settings so that the recalculation happens not only when there are any edits (changes) to the spreadsheet, but also every minute or every hour also.

Iterative Calculation

Spreadsheets do not like circular formulas. For example if in cell C5 I type the formula =SUM(C1:C5) then I am trying to add the sum to the sum … which makes the spreadsheet very confused and grumpy. Since “Iterative calculation” is turned off you will get an error (#REF) when you have a circular dependency.
Circular dependency

If you turn ON “Iterative calculation” (and I’ll be honest I have no clue why you would want to do that) it will do your formula a set number of times. Notice in the screenshot below that my formula in C5 is =SUM(C1:C5) and the sum says 45. This is because when you turn on “Iterative calculation” it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It’s a fun math problem to think about but the reality is you do not need that so don’t worry about the math.
iterative calculation

Spreadsheet Settings NOT Sheets Settings

It is important to point out that the settings are for that spreadsheet NOT for Sheets. This means they are not global settings. If you change the settings the will not be reflected in other spreadsheets.

(adsbygoogle = window.adsbygoogle || []).push({});



Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.