Menu
Is there anyway to change to order of specified sheet which already existed?
I see there's API called sheet.getIndex(), but there's no set's.
The only way now seems call insertSheet().
insertSheet(optName, optSheetIndex, optAdvancedArgs)
You can specify the index with optSheetIndex. Any idea?
254
Method 1 - Change Order of Tabs Left-click and hold the mouse button until you see a little black arrow appear next to the tab and your mouse pointer should have a small "page" icon under it (this icon didn't come through on the screenshot below). Then, simply drag the sheet tab to whichever position you want.
Sort an entire sheet On your computer, open a spreadsheet in Google Sheets. At the top, right-click the letter of the column you want to sort by. Click Sort sheet A to Z or Sort sheet Z to A.
You can achieve this with setActiveSheet() and moveActiveSheet().
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
