Script for Data Sorting

📌 Steps to Sort Data Using a Script in Google Sheets

1. Open your Google Sheet.
2. Click Extensions → Apps Script.
3. Delete any existing code and paste the script below.
4. Click Save (💾 icon).
5. Click Run ▶️ to execute the script.

---

🔹 Sorting a Specific Range

• If you only want to sort a specific range (e.g., A:K by Column A)

function SortCustTable() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A:k').activate(); spreadsheet.getActiveRange().offset(1, 0, spreadsheet.getActiveRange().getNumRows() - 1).sort({column: 1, ascending: true}); };

✅ Modifications:

• Change {column: 1, ascending: true} to sort by a different column.
• Set ascending: false for descending order.

🔹 Auto-Sort When Data Changes

To automatically sort the sheet whenever the data changes, use this onEdit trigger:

function onEdit(e) { var sheet = e.source.getActiveSheet(); var range = sheet.getDataRange(); range.sort({column: 2, ascending: true}); // Change column as needed }

✅ How to Enable Auto-Sorting: Go to Apps Script. Click Triggers (Clock Icon). Select onEdit and set it to run on "From spreadsheet → On edit". 

🎯 Use Cases 

✔️ Sort names alphabetically. 

✔️ Arrange numbers from smallest to largest. 

✔️ Automatically sort when data updates.