Wax shaqo ah ma ku qabatay xaashida shaqada ee Excel oo aad u dheer ama ballaadhan, oo waa inaad kor iyo hoos ugu rogtaa, dhinac ilaa dhinac, oo ay cudud daalinaysaa? Qaboojinta^(Freezing) iyo kala qaybinta^(Splitting) shaashadaha waa hab ka dhigaya socodka iyo daawashada boggaga mid la maarayn karo.

Ku qabooji oo ku kala qaybi baalasha Excel

Qalabka qaboojinta^{(Freezing Pane)} wuxuu hayaa safafka iyo tiirarka la arki karo inta ka hartay xaashida shaqadu waxay duubtaa (ku salaysan xulashada hadda).

• Qabo Safka Sare^{(Freeze Top Row)} : Ka dhig safka sare mid muuqda markaad dhex wareegayso xaashida shaqada inteeda kale.
• Qabo Tiirka Koowaad^{(Freeze First Column)} : Ka dhig tiirka kowaad mid muuqda markaad dhex wareegayso xaashida shaqada.

Kala^(Split) qaybsanaantu waxay u qaybisaa daaqada muraayado kala duwan oo mid kastaa goonidiisa u duubo.

Maqaalkan, waxaan ku sharxi doonaa:

1. Sida loo qaboojiyo hal saf iyo tiir
2. Sida loo qaboojiyo dhowr saf iyo tiirar
3. Sida isla markiiba loo qaboojiyo safka iyo tiirka
4. Sida loo furo dhammaan safafka iyo tiirka
5. Sida loo kala qaybiyo daaqadaha si toos ah iyo toosan
6. Sida loo saaro Split

1] Sida^(How) loo qaboojiyo hal saf iyo tiir gudaha Excel

Si aad u qaboojiso hal saf ama tiir, dhagsii View tab, dhagsii  baalasha qaboojiya^{(Freeze Panes)} , ka bacdina guji  Freeze^{(Freeze Top Row)} Safka Sare ama Qabo Tiirka Koowaad^{(Freeze First Column)} . Maqaalkan, waxaanu dooran doonaa safka ugu sarreeya ee Barafka^{(Freeze Top row)} . U fiirso^(Notice) marka aad ku dul wareegayso xaashida shaqada, safka kowaad weli wuu soo baxayaa mana baxayo.

2] Sida^(How) loo qaboojiyo dhowr saf iyo tiirar gudaha Excel

Si aad u qaboojiso^(Freeze) safaf badan ama tiirar. Dooro safafka ama tiirarka aad rabto inaad qaboojiso adigoo gujinaya ciwaanka safka ama tiirka. Tag tab View tab, dhagsii barafyada qaboojiyaha^{(Freeze Panes)} , ka bacdina guji Freeze Pane ee liiska hoos-u-dhaca ah.

Akhri^(Read) : Sida loo Sameeyo oo wax looga beddelo Foomka Su'aalaha ama Shaxda ee Helitaanka Microsoft .

3] Sida^(How) isla markiiba loo qaboojiyo safafka iyo tiirka gudaha Excel

Si isla markaaba loo qaboojiyo safka iyo tiirka Dooro safka iyo midigta tiirka, ka bacdi tag View dooro barafyada qaboojinta^{(Freeze Panes)} . Guji qaybta qaboojinta^{(Freeze Pane)} . U fiirso markaad kor u qaadayso, safka kowaad ma baaba'ayo, markaad hoos u rogto, tiirka bidix ee safka aad dooratid ma dhaqaaqo.

4] Sida^(How) loo furo safafka iyo tiirarka Excel

Si aad uga saarto safafka iyo tiirka, u gudub View oo dooro barafka qaboojiyaha ee liiska hoos-u-dhaca dooro Pane ^{(Freeze Pane)}Unfreeze^{(Unfreeze Pane)} .

5] Sida^(How) loo kala qaybiyo daaqadaha si toos ah iyo toosan gudaha Excel

Si loo kala qaybiyo daaqadaha Excel . Guji ciwaanka safka ah ama tiirka, dooro Kala^(Split) qaybso tab View ee Kooxda Daaqadda^{(Window Group)} . Waxaad ku arki doontaa xaashida shaqada ee khad cawlan^{(Thick Grey Line)} oo dhumuc weyn leh; waxaad u jiidi kartaa xariiqan meesha aad rabto inaad kala qaybiso daaqada. Waxaad arki doontaa qayb ka mid ah xaashida shaqada (oo lagu arkay sawirka sare).

Akhri^(Read) : Sida loogu daro qoraalada dhibcaha xabaasha ee Microsoft Excel^{(How to add bullet points to text in Microsoft Excel)} .

6] Sida meesha looga saaro Split in Excel

Tag tab View tab mar kale kala qaybso^(Split) . Kala qaybsanaanta xaashida shaqada waa laga saari doonaa.

Waxaan rajeynayaa inaad u aragto qoraalka mid faa'iido leh.

How to Freeze and Split Panes in Excel worksheets

Haνe you had any work in an Excel worksheet that is too long or wide, and you must scroll up and down, side to side, and it makes your arm tired? Freezing and Splitting screens is a method that makes navigation and viewing between pages more manageable.

Freeze and Split Panes in Excel

Freezing Pane keeps rows and columns visible while the rest of the worksheet scrolls (based on current selection).

• Freeze Top Row: Keep the top row visible while scrolling through the rest of the worksheet.
• Freeze First Column: Keep the first column visible while scrolling through the worksheet.

Split divides the window into different panes that each scroll separately.

In this article, we are going to explain:

1. How to freeze a single row and column
2. How to freeze multiple rows and columns
3. How to instantaneously freeze row and column
4. How to unfreeze all rows and column
5. How to split windows vertically and horizontally
6. How to remove Split

1] How to freeze a single row and column in Excel

To freeze a single row or column, click on the View tab, click  Freeze Panes, and then click  Freeze Top Row or Freeze First Column. In this article, we are going to choose the Freeze Top row. Notice that when you are scrolling in the worksheet, the first row is still showing and not disappearing.

2] How to freeze multiple rows and columns in Excel

To Freeze multiple rows or columns.  Select the rows or columns you want to freeze by clicking the heading of the row or column.  Go to the View tab, click Freeze Panes, Then click Freeze Pane in the drop-down menu.

Read: How to Create and Modify a Form for a Query or Table in Microsoft Access.

3] How to instantaneously freeze row and column in Excel

To instantaneously freeze the row and column.  Select the row and the right of the column, then go to View select Freeze Panes. Click Freeze Pane. Notice when you are scrolling up, the first row is not disappearing, and when you are scrolling down, the column on the left of the row you select is not moving.

4] How to unfreeze rows and column in Excel

To unfreeze row and column, go on View and select Freeze Pane in the drop-down menu choose Unfreeze Pane.

5] How to split windows vertically and horizontally in Excel

To split windows in Excel. Click a row or column heading, select Split on the View tab in the Window Group. You will see a Thick Grey Line in the worksheet; you can drag this line to where you want to split in the window. You will see a split of your worksheet (seen in the photo above).

Read: How to add bullet points to text in Microsoft Excel.

6] How to remove Split in Excel

Go to the View tab click Split again. The split in the worksheet will be removed.

I hope you find the post useful.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo OR shaqada Excel si loo go'aamiyo haddii xaaladdu run tahay

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel