Step 3 of 4 · Google Sheets Essentials
Freeze 1 row, sort by column
Freeze 1 row, sort by column — step 3 of 4 in Google Sheets Essentials. View → Freeze → 1 row. To sort: click inside the table, Data → Sort sheet, check that headers are used.
Free career skills tip: Freeze 1 row, sort by column (step 3 of 4 from "Google Sheets Essentials").
View → Freeze → 1 row. To sort: click inside the table, Data → Sort sheet, check that headers are used.
If one row doesn't move, you had a blank row splitting the table.
You'll need
- No merges
- Frozen header
- Sort tested
1 more paragraph in this tip — free with a Learnlyst account.
Create a free account to read the full tip
Unlock “Freeze 1 row, sort by column” plus daily tips. Guides and course pages stay public for search.
From the full photographed course
Google Sheets Essentials →This tip is one step — unlock all 4 steps inside Learnlyst.
More Career Skills tips
Ready for the full Learnlyst library?
Free account for daily tips · $9/mo or $79/yr for every course.