How to Sort Data Alphabetically, Numerically, and by Date in Google Sheets

Whether tracking monthly household expenses, managing customer sales pipelines, or analysing survey responses in Google Sheets, raw data rarely enters your spreadsheet in logical order. Sorting rows alphabetically by surname, chronologically by transaction date, or numerically from highest revenue to lowest is essential for making sense of large tables. However, sorting incorrectly often scrambles your formulas or accidentally mixes your top header row into the data. Following proper sorting procedures guarantees fast, accurate organization.

Two Ways to Sort in Google Sheets: Sheet vs. Range

Understanding the critical difference between sorting the whole sheet versus sorting a range prevents accidental data corruption:

• Sort Sheet: Reorders every single row across the entire worksheet based on values in your chosen column. Columns that are not part of your table will also be sorted.
• Sort Range: Sorts strictly within your highlighted table boundaries, leaving surrounding notes, summaries, or side calculations completely untouched.

Method 1: Sort a Selected Range with Header Protection (Recommended)

The safest and most reliable way to sort data without disturbing header titles:

1. Open your spreadsheet in Google Sheets.
2. Click and drag to highlight your complete table, including the top header row (e.g., cells A1 through D150).
3. Click on the Data menu in the top toolbar.
4. Hover over Sort range and click on Advanced range sorting options.
5. In the modal dialogue, check the box labelled Data has header row. Google Sheets will automatically exclude Row 1 from sorting and display your actual column names.
6. Under Sort by, select the column you want to order by (e.g., Date, Customer Name, or Amount).
7. Choose between A → Z (ascending / oldest to newest / smallest to largest) or Z → A (descending / highest to lowest).
8. Click the green Sort button. Your table will reorganize instantaneously while preserving Row 1.

Method 2: Multi-Level Sorting (Sort by Multiple Columns)

If you want to sort customer orders first by Department, and then by Total Sales within each department:

1. Highlight your table and open Data > Sort range > Advanced range sorting options.
2. Tick Data has header row.
3. Set the first sort rule to Department (A → Z).
4. Click the blue Add another sort column link.
5. Set the secondary rule to Total Sales (Z → A).
6. Click Sort. Google Sheets will group departments together alphabetically and sort sales numbers within each group seamlessly.

Method 3: Quick Filter Sorting

You can also enable interactive filter arrows across your headers: highlight your table and click Data > Create a filter. Small dropdown arrows will appear in each header cell, allowing you to sort A → Z or Z → A with a single click anytime.