Skip to content

Freezing rows and columns #784

@lgnch

Description

@lgnch

Is your feature request related to a problem? Please describe.
Users have requested the ability to freeze rows and columns

Describe the solution you'd like
The ability to select a row/column and then freeze the pain. This feature is already available in Libre office and it would be a nice feature to have in collabora online.

Describe alternatives you've considered
Google docs

Additional context
To freeze a row:
Locate the row or rows you want to freeze. In this example, we'll freeze the top two rows. Note: You do not need to select the rows you want to freeze.

Deciding which rows to freeze
Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of rows to freeze from the drop-down menu.

Freezing rows
The top two rows are frozen in place. You can scroll down your worksheet while continuing to view the frozen rows at the top.

The frozen rows
To freeze a column:
Locate the column or columns you want to freeze. In this example, we'll freeze the leftmost column. Note: You do not need to select the columns you want to freeze.

Choosing which column to freeze
Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of columns to freeze from the drop-down menu.

Freezing a column
The leftmost column is now frozen in place. You can scroll across your worksheet while continuing to view the frozen column on the left.

The frozen column
To unfreeze rows, click View, hover the mouse over Freeze, then select No rows. To unfreeze columns, click View, hover the mouse over Freeze, then select No columns.

Unfreezing a row

modifying_freeze_column_menu
modifying_freeze_column_result
modifying_freeze_column_select
modifying_freeze_no

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions