Ukupela umbhalo wokuqhafaza kusetshenziselwa ukukhombisa ukunganaki, ukungaqondakali kwesenzo noma umcimbi. Kwesinye isikhathi lesi sici siba yisidingo sokusebenzisa lapho sisebenza e-Excel. Kepha, ngeshwa, noma ikhibhodi, noma ingxenye ebonakalayo yesibonakaliso sohlelo ayinamathuluzi atholakalayo okwenza lesi senzo. Ake sibheke ukuthi ungawusebenzisa kanjani umbhalo owedlule e-Excel.
Isifundo: Umbhalo onamandla wokuqina kwiMicrosoft Word
Kusetshenziswa umbhalo onamandla
Ukushaywa ngamandla e-Excel yinto yokufometha. Ngokuvumelana nalokhu, le mpahla inganikezwa umbhalo usebenzisa amathuluzi wokufometha.
Indlela yoku-1: imenyu yokuqukethwe
Indlela evame kakhulu ngabasebenzisi yokufaka umbhalo ohlukaniselwe phakathi kwabasebenzisi ukuya efasiteleni ngemenyu yokuqukethwe Uhlobo Lweseli.
- Khetha iseli noma ibanga lapho umbhalo ofuna ukwenza uwele khona. Qhafaza kwesokudla. Imenyu yokuqukethwe iyavula. Chofoza ohlwini olusohlwini Uhlobo Lweseli.
- Iwindi lokufometha liyavula. Iya kuthebhu Ifonti. Hlola ibhokisi eliseduze nentwana Ukuhlaselwaokuyiqembu lezilungiselelo "Ukuguqulwa". Chofoza inkinobho "Kulungile".
Njengoba ubona, ngemuva kwalezi zenzo, izimpawu ezisezingeni elikhethiwe zahlukaniswa.
Isifundo: Ifometha amatafula ku-Excel
Indlela 2: fometha amagama ngamanye kumaseli
Imvamisa kuyadingeka ukwenza ukuthi ukwazi ukuqaqa hhayi konke okuqukethwe esitokisini, kepha amagama athile akulo kuphela, noma nengxenye yegama. Ku-Excel, lokhu kungenzeka futhi.
- Sibeka isikhombisi ngaphakathi kweseli bese sikhetha ingxenye yombhalo okufanele idabule. Qhafaza kwesokudla kumenyu yokuqukethwe. Njengoba ukwazi ukubona, inokubukeka okuhlukile okuhlukile kunasetshenziswa indlela edlule. Noma kunjalo, into esiyidingayo "Ifomethi yeseli ..." nalapha. Qhafaza kuwo.
- Iwindi Uhlobo Lweseli iyavula. Njengoba ukwazi ukubona, kulokhu kuqukethe ithebhu eyodwa kuphela Ifonti, okubuye kube lula ukwenza lo msebenzi, ngoba asikho isidingo sokuya noma kuphi. Hlola ibhokisi eliseduze nentwana Ukuhlaselwa bese uchofoza inkinobho "Kulungile".
Njengoba ubona, ngemuva kwale maniplication, kuphela ingxenye ekhethiwe yezinhlamvu zombhalo esitokisini yakhishwa.
Indlela yesi-3: amathuluzi wetheyiphu
Ukushintshwa kwamaseli wokufometha ukunikeza umbhalo ukubukeka okunamandla kungenziwa ngokusebenzisa iribhoni.
- Khetha iseli, iqembu lamaseli noma umbhalo ngaphakathi kwalo. Iya kuthebhu "Ikhaya". Sichofoza isithonjana ngesimo somcibisholo oqondile obekwe ekhoneni elingezansi kwesakhiwo sebhulokhi Ifonti ekhasethini.
- Iwindi lokufomatha livula ngokusebenza okugcwele noma elifushane. Kuya ngokuthi ukhethe ini: amaseli noma umbhalo nje. Kodwa noma ngabe iwindi linokusebenza okugcwele kwethebhu eminingi, izovula kuthebhu Ifonti, esidinga ukuxazulula inkinga. Okulandelayo, senza okufanayo nakwindlela ezimbili ezedlule.
Indlela 4: isinqamuleli sekhibhodi
Kepha indlela elula yokwenza ukuqhutshwa kombhalo kusetshenziswe izinkinobho ezishisayo. Ukuze wenze lokhu, khetha iseli noma umbhalo oqonde kuwo bese uthayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + 5.
Impela, le ndlela elula futhi esheshayo kunazo zonke izindlela ezichaziwe, kepha uma kunikezwe iqiniso lokuthi inani elilinganiselwe labasebenzisi ligcina ukuhlanganiswa okuhlukahlukene kwe-hotkey kwimemori yabo, le ndlela yokwakha umbhalo odlulisiwe iphansi imvamisa yokusebenzisa le nqubo ngewindi lokufometha.
Isifundo: Izitolo ezishisayo
Ku-Excel, kunezindlela ezimbalwa zokwenza umbhalo uthambekele. Zonke lezi zinketho zihlobene nomsebenzi wokufomatha. Indlela elula yokwenza ukuguqulwa kohlamvu okuchaziwe ukusebenzisa inhlanganisela ye-hotkey.