Validation Rule: Freeze

#EN #Excel #Validation

Updated over a week ago

Validation rule to use

In order to freeze a column (it won't move if you swipe your grid left and right), you will need to use the validation rule freeze or fixed.

Type of controls available with this keyword

Field

It is not possible to use this validation rule within a field.

Column

Use the 123 method to create a column control.

Keywords available with this validation rule

Important notes

  • You may freeze multiple columns.

  • However, it is important not to freeze too many at the same time, to avoid being unable to use your grids freely.
    It is important to review your freezed columns under the iPad version and the Windows version. The Windows version can display more columns, depending on the display resolution of your screen.

  • Freezed columns need to be following one another.
    If you wish to freeze a column, it has to be the first one in your grid.
    If you wish to freeze multiple columns, they have to be one next to the other.

  • Freezed columns won't show on the Paperless website.

  • You can not freeze all the columns in a single table.

Did this answer your question?