Microsoft Excel wuxuu kaa caawinayaa inaad habayso oo aad ku falanqayso xog balaadhan^{(organize and analyze extensive data)} oo software-keeda ah. Waxay ka ciyaartaa door muhiim ah oo ka bilaabma warshado yaryar ilaa warshado baaxad leh. Isticmaalayaashu waxay samayn karaan falanqayn maaliyadeed iyagoo isticmaalaya qalabkan xog ururinta ee xoogga leh. Waxay bixisaa codsiyo badan sida falanqaynta ganacsiga, maamulka dadka, maaraynta barnaamijka, falanqaynta istiraatiijiyadeed, ujeedooyinka maamulka, xakamaynta hawlgalka, iyo warbixinta waxqabadka. Si kastaba ha ahaatee, waxaa inta badan loo isticmaalaa in lagu kaydiyo oo lagu kala saaro xogta^{(mainly used to store and sort data)} si sahlan loo falanqeeyo. Microsoft Excel 2016 iyo 2019 waxay taageerayaan sifo aad ku qaboojin karto safka gudaha Excel . Sidaa awgeed^(Hence), marka aad kor ama hoos u rogto, muraayadaha barafaysan waxay ku harayaan isla meel. Tani waxay ku imanaysaa anfaca markaad haysato xog daboolaysa safaf iyo tiirar badan. Maanta, waxaan ka wada hadli doonaa sida loo qaboojiyo ama loo furo safafka, tiirarka ama muraayadaha MS Excel .

How to Freeze/Unfreeze Rows or Columns in MS Excel

1048576 saf & 16,384 ^{(1048576 rows & 16,384)} tiir ee Excel^{(columns in Excel )} waxay u kaydin karaan xog xad dhaaf ah oo habaysan. Astaamaha kale ee xiisaha leh ee Excel waxaa ka mid ah:

• shaandhaynta xogta,
• Kala soocida xogta,
• Soo hel oo beddel sifada,
• Nadiifinta la dhisay,
• Miiska gunta,
• Ilaalinta erayga sirta ah, iyo qaar kaloo badan.

Intaa waxaa dheer, waxaad ku qaboojin kartaa safaf badan ama tiirar gudaha Excel. Waxaad barafaysan kartaa qayb ka mid ah xaashida safafka, tiirka ama muraayadaha Ecel si aad u muujiso inta aad dhex dhex mareyso xaashida inteeda kale. Tani waxay faa'iido u leedahay hubinta xogta qaybaha kale ee xaashida shaqada adiga oo aan lumin madaxyadaada ama calaamadahaaga. Sii wad akhrinta si aad u barato sida loo qaboojiyo ama loo furo safafka, tiirarka ama muraayadaha Microsoft Excel .

Eray bixin Muhiim ah ka hor inta aanad bilaabin
^{(Important Terminology Before You Begin )}

• Qaboojiya Muraayadaha:^{(Freeze Panes: )} Iyada oo ku saleysan xulashada hadda, waxaad ku hayn kartaa safafka iyo tiirarka kuwa muuqda inta warqadda shaqada inteeda kale kor iyo hoos u soo duuduubo.
• Qabo Safka Sare:^{(Freeze Top Row: )} Habkani wuxuu noqon doonaa mid waxtar leh haddii aad rabto inaad qaboojiso kaliya safka hore ee madaxa/sare. Doorashadani waxay ilaalin doontaa safka sare mid muuqda, waxaadna ku dhex wareegi kartaa inta ka hartay xaashida shaqada.
• Qabo Tiirka Kowaad:^{(Freeze First Column: )} Waxaad ka dhigi kartaa tiirka kowaad mid muuqda inta aad ka dhex wareegi karto inta ka hartay xaashida shaqada.
• Daaqadaha fur:^{(Unfreeze Panes: )} Waxaad furi kartaa dhammaan safafka iyo tiirarka si aad ugu dhex gudubto dhammaan xaashida shaqada.

Xulashada 1: Sida loo qaboojiyo safka gudaha Excel^{(Option 1: How to Freeze a Row in Excel)}

