MR6 | Macro trên Google Sheet
//10 reset all filters for a data range on current Sheet function resetFilter() {   var sheet = SpreadsheetApp.getActiveSheet();   var range =..
07
12
2019
//8. hide all sheets except the active one function hideAllSheetsExceptActive() {   var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();  ..
07
12
2019
//6. set all Sheets tabs to red function setTabColor() {   var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();  ..
07
12
2019
//4. unhide all rows and columns in current Sheet data range function unhideRowsColumnsActiveSheet() {   var sheet = SpreadsheetApp.getActiveSheet();  ..
07
12
2019
//3. sort sheets alphabetically function sortSheets() {   var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();   var sheets =..
07
12
2019
//1. convert all formulas to values in the active sheet function formulasToValuesActiveSheet() {   var sheet = SpreadsheetApp.getActiveSheet();   var..
07
12
2019
// code by: Thanh ND // Copy as you wish. No attribution required. var mangso = ['không', 'một', 'hai', 'ba', 'bốn', 'năm', 'sáu', 'bảy', 'tám',..
07
12
2019
Chat ngay
Hotline02516544809
Chat ngay