Google Sheets: sort a resource list and keep each row together
Sorting only one column can separate names or items from their related information. Practise on a copy with non-sensitive sample data.
sort a resource list and keep each row together
- Make an approved copy before a major reorganisation.
- Select the complete table range, including all related columns.
- Use Data and the sort-range options. Indicate that the range has a header row when appropriate.
- Choose the column and ascending or descending order.
- Check several complete rows against the original before saving or sharing the result.
Still need help?
Undo immediately if related columns become misaligned. Send an anonymised example and the selected range if IT needs to investigate.
Practical advice and common pitfalls
Select the full table, including related columns, before sorting. Check a known row afterwards to confirm the values stayed together. Use a filter view or a copy when colleagues are editing the same sheet.
Before you begin
Make a copy before changing a shared spreadsheet. Confirm whether the first row contains headings and whether numbers are stored as numbers rather than text.
Check the result and troubleshoot
When sorting, select the entire data range so names and associated values remain together. Check formula results against a small manual example and preview printing before distributing a sheet.
When to contact school IT support
If the problem remains, include the article title, device type, approximate time, exact error wording and the checks already completed. Do not include passwords, sign-in codes or sensitive pupil information.
Send a request and include the steps you already tried.