Ngokuvamile, okuqukethwe kweseli etafuleni akuhambisani nemingcele ebekwe ngokuzenzakalelayo. Kulesi simo, umbuzo wokukhulisa kwawo uba osebenzayo ukuze yonke imininingwane ihambisane nokubuka okuphelele komsebenzisi. Ake sithole ukuthi ungenza kanjani le nqubo ku-Excel.
Inqubo yokwandisa
Kunezinketho eziningi zokwandisa amaseli. Ezinye zazo zihlinzeka umsebenzisi ukuba aqhube imingcele ngesandla, futhi ngosizo lwabanye ungahlela ukusebenza ngokuzenzekelayo kwalolu nqubo kuye ngobude bokuqukethwe.
Indlela yoku-1: ukuhudula nokudonsa okulula
Indlela elula futhi enembile kakhulu yokwandisa usayizi weseli ukuhudula imingcele ngesandla. Lokhu kungenziwa ngezixhumanisi ezilinganiselwe nezilinganiselwe zemigqa namakholomu.
- Beka isikhombisi emngceleni ongakwesokudla womkhakha esilinganisweni esiphezulu sekholomu esifuna ukuwandisa. Ngesikhathi esifanayo, isiphambano sibonakala ngezici ezimbili ezikhomba ngezindlela ezihlukile. Cisha inkinobho yesinxele segundane bese uhudula imingcele ngakwesokudla, okungukuthi, kude nenkabeni yeselula ekhuliswayo.
- Uma kunesidingo, inqubo efanayo ingenziwa ngezintambo. Ukuze wenze lokhu, faka isikhombisi emngceleni ongaphansi komugqa ozokwandisa. Ngokufanayo, bamba inkinobho yegundane lesokunxele bese udonsa umngcele phansi.
Qaphela! Uma kusesikalini esinqunyiwe sezixhumanisi ufaka isikhombisi emngceleni ongakwesokunxele wekholomu ekhuliswayo, futhi ekugcineni - emngceleni ongaphezulu wegqawu, ngemuva kokulandelwa kwenqubo, ubukhulu bamaseli ahlosiwe ngeke banda. Bavele baphambuke ngokushintsha ubukhulu bezinye izakhi zeshidi.
Indlela 2: ukwandisa amakholomu amaningi nemigqa
Kukhona futhi inketho yokwandisa amakholomu amaningi noma imigqa ngesikhathi esifanayo.
- Khetha ngasikhathi sinye imikhakha eminingana esikalini esinqunyiwe nesiqondile sezixhumanisi.
- Beka isikhombisi emngceleni ongakwesokudla weseli elingaphambili (ngesilinganiso esinqunyiwe) noma kumngcele ophansi weseli ephansi kunazo zonke (ngokulinganisa okuqondile). Bamba inkinobho yegundane lesokunxele bese uhudula umcibisholo obonakala ngakwesokudla noma phansi, ngokulandelana.
- Ngakho-ke, akuyona nje kuphela uhla oluqine kakhulu olwandisiwe, kodwa futhi namaseli wendawo yonke ekhethiwe.
Indlela 3: okokufaka okubhaliwe kwesayizi ngokusebenzisa imenyu yesimo
Ungaphinda ufake ngesandla usayizi weseli, kulinganiswa ngamanani wenombolo. Ngokuzenzakalelayo, ukuphakama kuyunithi eyi-12.75, nobubanzi yizinyunithi ezingu-8.43. Ungakwazi ukwandisa ukuphakama kuya kwamaphuzu angu-409, futhi ububanzi bufika ku-255.
- Ukuze ushintshe imingcele yobubanzi bamaseli, khetha uhla olufunayo esikalini esinqunyiwe. Sichofoza kuso ngenkinobho yegundane kwesokudla. Emenyu yomongo evelayo, khetha into "Ububanzi bekholomu".
- Iwindi elincane livuleka lapho ufuna ukusetha ububanzi obufunayo bekholomu amayunithi. Faka usayizi oyifunayo kusuka kwikhibhodi bese uchofoza inkinobho "Kulungile".
Ngendlela efanayo, ukushintsha ukuphakama kwemigqa.
- Khetha umkhakha noma ububanzi bezinga elihle lama-coordinates. Chofoza kule ndawo ngenkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Ukuphakama komugqa ...".
- Iwindi evuleka lapho udinga ukushayela ukuphakama okufunayo kwamaseli webanga elikhethiwe amayunithi. Yenza lokhu bese uchofoza inkinobho. "Kulungile".
Izinyathelo ezingenhla zivumela ukwandisa ububanzi nokuphakama kwamaseli kumunithi wokulinganisa.
Indlela 4: Faka usayizi wamaseli ngokusebenzisa inkinobho ku-tape
Ngaphezu kwalokho, kungenzeka ukusetha usayizi weseli ocacisiwe ngokusebenzisa inkinobho ku-tape.
- Khetha amangqamuzana eshidi lapho ubukhulu obunzima ukubekwa khona.
- Iya kuthebhu "Ikhaya"uma singesinye. Chofoza inkinobho ethi "Fometha," ekhonjeni eqoqweni le "Amaseli". Uhla lwezenzo luvulwa. Ngenye indlela khetha izinto kulo "Ukuphakama komugqa ..." futhi "Ububanzi bekholomu ...". Ngemva kokuchofoza ngayinye yalezi zinto, amafasitela amancane azovuleka, indaba eyaphi lapho echaza indlela yangaphambilini. Kuzodingeka bafake ububanzi obufunayo nokuphakama kwebanga elikhethiwe lamaseli. Ukuze amangqamuzana akhule, inani elisha lala mingcele kumele libe likhulu kunenani elibekiwe ngaphambilini.
Indlela 5: Ukwandisa usayizi wawo wonke amaseli kushidi noma encwadini
Kunezimo lapho kudingeka khona ukwandisa ngokuphelele wonke amaseli eshidi noma ngisho nencwadi. Sizoqonda ukuthi singayenza kanjani.
- Ukuze wenze lo msebenzi, kuyadingeka, okokuqala, ukhethe izakhi ezidingekayo. Ukuze ukhethe zonke izakhi zeshidi, ungamane ucindezele inhlanganisela eyinhloko ekhibhodi Ctrl + A. Kunenketho yesibili yokukhetha. Kuhilela ukucindezela inkinobho ngesimo sexande, esitholakala phakathi kwezilinganiso eziqondile nezingezansi ze-Excel.
- Ngemva kokukhetha ishidi kunoma iyiphi yalezi zindlela, chofoza inkinobho esivele esazijwayele. "Fometha" kwi-tape bese wenza izenzo ezengeziwe ngendlela efanayo njengoba kuchazwe ngendlela yangaphambilini nephuzu lokuguqulwa ngephuzu "Ububanzi bekholomu ..." futhi "Ukuphakama komugqa ...".
Senza izenzo ezifanayo ukwandisa usayizi weseli wencwadi yonke. Kuphela kokukhethwa kwawo wonke amashidi esisebenzisa enye ukwamukela.
- Chofoza inkinobho yesokudla yegundane kulebula lalawa mahlamvu, elitholakala phansi kwefasitela ngokushesha ngaphezu kwebha yendawo. Emenyu evelayo, khetha into "Khetha wonke amashidi".
- Ngemuva kokushicilelwa amashidi, senza izenzo kwi-tape besebenzisa inkinobho "Fometha"okuchazwe ngendlela yesine.
Isifundo: Indlela yokwenza amangqamuzana asayizi ofanayo ku-Excel
Indlela 6: Ububanzi be-Auto
Le ndlela ayikwazi ukubizwa ngokuthi ukunyuka okugcwele ngobukhulu bamaseli, kodwa, kodwa, kuyasiza futhi ukulingana ngokuphelele nombhalo ngaphakathi kwemingcele ekhona. Ngesizo salo, abalingiswa bombhalo bahlulwa ngokuzenzakalelayo ukuze kufanelwe esitokisini. Ngakho-ke, singasho ukuthi ubukhulu bayo buhambisana nokwanda kombhalo.
- Khetha ibanga lapho sifuna ukusebenzisa khona ububanzi be-autoselection ububanzi. Chofoza ekukhethweni ngenkinobho yegundane efanele. Imenyu yomongo ivulwa. Khetha into kuwo "Fometha amaseli ...".
- Iwindi yokufometha ivula. Iya kuthebhu "Ukuqondanisa". Ebhokisini lesethingi "Bonisa" usethe uphawu eduze kwepharamitha "Ububanzi Bokuzenzakalela". Sicindezela inkinobho "Kulungile" phansi kwefasitela.
Ngemva kwalezi zenzo, kungakhathaliseki ukuthi irekhodi lizoba lide kangakanani, kodwa lizohlangana neseli. Kodwa-ke, kubalulekile ukucabangela ukuthi uma kunezinhlamvu eziningi kakhulu esakhiweni sekhasi futhi umsebenzisi ngeke akwandise kwelinye lezindlela zangaphambilini, khona-ke leli rekhodi lingase libe lincane kakhulu, ngisho lingakwazi ukufunda. Ngakho-ke, akumukeleki kuwo wonke amacala ukuba aneliswe kuphela ngalolu khetho ukuze uvumelane nedatha ngaphakathi kwemingcele. Ngaphezu kwalokho, kufanele kushiwo ukuthi le ndlela isebenza kuphela ngombhalo, kodwa hhayi ngamanani ezinombolo.
Njengoba ungabona, kunezindlela eziningi zokwandisa usayizi, kokubili amangqamuzana ngabanye namacembu wonke, kuze kube ukwanda kuzo zonke izakhi zeshidi noma ibhuku. Umsebenzisi ngamunye angakhetha inketho elula kunazo zonke ukuba enze le nqubo ezimweni ezithile. Ngaphezu kwalokho, kunendlela eyengeziwe yokulinganisa okuqukethwe ngaphakathi kweseli ngosizo lobubanzi be-auto. Yiqiniso, indlela yokugcina inezinamba eziningana.
