Question

what do you mean by freeze and unfreeze of rows​

Answer 1

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.

Freezing panes could hide rows or columns, or cause the column headings to always be visible even after scrolling.

To unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panesoption in the popup menu

Answer 2

Freeze and unfreeze of rows option is described below:

• Freezing and unfreezing of particular cell or group of cells is a feature available in Microsoft Excel or spreadsheets.
• By activating the "freeze" option in a spreadsheet, it enables the view of frozen cells even if the user scrolls up down or through left-right in the worksheet.
• This option is useful when we require a certain herder, heading, or title cells to be observable while we scroll.
• The excels provides different types of freezing options including freezing pane, freezing the topmost row, or freezing the first column.
• Unfreezing of selected cells deactivates the "freeze" feature and turn them back to normal mode.
• Hence, rows are frozen and unfroze for the above-stated purpose.