To disable or enable it, go to View tab, click the Freeze Pane button, and click Show frozen panes shadow.

Select the Freeze Panes option in the menu and choose one of the available presets: Freeze Panes (depends on the previously selected cell), Freeze Top Row, and Freeze First Column.īy default, a subtle green line shows where a frozen column and/or rows starts. To freeze two rows on the top and two columns on the left at the same time, select cell C3.To freeze the first column and the top row of the worksheet simultaneously, select cell B2,.To freeze multiple columns on the left, select the column to the right of the last column you want to lock,.To lock the left-most column only, select cell B1 / the entire column B, or use the Freeze First Column option available in the Freeze Panes drop-down menu on the View tab,.

To freeze multiple rows on the top, select the row below the last row you want to lock,.

To lock the top-most row only, select cell A2 / the entire row 2, or use the Freeze Top Row option available in the Freeze Panes drop-down menu on the View tab,.

Here you can see a number of simple examples explaining which cell, row or column should be selected to freeze certain rows or columns or both rows and columns at once: Select the cell located below the row you want to lock and to the right of the column you want to lock.

How to lock cells in openoffice excel