I uhlu olwehlayo Excel

Namuhla ikhompyutha buye baba ingxenye ebalulekile ezimpilweni zethu. izinhlelo ezihlukahlukene ngakho umsebenzi ube lula ukuthi awukwazi ukwenza ngaphandle kwabo ngisho ongenalwazi imfundamakhwela umsebenzisi. Omunye wabo kwakungu-hlelo e-Excel - elula, elula futhi impela. Ngenxa izici zayo eziningi, ingasetshenziswa njengendlela computer ekhaya, futhi umsebenzi ehhovisi. Ukuze kwabanye lena sekuyindlela nje elibalulekile.

Yiqiniso, ukuze uqale ukusebenza ne-Excel kunzima ngempela, kodwa ngokuhamba kwesikhathi, baqonde imisebenzi yayo, kuba lula kakhulu. umsebenzisi Novice kuba ngezinye izikhathi okunzima ukuyiqonda yonke ezicashile umsebenzi, ngakho isihloko Bayokhuluma udaba oluthile, okuyinto iyathakazelisa abaningi: "Indlela yokwenza uhlu olwehliswayo Excel». Zama ukuqonda.

Okokuqala, kufanele siqonde ukuthi lokhu uhlu olwehlayo Excel. Kaningi, ukusebenza e-Excel-amadokhumenti, abasebenzisi isidingo ukungena idatha efanayo ku amaseli amaningi. Icala kuyinto enzima futhi okungadingekile. Ukuze ngandlela-thile lula inqubo, baqaphe imisebenzi efana isicelo, njengoba izinhlu edonsela phansi. Lena into Ukugunda kakhulu, futhi wenze uhlu ngezindlela ezihlukahlukene.

Ngakho, uhlu olwehlayo Excel zingahlelwa usebenzisa indlela ejwayelekile futhi usebenzisa izilawuli isofthiwe. Icala lokuqala kufanelekile Wabasaqalayo kanye nezenzo ezenziwa okufanayo kuzo zonke izinhlobo wokusebenza. Ukuze uqale, khetha wonke amaseli oyifunayo ngedatha, okumele kwenziwe kule uhlu olwehlayo. Khona-ke wenza emnyango kumenyu, futhi ukulandelana elandelayo yezenzo: "Faka" - "Igama" - "Beka".

Faka igama ukuze ukwazi ukukhetha ububanzi (kungaba ikhona, isimo main - kufanele izikhala). Izenzo ziqinisekiswa ngokucindezela "KULUNGILE". Manje-ke kubalulekile ukuphawula iseli lapho uhlu izomashela. Ungaveza angaphezu kwelilodwa. Nalapha kuvula kwemenyu bese ukhetha umyalo "Idatha" - "Hlola". Khona-ke "Izinketho" ithebhu. Kuzo zonke ezihlongozwayo nedatha "ohlwini" okufanele akhethwe. Esikhathini "Umthombo" ukungena ngemvume "bayalingana" futhi okushiwo ekuqaleni igama ohlwini kungabikho izikhala. Uqedile. Excel uhlu lokwehlayo ukudala ngendlela esezingeni.

Ekhuluma ewukuhlakanipha okwenziwe imithombo datha benza ngamandla okuthiwa ububanzi, isibonelo, noma yimuphi uhla lwamanani. Uma udinga ukwengeza idatha kudokhumenti Ngokuyinhloko, zingezwa ngokuzenzakalela eyehlayo uhlu Excel. Kukhona umsebenzi uhlu ezixhunyiwe. Lokhu kusho ukuthi uma wenza izinguquko eyodwa, basuke sashintsha ngokuzenzakalelayo nezinye.

Icala sesibili kuhilela kudalwa uhlu olwehliswayo ukusebenzisa izilawuli. In the version-Excel 2007-2010 kubha yamathuluzi ukuvula ithebhu "Unjiniyela" (uma uhlelo amadala esivula "Amafomu" ithebhu). Lapha, amathuluzi ngenhla, kubalulekile ukuba uthole isithonjana uhlu olwehliswayo, sikhethe bese ukudweba isikwele. Lokhu kuyoba elilandelayo uhlu olwehliswayo Excel.

Sebenzisa inkinobho yegundane kwesokudla, ukhethe "Ifomethi Into". Esikhathini ibhokisi okuholela, afeze oda imiyalo ezilandelayo: "ukudala uhlu band" (khetha lawo amaseli kufanele kube ohlwini), "Cell isixhumanisi" (ucacise iseli okuzokwenza ibhaliswe inombolo nto), kanti owokugcina uyoba ngo - " inani lemigqa uhlu "(faka inombolo oyifunayo imigqa uhlu esikhathini esizayo). Yonke indawo ukuqinisekisa isenzo ngokucindezela "KULUNGILE". I uhlu olwehliswayo kudalwa, ungaqala ukusebenza.

Indlela elula kakhulu ukwakha okuya phansi uhlu, okuyinto efanelekayo ngisho kulabo bengaba nokuqonda okuncane mayelana amakhompyutha kanje. amanani amabili noma amathathu afakwe ikholomu (okuningi ngangokunokwenzeka). On omunye wabo hambisa isikhombisi bese ucindezela ukhiye inhlanganisela ikhibhodi Alt Umcibisholo obheke phezulu naphansi noma usebenzise inkinobho yegundane kwesokudla ukukhethela "Khetha ohlwini okwehliswayo."