How to Arrange Data in Ascending Order in Google Sheets

Organizing data is the first step toward finding any real insight, and arranging it in ascending order - from A to Z or smallest to largest - is one of the most basic ways to bring clarity to a messy spreadsheet. Whether you're alphabetizing a list of names, organizing sales by date, or ranking performance from lowest to highest, Google Sheets has several ways to get it done. This guide will walk you through everything from simple one-click sorting to powerful formulas that update automatically.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Quickest Method: Using the 'Sort range' Tool

For most day-to-day tasks, the built-in sorting tool is all you need. It’s fast, straightforward, and perfect for when you just need to organize your static dataset quickly. Let's look at how to sort a single column and then how to sort your entire dataset based on one or more columns.

How to Sort a Single Column (With Caution)

Sometimes you have a simple, single-column list you want to alphabetize. Be careful with this method if you have related data in adjacent columns, as sorting just one column will jumble your data integrity. For a standalone list, however, it's perfect.

1. Click on the column letter (e.g., Column A) to select the entire column you want to sort.
2. Navigate to the menu bar and click Data > Sort sheet.
3. A submenu will appear. Choose Sort sheet by column A (A to Z) to sort in ascending order. To sort descending, you would choose Sort sheet by column A (Z to A).

Your column will instantly be rearranged. Again, use this only for single-column lists. If Column B has data related to Column A, those rows will no longer match up!

The Best Practice: Sorting Your Entire Data Range

The safest and most common way to sort is by using the 'Sort range' tool. This method keeps all your rows intact, ensuring that related data stays together. Imagine you have a list of sales reps, their regions, and their sales totals. You want to sort them alphabetically by name without mixing up who sold what in which region.

Here’s how to do it correctly:

1. Select your data range. Click on the top-left cell of your data (e.g., A1) and drag your mouse to the bottom-right cell to highlight the entire table you want to sort. Avoid selecting the entire sheet by clicking the box between row 1 and column A unless you truly want to sort everything.
2. Go to the menu and click Data > Sort range > Advanced range sorting options.
3. A new window will pop up with several options. First, and most importantly, check the box for Data has a header row if your columns have titles like "Name," "Region," or "Sales." This tells Google Sheets to leave your first row alone and only sort the data below it.
4. In the 'Sort by' dropdown, choose the column you want to organize your data by. For example, if you want to alphabetize by last name, you'd select the "Last Name" column.
5. Ensure the next dropdown is set to A → Z for ascending order. (Z → A is for descending order).
6. Click Sort.

Your entire table will now be reordered based on the column you selected, with all corresponding row data moved along with it. No more mismatched reps and sales figures!

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Sorting by Multiple Columns

What if you have multiple people with the same last name? You can add a secondary sorting rule to organize them by first name too.

• In the 'Sort range' window, after setting up your first rule (e.g., Sort by "Last Name," A → Z), click on Add another sort column.
• A second set of dropdowns will appear. Now, you can choose your secondary column, like "First Name," and also sort it from A → Z.
• You can continue adding columns for even more granular sorting. Google Sheets will sort your data in the order of the rules you've set, from top to bottom.

An Alternative Approach: Sorting With Filters

If you're already using filters to view your data, you can sort directly from there. Filters offer a non-permanent way to view sorted data without rearranging the original dataset, which can be useful when collaborating with a team.

1. Select your data range and go to Data > Create a filter (or click the filter icon in the toolbar).
2. You'll see small dropdown arrows appear in each header cell.
3. Click the arrow in the header of the column you wish to sort.
4. In the menu that appears, simply click Sort A-Z.

Your view of the data is now sorted. To return to the original order, just go to Data > Remove filter. This approach is excellent for temporary analysis or when you don't want to alter the 'master' arrangement of the spreadsheet.

For Dynamic Sorting: The SORT Function

While the menu tools are great for one-off sorts, they are static. If you add new data, you have to re-sort it manually. The SORT function solves this by creating a new, dynamically sorted copy of your data that updates automatically as the original source changes.

This is extremely powerful for building dashboards or reports where you always want to see an organized list, no matter what new information is added.

Understanding the SORT Function Syntax

The formula looks like this:

=SORT(range, sort_column, is_ascending)

• range: This is the group of cells you want to sort. For example, A2:C100.
• sort_column: This is the column within your range that you will base the sort on. It's important to specify this as an index number (1 for the first column in your range, 2 for the second, etc.), not the column letter (like 'A').
• is_ascending: This is a TRUE or FALSE value. Use TRUE for ascending order (A-Z, 1-10) and FALSE for descending order (Z-A, 10-1).

