Click the
View settings icon in the upper right corner of the top toolbar, or go to the View tab, or right-click the selected cell to open the contextual menu. 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.
By default, a subtle green line shows where a frozen column and/or rows starts. To disable or enable it, go to View tab, click the Freeze Pane button, and click Show frozen panes shadow. The Show frozen panes shadow option is also available on the View settings menu on the right side of the top toolbar.
When the Show frozen panes shadow is disabled, a horizontal or vertical gray line shows the frozen columns or lines. The areas above and to the left of these lines are locked. Now you can scroll your worksheet to make sure that all the necessary data remain visible.
To unlock the previously frozen rows and columns, just open the
View settings menu and click the Freeze Panes option once again, or right-click anywhere within the worksheet and select the Unfreeze Panes option from the context menu, or go to the View tab, click the Freeze Panes button and select the Unfreeze Panes option.