Videos/Freeze rows and or columns in Calc

Foreword




The video "Freeze Rows and or Columns in Calc LibreOffice 6.4" 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 6.4

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 fixed.

In these example, you place the cursor in cell.

Then row +  and column  +  are fixed.

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

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

Select.

View frozen rows and columns
If you now scroll down, the lines  and   are freezed.

And if you move the horizontal scroll bar to the right, columns  and   remain freezed.

Remove the Freezing
The Freezing can be canceled again with.

- up -

Work files
[[Media:20200611_Housekeeping book in Calc.ods|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

Donate
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.