Freeze rows and or columns in Calc

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 (in German [DE]):

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

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.

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.

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.

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

Here you will find the Documentation / Manuals:

For questions on this topic go to:

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

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.