Better Sheets

How to sort in google sheet

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.

Browse more tutorials

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...

Beginner

CONCATENATE() JOIN()

Combine Sheets Into One Sheet As It Happens

Jodi asked: ab out Building a sales CRM spreadsheet that has 4-5 tabs a...

Intermediate

IMPORTRANGE() SORT()

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...

Beginner

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

How To Sort A Filter

This will allows you to analyze and organize your data.

Data validation Intermediate

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another arra...

Intermediate

INDIRECT() SORT() TRANSPOSE()

Unlock these tutorials

Related blog posts

Written guides that go deeper on this question.

Browse the blog

Figure Out Frequency of Numbers

Discover how to figure out the frequency of numbers, product IDs, text, emails and much more! Essential tips and tricks revealed.

Getting Started in Google Sheets Spreadsheet Management

Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

No exact channel match cached for “How to sort in google sheet” yet. Search Better Sheets on YouTube.

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 ...

SORT

SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...

#SPILL! error

#SPILL! means a dynamic array formula tried to fill multiple cells but something blocked the spill range. Another val...

COLUMN()

Google Sheets COLUMN() function guide

SORT()

Google Sheets SORT() function guide

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 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 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 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 →

Can you sort 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 numerically 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?

636+ 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.

Browse more questions

Learning Sheets for real

Unlock the full library, generators, and templates with membership.

See membership