Waxaad ku qaboojin kartaa saf gudaha Excel ama waxaad ku qaboojin kartaa safaf badan gudaha Excel adiga oo raacaya tillaabooyinka hoos ku xusan:

1. Riix furaha Daaqadaha^(Windows) . Ku qor & raadi Excel oo ku dhufo si aad u furto.

2. Fur xaashida Excel ee^{(Excel sheet)} aad rabto oo dooro saf ^(row)kasta^{( any)} .

Xusuusin 1:^{(Note 1:)} Had iyo jeer dooro safka ka hooseeya safka^{(below the row)} aad rabto inaad qaboojiso. Taas macnaheedu waa haddii aad rabto in aad barafowdo ilaa safka 3aad, waa in aad doorataa safka 4aad.

3. Dabadeed, dooro View in bar menu sida ka muuqata.

4. Guji barafyada qaboojiyaha^{(Freeze Panes)} > barafyada qaboojiyaha^{(Freeze Panes)} ee liiska hoos-u-u-dhaca ah sida hoos ku sawiran.

Dhammaan safafka ka hooseeya safka la doortay waa la barafayn doonaa^{(All the rows below the selected row will be frozen)} . Safafka ka sarreeya unugga/ safafka la doortay waxay joogi doonaan isla meel markaad hoos u rogto. Halkan tusaale ahaan, markaad hoos u rogto, safka 1, safka 2, safka 3 wuxuu ahaan doonaa isla meel iyo inta kale ee warqadda shaqada.

Sidoo kale akhri: ^{(Also Read:)} Sida loo koobi karo oo loo dhajiyo qiyamka iyada oo aan la helin qaabab ku jira Excel^{(How to Copy and Paste Values Without formulas in Excel)}

Xulashada 2: Sida loo qaboojiyo safka sare ee Excel^{(Option 2: How to Freeze Top Row in Excel)}

Waxaad ku qaboojin kartaa safka madaxa xaashida shaqada adoo raacaya tillaabooyinka la bixiyay:

1. U bilow Excel sidii hore.

2. Fur xaashida Excel^{(Excel sheet)} oo dooro unug ^(cell)kasta^{( any)} .

3. U beddel View tab xagga sare sida ka muuqata.

4. Guji barafyada qaboojinta^{(Freeze Panes)} > Qabo safka sare^{(Freeze Top Row)} sida muuqata.

Hadda, safka hore ee ugu horreeya waa la qaboojin doonaa, inta ka hartay xaashida shaqadana si caadi ah ayay u rogrogmi doontaa.

Sidoo kale akhri: ^{(Also Read:)} Hagaaji Outlook App ma furmi doono Windows 10^{(Fix Outlook App Won’t Open in Windows 10)}

Xulashada 3: Sida loo qaboojiyo tiirka gudaha Excel^{(Option 3: How to Freeze a Column in Excel)}

Waxaad ku xayiri kartaa tiirar badan ama hal tiir gudaha Excel sida soo socota:

1. Riix furaha Daaqadaha^(Windows) . Ku qor & raadi Excel oo ku dhufo si aad u furto.

2. Fur xaashida Excel^{(Excel sheet)} oo dooro tiir ^(column)kasta^{( any)} .

Xusuusin:^(Note:) Had iyo jeer dooro tiirka ku habboon ^{(to the)}tiirka ^(right) aad^(column) rabtay inaad qaboojiso. Taas macnaheedu waa haddii aad rabto inaad qaboojiso tiirka F, dooro tiirka G iyo wixii la mid ah.

3. U beddel View tab sida hoos ku cad.

4. Guji barafyada qaboojinta^{(Freeze Panes)} oo dooro baraf qaboojinta^{(Freeze Panes)} sida ku cad.

Dhammaan tiirarka bidix ee tiirka la doortay waa la barafayn doonaa^{(All the columns left of the selected column will be frozen)} . Markaad midig u guurto, safafka bidix ee tiirka la doortay waxay joogi doonaan isla meel. Halkan tusaalahan, markaad midig u rogto, tiirka A, tiirka B, tiirka C, tiirka D, tiirka E, iyo tiirka F waxay joogi doonaan isla meel, inta kale ee xaashida shaqada waxay u guuri doontaa bidix ama midig.

