4.19 Freezing panes (फ़्रीज़िंग पेन्स)

Whenever you’re working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, such as the ability to freeze panes and split your worksheet.

जब भी आप एक्सेल में बहुत अधिक डेटा के साथ काम कर रहे हों, तो आपकी वर्कबुक में जानकारी की तुलना करना मुश्किल हो सकता है। सौभाग्य से, एक्सेल में कई उपकरण शामिल हैं जो एक ही समय में आपकी वर्कबुक के विभिन्न हिस्सों से कंटेंट को देखना आसान बनाते हैं, जैसे कि पैन को फ्रीज करने और अपनी वर्कशीट को विभाजित करने की क्षमता आदि।

Freeze Top Row: To freeze the top row, execute the following steps.

Step 1: On the View tab, in the Window group, click Freeze Panes. Click Freeze Top Row. Step 2: Scroll down to the rest of the worksheet. Result: The top row remains visible while scrolling through the rest of the worksheet.

Unfreeze Panes: To unlock all rows and columns, execute the following steps.

Step 1: On the View tab, in the Window group, click Freeze Panes.

Step 2: Click Unfreeze Panes. Result: Unlock all rows and columns to scroll through the entire worksheet.

Freeze Panes: To freeze panes, execute the following steps.

Step 1: Select row 3. On the View tab, in the Window group, click Freeze Panes.

Step 2: On the View tab, in the Window group, click Freeze Panes -> Freeze Panes.

Step 4: Scroll down to the rest of the worksheet. Result: All rows above row 3 are frozen.

Note: To keep columns visible while scrolling to the right of the worksheet, select a column and click Freeze panes.

Step 5: Select cell C3 (unfreeze panes first).

Step 6: On the View tab, in the Window group, click Freeze Panes -> Freeze Panes.

Result: The region above row 3 and to the left of column C is frozen.