How to Sort Cells in Google Sheets Via Sort Range

Sorting by range, much like installing a filter, is a great way to quickly organize your data; both numerically and alphabetically. I will show you how to do so in just a few easy steps.

Step #1: Highlight the Cells

How to Sort Cells in Google Sheets Via Sort Range Step 1

First, highlight the cells that you wish to sort and then open the “Data” menu.

Step #2: “Data”–>”Sort Range”

How to Sort Cells in Google Sheets Via Sort Range Step 2

In the “Data” menu, select the option titled Sort Range. This will take you to a box that will help you sort your cells.

Step #3: Sort Your Cells

How to Sort Cells in Google Sheets Via Sort Range Step 3

If you highlighted the header row as well, like I did, make sure you click that box. From here, you will be able to sort your selected columns in ascending or descending order.

  • Numbers will be sorted from max to min (and Vice Versa).
  • Letters and Words will be sorted alphabetically from A-Z (or from Z-A).

You also can add more columns to be sorted while you are still in the sorting box.

Step #4: Verify Success

How to Sort Cells in Google Sheets Via Sort Range Step 4

As you can see, the column has successfully been alphabetized from A-Z, as was planned.

That is how you sort and break apart your cells in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!