Xulashada 4: Sida loo qaboojiyo Tiirka Koowaad ee Excel^{(Option 4: How to Freeze First Column in Excel)}

Waxaad ku qaboojin kartaa tiirka Excel , tusaale ahaan, qabooji tiirka koowaad ee xaashida shaqada adiga oo raacaya tillaabooyinka hoose.

1. U bilow Excel sidii hore.

2. Fur xaashida Excel^{(Excel sheet)} oo dooro unug ^(cell)kasta^{( any)} .

3. U beddel View tab xagga sare sida muuqata.

4. Guji barafyada qaboojinta^{(Freeze Panes)} oo markan, ka dooro Freeze First Column option ka menu-hoosaadka.

Sidaa darteed, tiirka koowaad waa la barafoobayaa, halkaas oo aad si caadi ah ugu dhex wareegi karto inta ka hartay xaashida shaqada.

Sidoo kale akhri: ^{(Also Read:)} Hagaaji Microsoft Office oo aan furnayn Windows 10^{(Fix Microsoft Office Not Opening on Windows 10)}

Xulashada 5: Sida loo qaboojiyo baakadaha gudaha Excel^{(Option 5: How to Freeze Panes in Excel)}

Tusaale ahaan, haddii aad xogta ku gelayso kaadhka warbixinta oo ay ku jiraan magacyada ardayda iyo calamadaha, had iyo jeer waa shaqo aad u dhib badan in aad u rogto madaxa (oo ay ku jiraan magacyada maadada) iyo calaamadda (ay ku jiraan magaca ardayda) inta badan. Xaaladdan, qaboojinta labada saf iyo tiirarka ayaa ku caawin doona. Waa kan sida loo sameeyo isla:

1. U bilow Excel sidii hore. Fur xaashida shaqada ee aad ^(worksheet)rabto^(desired) oo dooro unug^(cell) kasta .

Xusuusin 1:^{(Note 1:)} Had iyo jeer hubi inaad dooratid unug dhanka midig ee tiirka oo ka hooseeya safka^{(right of the column and below the row)} aad rabto inaad qaboojiso. Tusaale ahaan, haddii aad rabto inaad qaboojiso safka koowaad & tiirka koowaad^{(first row & first column)} , dooro unugga dhanka midig ee shayga tiirka koowaad oo ka hooseeya shafka safka koowaad, ie, dooro unugga B2^{(select B2 cell)} .

2. Guji tab View oo ka soo baxa ribbon sare.

3. Guji barafyada qaboojinta^{(Freeze Panes)} sida muuqata.

4. Dooro ikhtiyaarka calaamadeysan barafyada qaboojinta^{(Freeze Panes)} sida hoos lagu muujiyey.

Dhammaan safafka ka sarreeya safka la xushay iyo dhammaan tiirarka dhanka bidix ee tiirka la doortay waa la barafoobayaa, xaashida shaqada inteeda kalena waa ay duubi doontaa. Haddaba halkan, tusaale ahaan, safka koowaad iyo tiirka kowaad waa la barafoobay, inta kale ee xaashida shaqadu waxay u duuduubtaa sida hoos ku cad.

Sida Loo Furo Safka, Tiirarka, ama Saqafka gudaha Excel^{(How to Unfreeze Rows, Columns, or Panes in Excel)}

Haddii aad qaboojisay saf, tiirar, ama muraayado, ma samayn kartid tallaabo kale oo qaboojin ilaa laga saaro mooyee. Si aad u furto safafka, tiirarka, ama muraayadaha Excel , hirgeli tillaabooyinkan:

1. Dooro unug kasta^{( any cell)} oo ku jira xaashida shaqada^(worksheet) .

2. U gudub View tab.

3. Hadda, dooro barafyada qaboojiyaha oo dhagsii furaha Unfreeze ^{(Unfreeze Panes)}sida^{(Freeze Panes)} hoos ku sawiran.

Fiiro gaar ah: ^(Note:) Hubi^(Make) inaad haysato unug/ saf/column xaalad barafaysan. Haddii kale^(Otherwise) , ikhtiyaarka ah in aan baraf^{(Unfreeze Panes )} laga dhigin ma muuqan doonto.

