Ungawenza kanjani umbhalo ocindezelekile ku-Excel

Umbhalo ocindezelekile ku-Microsoft Excel

Ukubhala ngombhalo womqhele kusetshenziselwa ukukhombisa ukunganaki, ukungasebenzi kwesenzo esithile noma umcimbi. Kwesinye isikhathi lesi sici sivela isidingo sokufaka isicelo lapho sisebenza ku-Excel. Kepha, ngeshwa, noma kwikhibhodi, noma engxenyeni ebonakalayo yesibonisi sohlelo awekho amathuluzi abonakalayo wokwenza lesi senzo. Ake sibheke ukuthi usengawusebenzisa kanjani umbhalo onqamule ku-Efpelle.

Isifundo: Umbhalo Ocindezelekile KuMicrosoft Word

Ukusetshenziswa kombhalo onqamule

I-Excreting ku-Excel yinto yokufometha. Ngokuvumelana nalokhu, le mpahla inganikezwa usebenzisa amathuluzi wokushintsha ifomethi.

IMenyu 1: Imenyu yokuqukethwe

Imodi ejwayelekile kakhulu phakathi kwabasebenzisi yindlela yokuvula umbhalo onqamule okuhambisana noguquko ngewindi lokuqukethwe ewindini le- "cell format".

Sigqamisa iseli noma ibanga, umbhalo lapho udinga ukuwenza khona. Chofoza inkinobho yegundane kwesokudla. Imenyu yomongo iyavula. Chofoza ohlwini nge "fomay of amaseli".

Ukushintshela kwifomethi yeseli ku-Microsoft Excel

Iwindi lokufometha livula. Iya kuthebhu "yefonti". Faka umaki wokuhlola phambi kwento "eqondile", esomhlokweni we- "Modiff" wezilungiselelo. Chofoza inkinobho ethi "KULUNGILE".

Amangqamuzana efomathi ku-Microsoft Excel

Njengoba sibona, ngemuva kwalezi zenzo, izinhlamvu ebangeni elizinikezele zavela.

Umbhalo ocindezelekile kumaseli ku-Microsoft Excel

Isifundo: Ukufomatha amatafula ku-Excel

Indlela 2: Ukufomatha kwamagama ngamanye kumaseli

Imvamisa, kuyadingeka ukwenza konke okuqukethwe esitokisini, kepha kuphela amagama athile akulo, noma ingxenye yeZwi. Ku-Excel kungenzeka futhi ukukwenza.

Sisungula isikhombisi ngaphakathi esitokisini futhi sigqamise ingxenye yombhalo okufanele wenziwe. Qhafaza kwesokudla imenyu yokuqukethwe. Njengoba sibona, inohlobo oluhlukile kunalokho lapho usebenzisa indlela edlule. Noma kunjalo, into engiyidingayo "amaseli efomathi ..." Kukhona futhi lapho. Chofoza kuyo.

Iwindi le- "Cell format" livula. Njengoba ubona, kuqukethe konke okuvela kuthebhu eyodwa "font", okuthi futhi kube lula umsebenzi, njengoba ungadingi ukuya noma kuphi. Sifaka umkhaza obhekene nento "ecindezelekile" bese ucindezela inkinobho ethi "KULUNGILE".

Ifomethi yamaseli ohlelweni lweMicrosoft Excel

Njengoba sikwazi ukubona, ngemuva kwalokhu kungasebenzi, yingxenye ekhethiwe yezimpawu zombhalo esitokisini yachotshozwa.

Umbhalo ocindezelekile esitokisini kuMicrosoft Excel

Indlela 3: Amathuluzi ku-Ribbon

Ushintsho ekufomeni kwamaseli ukunikela umbhalo uphume, kungenziwa ngetheyipu.

Sigqamisa iseli, iqembu lamaseli noma umbhalo ngaphakathi kulo. Iya kuthebhu "Yasekhaya". Chofoza isithonjana ngendlela yemicibisholo e-oblique etholakala ekhoneni elingezansi kwesokudla kwefonti yamathuluzi wefonti ethepheni.

Ukuguqulwa kokufomatha ku-Microsoft Excel

Iwindi lokufometha livula noma lisebenze ngokuphelele, noma lifinyeziwe. Kuya ngeqiniso lokuthi ubekelwe: amaseli noma umbhalo kuphela. Kepha noma ngabe iwindi lizoba nokusebenza okugcwele okugcwele, lizovulwa kuthebhu "yefonti", esidinga ukuxazulula umsebenzi. Okulandelayo, yenza okufanayo nasezikhethweni ezimbili ezedlule.

Indlela 4: Inhlanganisela yokhiye

Kepha indlela elula yokwenza umbhalo unqamule ukusetshenziswa kwezikhiye "ezishisayo". Ukuze wenze lokhu, khetha iseli noma igama elithi Inkulumo kulo bese ushayela ukhiye wekhibhodi kukhibhodi ye-CTRL + 5.

Vele, lokhu kulula kakhulu futhi okusheshayo kwazo zonke izindlela ezichaziwe, kepha kunikezwe iqiniso lokuthi inani elilinganiselwe labasebenzisi ligcina ukuhlanganiswa okuhlukahlukene kwezinkinobho ezishisayo, lokhu okuhlukile kokudala umbhalo onqabile kuphansi kokuvama kwalokhu Inqubo ngewindi lokufomatha.

Isifundo: Okhiye abashisayo ku-evelela

Ku-Excel Kunezindlela eziningana zokwenza umbhalo uphume. Zonke lezi zinketho zihambisana nomsebenzi wokufomatha. Indlela elula yokwenza ukuguqulwa kwezimpawu ezicacisiwe ukusebenzisa inhlanganisela yezinkinobho ezishisayo.