How to☝️ Sort Data by Column in Google Sheets

To sort data by column in Google Sheets, first select your data, then go to the Create filter option on the toolbar. Next, go to your data, click on the Filter icon, and pick the sorting style you want. Afterward, press the Filter icon to remove the filter. The results will be displayed.

Read on to learn more about sorting data in Google Sheets. This article will teach you how to sort data on a desktop, on a mobile device, and by using a custom formula. Let’s get started!

How to Sort by Column in Google Sheets on a Desktop

The following methods using the Filter option can be helpful if you are working on a desktop. Let’s take a look at how this works.

Method 1

Using the following method, you will be able to sort your data in just a few seconds.

Difficulty: Beginner

Time Estimate: 7 seconds

  1. Select the data.
  2. Click on the Create filter option on the toolbar.
  3. Press the Filter icon.
  4. Choose the sorting style you need.

How to Sort by Column in Google Sheets on a Desktop

5. Go back to the toolbar and remove the Filter.

Filter

This is how it should look once you’re done. Keep in mind that this method might not work if your cells contain Google Sheets emojis.

The Data

Method 2

Another easy way to sort your data is to use the Data menu.

Difficulty: Beginner

Time Estimate: 7 seconds

  1. Highlight your data. 
  2. Navigate to the Data menu.
  3. Click on the Sort sheet by column option.
  4. Pick the sorting you need.

The Sort sheet by column option

Voila! That’s all it takes.

The Data

How to Sort by Column in Google Sheets on a Mobile Device

Here is a step-by-step guide on managing your data while on a mobile device.

Difficulty: Beginner

Time Estimate: 10 seconds

  1. Select all your data.
  2. Go to the three-dot menu in the upper right corner.

How to Sort by Column in Google Sheets on a Mobile Device

  1. Choose the Create a filter option.

The Create a filter option

  1. Click on the Filter icon.
  2. Pick the sorting style you need for your spreadsheet.

The Filter icon

  1. Again, click on the three-dot menu.

Three-dot menu

  1. Choose the Remove filter option.

The Remove filter option

Piece of cake! Your goal has been achieved!

Data

Bonus: Sorting Data by Column Using a Custom Formula

If you find that the methods introduced thus far are not working for you, we suggest trying other methods available. Below is a detailed description of how to use a formula to sort your data.

How to Sort from A to Z (Smallest to Largest)

By default, the following formula will sort your data using the A to Z order.

Difficulty: Beginner

Time Estimate: 7 seconds

  1. Click on the cell where you need your result.
  2. Go to the Formula bar and enter the formula =SORT(A2:A13). Here, A2:A13 is the cell range with the data you want to organize.

How to Sort from A to Z (Smallest to Largest)

  1. Tap the Enter key on your keyboard.

The Months

Congratulations! You have the desired result!

How to Sort from Z to A (Largest to Smallest)

If you want to set the order from Z to A, you need to use the following formula.

Difficulty: Beginner

Time Estimate: 10 seconds

  1. Select the cell where you want the result.
  2. Navigate to the Formula bar and type the formula =SORT(A2:A13,1,FALSE), where A2:A13 is the cell range with the data you need to sort.

ow to Sort from Z to A (Largest to Smallest)

  1. Press the Enter key on the keyboard.

Months

If you’re having any issues using the filtering functionality, use our in-depth guide on troubleshooting why the filter option is not working in Excel.

Sorting Data in Google Sheets FAQs

For more in-depth information about this topic, we suggest that you view the FAQs below. We hope you find them useful!

How do I sort by color in Google Sheets?

To sort by color in Google Sheets, start by selecting your data. Navigate to the Data menu and click on Create a filter.

How do I sort by color in Google Sheets

Next, press the Filter icon, choose the Sort by color option, click on Fill color, and select the color you need to sort by.

The Sort by color option

Finally, click on the Filter icon to remove the filter once you’re done.

The Filter

It’s that simple!

Sort be color

How do I sort two columns in Google Sheets?

To sort two columns in Google Sheets, select the columns with the data, go to the Data menu, choose Sort range from the list, and click on Advanced range sorting options

How do I sort two columns in Google Sheets

Check the Data has header row box if you need it, set the sorting to the first column, and click on Add another sort column.

Advanced range sorting options

Next, pick the sorting style and press Sort.

Sort range

Here is the result!

The Data in Google Sheets

How do I sort a column numerically in Google Sheets?

To sort a column numerically in Google Sheets, select your values, go to the Data menu, click on the Sort sheet option, and select the sorting order you need. A to Z orders numbers from smallest to largest, and Z to A orders numbers from largest to smallest.

How do I sort a column numerically in Google Sheets

This is as easy as ABC—or, perhaps more accurately, 1-2-3!

Numbers

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X