跳到主要内容

Hide or unhide rows and columns

Hides or unhides the specified rows and/or columns in the spreadsheet.

(function() {
let sheet = Api.GetActiveSheet();

// ---change this section according to the data---
let range = sheet.GetRange("A:P");
let rowsToHide = [5, 8, 9, 12, 14, 16, 21, 22, 31, 32, 33];
let columnsToHide = [2, 4, 5, 7, 8, 10, 11, 13, 14, 16];
let hidden = sheet.GetRows(rowsToHide[0]).GetHidden();

function hideUnhideDetails(hidden) {
rowsToHide.forEach(row => {
sheet.GetRows(row).SetHidden(!hidden);
});
columnsToHide.forEach(column => {
range.GetCols(column).SetHidden(!hidden);
});
}
hideUnhideDetails(hidden);
})();

Methods used: GetActiveSheet, GetRange, GetRows, GetHidden, GetCols, SetHidden

Reference Microsoft VBA macro code

Sub HideUnhide()
Rows("5:10").Hidden = Not Rows("5:10").Hidden
Columns("B:D").Hidden = Not Columns("B:D").Hidden
End Sub

Result

Hide or unhide rows and columnsHide or unhide rows and columns