TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

Unhide all rows and columns

Description

Unhides all the rows and columns in the active spreadsheet.

(function()
{
    var activeSheet = Api.ActiveSheet;
    var indexRowMax = 1048576;
    var n = 1;
    for (let i = 0; i < indexRowMax; i++) {
        activeSheet.GetRows(n).SetHidden(false);
        n++;
    }
    var newRange = activeSheet.GetRange("A1");
    newRange.SetValue("All the rows and columns are unhidden now");
})();

Methods used: GetActiveSheet, GetRows, SetHidden, GetRange, SetValue

Result

Unhide all rows