Sidoo kale Akhri: ^{(Also Read:)} Sida Loo Joojiyo Kooxaha Microsoft Furitaanka Bilowga^{(How to Stop Microsoft Teams from Opening on Startup)}

Talada Pro: Sida loo Abuuro Button Barafka Sixirka^{(Pro Tip: How to Create Magic Freeze Button)}

Waxa kale oo aad ka dhex abuuri kartaa badhanka qaboojinta/furista sixirka gudaha aalada Helitaanka Degdegga ah^{(Quick Access toolbar)} si aad u qaboojiso safka, tiirka, tiirka kowaad, safka kowaad, ama muraayadaha hal gujis.

1. U bilow Excel sidii hore.

2. Guji falaarta hoose^{(down arrow)} , ee lagu muujiyay, xaga sare ee xaashida shaqada.

3. Guji amarro badan^{(More Commands)} sida ku cad.

4. Dooro barafyada qaboojinta^{(Freeze Panes)} liiska ka dibna dhagsii Add .

5. Ugu dambeyntii, dhagsii OK . Daaqadaha ^(Freeze) Qabo Ikhtiyaarka ^(Panes) Helitaanka Degdegga^{(Quick Access)} ah ayaa laga heli doonaa xagga sare ee xaashida shaqada ee MS Excel .

Su'aalaha Inta Badan La Isweydiiyo (FAQs)^{(Frequently Asked Questions (FAQs))}

Q1. Waa maxay sababta ikhtiyaarka barafyada barafku xaashidayda ugu cirroobay?^{(Q1. Why is the Freeze Panes option greyed out in my worksheet?)}

Jawaab. ^(Ans.)Ikhtiyaarka barafyada qaboojiyaha waa la cirray^{(Freeze Panes)} marka aad ku jirto qaabka tafatirka^{( in editing mode)} ama xaashida shaqada waa la ilaalinayaa^{(worksheet is protected)} . Si aad uga baxdo habka tafatirka, taabo furaha Esc^{(Esc key)} .

Q2. Sideen u xidhi karaa unugyada Excel intii aan la qaboojin lahaa?^{(Q2. How can I lock cells in Excel instead of freezing them?)}

Jawaab. ^(Ans.)Waxaad isticmaali kartaa kala qaybsanaanta^(Split) liiska View si aad u kala qaybiso oo aad u xidho unugyada. Haddii kale, waxaad samayn kartaa miiska Ctrl + T T. Samaynta miis waxay xidhi doontaa madaxa tiirka markaad hoos u dhaadhacdo. Akhri hagahayaga sida loo xidho ama loo furo unugyada Excel^{(How To Lock Or Unlock Cells In Excel)} .

lagu taliyay:^{(Recommended:)}

• Sida loo hubiyo inta VRAM ah ee aan ku haysto Windows 10^{(How to Check How Much VRAM Do I Have on Windows 10)}
• Sida Loo galo Xarunta Maamulka ee Kooxaha Microsoft^{(How to Access Microsoft Teams Admin Center Login)}
• Sida loo beddelo tiirarka ama safafka gudaha Excel^{(How to swap columns or rows in Excel)}
• Sida Loo Isticmaalo Calaamadaha Qarsoon ee Kooxaha Microsoft^{(How to Use Microsoft Teams Secret Emoticons)}

Waxaan rajeyneynaa in hagahan uu waxtar lahaa, oo aad awooday inaad qaboojiso oo aad ka saarto safafka, tiirarka ama muraayadaha Excel. ^{(freeze and unfreeze rows, columns or panes in Excel. )}Xor baad^(Feel) u tahay inaad nala soo xidhiidho su'aalahaaga iyo soo jeedintaada adigoo isticmaalaya qaybta faallooyinka ee hoose.

How to Freeze Rows and Columns in Excel

