قالب وردپرس درنا توس
Home / Tips and Tricks / How to sort by multiple columns in Google Sheets

How to sort by multiple columns in Google Sheets



Google Sheets

When analyzing complex amounts of data in Google Sheets, you can take advantage of its built-in sorting function to organize 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 your Google Sheets spreadsheet and select the amount of data you want to sort. You can do this manually by selecting the cells with the mouse or by selecting one of the cells in your data set and pressing Ctrl + A on the keyboard.

RELATED: Google Sheets Beginner̵

7;s Guide

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

To sort data in Google Sheets, select your data set, then tap Sort> Sort Range.  “Width =” 570 “height =” 370 “onload =” pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);  “onerror =” this.onerror = null;  pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this);  “/></p>
<p>In the “Sort intervals” option box, you can choose how you want to sort your data.</p>
<p>You can select the column to be sorted by, and whether you want to sort in ascending or descending order.  Click “Data has header row” to be able to select columns after the header cell.</p>
<p><img class=

By default, Google Sheets offers only one column to sort by. To add more columns to your sort options, select the “Add another sort column” button.

Print

When you sort by multiple columns in Google Sheets, sorting will take place from top to bottom. For example, a sample spreadsheet has product sales data with product names, sales dates, and prices displayed.

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

A sorting option for Google Sheets with multiple columns added.

You can sort this in ascending order, starting with product name near the beginning of the alphabet at the top, then with prices sorted by the minimum amount. Select “AZ” to sort this way or “ZA” to sort in descending order instead.

You can also mix and match these options. In this example, you can sort in ascending order of product name and descending order of sales amount.

In the Google Sheets sort box, select

When your sorting options are set, select the “Sort” button to sort your data. The information in your spreadsheet will be rearranged according to the rules in the “Sort intervals” option box.

An example of sets of data in Google Sheets, sorted with the built-in sorting tool.

For this example, the information above has been sorted by product name and prices in ascending order. This is clearly shown with the monitor and mouse products.

Priced at $ 100, the screen would come in second place if the sorting was performed only in the “Price” column (column C). However, since the sorting was performed first in the “Product” column (column A), the sold monitor was placed in front of the mouse.

Example of sorted Google Sheets data with one and more columns.

You can undo one of these types by performing a different sort on your data set, by pressing the “Undo” button in the menu bar or by pressing Ctrl + Z on the keyboard.

RELATED: All the best keyboard shortcuts for Google Sheets




Source link