Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet |
Hide target | enum | Optional | rows | —rowscolumnssheet |
Action action | enum | Optional | hide | —hideunhide |
Range range | string | Optional | — | Rows as 2:10, or columns as C:E Shown when target = rows / columns |
Very Hidden veryHidden | boolean | Optional | false | Cannot be unhidden from Excel's own menu Shown when target = sheet |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Duplicate Excel WorkSheet
Make a copy of an existing sheet
Freeze Panes
Keep the headings on screen while the rest of the sheet scrolls
Get Used Range
Find where the data on a sheet starts and ends. Worked out from cells that hold something, so a cell that was formatted and then emptied does not count
Protect Worksheet
Stop a sheet being edited by accident. This is not security: an Excel sheet password is trivially removed, so use it to protect a report from mistakes rather than to keep a secret