How to Freeze Panes in MS-Excel?

In Microsoft Excel, freezing panes is a useful feature that allows users to keep certain rows or columns visible while scrolling through large datasets. This is particularly helpful when working with long spreadsheets where you need to keep headers, labels, or other important information in view as you navigate through the data. Freezing panes ensures that crucial information remains accessible and readable, improving the user experience and efficiency when working with extensive data.

### Steps to Freeze Panes in MS Excel

1. Open the Excel Workbook: Begin by opening the Excel workbook where you want to freeze panes. Make sure the worksheet is loaded and ready for modification.

2. Select the Cell Where You Want to Freeze Panes: The key to freezing panes in Excel is selecting the right cell. The cell you select will determine which rows and columns get frozen. For example, if you want to freeze the first row and the first column, you should select the cell in the second row and second column (B2). 

   - To freeze the top row only, select any cell in the second row.
   - To freeze the first column only, select any cell in the second column.
   - To freeze both the top row and the first column, select cell B2.

3. Go to the View Tab: Once you have selected the appropriate cell, navigate to the View tab at the top of the Excel window. This tab contains the options related to worksheet viewing, including the Freeze Panes option.

4. Click on Freeze Panes: In the Window group under the View tab, click on the Freeze Panes button. This will display a dropdown menu with three options:
   - Freeze Panes: This will freeze both the rows above and columns to the left of the selected _____ ___ ____ __________ _____ ______ _____ ___.
