Keep the headings on screen while the rest of the sheet scrolls
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet |
Freeze mode | enum | Optional | topRow | —topRowfirstColumntopRowAndFirstColumnatCellnone |
Cell cell | string | Optional | — | Everything above and left of this cell stays put, such as B2 Shown when mode = atCell |
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
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
Hide Rows, Columns or Sheets
Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work
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