function onOpen() {
    sortSheetsByName();
}
function sortSheetsByName() {
    var aSheets = new Array();
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    for (var s in ss.getSheets()) {
        aSheets.push(ss.getSheets()[s].getName());
    }
    if (aSheets.length) {
        aSheets.sort();
        for (var i = 0; i < aSheets.length; i++) {
            var theSheet = ss.getSheetByName(aSheets[i]);
            if (theSheet.getIndex() != i + 1) {
                ss.setActiveSheet(theSheet);
                ss.moveActiveSheet(i + 1);
            }
        }
    }
}​
스크립트 저장 후 파일을 열면 바로 실행 됨.

출처: https://support.google.com/docs/thread/2806598/any-way-to-sort-sheets-in-alphabetical-order-in-my-workbook?hl=en

+ Recent posts