How to Freeze Panes in MS-Excel?
Freezing panes in MS Excel is a feature that allows you to keep specific rows or columns visible while you scroll through your worksheet. This is particularly useful when working with large datasets, as it helps to maintain context, especially when dealing with header rows or important reference columns. Freezing panes ensures that the key information remains in view, even as you navigate through different sections of the spreadsheet.
To freeze panes in Excel, you can follow a few simple steps, and the feature can be applied in different ways depending on your specific needs: freezing the top row, freezing the first column, or freezing both rows and columns simultaneously. Below are the methods and steps for freezing panes in Excel:
1. Freezing the Top Row:
Freezing the top row is a common practice when dealing with datasets where the first row contains headers or important labels. To freeze the top row, follow these steps:
- Open your Excel workbook.
- Go to the "View" tab on the ribbon.
- In the "Window" group, click on "Freeze Panes."
- From the drop-down menu, select "Freeze Top Row."
- After this, when you scroll down the worksheet, the top row will remain visible,
________ __________ ___ _________ _______ ____ __________ _______ _____ _____.
______ _______ ___ ________ _______ _______.
_____ ________ _________ _______ _______ _______.
____ ___ ________ __________ _________ _____ _______ __________ __________.
______ _____ ________ ___ _________ ________ __________ _______ _______ ________.
_________ ______ __________ ____ _______ ___ ______ ____ _______.
___ _________ _________ _______ _____ __________ ________ _____.
_____ ________ ___ __________ _________ ___.
________ _____ ____ ___ _________ ______ _________.
________ ______ _________ _____ ____ ________.
______ ___ _________ ___ ________ ____ _________ __________.
_______ ___ _______ _______ _________.
______ __________ _______ ________ ____ ________ __________.
_________ ________ ______ __________ __________ ________.
________ __________ _______ __________ ________ ____ _________ ________ ____.
______ __________ ______ ___ ______ __________.
______ ___ _______ ___ _________.
_________ _____ ________ ________ ________ _____ _______ ________ __________.
___ ________ ____ __________ _____ ___ ____.
________ ______ ______ ______ _________.
____ _______ _______ ___ ______ __________ ___.
_____ ____ ____ ______ _________ ________ ________.
________ _____ ____ ___ _________ ________.
___ _________ __________ _________ __________ ______ _______ ________.
________ ________ _______ ______ __________ ____ ________ ________ _____.
________ ____ __________ ___ _______.
__________ _______ ___ ________ __________ _____ ___.
___ _____ ______ ___ _____ ______ _____ __________ ________ _____ __________ _____.
_________ ________ ______ _________ __________.
_______ ____ ____ _____ _____ ___ _______ _______ ________.
____ ____ ___ _____ ________.
_____ _____ __________ _____ ____ _________ __________ ______ _________ _______.
___ ______ ____ _____ _______ ________ ______.
_________ ___ ___ ____ _________ ___ __________ ______ ___.
___ _________ __________ ___ __________ __________ ______.
_______ _______ ______ _________ _______ ____ __________ _____.
_____ _________ __________ ______ _______ ________ ______ __________ ______.
_______ ____ _______ _______ ______ ___ ______.
_______ ______ _______ __________ _________ _________ ____ __________ _____.
_____ ___ _________ ____ __________.
____ ___ _____ _____ ____ ________.
_______ _______ ________ ______ ______ ___ __________ _____.
______ ______ _______ _________ ___ _____ ____ ________ _________.
___ _______ ___ _________ _______ __________ ____ ____ _______.
__________ __________ ____ ________ _________ ___ ___ _____ ____ ______ __________.
_____ ___ ____ ________ __________ ____ ________ ___ ______.
__________ ______ ______ _________ __________ ______ _______ _________ ___ ______ ______ ________.
______ _____ _________ _____ _____ ________ ______ ___ __________ _________ _________.
__________ _____ _____ ________ ______ ______ ______ ______ _________.
______ ___ ____ __________ _________ ___ ______ _______ _________ __________.
_________ __________ ________ ________ ______ _______ _____ _____ _______.
______ _________ ______ ________ ______ ___ _________.
__________ __________ ______ _________ ___.
____ _______ _____ ____ _____.
___ ___ ____ _____ _____ _________ _______.
_________ ________ ___ ___ _______ ______.
_____ ____ ___.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required