Indlela yokwahlula isikrini kwi-Excel

Sebenzisa i-Excel's split feature feature ukuze ukhangele iikopi ezininzi zephepha elifanayo. Ukuqhawula isikrini kukwahlula iphepha lokusebenzela langoku kunye kunye / okanye ngokuzenzekelayo kumacandelo amabini okanye amane okuvumela ukuba ubone indawo efanayo okanye eyahlukileyo kwiphepha lokusebenzela.

Ukuqhekeza isikrini kuyindlela yokuqhaqhazela ukugcina izihloko zephepha lokusebenzela okanye izihloko kwi-isikrini njengoko ugoqa. Ukongezelela, izikrini ezihlukeneyo zingasetyenziselwa ukuthelekisa imigqa emibini okanye iikholomu zedatha ezikwindawo ezahlukeneyo zephepha lokusebenzela.

Ukufumana izikrini ezihlukeneyo

1. Cofa kwi- View ithebhu yebhebhoni .
2. Cofa kwi icon yeSahlulo ukwahlula isikrini kwiindawo ezine.

Qaphela: Ibhokisi leSahlulo ayikho

Ibhokisi ekwahlukileyo, indlela yesibini kunye eyaziwayo kakhulu yokwahlula isikrini kwi-Excel, isuswe ngu-Microsoft kuqala nge-Excel 2013.

Kulabo abasebenzisa i-Excel 2010 okanye ngo-2007, imiyalelo yokusebenzisa ibhokisi yokwahlula ingafumaneka ngezantsi.

Ukwahlula Isikrini Kwizinto ezimbini okanye ezine

Kulo mzekelo, siza kukwahlula isikrini se-Excel sibe ngamacandelo amane usebenzisa isithonjana seSahlulo esibekwe kwiThebhu yokujonga yebhoni.

Olu khetho lusebenza ngokufaka ii-bar ehlukeneyo ezizenzekelayo kunye ezicacileyo kwiphepha lokusebenzela.

Ikhefu nganye iqulethe ikopi yomsebenzi wonke kwaye iibhawu zokudibanisa zinokusetyenziswa ngokuzikhethela okanye ngokudibeneyo kukuvumela ukuba ubone imigqa eyahlukeneyo kunye neenkcukacha zedatha ngexesha elinye.

Umzekelo: Ukuqhawula isiKrini kwimiNxeba kunye nokuVikela

Amanyathelo angezantsi ajonga indlela yokwahlula isikrini se-Excel zombini ngokuzenzekelayo kunye ngokuzenzekelayo usebenzisa isici seSahlulo.

Ukongeza iDatha

Nangona idatha ayifuni ukuba khona kwiiskrini zokuhlukanisa ukusebenza, yenza kube lula ukuqonda indlela le mpahla isebenza ngayo ukuba ishidi lokusebenzela eliqulethe idatha lisetyenzisiweyo.

1. Vula ishidi lokusebenzela elinomlinganiselo ofanelekileyo weenkcukacha okanye ukongeza imiqolo emininzi yedatha - njengedatha ebonwe kumfanekiso ongentla-kwiphepha lokusebenzela.
2. Khumbula ukuba ungasebenzisa isibambo sokuzalisa ukuzalisa ngokuzenzekelayo iintsuku zeveki kunye nezihloko zekholomu ezilandelelanayo ezifana neSample1, Sample2 njl.

Ukuqhekeza isikrini kwi ezine

1. Cofa kwi- View ithebhu yebhebhoni.
2. Cofa kwi icon yeSahlulo ukuze uvule iskrini somgca wecala.
3. Iibhawulwe zomgca kunye neendawo ezimele zimele zivele phakathi kwiphepha lokusebenzela.
4. Kwimiba emine yamadrafri amane adalwe yimivalo yokuhlula kufuneka ibe ikopi yesikhewu somsebenzi.
5. Kufuneka kubekho imivalo emibili yokuprola ngakwesokudla kwesikrini kunye nemivalo emibili engqamliyo engezantsi kwesikrini.
6. Sebenzisa imivalo yokupaka ukujikeleza kwi-quadrant nganye.
7. Ukubuyisela imivalo yokuhlula ngokuchofoza kubo kwaye ubadonse nge mouse.

Ukuqhekeza isikrini kwiBini

Ukunciphisa inani lezikrini ukuya kubini, donsela enye yeembalo zokuhlula ezimbini ukuya phezulu okanye ngakwesokudla kwesikrini.

Ngokomzekelo, ukuba isikrini sihlukaniswe ngokukhawuleza, donsela ibha yecala ekwahlukileyo ukuya ekude kunene okanye ngasekunene kwiphepha lokusebenzela, ushiye kuphela ibha engqambileyo ukuba uhlukanise isikrini.

