Njengoko uyazi, ngokuzenzekelayo, kwiseli enye, iphepha eliphezulu likwindawo enye ngeenombolo, isicatshulwa okanye enye idatha. Kodwa yintoni endifanele ndiyenze ukuba ufuna ukudlulisela isicatshulwa ngaphakathi kwiseli enye? Lo msebenzi unokwenziwa usebenzisa ezinye zeenkqubo zenkqubo. Makhe siyifumane indlela yokwenza umqolo ukuguqulela kwiseli e-Excel.
Iindlela zokutshintsha isicatshulwa
Abanye abasebenzisi bazama ukutshintshela itekisi ngaphakathi kwiseli ngokucinezela iqhosha le-Enter iqhosha. Kodwa ngabo bafuna nje ukuba isikhombisi sifudukele kumgca olandelayo. Siza kuqwalasela iindlela zokudluliselwa ngokuchanekileyo ngaphakathi kwiseli, zombini zilula kwaye zinzima kakhulu.Indlela yoku-1: Sebenzisa ikhibhodi
Eyona ndlela ilula yokudlulisela ukuya komnye umtya kukuseta isikhombisi ngaphambi kwecandelo ofuna ukudlulisela, kwaye emva koko thayipha i-Alboard Alt Alt (ngasekhohlo).
Ngokungafaniyo nokusetyenziswa kweqhosha elinye kuphela, usebenzisa le ndlela, kuya kuba sisiphumo esibekwe.
Isifundo: Izitshixo ezishushu kwi-Excele
Indlela 2: Ukufomatha
Ukuba umsebenzisi akabekeki misebenzi atshintshe amagama athile kumgca omtsha, kwaye kufuneka ubalungiselele kwiseli enye, ngaphandle kokuya ngaphaya komda, unokusebenzisa isixhobo sokufomatha.
- Khetha iseli apho isicatshulwa sidlula khona imida. Cofa kuyo kwiqhosha le mouse lasekunene. Kuluhlu oluvula, khetha eyona mpahla ingu-proform ... ".
- Ifestile yokufomatha ivuliwe. Yiya kwi "thungelwano" ithebhu. Kwi-"boobing" Useto lwe-Block, khetha "ukugqithisela ngokwe" iparameter, ukuyiphawula ngophawu lwetsheki. Cofa kwiqhosha "Kulungile".
Emva koko, ukuba idatha ivele ngaphaya kwemida yeseli, iya kwanda ngokuzenzekelayo ukuphakama, kwaye amagama aya kutshintshelwa. Ngamanye amaxesha kuya kufuneka wandise imida ngesandla.
Ukwenzela ukuba akukho nto ayifontini nganye nganye, unokukhetha kwangoko indawo yonke. Ukungancedi kakuhle kolu khetho kukuba ukudluliselwa kwenziwa kuphela xa amagama engahambelani kwimida, ngaphandle, icandelo liqhutywa ngokuzenzekelayo ngaphandle kokuthatha inkanuko yomsebenzisi.
Indlela 3: Sebenzisa ifomula
Unokwenza kwakhona ukudluliselwa ngaphakathi kwiseli usebenzisa ifomula. Olu khetho lulunga kakhulu ukuba isiqulatho siboniswe ukusebenzisa imisebenzi, kodwa inokusetyenziswa kwiimeko eziqhelekileyo.
- Fomatha iseli njengoko kubonisiwe kuhlobo lwangaphambili.
- Khetha iseli kwaye ufake le ntetho elandelayo kuyo okanye kumtya:
= Ukubamba ("isicatshulwa1"; isimboli (10); "Isicatshulwa2")
Endaweni ye "Guqula1" kunye "nemibhalo2", kufuneka usebenze endaweni yamagama okanye iiseti zamagama ofuna ukuwadlulisela. Iimpawu zefomula ezisele azidingi.
- Ukuze isiphumo sokuboniswa kwiphepha, cofa iqhosha lokungena kwikhibhodi.
Eyona nto igwenxa kule ndlela yinyani yokuba kunzima ngakumbi ekwenzeni kunokukhetho lwangaphambili.
Isifundo: Amanqaku aluncedo
Ngokubanzi, umsebenzisi kufuneka athathe isigqibo sokuba zeziphi iindlela ezicetywayo ezijolise ekusebenziseni kwimeko ethile. Ukuba ufuna kuphela bonke abalinganiswa ukuba bangene kwimida yeseli, emva koko bafomathela ngendlela enqwenelekayo, kwaye konke ukufota konke. Ukuba ufuna ukuseta ugqithiso lwamagama athile, emva koko ucofe indibaniselwano ehambelana nayo, njengoko kuchaziwe kwinkcazo yendlela yokuqala. Inketho yesithathu iyacetyiswa kuphela xa idatha itsalwa kwezinye i-ranges esebenzisa ifomula. Ngamanye amaxesha, ukusetyenziswa kwale ndlela ayisebenzi, njengoko kukho iindlela ezilula ezilula zokusombulula umsebenzi.