Microsoft Excel helps you to organize and analyze extensive data with its spreadsheet software. It plays a vital role starting from a small-scale industry to a large-scale industry. The users can perform financial analysis with this powerful data organization tool. It offers a heap of applications like business analysis, people management, program management, strategic analysis, administration purposes, operation control, and performance reporting. However, it is mainly used to store and sort data for easy analysis. Microsoft Excel 2016 and 2019 support a feature by which you can freeze a row in or a column in Excel. Hence, when you scroll up or down, the frozen panes remain in the same place. This comes in handy when you have data covering multiple rows and columns. Today, we will discuss how to freeze or unfreeze rows, coulumns or panes in MS Excel.

How to Freeze/Unfreeze Rows or Columns in MS Excel

1048576 rows & 16,384 columns in Excel can store an excessive collection of data in an organized manner. Some other exciting features of Excel include:

• Data filtering,
• Data sorting,
• Find and replace feature,
• Built-in formulae,
• Pivot table,
• Password protection, and many more.

Moreover, you can freeze multiple rows or columns in excel. You can freeze a portion of the sheet viz row, column or panes in Ecel to keep it visible while you scroll through the rest of the sheet. This is useful for checking out the data in other parts of your worksheet without losing your headers or labels. Keep reading to learn how to freeze or unfreeze rows, columns or panes in Microsoft Excel.

Important Terminology Before You Begin

• Freeze Panes: Based on the current selection, you can keep the rows and columns visible while the rest of the worksheet scrolls up and down.
• Freeze Top Row: This feature will be helpful if you want to freeze only the first header/top row. This option will keep the top row visible, and you can scroll through the rest of the worksheet.
• Freeze First Column: You can keep the first column visible while you can scroll through the rest of the worksheet.
• Unfreeze Panes: You can unlock all the rows and columns to scroll through the entire worksheet.

Option 1: How to Freeze a Row in Excel

You can freeze a row in Excel or freeze multiple rows in Excel by following the below-mentioned steps:

1. Press the Windows key. Type & search Excel and click on it to open it.

2. Open your desired Excel sheet and select any row.

Note 1: Always choose the row that is below the row you want to freeze. This means if you want to freeze up to the 3rd row, you must select the 4th row.

3. Then, select View in the menu bar as shown.

4. Click Freeze Panes > Freeze Panes in the drop-down menu as depicted below.

All the rows below the selected row will be frozen. The rows above the selected cell/row will stay in the same place when you scroll down. Here in this example, when you scroll down, row 1, row 2, row 3 will remain in the same place and the rest of the worksheet scrolls.

Also Read: How to Copy and Paste Values Without formulas in Excel

Option 2: How to Freeze Top Row in Excel

You can freeze the header row in the worksheet by following the given steps:

1. Launch Excel as earlier.

2. Open your Excel sheet and select any cell.

3. Switch to the View tab at the top as shown.

4. Click Freeze Panes > Freeze Top Row as shown highlighted.

Now, the first top row will be frozen, and the rest of the worksheet will scroll normally.

Also Read: Fix Outlook App Won’t Open in Windows 10

Option 3: How to Freeze a Column in Excel

You can freeze multiple columns or a single column in Excel as follows:

1. Press the Windows key. Type & search Excel and click on it to open it.

2. Open your Excel sheet and select any column.

Note: Always choose the column that is right to the column you wanted to freeze. This means that if you want to freeze column F, select column G and so on.

3. Switch to the View tab as shown below.

4. Click Freeze Panes and select Freeze Panes option as depicted.

All the columns left of the selected column will be frozen. When you scroll right, the rows in the left of the selected column will stay in the same place. Here in this example, when you scroll right, column A, column B, column C, column D, column E, and column F will stay in the same place, and the rest of the worksheet will scroll left or right.

Option 4: How to Freeze First Column in Excel

You can freeze a column in Excel, i.e., freeze the first column in the worksheet by following the below steps.

1. Launch Excel as earlier.

2. Open your Excel sheet and select any cell.

3. Switch to the View tab from the top as shown.

4. Click Freeze Panes and this time, select Freeze First Column option from drop-down menu.

Thus, the first column will be frozen, where you can scroll through the rest of the worksheet normally.

Also Read: Fix Microsoft Office Not Opening on Windows 10

Option 5: How to Freeze Panes in Excel

