EXCEL Freeze panes function

The EXCEL Freeze panes function in RPA.

Help CentreBuilding 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:

  1. Navigate to the process where you would like to add the EXCEL Freeze panes function
  2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
  3. On the menu that appears, click on the “+ Activity” item
  4. From here you can select the EXCEL Freeze panes option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
CellYesText-The cell reference to freeze panes at (e.g. B2)

Output variables

This action does not produce output variables.


Errors

ErrorDescription
File not openThe Excel file must be open
Invalid cellThe 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

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.