Ukubalwa kwekhasi kuyithuluzi eliwusizo kakhulu okulula ukuhlela idokhumenti uma ushicilela. Ngempela, amaphepha amanani alula kakhulu ukubola. Futhi ngisho noma bavele baxube esikhathini esizayo, ungakwazi njalo ukuphinda ngokulandela izinombolo zabo. Kodwa ngezinye izikhathi kuyadingeka ukususa lokhu okubalwe ngemuva kokusetha kudokhumenti. Ake sibone ukuthi lokhu kungenziwa kanjani.
Bheka futhi: Ungasusa kanjani ukuhlukunyezwa ngeZwi
Izinketho zokususa izinombolo
I-algorithm yenqubo yokukhishwa kwenombolo ku-Excel, kuqala kokunye, incike ekutheni nokuthi ibekwe kanjani. Kunamaqembu amabili wokubala okuyinhloko. Owokuqala kubo ubonakala lapho ephrinta idokhumenti, futhi okwesibili kungabonwa kuphela ngenkathi isebenza nespredishithi kumqapha. Ngokuhambisana nalokhu, amakamelo nawo asuswa ngezindlela ezihluke ngokuphelele. Ake sibuke ngokuningiliziwe.
Indlela 1: Susa Izinombolo Zamakhasi Ezingemuva
Ake sibheke ngokushesha kwinkqubo yokukhipha ukubalwa kwekhasi lesemuva, okubonakalayo kuphela esikrinini sokuqapha. Lokhu kubalwa ngohlobo "Ikhasi 1", "Ikhasi 2", njll, eliboniswa ngokuqondile eshadini ngokwayo kwimodi yokuguqula. Indlela elula kakhulu yokuphuma kwalesi simo ukushintshela kunoma iyiphi enye imodi yokubuka. Kunezindlela ezimbili zokwenza lokhu.
- Indlela elula yokushintshela kwenye imodi ukuchofoza esithombeni kubha yesimo. Le ndlela ihlale ikhona, futhi ngokuchofoza okukodwa, kungakhathaliseki ukuthi ungubani ithebhu. Ukwenza lokhu, chofoza ngokuchofoza ngakwesokunxele kunoma yikuphi kwezimpawu ezimbili zokushintsha imifanekiso, ngaphandle kwesithonjana "Ikhasi". Lezi zishintsha zikhona kubha yesimo ngakwesobunxele besilayidi yokusondeza.
- Ngemuva kwalokho, ukubalwa kwezinombolo ngeke kusabonakala ekhasini lokusebenzela.
Kukhona futhi inketho yokushintsha imodi usebenzisa amathuluzi ku-tape.
- Hambisa kuthebhu "Buka".
- Ebhebheni ekuvimba amasethingi "Imodi yokubuka ibhuku" chofoza inkinobho "Okuvamile" noma "Ukuhlelwa Kwekhasi".
Emva kwalokhu, imodi yekhasi izokhutshazwa, okusho ukuthi ukubalwa kwenamba kuzophinde kuphele.
Isifundo: Ungasusa kanjani ukubhalisa Page 1 ku-Excel
Indlela 2: Sula Izihloko nezinyawo
Kukhona nesimo esivumelanayo lapho ukubala kungabonakali uma usebenza netafula ku-Excel, kodwa kubonakala uma ushicilela idokhumenti. Futhi, kungabonakala efasiteleni lokubuka kuqala kwedokhumenti. Ukuze uye lapho, udinga ukuthuthela kuthebhu "Ifayela"bese kwimenyu emele kwesokunxele ukhethe isikhundla "Phrinta". Endaweni efanele yefasitela evula, indawo yokubuka kuqala yedokhumenti izotholakala. Yilapho ongabona ukuthi leli khasi lizobalwa noma linganyathelwanga. Izinombolo zingatholakala phezulu kweshidi, ngezansi noma kuzo zombili izikhundla ngesikhathi esifanayo.
Lolu hlobo lokubala luyenziwa ngokusebenzisa izinhloko nezinyawo. Lezi yizinsimu ezifihliwe, idatha ebonakalayo ekuphrintiwe. Zisetshenziselwa ukubala, ukufakwa kwamanothi ahlukahlukene, njll. Ngesikhathi esifanayo, ukuze ulandele ikhasi, akudingekile ukuthi ufake inombolo kukhasi ngalinye lekhasi. Kwanele ekhasini elilodwa, ekubeni kwimodi yezinhlokweni nezinyawo, ukubhala le nkulumo kunoma iyiphi yalezi zindawo ezintathu eziphezulu noma ezintathu:
& [Ikhasi]
Emva kwalokho, ukubalwa okuqhubekayo kwawo wonke amakhasi kuzokwenziwa. Ngakho-ke, ukususa lokhu kubalwa, udinga nje ukusula inkundla yonyawo lokuqukethwe, bese ulondoloza idokhumenti.
- Okokuqala, ukwenza umsebenzi wethu, udinga ukuya kwimodi yezinhlokweni nezinyawo. Lokhu kungenziwa ngezinketho eziningana. Hambisa kuthebhu "Faka" bese uchofoza inkinobho "Izinyawo"okuyinto itholakala ku-tape ebhodini lamathuluzi "Umbhalo".
Ngaphezu kwalokho, ungabona izihloko nezinyawo ngokuya kwimodi yokuhlela ikhasi, ngesithonjana esivele sijwayele kithi kubha yesimo. Ukuze wenze lokhu, chofoza isithonjana esiyisisekelo sokushintsha izindlela zokubuka, okubizwa ngokuthi "Ukuhlelwa Kwekhasi".
Enye indlela ukuya kuthebhu "Buka". Lapho kufanele uchofoze inkinobho "Ukuhlelwa Kwekhasi" kwi-tape eqenjini lezinsimbi "I-Book View Modes".
- Noma yikuphi okukhethwa kukho okukhethiwe, uzobona okuqukethwe kwekhanda nesiqu. Esimweni sethu, inombolo yekhasi itholakala emasimini aphansi angaphansi kwesokunxele nesokunxele.
- Vele ubeke isikhangiso ensimini ehambelana bese uchofoza inkinobho. Susa kwikhibhodi.
- Njengoba ubona, ngemuva kwalokho ukubalwa kwenombolo kwanyamalala hhayi ekhoneni elingenhla elingakwesokunxele sekhasi lapho inyawo lithathwe khona, kodwa nakuzo zonke ezinye izakhi zedokhumenti endaweni efanayo. Ngendlela efanayo susa okuqukethwe kwonyawo. Setha isikhombisi lapho futhi uchofoze inkinobho. Susa.
- Manje ukuthi yonke idatha yekhanda nenyawo isusiwe, singashintsha ekusebenzeni okujwayelekile. Kulokhu, kungaba kuthebhu "Buka" chofoza inkinobho "Okuvamile", noma kubha yomumo, chofoza inkinobho ngegama elifanayo.
- Ungakhohlwa ukuphinda ubhale kabusha idokhumenti. Ukuze wenze lokhu, chofoza nje kwisithonjana, esinesimo se-floppy disk futhi sisekhoneni eliphezulu elingakwesokunxele lewindi.
- Ukuze uqiniseke ukuthi izinombolo zanyamalala ngempela futhi ngeke zivele ekuphrintiwe, hamba kuthebhu "Ifayela".
- Ewindini evulekayo, hamba kusigaba "Phrinta" ngokusebenzisa imenyu eqondile ngakwesobunxele. Njengoba ubona, ukuphazamiseka kombhalo akukho endaweni yokubuka kuqala esivamile kithi. Lokhu kusho ukuthi uma siqala ukunyathelisa incwadi, khona-ke ekuphumeni siyothola amashidi ngaphandle kokubala, yilokho okwakudingeka kwenziwe.
Ngaphezu kwalokho, ungakhubaza izihloko nezinyawo eziphelele.
- Iya kuthebhu "Ifayela". Hambisa esigatshaneni "Phrinta". Engxenyeni ephakathi kwefasitela yizilungiselelo zokuphrinta. Ngaphansi kwesonto le-block, chofoza okubhalwe phansi "Izilungiselelo zekhasi".
- Iwindi lamasethingi ekhasi liqaliswa. Emasimini "Isihloko" futhi Ngama-footer kusuka ohlwini lokudonsa phansi, khetha ukhetho "(cha)". Emva kwalokho, chofoza inkinobho "Kulungile" phansi kwefasitela.
- Njengoba ungabona endaweni yokubuka kuqala, ishidi elibalalayo liyanyamalala.
Isifundo: Ungasusa kanjani izihloko nezinyawo kwi-Excel
Njengoba ubona, ukukhetha indlela yokukhubaza ukubalwa kwekhasi kuxhomeke ngokuyinhloko ukuthi le nombolo isampuliwe kanjani. Uma iboniswa kuphela esikrinini sokuqapha, kwanele ukushintsha imodi yokubuka. Uma izinombolo ziphrintiwe, ngakho-ke kulokhu kubalulekile ukususa okuqukethwe kwekhanda nesiqu.