For instance, if you are entering data in a report card containing students’ names and marks, it is always a hectic job to scroll to the header (containing subject names) and the label (including the name of students) often. In this scenario, freezing both the row and column fields will help you. Here’s how to do the same:

1. Launch Excel as earlier. Open desired worksheet and select any cell.

Note 1: Always ensure that you choose a cell to the right of the column and below the row you want to freeze. For example, if you want to freeze the first row & first column, select the cell to the right of the first column pane and below the first-row pane, i.e., select B2 cell.

2. Click on the View tab from the top ribbon.

3. Click Freeze Panes as shown.

4. Select option marked Freeze Panes as illustrated below.

All the rows above the selected row and all the columns to the left of the selected column will be frozen, and the rest of the worksheet scrolls. So here, in this example, the first row and the first column are frozen, and the rest of the worksheet scrolls as depicted below.

How to Unfreeze Rows, Columns, or Panes in Excel

If you have frozen any rows, columns, or panes, you cannot perform another freezing step unless it is removed. To unfreeze rows, columns, or panes in Excel, implement these steps:

1. Select any cell in the worksheet.

2. Navigate to the View tab.

3. Now, select Freeze Panes and click on Unfreeze Panes as depicted below.

Note: Make sure you have any cell/row/column in a frozen state. Otherwise, an option to Unfreeze Panes will not appear.

Also Read: How to Stop Microsoft Teams from Opening on Startup

Pro Tip: How to Create Magic Freeze Button

You can also create a magic freeze/unfreeze button in the Quick Access toolbar to freeze a row, column, first column, first row, or panes with a single click.

1. Launch Excel as earlier.

2. Click the down arrow, shown highlighted, from the top of the worksheet.

3. Click More Commands as shown.

4. Select Freeze Panes in the list and then click Add.

5. Finally, click OK. Freeze Panes Quick Access option will be available at the top of the worksheet in MS Excel.

Frequently Asked Questions (FAQs)

Q1. Why is the Freeze Panes option greyed out in my worksheet?

Ans. The option Freeze Panes is greyed out when you are in editing mode or worksheet is protected. To exit the editing mode, press Esc key.

Q2. How can I lock cells in Excel instead of freezing them?

Ans. You can use the Split option in the View menu to split and lock cells. Alternately, you can create a table by Ctrl + T. Creating a table will lock the column header when you scroll down. Read our guide on How To Lock Or Unlock Cells In Excel.

Recommended:

• How to Check How Much VRAM Do I Have on Windows 10
• How to Access Microsoft Teams Admin Center Login
• How to swap columns or rows in Excel
• How to Use Microsoft Teams Secret Emoticons

We hope that this guide was helpful, and you were able to freeze and unfreeze rows, columns or panes in Excel. Feel free to reach out to us with your queries and suggestions via comments section below.

Related posts

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Koobiyi Paste ma shaqaynayo Windows 10? 8 siyaabood oo loo hagaajiyo!

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• 5 siyaabood oo looga saaro Hyperlinks Documents Microsoft Word

• Sida loo abuuro Barcode adoo isticmaalaya Microsoft Word

• Hagaaji hubinta Higgaadda oo aan ku shaqayn Microsoft Word

• Sida looga saaro erayga sirta ah ee Excel File

• 5 siyaabood oo loo Geli karo Calaamada Xididada Square ee Erayga

• Sida Loo Sameeyo Margins 1 Inch gudaha Microsoft Word

• Sida loo beddelo cabbirka slide ee PowerPoint: Dhammaan waxaad u baahan tahay inaad ogaato -

• Sida Loo Furo Fayl kasta ASPX (U beddelo ASPX PDF)

• Sida loo beddelo jihaynta hal bog (ama ka badan) dukumeenti Word ah

• Sida loo Copy and paste value without formula in Excel

• Sidee Loogu Wareejin karaa Microsoft Office Kombiyuutar Cusub?

• Hagaaji Microsoft Office Aan Furaneyn Windows 10

• Sida loo tirtiro qiyamka unugyada laakiin ku ilaali qaacidooyinkaaga, gudaha Microsoft Excel

• Sida Loo Bilaabo Microsoft Word In Mode Safe