Explain freeze feature of spreadsheet .why is it used?
Answers
Freeze panes is a feature in spreadsheet applications, such as Microsoft Excel, LibreOffice Calc, and Google Sheets. It "freezes" a row or column, so that it is always displayed in place, regardless of what part of the spreadsheet is being displayed. When the user scrolls vertically or horizontally through an open spreadsheet, everything scrolls except the frozen row or column. Freezing panes is especially useful if your spreadsheet has a header row, that you want to always be visible.
How to use the freeze panes feature
Microsoft Excel 2010 and higher
Open the spreadsheet.
Click View.
In the View tab, click Freeze Panes and select the freeze option you want to choose. For example, choose Freeze top row to freeze the top row.
Earlier versions of Microsoft Excel and other spread sheet programs
Open the spreadsheet.
Using your mouse, highlight the entire row or column. For example, if you wanted to select row 1, click the row header 1.
Finally, select the Freeze pane option in the menu bar and choose the appropriate option.
Tip
You can also unfreeze the row or column by repeating the above steps.
Answer:
"freezes" a row or column, so that it is always displayed in place, regardless of what part of the spreadsheet is being displayed. ... Freezing panes is especially useful if your spreadsheet has a header row, that you want to always be visible.Nov 13, 2018