Right-click Context Menu of the row(s): Hide/Unhide Rows:Hide
Right-click Context Menu of the row(s): Hide/Unhide Rows:Unhide
Hide or unhide selected rows
1. wrowhide irng:=[Book1]Sheet1!: operation:=0; // hide row2 to 5 in Book1 Sheet1
2. wrowhide irng:=(:,:) operation:=0; //hide row1 to 2 and row 5 to 6 in active sheet.
Please refer to the page for additional option switches when accessing the x-function from script
This X-Function is used to hide or show specified rows. To call the X-function from the menu, right-click on the selected rows and select Hide/Unhide Rows.
Note: the hidden rows will be ignored in the plotting and analysis process. If you update the hidden range after plot or analysis operation, it will triggers the graph redrawing or analysis recalculation.