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

Google Sheets tutorials›Spreadsheet basics›Change time zone

Google Sheets · Verified tutorial

Change time zone in Google Sheets

Open File > Settings and change this spreadsheet's time zone to (GMT-05:00) Eastern Time. Save the setting. Do not change any cell values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Open File > Settings and change this spreadsheet's time zone to (GMT-05:00) Eastern Time. Save the setting. Do not change any cell values.

Step-by-step

1

Select the targetOpen File > Settings and change this spreadsheet's time zone to (GMT-05:00) Eastern Time.

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 time zone is America/New_York.

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 time zone is America/New_York.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
North	120
South	180

Video transcript

Open the prepared Regional settings spreadsheet.
Select the target. Open File > Settings and change this spreadsheet's time zone to (GMT-05:00) Eastern Time.
Apply the change. Save the setting.
The spreadsheet time zone is America/New_York.