Sebenzisa isici seskrini sokuhlukanisa i-Excel ukuze ubuke amakhophi amaningi wephepha lokusebenzela elifanayo. Ukushaya isikrini kuhlukanisa ishidi lokusebenzela langokuthi futhi / noma ngokuzenzekelayo kube yizigaba ezimbili noma ezine ezikuvumela ukuba ubone izindawo ezifanayo noma ezahlukene zephepha lokusebenzela.
Ukupaka isikrini kungenye indlela yokuqhaqhazela ukugcina izihloko zephepha lokusebenzela noma izihloko esikrinini njengoba ugoqa. Ngaphezu kwalokho, izikrini zokuhlukanisa zingasetshenziswa ukuqhathanisa imigqa emibili noma amakholomu wedatha akhiwe ezingxenyeni ezahlukene zeshidi lokusebenzela.
Ukuthola Izikrini Ezihlukanisiwe
- Chofoza kuthebhu Buka yebhebhoni .
- Chofoza kusithonjana sokuhlukanisa ukuze uhlukanise isikrini sibe izingxenye ezine.
Qaphela: Ibhokisi Elihlukanisiwe Alikho
Ibhokisi lokuhlukaniswa, indlela yesibili futhi ethandwa kakhulu yokwehlukanisa isikrini ku-Excel, isusiwe yi-Microsoft kuqala nge-Excel 2013.
Kulabo abasebenzisa i-Excel 2010 noma ngo-2007, imiyalo yokusebenzisa ibhokisi lokuhlukanisa ingatholakala ngezansi.
Hlukanisa Isikrini Ezingxenyeni ezimbili noma ezine
Kulesi sibonelo, sizohlukanisa isikrini se-Excel sibe yizintambo ezine usebenzisa isithonjana se- Split esisendaweni yokubuka ithebhoni.
Lolu khetho lusebenza ngokungeza amabhafa ahlukanisiwe angama-horizontal futhi aqondile kuya ekhasini lokusebenzela.
Ikhefu ngayinye iqukethe ikhophi yesikhwama sokusebenza kanye nemigoqo yokuhlukaniswa ingasetshenziswa ngendlela eyodwa noma ndawonye ukuvumela ukuba ubone imigqa ehlukene namakholomu wedatha ngesikhathi esifanayo.
Isibonelo: Ukuthungula Isikrini Kokubili Kokubili futhi Kubukeka
Izinyathelo ezingezansi zihlanganisa indlela yokuhlukanisa isikrini se-Excel kokubili ngokuzenzekelayo futhi ngokuzenzekelayo usebenzisa isici se-Split.
Ukungeza idatha
Nakuba idatha engadingeki ukuba khona ukuze izikrini zokuhlukaniswa zisebenze, yenza kube lula ukuqonda ukuthi lesi sici sisebenza kanjani uma ishidi lomsebenzi eliqukethe idatha lisetshenziswa.
- Vula ishidi lokusebenzela eliqukethe idatha enengqondo noma wengeza imigqa eminingana yedatha - njengedatha ebonwe esithombeni ngenhla - ekhasini lokusebenzela.
- Khumbula ukuthi ungasebenzisa isibambo sokugcwalisa ukugcwalisa ngokuzenzakalelayo izinsuku zeviki kanye nezihloko zekholomu ezilandelanayo njengeSample1, Sample2 njll.
Ukuchitha isikrini ku-Four
- Chofoza kuthebhu Buka yebhebhoni.
- Chofoza kusithonjana sokuhlukanisa ukuvula isici seskrini sokuhlukanisa.
- Kokubili imigoqo yokuhlukanisa enezinhlangothi eziqondile kufanele ivele phakathi kwephepha lokusebenzela.
- Kuwo wonke ama-quadrants amane adalwe ngemishayo yokuhlukaniswa kufanele kube ikhophi yephepha lokusebenzela.
- Kumele futhi kube nemiphongolo emibili yokuphenya ngakwesokunene kwesikrini nemigoqo emibili yokupheqa engezansi kwesikrini.
- Sebenzisa imigoqo yokupheqa ukuze uhambisane nendawo ngayinye.
- Ukuhlelwa kabusha kwemigoqo yokuhlukanisa ngokuchofoza kubo bese uhudula ngegundane.
Ukuchitha Isikrini Ngemibili
Ukuze unciphise inani lezikrini kuya kokubili, donsela enye yezingcingo ezimbili zokuhlukanisa ukuya phezulu noma kwesokudla kweskrini.
Isibonelo, ukuze isikrini sihlukaniswe ngokuzenzekelayo, donsela ibha yokuhlukanisa ngokuqondile kuze kube ngakwesokudla noma ngakwesokunxele kwiphepha lokusebenzela, ushiye ibha elilinganiselwe kuphela ukuze uhlukanise isikrini.
Ukususa izikrini ze-Split
Ukususa zonke izikrini zokuhlukaniswa:
- Chofoza ku- Buka> Hlukanisa ukuvula isici sesikrini sokuhlukanisa;
noma
- Hudula imigqa yombili yokuhlukaniswa ezinhlangothini zesikrini; ngemishayo yomabili kulesi sikhundla, isithonjana sokuhlukanisa ku-ribbon ivaliwe.
Hlukanisa Isikrini Se-Excel Ngebhokisi Elihlukanisayo
Ukuchitha isikrini ngebhokisi lokuhlukanisa
Njengoba kushiwo ngenhla, ibhokisi lokuhlukaniswa lisuswe kusuka ku-Excel kuqala nge-Excel 2013.
Isibonelo sokusebenzisa ibhokisi lokuhlukaniswa kufakwe ngezansi kulabo abasebenzisa i-Excel 2010 noma 2007 abafisa ukusebenzisa lesi sici.
Isibonelo: Izikrini zokuhlukanisa nebhokisi lokuhlukanisa
Njengoba singabonakala esithombeni esingenhla, sizohlukanisa isikrini se-Excel ngokusebenzisa ibhokisi lokuhlukanisa elisemkhatsini wesikrini somqulu oqondile.
Ibhokisi elihlukaniswe ngokuqondile likhona ekhoneni elingezansi elingakwesokudla kwesikrini se-Excel, phakathi kwamabhulobhobhodi aqondile nama-horizontal.
Ukusebenzisa ibhokisi lokuhlukaniswa kunokuba ukhetho lokuhlukanisa olubekwe ngaphansi kwethebhu lokubuka likuvumela ukuba uhlukanise isikrini ngesinye isiqondiso kuphela - yilokho abasebenzisi abaningi abafuna khona.
Ukungeza idatha
Nakuba idatha engadingeki ukuba khona ukuze izikrini zokuhlukaniswa zisebenze, yenza kube lula ukuqonda ukuthi lesi sici sisebenza kanjani uma ishidi lomsebenzi eliqukethe idatha lisetshenziswa.
- Vula ishidi lokusebenzela eliqukethe idatha enengqondo noma wengeza imigqa eminingana yedatha - njengedatha ebonwe esithombeni ngenhla - ekhasini lokusebenzela
- Khumbula ukuthi ungasebenzisa isibambo sokugcwalisa ukugcwalisa ngokuzenzakalelayo izinsuku zeviki kanye nezihloko zekholomu ezilandelanayo njengeSample1, Sample2, njll.
Ukukhahlela isikrini ngokugcwele
- Beka isikhombisi segundane ebhokisini lokuhlukanisa ngenhla ibha yokuphenya njengoba kuboniswe esithombeni ngenhla.
- I-pointer yegundane izoshintshela kumcibisholo omnyama ophethwe kabili uma upheqa ibhokisi lokuhlukaniswa.
- Uma i-pointer yegundane ishintsha, chofoza bese ubamba inkinobho yegundane lesokunxele .
- Umugqa omnyama ogobile kufanele uvele ngenhla umugqa wephepha lokusebenzela.
- Hudula isikhombisi segundane phansi.
- Umzila omnyama ogobile kufanele ulandele isikhombisi segundane.
- Uma isikhombisi segundane singaphansi kwezingqikithi zezihloko zekholomu kuphepha lokusebenzela ukukhipha inkinobho yegundane lesokunxele.
- Ibha yokuhlukanisa enezingqimba kufanele ivele ephepheni lokusebenzela lapho kukhishwa khona inkinobho yegundane.
- Ngaphezulu nangaphansi kwebha lokuhlukaniswa kufanele kube amakhophi amabili ephepha lokusebenzela.
- Kumele futhi kube nemigoqo emibili yokubonakala ngakwesokudla kwesikrini.
- Sebenzisa le mizila emibili yokuphenya ukuze ubeke idatha ukuze izihloko zekholomu zibonwe ngaphezu kwebha lokuhlukaniswa kanye nayo yonke idatha engezansi.
- Isikhundla se-bar yokuhlukaniswa singashintshwa kaningi njengoba kudingeka.
Ukususa izikrini ze-Split
Unezinketho ezimbili zokususa izikrini zokuhlukaniswa:
- Chofoza ebhokisini lokuhlukanisa ngakwesokudla ngakwesokunxele kwesikrini bese ulihudulela phezulu ekhasini lokusebenzela.
- Chofoza ku- Buka> Isithonjana sokuhlukanisa ukuvala isici sesikrini sokuhlukaniswa.