Skip to content

Instantly share code, notes, and snippets.

@ndthanh
Created December 10, 2018 17:34
Show Gist options
  • Save ndthanh/4545771faa93b25f767f1656a5db0111 to your computer and use it in GitHub Desktop.
Save ndthanh/4545771faa93b25f767f1656a5db0111 to your computer and use it in GitHub Desktop.
//5. unhide all rows and columns in data ranges of entire Google Sheet
function unhideRowsColumnsGlobal() {
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
sheets.forEach(function(sheet) {
var range = sheet.getDataRange();
sheet.unhideRow(range);
sheet.unhideColumn(range);
});
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment