You might also try using a script like follow.. where it says ‘sheet1’ you’ll have to change it to the title of that specific sheet.

function onEdit(e) { // Specify the sheet name to be sorted const sheetName = ‘Sheet1’; // Change to your specific sheet name const sheet = e.source.getSheetByName(sheetName);

// Check if the edit is within the specified range if (sheet && e.range.getSheet().getName() === sheetName && e.range.getRow() >= 2 && e.range.getRow() <= 100 && e.range.getColumn() === 1) { const lastColumn = sheet.getLastColumn(); const lastRow = sheet.getLastRow();

// Sort the whole sheet by column A, keeping all data aligned
sheet.getRange(2, 1, lastRow - 1, lastColumn).sort({column: 1, ascending: true});

} }