NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Change calculation settings

Google Sheets · Verified tutorial

Change calculation settings in Google Sheets

Open File > Settings > Calculation and set Recalculation to "On change and every minute". Save the setting. Do not change any cell values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Open File > Settings > Calculation and set Recalculation to "On change and every minute". Save the setting. Do not change any cell values.

Step-by-step

1

Select the targetOpen File > Settings > Calculation and set Recalculation to "On change and every minute".

2

Apply the changeSave the setting.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

The spreadsheet recalculates on changes and every minute.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Undo the last change, reselect the intended range, and try again. The spreadsheet recalculates on changes and every minute.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
North	120
South	180

Video transcript

Open the prepared Calculation settings spreadsheet.
Select the target. Open File > Settings > Calculation and set Recalculation to "On change and every minute".
Apply the change. Save the setting.
The spreadsheet recalculates on changes and every minute.