Freezing
and Unfreezing rows and columns
Freezing
locks number of rows at the top of a spreadsheet or number of columns on the
left of a spreadsheet or both. Frozen columns and rows remain the view during
scrooling, whereas other rows and columns gets scrolled.
1.
Click on the Header for the row
below where to the freeze or for the column to the right of where to freeze.
2.
Choose the Window -> Freeze. A
dark line appears, indicating where the freeze is put.
1.
Click the Cell that is immediately
below the row to be frozen and immediately to the right of the column to be
frozen.
2. Choose Window
-> Freeze.
3.
Two lines appear on the screen, a horizontal line above this cell and a
vertical line to the left of this cell. Now as you scroll around the screen,
everything above and to the left of these lines will remain in view.
To
unfreeze rows or columns, choose Window
-> Freeze. The check mark in Freeze will vanish.
Related Topics
Privacy Policy, Terms and Conditions, DMCA Policy and Compliant
Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.