New: ready-to-use spreadsheet templatesExplore the collection  →
Google Sheets · Verified tutorial

Freeze the first column in Google Sheets

Freeze exactly the first column using View > Freeze. Do not change any cell values.

Verified by JosephineAbout 60 seconds
Quick answer

Freeze exactly the first column using View > Freeze. Do not change any cell values.

Step-by-step

1

Select the targetFreeze exactly the first column.

2

Apply the changeView > Freeze.

Shortcut or faster method

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

Expected result

Exactly one column is frozen.

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. Exactly one column is frozen.

Example spreadsheet data

This is the clean fixture used for the verified run.

EmployeeDepartmentWeekHours
AnnaDesignWeek 132
BenSalesWeek 138
CaraFinanceWeek 235
DevOperationsWeek 240
EvaSupportWeek 336

Video transcript

  1. Open the prepared Team schedule spreadsheet.
  2. Select the target. Freeze exactly the first column.
  3. Apply the change. View > Freeze.
  4. Exactly one column is frozen.