Ngamanye amaxesha xa usebenza neetafile, kufuneka ufake isicatshulwa kwiseli ngokuthe nkqo, kwaye ungabi ngokuthe tyaba, njengoko ihlala yamkelwe. Eli nqaku linikezelwa yinkqubo ye-Excel. Kodwa ayinguye umsebenzisi owaziyo ukuyisebenzisa. Masijongane neendlela ezinokuthi zikwazi ukubhala itekisi ngokuthe nkqo.
Isifundo: Ungabhala njani ngokuthe nkqo kwi-Microsoft
Ukubhala Ukurekhoda ngokuthe nkqo
Umbuzo wokubandakanya ungeniso oluthe nkqo kwi-Excel lusonjululwe izixhobo zokufomatha. Kodwa ngaphandle kwezi zinto, zikho iindlela ezahlukeneyo zokuyisebenzisa ekusebenzeni.Indlela yoku-1: Ulungelelwaniso ngemenyu yemeko
Uninzi lwazo, abasebenzisi bakhetha ukubandakanya ukubhalwa ngokuchaseneyo kwesicatshulwa usebenzisa ulungelelwaniso kwi "fom formic" yefowuni "apho ungaya khona kwimenyu yemeko.
- Ngokucofa iqhosha lemouse lasekunene kwiseli, elinerekhodi ekufuneka siyiguqulele ibe sisikhundla esithe nkqo. Kwimenyu yemeko evula, khetha into "yefomathi".
- "Ifomathi yeseli" ivula. Yiya kwi "thungelwano" ithebhu. Kwicala lasekunene le-Windo evulekileyo kukho iisethi "zokuqhelanisa". Kwintsimi "Degree", okungagqibekanga "0". Oku kuthetha ukuba isikhokelo esithe tyaba sesicatshulwa kwiiseli. Qhuba kule ntsimi usebenzisa ixabiso lekhibhodi "90".
Unokwenza ngokufanayo. Kwisicatshulwa "Isicatshulwa" kukho igama elithi "umbhalo". Cofa kuyo, gubungela iqhosha lemouse lasekhohlo kwaye wolule de igama lamkele isikhundla esithe nkqo. Masikhuphe iqhosha lemouse.
- Emva kokuba useto oluchazwe apha ngasentla lwenziwe ngefestile, cofa kwiqhosha le-Ok.
Njengoko sibona, emva kwezi zenzo, ukungena kwiseli ekhethiweyo kuye kwabakho nkqo.
Indlela 2: Iintshukumo zeRibbon
Kulula ngakumbi ukwenza ukuba itekisi nkqo-isetyenziswa liqhosha elikhethekileyo kwi-ribbon, eyayingabasebenzisi abaninzi bazi nangaphantsi kwefestile yokufomatha.
- Khetha iseli okanye uluhlu apho siceba ukubeka ulwazi.
- Yiya kwithebhu "yasekhaya", ukuba okwangoku sikwinye ithebhu. Kwiteyiphu yesixhobo "solungelelwaniso" isixhobo, cofa kwiqhosha "lokuqhelanisa". Kuluhlu oluvula, khetha i "Riseterate i-up" into.
Emva kwezi zenzo, isicatshulwa kwiseli ekhethiweyo okanye uluhlu luya kuboniswa ngokuthe nkqo.
Njengoko ubona, le ndlela ilunge ngakumbi kunangaphambili, kodwa, nangona kunjalo, isetyenziswa kancinci. Kuyo yonke into efanayo, ngokungaphezulu kokwenza le nkqubo ngefestile yokufomatha, unokuya kwitheyisi yayo ehambelana neteyiphu. Ukwenza oku, ngelixa "kwikhaya", kwanele ukucofa kwi icon ngohlobo olufanelekileyo, olubekwe kwikona esezantsi yecandelo lesixhobo secandelo lesixhobo solingano.
Emva koko, "ifomathi yeseli" iya kuvulwa kwaye zonke izinto zabasebenzisi kufuneka zifane nendlela yokuqala. Oko kukuthi, kuya kuba yimfuneko ukwenza ukutshintsha kunye nezixhobo kwi "MALIT" ibhloko kwithebhu yokulungelelanisa.
Ukuba ufuna ukuthe nkqo kwindawo yesicatshulwa ngokwawo, kwaye iileta bezikwisikhundla esiqhelekileyo, ke kuye kwenziwa kusetyenziswa iqhosha lokufunda kwiteyiphu. Sicofa kweli qhosha kwaye kuluhlu oluvelayo, khetha umxholo "othe nkqo".
Emva kwezi zenzo, isicatshulwa siya kuthatha indawo ehambelanayo.
Isifundo: Iitafile zokufomatha kwi-Excel
Njengoko ubona, zimbini iindlela eziphambili zokuhlengahlengisa ukuqhelaniswa kwesicatshulwa: "kwifomathi yeseli" nangexesha "lokuvumelanisa" kwiteyiphu. Ngale ndlela, zombini ezi ndlela zisebenzisa indlela efanayo yokufomatha. Ukongeza, kuya kufuneka wazi ukuba kukho iinguqulelo ezimbini zendawo ethe nkqo yezinto eziseseleni: indawo ethe nkqo yoonobumba kunye nokufakwa kwamagama ngokubanzi. Kwimeko yokugqibela, iileta zibhalwe kwisikhundla esiqhelekileyo, kodwa kwikholamu.