Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
//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