___ _____ ____ _______ ________ _____ ______ ____ __________.
_________ _____ _____ ________ ________ ______.
______ ______ _________ __________ ________ _________.
_______ _______ ____ ______ ______ _____.
_______ ___ ___ _______ __________ ____ ___.
___ _______ ________ ____ _______ ____.
_______ ____ ___ ___ _________ ______ __________ ____ ___.
_________ _______ ____ ____ _______ ____ _____ __________.
_______ _____ ________ _________ _______ __________ ____.
___ ________ ________ _______ _______ ____ ________.
____ ____ _______ __________ ____ _____ ____ ______ __________ ________ ___ __________.
______ _________ ________ __________ _________ ___ ______.
________ ___ ________ ________ ________ __________ _____ _____ __________.
___ _______ ____ ______ _______ _________.
________ __________ __________ _____ __________ ___.
___ _____ ______ __________ ____ _____ ________ _______ _______ _____ ________.
_____ _________ __________ ___ ______ _______.
__________ __________ ___ ____ ___ ________ ________ _____.
_______ _____ ________ ___ ___ ________ ______ _____ _________ _________.
______ ___ _____ _______ _________ ________ _______ ______ ________.
____ __________ ____ _______ __________ ________ _____.
______ ____ ____ _________ ______ _______ ______ ____ _______ ________ __________ ____.
________ _________ _____ _____ _______.
__________ ____ _________ __________ ____ _____ _____ ______ _______ __________ _____ ____.
_____ ________ ____ ________ _______ __________ _________ _________ ____ ______.
_____ _______ _____ __________ ____ __________.
_____ __________ ___ _____ ____ __________ __________ _______ _____ __________ _____.
___ _______ __________ _____ _______ ___ _________ ___ ____ ____ ___ _____.
____ ________ _________ ___ ______ ____ ________ _______ ____ ______ ___.
____ ___ ____ ___ _______ ________ _________.
______ ____ ___ ___ __________ ___ ____ __________ __________.
__________ ______ _______ ________ ___ ______ ______ ___ _________.
_____ ____ ______ _______ __________ _____ ________ ________.
_________ ___ __________ _____ ___ _____ _________ ___ ________ ________.
_________ ________ ______ __________ _________ ________ _______ ______ _______ _______ _____.
_________ ________ ______ ______ _______ ____ ______ ________ _________ __________.
__________ __________ _______ ____ _________ __________ __________ ___.
________ _________ ____ _________ __________ ________.
___ ______ ________ _______ _____.
__________ __________ ________ ______ ________ ______ __________.
_________ _______ __________ ________ __________.
_______ ________ _____ __________ __________ _____ _____ ___ ________ ____ ____.
___ _______ _____ ______ _____ ________ ______ _________ ____ __________ __________ _______.
___ ______ _______ ________ _______ ________ ____ __________.
_________ ________ ________ ______ _________ _________ ______ ________.
__________ ____ __________ ___ _________ ____.
____ ____ ____ ____ _________ ________ ___.
____ _______ _______ __________ ________.
_____ ______ __________ ______ ___ _________ _______ _______ ________ _______ ________.
_______ ___ ______ _____ ___ ____ ______ _________.
___ __________ _______ _____ __________.
__________ __________ ________ ________ _________ ____ ______ ____ ____.
__________ _______ ___ _______ ____.
_________ _________ ____ _________ __________ _______ ____ __________ ______.
__________ ___ ___ ____ _____ _____ ______ ____ __________.
________ __________ ____ __________ _______ ____ ________ _____ ___.
_________ _____ ____ _______ _______ __________ _____ _____.
______ _______ ______ ____ ______ ______ __________ ____ ______ _____ ___.
_____ _____ __________ ________ ____ ______ ___ ____ _________.
_________ ____ _____ ________ __________ _____ _____ _________ ________ ___.
______ ____ ______ _____ _______ ______ ____ ___ ______ ___.
______ _______ ______ __________ _______ _______ ___ _______ ____ ______ _______ _________.
_______ ___ __________ ____ ______ ___ __________ __________ _________ ______ _____ ______.
_________ __________ _____ ________ _______.
__________ _______ ___ _________ _________ ________ ________ ____ ______ _________.
_________ ______ ______ ___ _________ ______ ____ ____ ______ _____.
_____ ___ ________ _________ _______.
____ ___ __________ ___ ________ ______ __________ _____.
________ ________ _______ __________ __________ _________ ______.
___ _____ ____ ______ ________ ______ _____ ______.
___ ________ ______ ____ ________ ____.
__________ ______ ________ __________ __________ ___ ________ _____ __________ _______ __________ __________.
_________ ________ ___ _____ __________ ______ ___ ____ _______.
________ ______ __________ ___ _____ ___ _____ _______.
__________ __________ ___ _________ ______ ___ _____ ________ ___.
__________ ___ ________ _________ __________ __________ _______ __________ __________ ______ _____.
_________ _______ _______ ___ ______ ____ _________ ______ ____ ___ _______ _____.
_______ ________ _________ _____ _________.
_____ ________ ___ ___ _______ _______ _________ _________.
____ ______ ____ __________ ___ _______ _________ ___ _________ __________ ______ ___.
________ _____ ___ ___ ___.
_________ ___ ______ _________ ____ ____ ___ ____ ___ ______.
________ _______ ________ __________ ______.
_______ ________ __________ _________ _______ _______ ________.
__________ ________ ___ ____ __________ ______ ______ ______ _________ ____ ______ ___.
_________ __________ _________ _________ _________ _______ __________ ________ _______ ____.
______ ___ _______ ___ ____ _____ _____ ________ __________ _____ __________ ____.
_____ _______ _______ ______ ___ __________ ___ ________ ___ __________ _____ ______.
________ _________ ________ _____ ____ _______ ____ _____.
________ ______ ____ ______ __________ __________ ___ ______ ___ __________.
__________ _________ _____ ___ _______ _____ ________ _________.
_______ ___ ____ ____ __________ _________ _________ _____.
_________ __________ ________ _______ ____ ___ _________ _____ __________ ______ _______ _________.
___ ________ __________ _______ ___ _______.
______ ________ ____ ____ ___ ____ ___ __________ ___.
_________ _____ ______ ______ ________ ______.
__________ ___ _______ ____ ______ _________ ____ __________ _______.
______ __________ _________ _______ ________ ___ _____.
_____ ________ __________ ____ _____ ____ ______ ________ ____.
________ __________ _______ ______ ____ ___ _____ _________.
_____ ________ ____ __________ ________ ___ ___ ___.
______ ________ _______ _____ ___ __________ __________ _____ ___ _____.
__________ ________ ___ ___ _________.
__________ _________ ______ __________ ________ _______ _____ ___ _____ ___ _________ _______.
_____ ______ _________ __________ ______ ______ _________ _______ _________ _____ ____ ______.
_________ __________ ______ _________ ___.
_____ _________.
Get Full Answer on WhatsApp