What is Freeze Panes in MS-Excel?

To lock any row or column, freeze panes is used. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.

Asked on February 23, 2019 in Excel.
Add Comment


  • 2 Answer(s)

    Freeze panes is a feature in spreadsheet applications, such as Microsoft ExcelLibreOffice 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.

    Answered on February 23, 2019.
    Add Comment

    Freeze panes is a feature in spreadsheet applications, such as Microsoft ExcelLibreOffice 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.

    Answered on June 14, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.