How to lock rows in Google Sheets for sorting
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Steps
-
1
Select the range or click inside the column.
-
2
Open Data → Sort sheet or Data → Sort range.
-
3
Choose column and A→Z or Z→A.
-
4
Use Advanced options for multi-column sorts.
Related tutorials
These videos might help you go deeper on this topic.
Password Protecting Data In a Google Sheet
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
Password Protecting Data In a Google Sheet Part 2 The Basics
Related blog posts
Written guides that go deeper on this question.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function ...
Open →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...
Open →#SPILL! error
#SPILL! means a dynamic array formula tried to fill multiple cells but something blocked the spill range. Another val...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →SORT()
Google Sheets SORT() function guide
Open →Related questions
How do you sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How do i sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to sort data on Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to automatically sort data in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →How to keep rows together when sorting in Google Sheets
Select your data, then use Data → Sort sheet or Data → Sort range. Pick the column and direction. Advanced range sorting options let you add secondary keys. Sorting changes the sheet in place; =SORT(...) builds a sorted spill range elsewhere.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.