Ukufaka izinombolo kwekhasi kuyithuluzi elisebenziseka kakhulu okulula ukuhlela ngalo idokhumenti lapho uphrinta. Ngempela, amashidi anezinombolo kulula kakhulu ukuhlela ngokulandelana. Futhi uma kwenzeka bexubana ngokuzayo ngokuzayo, ungahlala ubangeza ngokushesha ngokuya ngezinamba zabo. Kepha kwesinye isikhathi udinga ukususa lokhu kubalwa ngemuva kokufakwa kudokhumenti. Ake sibheke ukuthi lokhu kungenziwa kanjani.
Bheka futhi: Ungakususa kanjani ukubalwa kwamakhasi ngeZwi
Izinketho zokususa izinombolo
I-algorithm yenqubo yokususa izinombolo ku-Excel, okokuqala, kuya ngokuthi ifakwe kanjani futhi kungani. Kunamaqembu amabili amakhulu wokubala. Owokuqala wabo uyabonakala lapho kudicilelwa idokhumenti, bese okwesibili kungabukwa kuphela ngenkathi kusebenza nespredishithi kumqaphi. Ngokuhambisana nalokhu, izinamba nazo zihlanzwa ngezindlela ezihluke ngokuphelele. Masihlale phezu kwabo ngemininingwane.
Indlela yoku-1: susa izinombolo zekhasi zangemuva
Masizihlalele ngokushesha kwinqubo yokususa ukubalwa kwamakhasi angemuva, okubonakala esibukweni kuphela. Lokhu kubalwa kwenombolo yohlobo lwe- "Ikhasi 1", "Ikhasi 2", njll, okukhonjiswa ngqo ekhasini ngokwalo kwimodi yokubukwa kwekhasi. Indlela elula yokuphuma kulesi simo ukumane ushintshele kunoma iyiphi enye indlela yokubuka. Kunezindlela ezimbili zokufeza lokhu.
- Indlela elula yokushintshela kwenye imodi ngokuchofoza kusithonjana kwibha yesimo. Le ndlela ihlala itholakala, futhi ngokoqobo ngokuchofoza okukodwa, noma ngabe ukuphi kwithebhu. Ukuze wenze lokhu, chofoza ngokuchofoza kwesobunxele kunoma yiziphi izithonjana zokushintsha imodi ezimbili, ngaphandle kwesithonjana "Ikhasi". Lokhu kushintshwa kutholakala kubha yesimo ngakwesokunxele kwesilayidi sokusondeza.
- Ngemuva kwalokho, okubhaliwe ngezinombolo ngeke kusabonakala ekhasini lokusebenzela.
Kukhona nenketho yokushintsha izindlela usebenzisa amathuluzi ku-tape.
- Hambisa kuthebhu "Buka".
- Kubambo olubunjiwe kuzilungiselelo Ukubukwa Kwencwadi chofoza inkinobho "Okujwayelekile" noma Ukuhlelwa Kwekhasi.
Ngemuva kwalokho, imodi yamakhasi izovalwa, okusho ukuthi izinombolo ezingemuva zizonyamalala.
Isifundo: Ungakususa kanjani okubhaliwe ekhasini 1 ku-Excel
Indlela 2: sula izihloko nama-footer
Kunesimo sokubuyela emuva lapho, lapho sisebenza netafula e-Excel, ukubalwa kwezinombolo akubonakali, kodwa kuvela lapho kudicilelwa idokhumenti. Futhi, kungabonakala ewindini lokuhlola idokhumenti. Ukuze uye lapho, udinga ukuya kuthebhu Ifayelabese ukhetha into kumenyu mpo yangakwesobunxele "Phrinta". Engxenyeni engakwesokudla yewindows evulayo, indawo yokubuka kuqala yedokhumenti izotholakala. Yilapho lapho ungabona khona ukuthi ikhasi ekuphrintweni lizobalwa noma cha. Izinombolo zingatholakala phezulu kweshidi, phansi noma kuzo zombili izikhundla ngasikhathi sinye.
Lolu hlobo lokufakwa kwezinombolo lwenziwa kusetshenziswa abasebenza ezinyaweni. Lezi yizinkambu ezifihliwe lapho idatha ibonakala ekuphrintweni. Zisetshenziselwa ukufaka izinombolo kuphela, ukufakwa kwamanothi ahlukahlukene, njll. Ngaso leso sikhathi, ukufaka izinombolo ekhasini, awudingi ukufaka inombolo ekhasini ngalinye lekhasi. Kwanele ekhasini elilodwa, ngenkathi sikumodi yonyawo, ukubhala isisho kunoma iyiphi inkambu emithathu ephezulu noma emithathu ephansi:
& [Ikhasi]
Emva kwalokho kuzokwenziwa izinombolo eziqhubekayo zawo wonke amakhasi. Ngakho-ke, ukuze ususe le nombolo, udinga nje ukusula inkambu ye-footer kokuqukethwe, bese ugcine idokhumenti.
- Okokuqala, ukuqeda umsebenzi wethu kudingeka sishintshele kwimodi yonyaweni. Lokhu kungenziwa ngezinketho ezimbalwa. Hambisa kuthebhu Faka bese uchofoza inkinobho "Amaheda namahederali"etholakala kubambo kubhokisi lamathuluzi "Umbhalo".
Ngaphezu kwalokho, ungabona izihloko namahederidi ngokushintshela kumodi yokuhlelwa kwekhasi ngesithonjana esivele sazi kubha yezinga. Ukuze wenze lokhu, chofoza kusithonjana esimaphakathi sokushintsha izindlela zokubuka, ezibizwa Ukuhlelwa Kwekhasi.
Enye inketho ukuya kuthebhu "Buka". Chofoza inkinobho lapho. Ukuhlelwa Kwekhasi iribhoni eqenjini lamathuluzi Izinhlobo Zokubuka Izincwadi.
- Noma iyiphi inketho oyikhethayo, uzobona okuqukethwe izihloko namaheda. Esimweni sethu, inombolo yekhasi itholakala emasimini aphezulu angakwesokunxele nangaphansi.
- Vele usethe isikhombisi emkhakheni ofanele bese uchofoza inkinobho Susa kwikhibhodi.
- Njengoba ubona, ngemuva kwalokhu, izinombolo azanyamalala hhayi ekhoneni elingaphezulu ngakwesobunxele lekhasi lapho i-footer isuswe khona, kodwa futhi kuzo zonke ezinye izinto zedokhumenti endaweni efanayo. Ngendlela efanayo, sisusa okuqukethwe i-footer. Setha isikhombisi lapho bese uchofoza inkinobho Susa.
- Manje njengoba yonke imininingwane esezisekelweni isusiwe, singashintshela kumodi ejwayelekile yokusebenza. Ukuze wenze lokhu, kungaba kuthebhu "Buka" chofoza inkinobho "Okujwayelekile", noma kubha yesimo, chofoza inkinobho enegama elifanayo.
- Ungakhohlwa ukubhala kabusha idokhumenti. Ukuze wenze lokhu, chofoza nje isithonjana, esibukeka njenge-floppy disk futhi sitholakala ekhoneni elingaphezulu ngakwesobunxele lewindi.
- Ukuze uqiniseke ukuthi izinombolo zishabalale ngempela futhi zingaveli ekuphrintweni, siya kuthebhu Ifayela.
- Ewindini elivulayo, dlulela esigabeni "Phrinta" ngemenyu mpo ngakwesobunxele. Njengoba ubona, endaweni eseyijwayele yokubuka kuqala, ukubalwa kwamakhasi kudokhumenti kuyashoda. Lokhu kusho ukuthi uma siqala ukuphrinta le ncwadi, lapho-ke ukuphuma kuzoba ngamashidi ngaphandle kokubala izinombolo, nokuyinto obekumele siyenze.
Ngaphezu kwalokho, ungavimbela ama-footer ngokuphelele.
- Iya kuthebhu Ifayela. Siqhubekela esigatshaneni "Phrinta". Izilungiselelo zokuphrinta zitholakala enkabeni yewindi. Ngezansi kwaleli bhlokhi, chofoza okubhaliwe Izilungiselelo Zekhasi.
- Iwindi lokukhetha ikhasi liqala. Emasimini Unhlokweni futhi Unyawo kusuka ohlwini olwehliswayo, khetha inketho "(cha)". Ngemuva kwalokho chofoza inkinobho "Kulungile" phansi kwewindi.
- Njengoba ubona endaweni yokubuka kuqala, izinombolo zamashidi ziyanyamalala.
Isifundo: Ungasusa kanjani i-footers e-Excel
Njengoba ukwazi ukubona, ukukhethwa kwendlela yokukhubaza izinombolo zamakhasi kuncike ikakhulukazi ekutheni kufakwa izinombolo kanjani ngqo. Uma ikhonjiswa kuphela esikrinini sokuqapha, vele ushintshe imodi yokubuka. Uma izinombolo ziphrintiwe, khona-ke kuleli cala, udinga ukususa okuqukethwe i-footer.
