Monday, October 19, 19:38
Home how To How to sort multiple columns in Google Sheets

How to sort multiple columns in Google Sheets

When analyzing complex datasets in Google Sheets, you can take advantage of the built-in sorting feature to organize your data. You can sort by individual columns or, for more complex data, you can sort by multiple columns.

To do this, you need to open the spreadsheet of Google Sheets and select the data set you want to sort. You can do this manually by selecting the cells using your mouse or by selecting one of the cells in your data set and pressing Ctrl + A.

Once your data is selected, click Data> Sort Range from the Google Sheets menu.

In the "Sort Range" box, you can choose how you want to sort your data.

You can select the column for classification against, as well as whether it will be sorted in ascending or descending order. Click on "Data Has Header Row" to select columns from the "header cell".

google sheets

By default, Google Sheets will only offer one column for sorting. To add multiple columns to the sorting options, select the "Add Another Sort Column" button.

When you sort in multiple columns in Google Sheets, the sorting will be done from top to bottom. For example, a spreadsheet example has product sales data with product names, sales dates, and prices.

If you want to sort this data by name and then by the amount sold, you would first want to select the product name column in column A (named “Product”) and secondly the amount sold in column C (with name “Price”).

You can sort it in ascending order, starting with product names near the beginning of the alphabet at the top and then sorting prices by the smallest amount. Select “AZ” to sort this way or “ZA” to sort in descending order.

You can also combine and match these choices. For this example, you can sort product names in ascending order and sales amounts in descending order.

google sheets

Once the sorting options are set, select the "Sort" button to sort your data. The data on your spreadsheet will be rearranged according to the rules set out in the "Sort Range" options box.

google sheets

You can undo any of these items by running another item in your dataset by pressing the "Undo" button on the menu bar or by pressing Ctrl + Z on your keyboard.


Please enter your comment!
Please enter your name here

Teo Ehc
Teo Ehc
Be the limited edition.


Windows 10: Microsoft has released a new task manager for gamers

If your computer games are slow or slow, you can free up resources in Windows 10 using the new task manager ...

NASA's Osiris-Rex is expected to land on the asteroid Bennu tomorrow

NASA's Osiris-Rex spacecraft will land on a large asteroid for a while on Tuesday and will collect some rocks and ...

How to turn off all vibrations on your iPhone completely

Some people are particularly sensitive to the vibrations of their iPhone, either for personal or medical reasons. Thanks to...

How to convert Keynote presentations to Microsoft PowerPoint

Apple presentation software does all the hard work when converting a PowerPoint presentation to Keynote. Doing the opposite, ...

QAnon Conspiracy Theories: YouTube removes them from the platform

YouTube is the latest social networking site to launch a campaign against the spread of QAnon conspiracy theories.

Vizom: New malware hijacks bank accounts

Vizom disguises itself as a popular "videoconferencing software", with meetings all online due to the pandemic. Investigators...

The Windows 10 Calculator has been ported to Linux

The Windows 10 Calculator has been ported to Linux and can be installed from the Canonical Snap Store. The ...

System breach exposes Kleenheat customer data

Australian-based gas company Kleenheat has warned some of its customers of data breaches, which may ...

US Election: Candidates manipulate voters via email!

The politicians who are candidates for the upcoming US elections use psychological tricks and "dark" patterns in their emails to ...

Google Chrome and Edge create random debug.log logs

An error in the latest version of Chrome and other Chromium-based browsers causes random debug.log files to be created ...