Imvamisa, okuqukethwe esitokisini etafuleni akuhambelani nemingcele efakwe ngokuzenzakalelayo. Kulokhu, umbuzo wokunwetshwa kwabo kufanele usebenze ngokulandelana kwayo yonke imininingwane ukuze ivumelane futhi ubone umsebenzisi. Ake sibheke ukuthi le ndlela le nqubo engahle yenziwe kanjani.
Inqubo yokwandisa
Kunokukhethwa okuningana okunwebeka amaseli. Ezinye zazo zibandakanya ukuphikisana ngokwakho imingcele, futhi nabanye ungahlela ukwenziwa okuzenzakalelayo kwale nqubo ngokuya ngobude bokuqukethwe.Indlela 1: Imingcele elula yokuhudula
Inketho elula futhi enembile yokwandisa osayizi beseli ukudonsela imingcele ngesandla. Lokhu kungenziwa ngesilinganiso esithe mpo nesivundlile semigqa namakholomu izixhumanisi.
- Sisungula isikhombisi emngceleni wesokudla lomkhakha ovundlileka ukudidiyela isilinganiso sekholomu esifuna ukunweba. Ngasikhathi sinye, isiphambano sivela ngamaphoyinti amabili aqondiswe ezinhlangothini eziphambene. Chofoza inkinobho yegundane kwesobunxele nemingcele efanelekile ngakwesokudla, okungukuthi, kude nendawo enkabeni yeseli elinwebekayo.
- Uma kunesidingo, inqubo enjalo ingenziwa ngemigqa. Ukuze wenze lokhu, udinga ukubeka isikhombisi emkhawulweni ophansi womugqa ozowakhula. Ngokufanayo, bopha inkinobho yegundane kwesobunxele bese udonsa umngcele phansi.
QAPHELA! Uma esilinganisweni esivundlile usibeka isikhombisi emkhawulweni wesobunxele wekholamu enwetshiwe, futhi mpo eyodwa kuya umkhawulo ophezulu womugqa, wenza inqubo yokutshala, bese usayizi amaseli aqondiwe ngeke akhuphuke. Bamane bahambisa eceleni ngenxa yoshintsho ngobukhulu bezinye izinto zeshidi.
Indlela 2: Ukunwetshwa kwamakholomu amaningana nemigqa
Kukhona futhi inketho yokunweba amakholomu noma imigqa eminingana ngasikhathi sinye.
- Sigqamisa imikhakha eminingana esikalini esivundlile naso.
- Sisungula isikhombisi emngceleni wesokudla ngakwesokudla kwelungelo kusuka kumaseli (ngesilinganiso esivundlile) noma umkhawulo ophansi weseli eliphansi (ngesilinganiso esithe mpo). Chofoza inkinobho yegundane kwesobunxele bese udonsa umcibisholo uvele ngokulandelana noma phansi.
- Lokhu kwandisa hhayi kuphela ibanga elibi kakhulu, kodwa futhi namaseli endawo ekhethiwe yonke.
Indlela 3: Ukufakwa kosayizi ngesandla ngemenyu yokuqukethwe
Ungenza futhi okokufaka okwenziwe ngesandla kosayizi weseli, kulinganiswe ngamanani amanani. Ngokuzenzakalelayo, ukuphakama kunosayizi wamayunithi ayi-12,75, futhi ububanzi bungamayunithi angama-8.43. Ungakhulisa kuze kube ngamaphuzu angama-409, futhi ububanzi bube ngu-255.
- Ukuze ushintshe amapharamitha wobubanzi beseli, khetha uhla olufunayo esikalini esivundlile. Chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe evelayo, khetha into ethi "ikholomu ebanzi".
- Kuvulwa iwindi elincane, lapho udinga ukufaka khona ububanzi bekholomu oyifunayo kumayunithi. Faka usayizi oyifunayo kwikhibhodi bese uqhafaza inkinobho ethi "Kulungile".
Indlela efanayo yenziwa ushintsho emigqeni.
- Khetha umkhakha noma ukwahluka kwesilinganiso esiqonde mpo. Chofoza kuleli sayithi ngenkinobho yegundane efanele. Kumenyu yokuqukethwe, khetha "ukuphakama kwentambo ..." into.
- Iwindi livula, lapho udinga ukushayela khona ukuphakama okufunwa kwamaseli wohlu olukhethiwe kumayunithi. Sikwenza bese sichofoza inkinobho ethi "Kulungile".
Ukukhohlisa okungenhla kukuvumela ukwandisa ububanzi nokuphakama kwamaseli kumayunithi wokulinganisa.
Indlela 4: Faka usayizi wamaseli ngenkinobho ku-Ribbon
Ngaphezu kwalokho, kungenzeka ukusetha usayizi weselula ochaziwe nge-tape inkinobho.
- Sikwabela iseli eshidini, usayizi ofuna ukufaka kuwo.
- Iya kuthebhu "Yasekhaya", uma sikwenye. Chofoza inkinobho ethi "format", etholakala ethepheni ku- "Cell" yamathuluzi. Uhlu lwezenzo luyavula. Ngokuhlukile Khetha amaphuzu "umugqa wokuphakama ..." kanye "nobubanzi bekholomu ...". Ngemuva kokucindezela ngakunye kwalezi zinto, kuzovulwa amafasitela amancane, lapho le ndaba yayilandela lapho ichaza indlela edlule. Bazodinga ukwethula ububanzi obufunayo nokuphakama kobubanzi be-cell. Ukuze amaseli akhuphuke, inani elisha lalezi zinhlaka kumele libe likhulu kunalokho okufakwe ngaphambili.
Indlela 5: Khulisa usayizi wawo wonke amashidi eshidi noma incwadi
Kunezimo lapho udinga ukwandisa ngokuphelele wonke amaseli eshidi noma nezincwadi. Tshela ukuthi ungakwenza kanjani.
- Ukuze wenze lo msebenzi, okokuqala, khetha izinto ozifunayo. Ukuze ukhethe zonke izinto zeshidi, ungavele ucindezele ukhiye wekhibhodi ku-CTRL + ikhibhodi. Kukhona inketho yesibili. Kusho ukucindezela inkinobho ngendlela yesikwele, etholakala phakathi kokuqondisa okuqondile futhi okuvundlile kwe-Excel Scale.
- Ngemuva kokuthi ishidi selikhishwe nganoma iyiphi yalezi zindlela, chofoza inkinobho ethi "format" esevele ejwayelene "ethepheni futhi ukhiqize ezinye izenzo ngendlela efanayo njengoba kuchaziwe ngendlela eyedlule nenguquko kumaphoyinti" Ububanzi bekholomu .. . "kanye" nokuphakama komugqa ... ".
Izenzo ezifanayo zikhiqiza ukwandisa usayizi wamaseli kuyo yonke incwadi. Ukugqamisa kuphela wonke amashidi esisebenzisa omunye ukwamukela.
- Ngokuchofoza inkinobho yegundane efanele kwilebula yanoma imaphi amashidi, atholakala ezansi kwewindi ngokushesha ngaphezulu kwesilinganiso sesimo. Kumenyu evela, khetha u- "abela wonke amashidi".
- Ngemuva kokuthi amashidi aqokonyisiwe, yenza umsebenzi we-Ribbon usebenzisa inkinobho ethi "format", okuchazwe ngendlela yesine.
Isifundo: Kanjani ukwenza amaseli osayizi ofanayo ku-Excel
Indlela 6: Ububanzi
Le ndlela ayikwazi ukubizwa ngokuthi ukwanda okugcwele kosayizi weseli, kepha, noma kunjalo, kuyasiza nokufanelana nombhalo ngokuphelele kwimikhawulo etholakalayo. Lapho isizwa, ukwehla okuzenzakalelayo ezimpawuni zombhalo kungukuthi lingene esitokisini. Ngakho-ke, kungashiwo ukuthi usayizi wawo ohlobene nombhalo uyanda.
- Sabela ububanzi obufisa ukusebenzisana nalo ukuthola izakhiwo zobubanzi bebubanzi. Chofoza ekuqokomeni inkinobho yegundane efanele. Imenyu yomongo iyavula. Khetha kuyo "ifomethi yeseli ...".
- Iwindi lokufometha livula. Iya kuthebhu ethi "Alignment". Ku-Izilungiselelo ze- "Display" Vimbela izilungiselelo, sibeka umkhaza eduze nepharamitha "Yound". Chofoza inkinobho ethi "Kulungile" ezansi kwewindi.
Ngemuva kwalezi zenzo, noma ngabe ukuqoshwa kuyinto isikhathi esingakanani, kepha kuzolingana esitokisini. Kuliqiniso, kufanele ucabangele ukuthi uma kunezinhlamvu eziningi kakhulu eshidini elishiywe, futhi umsebenzisi ngeke awukhuliseke ngenye yezindlela ezedlule, khona-ke lokhu kufakwa kungaba yincane kakhulu, kuze kube yilapho kungafundeki kakhulu. Ngakho-ke, bangena ngohlobo olunikeziwe ukuqinisekisa imininingwane emingceleni, hhayi kuzo zonke izimo kwamukelekile. Ngaphezu kwalokho, kufanele kushiwo ukuthi le ndlela isebenza kuphela ngombhalo, kepha hhayi ngamanani ezinombolo.
Njengoba sibona, kunezindlela eziningi zokwandisa usayizi wazo zombili amaseli ngamanye namaqembu aphelele, kuze kukhuphuke kuzo zonke izinto zeshidi noma izincwadi. Umsebenzisi ngamunye angakhetha inketho elula kunazo zonke ukwenza le nqubo ngezimo ezithile. Ngaphezu kwalokho, kunendlela eyengeziwe yokuhlalisa okuqukethwe emikhawulweni yeseli usebenzisa ububanzi bebubanzi. Kuliqiniso, indlela yokugcina inemikhawulo ethile.