Help Centre › Building Processes
This article describes the RPA Excel functionality to freeze panes.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Freeze panes function allows you to freeze panes.
Setting it up
To use the EXCEL Freeze panes function, follow these instructions:
{{popups:rpas/add:action=excel-freeze}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Freeze panes function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Freeze panes option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Cell | Yes | Text | - | The cell reference to freeze panes at (e.g. B2) |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Invalid cell | The cell reference is not valid |
Tips
- Rows above and columns to the left of the specified cell are frozen
- Use A2 to freeze the header row