How to Sort Data in Google Sheets

Sorting helps you organize your data to find patterns, identify trends, and prepare reports quickly.

Select Your Data Range

Click and drag to select the data range you want to sort, including headers.

Go to Data > Sort range. If your data has header rows, check "Data has header row".

💡 Always include header rows in your selection to keep them at the top.

Select the column to sort by and choose A-Z (ascending) or Z-A (descending).

Click "Add another sort column" to sort by multiple criteria — for example, sort by department first, then by name within each department.

Yes. Create a custom sort order list and use Data > Sort range > Advanced sorting options.

Use Data > Sort range and click "Add another sort column" for each additional level.