📋 GS Sort by Range Guide
📩 1. Formula Name + Syntax
p>Feature:
Sort Range (menu-based action, not a formula)
Navigation:
Data → Sort Range
You choose a cell range, then apply sorting by one or more columns through the menu UI.
📩 2. What it does
Sorts a selected block of cells in-place by chosen columns using ascending or descending order.
📄3. Use Case / Scenario
You have a sales report in a specific region, and want to sort only that selected portion (not the entire sheet) by sales amount or salesperson name. Sort Range lets you do that without touching data outside the selected block.
🧪4. Interactive Example
Sample data in A1:C5:
Name | Region | Sales --------|--------|------- Alice | East | 500 Bob | West | 600 Charlie | East | 300 David | South | 700
Steps:
- Select range
A1:C5 - Go to
Data → Sort Range - Check “Data has header row”
- Select
Salescolumn - Choose “Z → A” to sort by highest sales
Result: Data is sorted in-place, with David at the top.
🛠️ 5. Real-Life Applications
- Sorting a list of employees by department or salary.
- Organizing product inventory by quantity or category.
- Alphabetizing customer names in a selected sheet section.
- Reordering a filtered table by date without affecting unrelated rows.
⚠️6. Common Errors + Fixes
- Headers Sorted as Data: Happens when “Data has header row” is not selected. Fix: Always check that option if headers are present.
- Wrong Column Sorted: User may pick the wrong sort column. Fix: Double-check column names in the dropdown.
- Only Partial Range Selected: Sorting may misalign rows. Fix: Always select the full data block including related columns.
🧠 7. Bonus Tips
- You can sort by multiple columns by clicking “Add another sort column”.
- If using filters, combine
Sort rangewithFilter viewsfor better results. - Make a copy of the data before sorting if order matters for other formulas.
- Use keyboard shortcut
Alt → D → S(on some browsers/systems) for faster access.