Ibhizinesi lebhizinisi lanoma yimaphi amadokhumenti igama layo. Lokhu okulandelwayo kusebenza futhi kumatafula. Ngempela, kujabulisa kakhulu ukubona ulwazi olukhonjiswe ngesihlokwana esihlotshaniswayo. Ake sithole ukulandelana kwezinyathelo okufanele zenziwe ukuze lapho usebenza namatafula e-Excel uhlale unamagama etafula eliphakeme.
Dala igama
Isici esiyinhloko lapho isihloko sizokwenza umsebenzi wayo ngokushesha ngokusemandleni, kuyisigaba saso semantic. Igama kufanele lithwale okuyinhloko kokuqukethwe kwetafula lethebula, lichaze ngokuqondile ngangokunokwenzeka, kodwa ngesikhathi esifanayo kube mfushane ngangokunokwenzeka ukuze umsebenzisi shazi kuye aqonde ukuthi lokhu kuyini.
Kodwa kulesisifundo, sisaphila kakhulu ngezikhathi ezinjalo zokudala, kodwa sizogxila ku-algorithm yokuhlanganisa igama letafula.
Isigaba 1: Ukwakha indawo yegama
Uma usuvele unetafula elenziwe ngomumo, kodwa udinga ukuyiqondisa, ngakho-ke, okokuqala, udinga ukudala indawo eshadini, eyabelwe isihloko.
- Uma uhlu lwamathebhu lusezingeni lokuqala lomshini nomngcele walo ongaphezulu, kuyadingeka ukusula isikhala segama. Ukuze wenze lokhu, setha isikhombisi kunoma iyiphi ingxenye yombqa wokuqala wetafula bese uchofoza kuso nge inkinobho yegundane efanele. Emenyu evula, khetha inketho "Namathisela ...".
- Ngaphambi kwethu kubonakala iwindi elincane okufanele ukhethe ukuthi yini oyifunayo ngokukhethekile: ikholomu, umugqa noma amaseli ngabanye abashintshayo. Njengoba sinomsebenzi wokwengeza umugqa, sihlela kabusha ushintsho endaweni efanelekile. I-Klaatsay ku "Kulungile".
- Umugqa ungeziwe ngaphezu kwetafula lethebula. Kodwa, uma ufaka umugqa owodwa phakathi kwegama kanye netafula, ngeke kube khona isikhala samahhala phakathi kwabo, okuzoholela ekutheni isihloko asizobonakala ngendlela esingathanda ngayo. Lesi simo asihambisani nabasebenzisi bonke, ngakho-ke kunengqondo ukwengeza imigqa eyodwa noma emibili. Ukwenza lokhu, khetha noma iyiphi into engenalutho esiyifake, bese uchofoze inkinobho yesokudla yegundane. Emenyu yomongo, ukhethe into futhi. "Namathisela ...".
- Izenzo ezengeziwe ezengezeni iwindi lamaseli ziphindaphindiwe ngendlela efanayo njengoba kuchaziwe ngenhla. Uma kunesidingo, ngendlela efanayo ungakwazi ukwengeza enye umugqa.
Kodwa uma ufuna ukwengeza ngaphezulu kweyodwa umugqa ngenhla kwetafula lethebula, khona-ke kukhona okukhethwa kukho ukusheshisa kakhulu inqubo futhi ungangezeli isici esisodwa ngesikhathi, kepha yenza isikhathi esisodwa.
- Khetha ububanzi obuqondile bamaseli phezulu kakhulu kwetafula. Uma uhlela ukwengeza imigqa emibili, kufanele ukhethe amaseli amabili, uma kukhona amathathu, amathathu, njll. Yenza ngokuchofoza ekukhethweni, njengoba kwenziwa ngaphambili. Emenyu, khetha "Namathisela ...".
- Futhi, ifasitela ivula lapho okudingeka ukhethe khona isikhundla. "Umzila" bese uchofoza "Kulungile".
- Ngaphezulu kwetafula letafula kuzongeza inani lemigqa, zingaki izakhi ezikhethiwe. Esimweni sethu, abathathu.
Kodwa kunenye indlela yokwengeza imigqa engezansi kwetafula ukubiza igama.
- Sakhetha phezulu kwetafula elinezici eziningi ezingxenyeni eziqondile njengoba imigqa ezokwengeza. Yilokho, siyakwenza, njengamanye amacala angaphambilini. Kodwa manje, iya kuthebhu "Ikhaya" kwi-ribbon bese uchofoze kwisithonjana ngesimo senxantathu kwesokudla kwenkinobho Namathisela eqenjini "Amaseli". Kuloluhlu, khetha inketho "Namathisela imigqa eshidi".
- Kukhona ukufakwa eshadini ngenhla kwethebhu ye-tabular yenombolo yemigqa, mangaki amangqamuzana adalulwe ngaphambilini.
Kulesi sigaba sokulungiselela kungacatshangwa ukuthi kuphelele.
Isifundo: Indlela yokwengeza umugqa omusha ku-Excel
Isigaba sesi-2: Ukuqamba igama
Manje sidinga ukubhala ngokuqondile igama letafula. Kufanele kube yilokho okushiwo isihloko, sesixoxwe kabanzi ngenhla, ngakho-ke angeke sihlale kulokhu, kepha sizogxila kuphela ezindabeni zobuchwepheshe.
- Kunoma yisiphi isici seshidi, esitholakala ngenhla kwethebhulethi emigqeni esiyidale esiteji sangaphambilini, faka igama elifunayo. Uma kunemigqa emibili ngaphezu kwetafula, kungcono ukukwenza ekuqaleni kokuqala kwabo, uma kunezintathu, bese kuba phakathi.
- Manje sidinga ukubeka leli gama phakathi kwetafula letafula ukuze lenze libukeke libonakala kahle.
Khetha lonke uhla lwamaseli alitholakala ngaphezu kwethebhu ye-tabular emgqeni lapho igama likhona khona. Ngesikhathi esifanayo, imingcele engakwesokunxele nangakwesokudla yokukhethwa akufanele idlule imingcele ehambelanayo yetafula. Emva kwalokho, chofoza inkinobho "Hlanganisa futhi ubeke phakathi"elitholakala kuthebhu "Ikhaya" ku-block "Ukuqondanisa".
- Emva kwalokho, izakhi zomugqa lapho igama letafula elitholakala khona lizohlanganiswa, futhi isihloko ngokwayo sizobekwa phakathi.
Kunenye indlela yokuhlanganisa amaseli emgqeni ngegama. Ukuqaliswa kwalo kuzothatha isikhathi esincane, kodwa, noma kunjalo, le ndlela kufanele ikhulunywe.
- Yenza okukhethwa kukho kwezakhi zomugqa wephepha, lapho igama lombhalo khona. Sichofoza ku-fragment ephawuliwe ngenkinobho yegundane kwesokudla. Khetha inani kusuka kuhlu "Fometha amaseli ...".
- Ewindini lokufometha sithuthela esigabeni. "Ukuqondanisa". Ku-block "Bonisa" hlola ibhokisi eduze nenani "Ukuhlanganiswa Kwamaselula". Ku-block "Ukuqondanisa" ensimini "Ngokuvamile" setha inani "Isikhungo" kusukela ohlwini lwezenzo. Chofoza "Kulungile".
- Kulokhu, amangqamuzana ekhethiwe ekhethiwe azohlanganiswa futhi, negama lombhalo lizobekwa phakathi kwento ehlanganisiwe.
Kodwa kwezinye izimo, ukuhlanganiswa kwamaseli ku-Excel akumukelekile. Isibonelo, uma usebenzisa amatafula ahlakaniphile, kungcono ukuthi ungasebenzisi kuwo nhlobo. Futhi kwezinye izimo, noma iyiphi inhlangano iphula isakhiwo sangempela sephepha. Yini okufanele uyenze uma umsebenzisi engafuni ukuhlanganisa amaseli, kodwa ngesikhathi esifanayo ufuna igama libe khona phakathi kwetafula? Kulesi simo, kukhona nendlela yokuphuma.
- Khetha ububanzi bomugqa ongaphezulu kwethebula equkethe isihloko, njengoba senze ekuqaleni. Sichofoza ekukhetheni ukubiza imenyu yesimo esikuyo lapho sikhetha khona inani "Fometha amaseli ...".
- Ewindini lokufometha sithuthela esigabeni. "Ukuqondanisa". Ewindini elisha ensimini "Ngokuvamile" khetha inani kusuka kuhlu "Ukukhetha okuphakathi". I-Klaatsay ku "Kulungile".
- Manje igama lizoboniswa phakathi kwetafula lethebula, kodwa amaseli ngeke ahlanganiswe. Nakuba kubonakala sengathi igama liphakathi, ikheli laso ngokomzimba lihambelana nekheli langempela leseli lapho lirekhodiwe ngaphambi kwenqubo yokulungiswa.
Isigaba 3: Ukufometha
Manje sekuyisikhathi sokufometha isihloko ukuze sithinte ngokushesha futhi sibonakale sitholakalayo ngangokunokwenzeka. Indlela elula yokwenza lokhu ikhona ngamathuluzi wokufometha tape.
- Maka isihloko ngokuchofoza kuso negundane. Ukuchofoza kufanele kwenziwe ngokuqondile ngeseli lapho igama likhona khona, uma ukulungiswa ngokukhethwa kusetshenzisiwe. Isibonelo, uma uchofoza endaweni esetsheni lapho igama liboniswa khona, kodwa awuboni ebhafini lefomula, lokhu kusho ukuthi empeleni akusikho kule nkampani yeshidi.
Kungenzeka kube nesimo esihlukile, lapho umsebenzisi ekhomba iseli elingenalutho, kodwa ubona umbhalo okhonjisiwe kubha yefomula. Lokhu kusho ukuthi ukuvumelanisa nokukhethwa kusetshenzisiwe futhi empeleni igama likhona kule seli, naphezu kokuthi akubukeki ngokubukeka. Ngenkambiso yokufometha, lesi sici kufanele sigcizelelwe.
- Qinisekisa igama ngokugqamile. Ukwenza lokhu, chofoza inkinobho "Bold" (pictogram njengencwadi "F") ku-block "Ifonti" kuthebhu "Ikhaya". Noma sebenzisa izinkinobho Ctrl + B.
- Khona-ke ungakwazi ukwandisa usayizi wefonti isihloko esihlobene nomunye umbhalo etafuleni. Ukwenza lokhu, uphinde ukhethe iseli lapho igama likhona ngempela. Chofoza kusithonjana ngesimo senxantathu, esitholakala ngakwesokudla kwensimu "Usayizi wefonti". Uhlu lwamasayizi wefonti luvuleka. Khetha inani wena ngokwakho elitholayo kakhulu kuthebula elithile.
- Uma ufisa, ungashintsha futhi igama lohlobo lwefonti kwenye inguqulo yokuqala. Sichofoza endaweni yegama. Chofoza kunxantathu ngakwesokudla kwensimu "Ifonti" ku-block efanayo kuthebhu "Ikhaya". Ivula uhlu olubanzi lwezinhlobo zefonti. Chofoza kulelo ocabanga ukuthi lifaneleka kakhulu.
Kodwa uma ukhetha uhlobo lwefonti udinga ukuqaphela. Ezinye zingase zingabi kufanelekile kumadokhumenti okuqukethwe okuqondile.
Uma ufisa, ungafometha igama cishe kuze kube nini nanini: yenza italic, shintsha umbala, usebenzise i-underline, njll. Siyeke kuphela ezakhiweni ezisetshenziselwa kakhulu ukufometha kwekhanda uma usebenza ku-Excel.
Isifundo: Ukufometha amatafula ku-Microsoft Excel
Isigaba 4: Ukugcizelela igama
Kwezinye izimo kuyadingeka ukuthi isihloko sihlale sibonakala, ngisho noma upheqa phansi itafula elide. Lokhu kungenziwa ngokuphina ibha yombhalo.
- Uma igama lisendleleni ephezulu yeshidi, kulula kakhulu ukwenza okubophayo. Hambisa kuthebhu "Buka". Chofoza kusithonjana "Faka endaweni". Kulolu hlu oluvulwayo, simisa entweni "Faka emgqeni ophezulu".
- Manje umugqa ophezulu wekhasi lapho igama elikhona khona lizobekwa khona. Lokhu kusho ukuthi kuzobonakala ngisho noma wehla phansi kwetafula.
Kodwa akulona njalo igama elibekiwe emgqeni ophezulu weshidi. Isibonelo, ngenhla sibheke isibonelo lapho sitholakala emgqeni wesibili. Ngaphezu kwalokho, kuyinto elula uma kungenjalo kuphela igama elinqunyelwe, kodwa futhi isihloko setafula. Lokhu kuvumela umsebenzisi ukuthi ahambe ngokushesha lapho idatha ekholomu isho. Ukuze usebenzise lolu hlobo lokuhlanganiswa, kumele usebenzise i-algorithm ehlukile.
- Khetha iseli elingakwesokunxele ngaphansi kwendawo okumelwe ilungiswe. Kulokhu, sizolungisa isihloko kanye nekhanda letafula ngokushesha. Ngakho-ke, khetha iseli lokuqala ngaphansi kwesihloko. Emva kwalokho chofoza kusithonjana "Faka endaweni". Ngalesi sikhathi ohlwini, khetha isikhundla, esibizwa ngokuthi "Faka endaweni".
- Manje imigqa enegama lethebula letafula futhi ikhanda layo lizonamathiselwa kushidi.
Uma usafuna ukulungisa igama kuphela ngaphandle kwekhanda, bese kulesi simo udinga ukukhetha iseli lokuqala lesobunxele, elitholakala ngaphansi kwegama lomugqa, ngaphambi kokuya kuthebhu ye-pinning.
Zonke ezinye izenzo kufanele zenziwe ngokuvumelana ncamashi ne-algorithm efanayo, eyashiwo ngenhla.
Isifundo: Indlela yokulungisa isihloko ku-Excel
Isinyathelo 5: Phrinta isihloko ekhasini ngalinye.
Ngokuvamile kuyadingeka ukuthi isihloko somqulu ophrintiwe kufanele sivele kumaphepha awo onke. Ku-Excel, lo msebenzi ulula ukuwusebenzisa. Kulesi simo, igama lwedokhumenti kuzodingeka lifake kanye kuphela, futhi ngeke kudingeke ukuba lifakwe ngekhasi ngalinye ngokwehlukana. Ithuluzi elisiza ukwenza leli thuba libe ngokoqobo linalo igama "Ngemizila". Ukuze uqedele ukuklama kwegama letafula, cabanga ukuthi ungayiprinta kanjani ekhasini ngalinye.
- Hambisa kuthebhu "Ukumaketha". Sichofoza kusithonjana "Print Printers"esithombeni "Izilungiselelo zekhasi".
- Iqalisa iwindi lezilungiselelo zekhasi kusigaba "Ishidi". Faka i-cursor ensimini "Ngemizila". Ngemuva kwalokho, khetha noma iyiphi iseli elitholakala ohlwini lapho ikhanda elibekwa khona. Kulesi simo, ikheli lendawo yonke enikeziwe iwela emkhakheni wewindi yamapharamitha ekhasi Chofoza "Kulungile".
- Ukuze uhlole ukuthi isihloko sizoboniswa kanjani uma ushicilela, iya kuthebhu "Ifayela".
- Hambisa kusigaba "Phrinta" usebenzisa amathuluzi okuzula kwimenyu yokuma kwesokunxele. Endaweni efanele yefasitela kukhona indawo yokubuka kuqala yedokhumenti yamanje. Kulindelwe ekhasini lokuqala sibona isihloko esibonisiwe.
- Manje kudingeka sibheke ukuthi igama lizoboniswa kwamanye amashidi ashicilelwe. Ngale njongo, yehlisa ibha yokuphenya phansi. Ungaphinda ufake inombolo yekhasi elifunayo kwenkambu yokubonisa ishidi bese ucindezela ukhiye Ngena. Njengoba ubona, kumashidi okushicilela wesibili kanye alandelayo isihloko siboniswa nakakhulu kakhulu kwesici esilandelayo. Lokhu kusho ukuthi uma sikhipha idokhumenti yokunyathelisa, khona-ke kuyo yonke ikhasi layo kuzoboniswa igama.
Lo msebenzi ekubunjweni kwesihloko somqulu ungacatshangwa uphelele.
Isifundo: Ukushicilela isihloko ekhasini ngalinye ku-Excel
Ngakho-ke, silandele i-algorithm yokufometha inhloko yombhalo ku-Excel. Yiqiniso, le algorithm ayiyona imfundo ecacile, okungeke kwenzeke ukuhambisa isinyathelo esisodwa. Ngokuphambene nalokho, kunenqwaba yezinketho zokwenza. Ikakhulukazi ngezindlela eziningi zokufometha igama. Ungasebenzisa inhlanganisela ehlukahlukene yamafomethi amaningi. Kule ndawo yomsebenzi, i-limiter ingumcabango womsebenzisi ngokwakhe. Nokho, sibonise izinyathelo eziyinhloko ekwenzeni isihloko. Lesi sifundo, esichaza imithetho eyisisekelo yesenzo, sibonisa indlela umsebenzisi angayisebenzisa ngayo imibono yakhe yokwakha.
