Lapho udala amathebula ku-Microsoft Office Excel, umsebenzisi angakwazi ukukhulisa usayizi wamalungu afanayo ukuze andise ulwazi oluqukethwe kumaseli. Lokhu kuyasiza uma ubukhulu bezinto zoqobo buncane kakhulu futhi kungasebenzi kahle. Lesi sihloko sizokwethula izici zokwandisa amatafula ku-Excel.
Ungawandisa kanjani usayizi wamathebula ku-Excel
Kunezindlela ezimbili eziyinhloko zokufeza lo mgomo: ukwandisa amangqamuzana ngamanye epuleti ngesandla, isibonelo, amakholomu noma imigqa; sebenzisa umsebenzi wokusondeza isikrini. Esimweni sokugcina, isikali seshidi lokusebenzela sizoba sikhulu, ngenxa yalokho zonke izimpawu ezikulo zizokhula. Zombili izindlela kuzoxoxwa ngazo ngokuningiliziwe ngezansi.
Indlela 1. Indlela yokukhulisa usayizi wamaseli ngamanye wohlu lwetafula
Imigqa esethebula ingakhuliswa ngale ndlela elandelayo:
- Beka ikhesa yegundane ngaphansi komugqa ukuze ukhuliswe emngceleni wayo ngomugqa olandelayo.
- Hlola ukuthi ikhesa isiphenduke umcibisholo okabili.
- Bamba i-LMB bese wehlisa igundane, okungukuthi usuka emugqeni.
- Qeda umsebenzi wokudonsa lapho umthungo ufinyelela usayizi ofisa ukuwusebenzisa.
- Ngokufanayo, nweba noma yimuphi omunye umugqa kuthebula elethulwa.
Nakani! Uma, ubambe i-LMB, uqala ukuhambisa igundane phezulu, umugqa uzoncipha.
Amasayizi amakholomu akhula ngendlela efanayo:
- Setha ikhesa yegundane ohlangothini lwesokudla oludlulele lwekholomu ethile, okungukuthi emngceleni wayo nekholomu elandelayo.
- Qiniseka ukuthi ikhesa iyashintsha ibe umcibisholo ohlukanisayo.
- Cindezela phansi inkinobho yegundane kwesokunxele bese uhambisa igundane kwesokudla ukuze wandise usayizi wekholomu yoqobo.
- Hlola umphumela.
Ngendlela ecatshangelwe, ungakwazi ukwandisa amakholomu nemigqa kuthebula enanini elingapheli kuze kube yilapho uhlu luthatha sonke isikhala sephepha lokusebenzela. Nakuba imingcele yenkambu ku-Excel ingenayo imikhawulo.
Indlela 2. Ukusebenzisa ithuluzi elakhelwe ngaphakathi ukwandisa usayizi wezinto zetafula
Kukhona futhi enye indlela yokukhulisa usayizi wemigqa ku-Excel, ebandakanya lokhu kukhohlisa okulandelayo:
- Khetha i-LMB umugqa owodwa noma ngaphezulu ngokuhambisa igundane ohlangothini lwephepha lokusebenzela “phezulu-phansi”, okungukuthi ngokuma mpo.
- Chofoza kwesokudla esiqeshini esikhethiwe.
- Kumenyu yokuqukethwe, chofoza into ethi "Ubude bomugqa ...".
- Emugqeni owodwa wewindi elivulayo, shintsha inani lobude obubhaliwe ngenombolo enkulu bese uchofoza okuthi "KULUNGILE" ukuze usebenzise izinguquko.
- Hlola umphumela.
Ukwelula amakholomu usebenzisa ithuluzi elakhelwe ohlelweni, ungasebenzisa le miyalelo elandelayo:
- Khetha ohlangothini oluvundlile ikholomu ethile yethebula edinga ukukhuliswa.
- Chofoza kwesokudla noma yikuphi engxenyeni ekhethiwe bese ukhetha inketho ethi “Ububanzi bekholomu …” kumenyu.
- Udinga ukubhalisa inani lobude elizoba likhulu kunalena yamanje.
- Qiniseka ukuthi i-elementi yohlu lwethebula inyukile.
Kubalulekile! Kumawindi athi “Ububanzi Bekholomu” noma “Ubude Bomugqa”, ungashintsha amanani ashiwo izikhathi ezimbalwa umsebenzisi aze athole umphumela awufunayo.
Indlela yesi-3: Ukulungisa ukukala kwemonitha
Ungakwazi ukwelula lonke ishidi ku-Excel ngokwandisa ukukalwa kwesikrini. Lena indlela elula yokuqeda umsebenzi, ehlukaniswe ngezinyathelo ezilandelayo:
- Vula idokhumenti ye-Microsoft Excel oyifunayo ngokusebenzisa ifayela eligciniwe kukhompyutha yakho.
- Cindezela inkinobho ethi “Ctrl” kukhibhodi ye-PC bese uyibamba.
- Ngaphandle kokukhipha u-“Ctrl”, skrola isondo legundane uye phezulu kuze kube yilapho isikali sesikrini sikhuphuka sibe ngusayizi odingwa umsebenzisi. Ngakho, itafula lonke lizokhula.
- Ungakwazi ukwandisa ukukalwa kwesikrini ngenye indlela. Ukuze wenze lokhu, ngenkathi useshidini le-Excel, udinga ukususa isilayidi ekhoneni elingezansi kwesokudla kwesikrini ukusuka kokuthi - ukuya +. Njengoba ihamba, ukusondeza idokhumenti kuzokwanda.
Ulwazi Olwengeziwe! I-Excel futhi inenkinobho ekhethekile ethi "Sondeza" kuthebhu ethi "Buka", ekuvumela ukuthi uguqule ukukala kwesikrini phezulu naphansi.
Indlela 4. Shintsha isikali sohlu lwethebula ngaphambi kokuphrinta idokhumenti
Ngaphambi kokuphrinta ithebula ku-Excel, udinga ukuhlola isikali salo. Lapha ungakwazi futhi ukwandisa usayizi we-array ukuze ithathe lonke ishidi le-A4. Ukusondeza ngaphambi kokuphrinta kuyashintsha ngokuya ngohlelo olulandelayo:
- Chofoza inkinobho ethi "Ifayela" ekhoneni eliphezulu kwesokunxele kwesikrini.
- Ewindini lohlobo lokuqukethwe, chofoza i-LMB kulayini "Phrinta".
- Esigatshaneni esithi “Izilungiselelo” kumenyu evelayo, thola inkinobho yokushintsha isikali. Kuzo zonke izinguqulo ze-Excel, itholakala ekugcineni ohlwini futhi ibizwa ngokuthi “Okwamanje”.
- Nweba ikholomu ngegama elithi “Okwamanje” bese uchofoza umugqa “Izinketho zokukala ngokwezifiso …”.
- Efasiteleni elithi "Izinketho Zekhasi", hamba kuthebhu yokuqala, esigabeni "Isikali", faka inkinobho yokuguqula emgqeni othi "Setha" bese ufaka inombolo yokukhulisa, isibonelo, 300%.
- Ngemva kokuchofoza "KULUNGILE" hlola umphumela efasiteleni lokubuka kuqala.
Nakani! Uma ithebula lingekho kulo lonke ikhasi le-A4, udinga ukubuyela efasiteleni elifanayo futhi ucacise inombolo ehlukile. Ukuze uthole umphumela oyifunayo, inqubo kuzodingeka iphindwe izikhathi eziningana.
Isiphetho
Ngakho-ke, kulula ukwelula itafula ku-Excel ekhasini eligcwele usebenzisa indlela yokukala isikrini. Ichazwe kabanzi ngenhla.