How to Freeze Rows in excel || Freeze Columns and Freeze panes Step by Step With Pictures

Freezing rows and columns has various advantages, Especially when working in the Excel table. The importance of freeze rows is to make the table easier to edit and read, it helps you to save time when working in Excel. In this article, we will cover, how to freeze rows, columns and freeze panes in Excel tutorials with pictures:

Idea 1: How to freeze the top row in Excel

Step 1: Select the  top row in your Excel sheet, That you wish to Freeze,

Step 2: Go to the 'View' tab in the ribbon at the top of the Excel window,

Step 3: Go to Freeze panes,

Step 4:  A dropdown menu will appear. Select the second option "Freeze Top Row" This option represents freeze top Row, your Excel's top rows have been frozen now. 

Look at the following picture for more practical information:

How to Freeze Rows in excel || Freeze Columns and Freeze panes Step by Step With Pictures

Idea 2: How to freeze two and more top rows in Excel

Step 1: Select the  top row in your Excel sheet, That you wish to Freeze,

Step 2: Go to the 'View' tab in the ribbon at the top of the Excel window,

Step 3: Go to Freeze panes,

Step 4: A dropdown menu will appear. Select the second option "Freeze Top Row" This option represents freeze top,

Step 5: Now put your cursor on the left hand "1" Then "right click", and a dropdown menu will appear, Click "Insert".

Now you have created a new row over the frozen row, And your two top rows have been frozen. If you want more freezer rows, follow "Step 5".

Look at the following picture for more practical information:

How to Freeze Rows in excel || Freeze Columns and Freeze panes Step by Step With Pictures

Idea 3: How to Freeze panes in Excel:

To freeze panes in Excel follow the following steps:

Step 1: Go to the 'View' tab in the ribbon at the top of the Excel window,

Step 2: Go to Freeze panes,

Step 3: A dropdown menu will appear. Select the first option "Freeze Panes".

 Look at the following picture for more practical information:

How to Freeze Rows in excel || Freeze Columns and Freeze panes Step by Step With Pictures


FAQ:

What is a freeze pane in Excel?

Sometimes we wish to freeze the top rows and first columns at a similar time, That time we can use "Freeze panes" which can freeze the top 6 rows and the first 3 columns at a similar time in Excel, which helps us to work in a long Excel sheet.

Conclusion

Now you know the tips and tricks to freeze rows, columns and freeze panes, Your next Excel project will be easily done. Thank you so much for reading.

Comments

Post a Comment

Popular posts from this blog

कार्यमुलक अनुसन्धानकाे नमुना | Action Research | प्रतिवेदन नमुना

Image
कार्यमुलक अनुसन्धान कक्षा ५ का विद्यार्थीहरुको सिकाइ उपलब्धि कम हुनका कारणहरुको अध्ययन   प्रस्तोतकर्ता .............. ..........................   परिच्छेद–एक   १ . १ अनुसन्धानको परिचय             विद्यार्थीहरुले विद्यालयमा विभिन्न किसीमका क्रियाकलापहरुको माध्यम बाट पूर्वनिर्धारीत उदेश्य अनुसार केहि न केहि ज्ञान , सिप र क्षमता प्राप्त गरिरहेका हुन्छन् । त्यसरी निश्चित सिपको क्षेत्रमा आर्जन गरेको ज्ञान , सिप , क्षमता , स्तर तथा दक्षता लाई विभिन्न परिक्षणका साधनबाट मापन गरिएको उपलब्धिलाइ सिकाइ उपलब्धि भनिन्छ । वालवालिकाले पाठ्यक्रम अतर्गत प्राप्त गरेको ज्ञान , सिप र क्षमतालाई उपलब्धि भनिन्छ ।  प्राथमिक विद्यालय तह विद्यार्थीको उच्च शिक्षाको आधार स्तम्भ को रुपमा रहेको छ । वर्तमान राष्ट्रिय पाठ्यक्रम प्रारुप २०६५ अनुसार प्राथमिक तहमा आधारभुत ज्ञाान तथा जिवनउपयोगी सिपको विकास गरि गुणात्मक शिक्षा प्रदान गर्न विद्यार्थी केन्द्रीत शिक्षण सिकाइ क्रियाकलापमा जोड दिइ अधिकत्तम व्यवहारीक सिकाइ उपलब्धि हासिल गर्ने लक्ष्य राखेको छ । निरन्तर विद्यार्थी मुल्याङ्कन अन्तर्गत सुधारात्मक सिकाइ , कमजोर विद
Read more

Aayush Singh Thakuri and Alizeh Jamali: A Cross-Border Love Story Blossoming on TikTok

Image
Alizeh Jamali & Aayush Singh Thakuri In a world where digital connections break down barriers, the remarkable love story of Aayush Singh Thakuri , a Hindu boy from Nepal, and Alizeh Jamali , a Muslim girl residing in Dubai from Pakistan, stands as a shining example of love that transcends borders and cultures. Their journey sparked on the virtual stage of TikTok, resonates with hearts worldwide, a tale that showcases the power of technology to unite souls, even across vast distances. First Meeting: Their initial encounter was one of serendipity, a live broadcast where they filtered and bantered with each other. Little did they know that this virtual encounter would lay the foundation for an extraordinary connection. As days turned into weeks, and weeks into months, their daily live interactions blossomed into a virtual companionship that held a magnetic charm for both of them. Alizeh's Journey to Nepal: The moment of destiny arrived when Alizeh, crossing borders and o
Read more

The religious conflict : what are factors that contribute to the violence?

Image
A religious conflict , commonly known as a religious war, refers to the  hostilities that can emerge between distinct religions, groups, or communities within a society. These conflicts often arise from a variety of sources, including longstanding rivalries, unresolved disputes, historical grievances, and differences in cultural norms and values. These conflicts can leave lasting scars on a society and impact its dynamics for generations to come. The phenomenon of religious conflicts has historical roots, and evidence suggests that such conflicts have been present throughout history, even in ancient times. Two Types of Religious Conflicts: 1.Internal Religious Conflict: Internal religious conflicts occur when differing opinions or religious beliefs within a single religious lead to conflict. These conflicts can vary in intensity and duration. They might arise from disagreements over religious practices, cultural traditions, or even the interpretation of religious roles and respons
Read more