Tuan_H
(Tuan H)
1
- Copy/Paste the information below to the clipboard
- Open the spreadsheet whose sheets need to be alphabetised
- Choose Tools > Script editor > Blank (this opens a new tab in the browser)
- Press Control+A followed by Control+V copy and paste the script in
- Press Control+S to save the script
- Choose Run > sortSheets
- Go back to the spreadsheet tab to view the new sorted tab order
–Copy everything below this line–
function sortSheets () {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetNameArray = [];
var sheets = ss.getSheets();
for (var i = 0; i < sheets.length; i++) {
sheetNameArray.push(sheets[i].getName());
}
sheetNameArray.sort();
for( var j = 0; j < sheets.length; j++ ) {
ss.setActiveSheet(ss.getSheetByName(sheetNameArray[j]));
ss.moveActiveSheet(j + 1);
}
}