Indlela Excel ukwenza okuya phansi uhlu: izindlela elula

Abantu abaningi abasebenzisa i-standard office suite kusuka e-Microsoft Excel-spreadsheet ngokusobala siyibukele phansi umhleli. I uhlu olwehliswayo ebhokisini, kulondolozwa ukuthi kuthatha isikhathi esingakanani ukungena noma cinga iminingwane, kwakha ambalwa, njengoba kuqhathaniswa Finyelela, lapho inqubo iyinkimbinkimbi kakhulu kunalokho. Ngezansi izindlela ezintathu eziyisisekelo ukuze udale uhlu ezinjalo, futhi amanye nemingcele ezibalulekile lokulawula.

Yiziphi okuya phansi uhlu?

Ingabe uhlu lolu hlobo ukubandakanya ezahlukene izicelo. Kokunye cell, ungafaka ezingaphezu kwesisodwa incazelo, njengoba kwenziwa ngokuzenzakalelayo, kodwa abaningana.

ongakhetha yokufakwayo ingase ezimbili:

• kuphela amagugu ohlwini elakhiwe.
• Amanani ohlwini, kanye nanoma yimiphi eminye idatha.

Ngakho, siqala ukusebenza ne-Excel. Dala uhlu olwehliswayo lapha ulula. Kodwa okokuqala, kumelwe enze izenzo ezithile wokulungiselela ekugcineni lonke inqubo kuyehla kuphela kukhethwa kokufaka idatha ezidingekayo.

Indlela Excel ukwenza okuya phansi uhlu: inqubo jikelele

Esigabeni sokuqala sihilela ukufinyelela umsebenzi, okuvumela ukuba enze le nqubo. Indlela Yokwenza i-Excel uhlu olwehliswayo ngesisekelo izici standard yohlelo? elula kakhulu. Okokuqala, khetha eyodwa noma cell ngaphezulu, okuyinto okuhloswe ukwethula ezinye ububanzi bamanani, kanye chofoza kwesokudla imenyu yengqikithi. Kuyo, kuqala ukusebenzisa "Idatha" ingxenye, bese - chofoza "Idatha Ukuqinisekisa". Futhi ukuya izilungiselelo ithebhu.

It has a isimo (test) wokuhlola yezinhlamvu Uhlobo lwedatha, futhi lapho sikhetha "ohlwini". Ngomqondo onabile, inkulumo Amasimu asele uze ukwazi zihlala zinjalo. Itholakala ngaphansi nje umugqa lapho amagugu umthombo kuzojovwa. Lapha kuba into sinesithakazelo.

I uhlu olwehlayo Excel 2007: manual kufakwa

Ake uqale nge ngokungena ngokwenza amagugu. Uma sikhuluma kanjani ukwenza Excel okuya phansi uhlu ngale ndlela, ikhambi ukuba linqume amagugu emkhakheni ngenhla kuphela. Kufanele kuqashelwe ukuthi udinga ukufaka amagugu ahlukaniswe amakhefanangqi for kwasendaweni isiRashiya. Ukuze isabelo IsiZulu osebenza ukhefana kuphela. Ububi le ndlela isobala: kuthatha isikhathi esiningi.

Umthombo ububanzi

Esimeni sesibili, ungasebenzisa ikhambi elisheshayo. Ngokwesibonelo, kudingeka ufake wonke amagugu kumaseli: kusukela A2 ziphethe A4. Umthombo icashunwa string, buyakhahlela isikhombisi. Khona-ke nje ukhethe band oyifunayo. Uhlelo ngokwalo uzokuphelisa setshwayo, kodwa bazobhalisa yenani akulona kwifomu «(A2: A4)», njengoba kwenziwa kumugqa ohambelana amafomula, futhi samuntu «= $ A $ 2: $ A $ 4".

Indlela ngempela okuhle ijubane layo ufaka amanani. Kodwa njengoba iningi bokwenza eziyinhloko ukungakwazi ukusebenzisa cell amabanga, okuyizinto ngakolunye amashidi ngaphandle okwamanje.

Ukubeka okuthiwa amabanga (uhlu)

Ekugcineni, enye indlela ukuxazulula inkinga indlela Excel ukwenza okuya phansi uhlu. Okokuqala, idala uqobo isukela futhi inikezwa igama okuhambisanayo. Bese kumthombo umugqa uyomane Udinga ukufaka igama, yandulelwe yisibonelo setshwayo. Le nqubo ikuvumela ukuba udale uhlu usebenzisa idatha nemagugu zitholakala emakhasini ezahlukene incwadi. Futhi le ndlela ngokuyinhloko elisetshenziswa izinguqulo Excel 2007, umhleli kanye ngezansi, njengoba lezi ukulungiswa angazi kanjani ukusebenza ibanga lapho idatha oshiwo amashidi ezahlukene.

Ngaphansi izilungiselelo, Phatha

Ngokuphathelene lokuthandwa nokulawula umhleli Excel iqoqo imisebenzi edingekayo. Kodwa kakhulu, mhlawumbe, ezithakazelisayo - ukusabalala nemingcele ukuze ubone okokufaka nemibandela efanayo. Lusebenza ezimweni lapho iqabunga kukhona amasheke amaningi kakhulu nezimo zabo kufanele zishintshwe. Ngenxa yale njongo, esigabeni kwedatha, eye yasetshenziswa zonke izindlela langaphambilini, ujike ithebhu "Imilayezo ukungena." Lapha ungafaka mfana ibonakala lapho wena kusebenze cell. Umlayezo kungaba ngaphakathi noma ngaphandle kwe ngokumane kokukhipha isheke uphawu kusukela iphuzu show yakhe. On Iphutha ithebhu, ungafaka isixwayiso mayelana ayilungile idatha input. Lokhu kuwusizo lapho kungekho izimo amagugu ukulawula kanzima noma uma kwenzeka ushintsho esinqunyiwe.

isiphetho

Njengoba singabona kusukela ngenhla, inkinga indlela Excel ukwenza okuya phansi uhlu avunyelwe akunzima kangako. Umbuzo uwukuthi: iyiphi indlela ukusebenzisa? Uma idatha akuyona kakhulu, version elula suit. Eyesibili indlela zigcwele yonk 'indawo. umsebenzisi Isilinganiso ngeke bakwamukele best. Kodwa uma ulwazi hlelo kusukela umsebenzisi akugcini kuphela usebenzisa elula lwemisebenzi lapha kuyoba ukwakha elilungile uhlu aqanjwe okwalandela idatha okokufaka amabanga ngenxa yabo. Njengoba ushintsho ohlwini okuthiwa kuyashesha futhi kulula. Ngokuvamile, khetha indlela elula kunazo zonke ngaphandle kwezinkinga.