Sort by multiple columns in Google Sheets
Sort A1:C5 first by Team A to Z and then by Score Z to A, keeping the header row.
Verified by JosephineAbout 60 secondsSort A1:C5 first by Team A to Z and then by Score Z to A, keeping the header row.
Step-by-step
Open the practice sheetUse the example data shown below so the result is easy to check.
Sort by multiple columnsSort A1:C5 first by Team A to Z and then by Score Z to A, keeping the header row.
Check the resultCompare the finished sheet with the expected result and correct the target range if needed.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
Blue rows appear first by descending score, followed by Green rows by descending score.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A1:C5 and repeat the final action. Blue rows appear first by descending score, followed by Green rows by descending score.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Team | Name | Score |
| Blue | Cara | 8 |
| Green | Anna | 9 |
| Blue | Ben | 7 |
| Green | Dev | 6 |
Video transcript
- Open the prepared Practice spreadsheet.
- Open the practice sheet. Use the example data shown below so the result is easy to check.
- Sort by multiple columns. Sort A1:C5 first by Team A to Z and then by Score Z to A, keeping the header row.
- Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
- Blue rows appear first by descending score, followed by Green rows by descending score.