Ifomathi yeseli ohlelweni lwe-Excel lisetha kuphela ukubukeka kwedatha lokubonisa idatha, kodwa futhi ikhombisa ohlelweni ukuthi kufanele lucutshungulwe kanjani: njengombhalo, njengezinombolo, njengosuku, njll. Ngakho-ke, kubaluleke kakhulu ukusetha kahle lo mkhuba wohlu oluzofakwa ngalo idatha. Esimweni esiphikisanayo, zonke izibalo zizobe zingalungile. Ake sithole ukuthi singashintsha kanjani ifomethi yamaseli ku-Microsoft Excel.
Isifundo: Ukufometha kombhalo ku-Microsoft Word
Izinhlobo eziyinhloko zokufometha kanye noshintsho lwabo
Ngokushesha thola ukuthi yiziphi amafomethi eselikhona. Uhlelo lunikeza ukukhetha enye yezinhlobo ezilandelayo eziyinhloko zokufometha:
- Okuvamile;
- Imali;
- Inombolo;
- Izezimali;
- Umbhalo;
- Usuku;
- Isikhathi;
- Ukuhlunga;
- Isilinganiso senzalo;
- Okuzikhethela.
Ngaphezu kwalokho, kukhona ukwahlukana kube izingxenye ezincane zokwakhiwa kwezinketho ezingenhla. Isibonelo, amafomethi nosuku nesikhathi anama-subspecies amaningana (DD.MM.GG., DD.myats.GG, DD.M, FM MM PM, HH.MM, njll).
Ungashintsha ukufometha kwamaseli ku-Excel ngezindlela eziningana ngesikhathi esisodwa. Sizoxoxa ngazo ngokuningiliziwe ngezansi.
Indlela 1: imenyu yokuqukethwe
Indlela ethandwayo kakhulu yokushintsha amafomethi wezintambo zedatha ukusebenzisa imenyu yokuqukethwe.
- Khetha amaseli adinga ukufomatha ngokufanele. Yenza ngokuchofoza inkinobho yegundane kwesokudla. Ngenxa yalokho, uhlu lwezenzo lwezenzo luvuleka. Udinga ukumisa ukukhethwa kwento "Fometha amaseli ...".
- Iwindi yokufometha ivuliwe. Iya kuthebhu "Inombolo"uma iwindi livuliwe kwenye indawo. Kusemkhakheni wepharamitha "Amafomu Amanani" Kukhona zonke izinketho zokushintsha izici ezixoxwe ngenhla. Khetha into ehambelana nedatha ebangeni elikhethiwe. Uma kunesidingo, engxenyeni efanele yefasitela sichaza ukubuyekezwa kwedatha. Sicindezela inkinobho "Kulungile".
Emva kwalezi zenzo, ifomethi yeseli ishintshiwe.
Indlela 2: Inombolo yamathuluzi wokubala ku-ribbon
Ukufometha kungabuye kushintshwe ngokusebenzisa amathuluzi ku-tape. Le ndlela iyashesha kunalowo owedlule.
- Iya kuthebhu "Ikhaya". Kulesi simo, udinga ukukhetha amangqamuzana afanele eshidi, futhi kuzilungiselelo ukuvimba "Inombolo" Ebhebheni, vula ibhokisi lokukhetha.
- Vele ukhethe ukhetho olufunayo. Ububanzi buzoshintsha ngokushesha ukufometha kwayo.
- Kodwa kuphela amafomethi asemqoka alethwe kulolu hlu. Uma ufuna ukucacisa ukufometha ngokuqondile, kufanele ukhethe "Amanye amafomathi wenombolo".
- Emva kwalezi zenzo, iwindi lizovuleka ukufometha ububanzi, obuye buxoxwe ngenhla. Umsebenzisi angakhetha lapha noma yimaphi amafomethi omqoka noma engeziwe.
Indlela 3: Ibhokisi lamathuluzi weselula
Enye indlela yokubeka lesi sici sobubanzi ukusebenzisa ithuluzi kuzilungiselelo zokuvimba. "Amaseli".
- Khetha ibanga kushidi, okufanele lifomathiwe. Kutholakala kuthebhu "Ikhaya", chofoza kusithonjana "Fometha"esiseqenjini lesithuluzi "Amaseli". Kuhlu lwezenzo ezivula, khetha into "Fometha amaseli ...".
- Ngemuva kwalokhu, iwindi lesifomathi esivele seliyaziwa lisebenza. Zonke izenzo ezengeziwe zifana nalokho okushiwo ngenhla.
Indlela 4: ama-hotkeys
Futhi ekugcineni, iwindi lokufometha lokubanzi lingabizwa ngokusebenzisa okwakuthiwa okhiye abashisayo. Ukuze wenze lokhu, qala ukhethe indawo ezoshintshwa kushidi, bese uthayipha inhlanganisela ekhibhodi Ctrl + 1. Emva kwalokho, ifasitela lokufometha elijwayelekile lizovuleka. Sishintsha izici njengoba kukhulunywe ngenhla.
Ngaphezu kwalokho, inhlanganisela ngayinye yokushisa ewusizo ikuvumela ukuba ushintshe ifomethi yamaseli ngemuva kokunika ibanga, ngisho ngaphandle kokubiza iwindi elikhethekile:
- Ctrl + Shift + - - ifomethi jikelele;
- I-Ctrl + Shift + 1 - izinombolo ngehlukanisi;
- Ctrl + Shift + 2 - isikhathi (amahora.maminithi);
- Ctrl + Shift + 3 - izinsuku (DD.MM.GG);
- Ctrl + Shift + 4 - ukheshi;
- I-Ctrl + Shift + 5 - inzalo;
- Ctrl + Shift + 6 - ifomethi O.OOE + 00.
Isifundo: Amakhadi ashisayo ku-Excel
Njengoba ubona, kunezindlela eziningana zokufometha izindawo zephepha le-Excel. Le nqubo ingenziwa ngokusebenzisa amathuluzi ku-tape, ngokubiza ifomathi yokufometha noma ngokusebenzisa izinkinobho ezishisayo. Umsebenzisi ngamunye uyazikhethela ukuthi yikuphi okulula kakhulu ukuxazulula imisebenzi ethile, ngoba kwezinye izimo kunelungelo lokusebenzisa amafomethi ajwayelekile, futhi kwabanye, ukukhombisa okuqondile izici ze-subspecies kuyadingeka.