Ukususwa kweSpred Screens

Ukususa zonke izikrini zokwahlula:

• Cofa kwi- View> Ukwahlula ukuguqula isicatshulwa sekrini;

okanye

• Dragla imivalo ebini ekwahlukileyo kumacala omnkrini; kunye nemivalo yomibini kule ndawo, icandelo lokuhlukanisa kwi-ribbon livaliwe.

Ukwahlula isikrini se-Excel ngebhokisi lokwahlula

Ukuqhekeza isikrini ngebhokisi lokwahlula

Njengoko kuchazwe ngasentla, ibhokisi ekwahlukileyo isuswe kwi-Excel ngokuqala nge-Excel 2013.

Umzekelo wokusebenzisa ibhokisi ekwahlukileyo ifakwe apha ngezantsi kulabo abasebenzisa i-Excel 2010 okanye 2007 abanqwenela ukuyisebenzisa.

Umzekelo: Izikrini zeSahlulo kunye nebhokisi leSahlulo

Njengoko kunokubonwa kumfanekiso ongentla, siza kukwahlula isikrini sase-Excel ngokuzenzekelayo usebenzisa ibhokisi ekwahlukileyo esekwe phezulu kwinqanaba le-scrollbar.

Ibhokisi ehlukanisiweyo ekhoyo ekhoneni elingezantsi lasekhompyutheni ye-Excel, phakathi kwee-scrollbars ezimileyo kunye nezingezantsi.

Ukusebenzisa ibhokisi ekwahlukileyo kunokuba ukhetho lokwahlukana oluphantsi kweTyhumbisi lubhenqa likuvumela ukuba uhlukanise isikrini kwisinye icala kuphela - yiloo nto abasebenzisi abaninzi abayifunayo.

Ukongeza iDatha

Nangona idatha ayifuni ukuba khona kwiiskrini zokuhlukanisa ukusebenza, yenza kube lula ukuqonda indlela le mpahla isebenza ngayo ukuba ishidi lokusebenzela eliqulethe idatha lisetyenzisiweyo.

1. Vula ishidi lokusebenzela elinomlinganiselo ochanekileyo wedatha okanye wongeza imiqolo emininzi yedatha - njengedatha ebonwe kumfanekiso ongentla - kwiphepha lokusebenzela
2. Khumbula ukuba ungasebenzisa isibambo sokuzalisa ukuzalisa ngokuzenzekelayo iintsuku zeveki kunye nezihloko zekholomu ezilandelelanayo ezifana neSampuli1, iSample2, njl.

Ukuqhekeza isikrini ngokuzenzekelayo

1. Faka isikhombisi se mouse phezu kwebhokisi ekwahlukileyo ngaphaya kwebhola yokucima ebonakalayo njengoko kuboniswe kumfanekiso ongentla.
2. Isalathisi se mouse siya kutshintshela kwintshombi emnyama ebomnyama xa uphezu kwebhokisi lehlulo.
3. Xa umqondiso we mouse uguquka, nqakraza ubambe inkinobho yemouse ekhohlo .
4. Umgca obumnyama ongapheliyo kufuneka uvele ngaphaya komqolo omnye wephepha lokusebenzela.
5. Dragla umgca we mouse kwihla.
6. Umgca omnyama ongqambileyo kufuneka ulandele isilathisi se mouse.
7. Xa isalathisi semouse singaphantsi kwimiqolo yezihloko zekholomu kwiphepha lokusebenzela ukhulule iqhosha le mouse.
8. Ibha yomgca ohlukileyo kufuneka ibonakale kwiphepha lokusebenzela apho iqhosha le mouse likhishwa khona.
9. Ngaphezulu nangaphantsi kwebhayibrari kufuneka ibe ikopi ezimbini zephepha lokusebenzela.
10. Kufuneka kubekho imigca emibili yokuprola ngakwesokudla kwesikrini.
11. Sebenzisa le mibhobho emibili ukubeka idatha ukwenzela ukuba izihloko zekholomu zibonakala ngaphaya kwebhayibrari kunye nayo yonke idatha engezantsi.
12. Isikhundla kwibar yokuhlukanisa sinokutshintshwa rhoqo njengoko kuyimfuneko.

Ukususwa kweSpred Screens

Unenketho ezimbini zokususa izikrini zokwahlula:

1. Cofa kwibhokisi ekwahlukileyo kwicala lasekunene leskrini uze uyibuyisele phezulu kwiphepha lokusebenzela.
2. Cofa kwi- View> Iqhosha lokwahlula ukucima isicatshulwa sekrini.