SORT Function in Action

Let's say you have a raw data list of YouTube video performance in cells A2:C50. Column A has the Video Title, Column B has the View Count, and Column C has the Publish Date.

To create a new list sorted by view count from lowest to highest, find an empty cell (e.g., E2) and enter this formula:

=SORT(A2:C50, 2, TRUE)

• A2:C50 is our source data.
• 2 tells the formula to sort based on the second column in that range (Column B, the View Count).
• TRUE tells it to sort in ascending order (lowest views to highest).

Press Enter, and Google Sheets will automatically populate a new, sorted table starting in cell E2. If you change a view count number in Column B or add a new video to the bottom of the raw data (as long as your range is updated, e.g., A2:C), the sorted list in column E will update in real-time.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Sorting by Multiple Columns with the SORT function

Just like with the tool, you can sort by multiple criteria. The syntax expands like this:

=SORT(range, sort_column1, is_ascending1, sort_column2, is_ascending2, ...)

For example, to sort products by "Category" (Column B) alphabetically, and then by "Price" (Column D) from lowest to highest, the formula would be:

=SORT(A2:D100, 2, TRUE, 4, TRUE)

This sorts first by the 2nd column (Category) ascending, then by the 4th column (Price) ascending.

Advanced Sorting: Using QUERY for Ultimate Flexibility

For those who want maximum control, the QUERY function is the most robust tool in Google Sheets. It allows you to use SQL-like language to select, filter, and sort your data all in one go.

The sorting part is handled by the ORDER BY clause.

QUERY Function Syntax for Sorting

=QUERY(range, "SELECT * ORDER BY column_letter asc")

• range: Your data, like A1:D100.
• "SELECT * ...": The query itself, written inside quotes. SELECT * means "select all columns."
• ORDER BY column_letter: Tells the query which column to sort by. Unlike SORT, here you use the actual column letter (e.g., A, B, C).
• asc: Stands for 'ascending.' Use desc for descending.

QUERY Function in Action

Using our sales data from A1:D100, where Column D is "Revenue," if we wanted to see all the data sorted from the lowest revenue to the highest, we'd write:

=QUERY(A1:D100, "SELECT * ORDER BY D asc")

The beauty of QUERY is you can combine it with filters. To see only sales from the "North" region (Column B) and sort them by ascending revenue, you could write:

=QUERY(A1:D100, "SELECT * WHERE B = 'North' ORDER BY D asc")

This delivers a pre-filtered, pre-sorted table that updates dynamically. It’s significantly more powerful for building complex reports.

Common Sorting Problems and How to Fix Them

Even with simple tools, things can go wrong. Here are a couple of common pitfalls and how to steer clear of them.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

"I Sorted One Column and It Jumbled All My Data!"

This is the most frequent sorting mistake. It happens when you select only a single column in a multi-column table and click sort. Google Sheets does exactly what you told it to do: it sorts only the selected cells, leaving neighboring columns untouched and completely misaligning your rows.

The Fix: Always select your entire data range before sorting, from the top-left cell to the bottom-right. Better yet, use the Data > Sort range tool, as it’s designed to handle tables and keep rows together.

"My Header Row Got Sorted Along With My Data!"

If you find your column titles mixed in alphabetically with your data after sorting, you forgot to tell Sheets to leave them alone.

The Fix: When using the Data > Sort range window, always make sure the "Data has a header row" box is checked. If you're using a formula like SORT or QUERY, simply start your range from the first row of actual data (e.g., A2:C100 instead of A1:C100).

"My Numbers Aren't Sorting Correctly!"

Sometimes numbers sorted in ascending order might show up like 1, 10, 100, 2, 25 instead of 1, 2, 10, 25, 100. This happens when your numbers are accidentally formatted as text.

The Fix: Select the column, go to Format > Number, and choose Number or Automatic. This will convert the text back to true numerical values that sort correctly.

Final Thoughts

From a simple click to sort a list alphabetically to writing powerful QUERY formulas for dynamic reporting, Google Sheets provides a full spectrum of tools for arranging data. For quick, one-time organization, the 'Sort range' tool is your best friend. For building living reports that update automatically as data flows in, the SORT family of functions is the way to go.

Mastering data presentation in spreadsheets is a valuable skill, but we know it’s often just one of a dozen manual steps required to get answers from your business data. This friction is why we built Graphed. Instead of pulling data from multiple sources into a sheet and then sorting and filtering, you can connect your platforms to Graphed and simply ask questions in plain English - like, "Show me my top 10 products by sales this quarter sorted lowest to highest" - and get an interactive, real-time dashboard instantly.