Skip to main content

Hide or unhide rows and columns

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

(function()
{
    let sheet = Api.GetActiveSheet();
    let range = sheet.GetRange("A1:M1");
    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();
    hideUnhideDetails(hidden);
    // Unhide if hidden, Hide if unhidden
    function hideUnhideDetails(hidden) {
        rowsToHide.forEach(row => {
            sheet.GetRows(row).SetHidden(!hidden);
        })
        columnsToHide.forEach(column => {
            range.GetCols(column).SetHidden(!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