Freeze rows and or columns in Calc

    From The Document Foundation Wiki
    Other languages:

    Foreword

    Rows and Columns frozen
    View ▸ Freeze Cells menu

    The video "Freeze Rows and or Columns in Calc - LibreOffice" links to this page, which contains further information.

    Link to the Video

    Link to the Video (in German [DE]):

    Zeilen und/oder Spalten fixieren in Calc – LibreOffice

    Open file

    Open calc and the file "20200611_Housekeeping book in Calc.ods".

    - Work files -

    Position the cursor

    For freezeing, the cursor must first be placed in the correct cell.

    All columns to the left of the selected cell and all rows above the selected cell are frozen.

    In these example, you place the cursor in cell C3.

    Then row 1+2 and column A+B are frozen.

    Freeze rows and columns

    Starting from this cell, the rows and columns are frozen then to the left and top of it.

    In the View menu you can choose between Freeze Rows and Columns or Freeze Cells.

    Select Freeze Rows and Columns.

    View frozen rows and columns

    If you now scroll down, the lines 1 and 2 are frozen.

    And if you move the horizontal scroll bar to the right, columns A and B remain frozen.

    Remove the Frozen

    The Frozen can be canceled again with View ▸ Freeze Rows and Columns.

    Further Informations

    Work files

    20200611_Housekeeping book in Calc.ods

    Documentation / Manuals

    Here you will find the Documentation / Manuals:

    Documentation / Manuals

    Any questions?

    For questions on this topic go to:

    Ask.LibreOffice

    Get Involved

    Join us today and help us to make it even better!

    Get Involved

    LibreOffice is Free Software and is made available free of charge.

    Your donation, which is purely optional, supports our worldwide community.

    If you like the software, please consider a Donation.