Ungasikhipha kanjani isihlungi ku-Excel

Ukuhlunga idatha ku-Excel kuyadingeka ukuze kube lula ukusebenza ngamatafula nenani elikhulu lolwazi. Ngakho, ngokwesibonelo, ingxenye ebalulekile ingafihlwa kumsebenzisi, futhi lapho isihlungi sicushiwe, bonisa ulwazi oludingekayo okwamanje. Kwezinye izimo, lapho ithebula lidalwe ngokungalungile, noma ngenxa yokungabi nalwazi komsebenzisi, kuba nesidingo sokususa isihlungi kumakholomu ngamanye noma eshidini ngokuphelele. Ukuthi lokhu kwenziwa kanjani ngempela, sizohlaziya esihlokweni.

Izibonelo zokudala ithebula

Ngaphambi kokuqhubeka nokukhipha isihlungi, qala ucabangele izinketho zokusivumela kuspredishithi se-Excel:

• Ukufaka idatha mathupha. Gcwalisa imigqa namakholomu ngolwazi oludingekayo. Ngemva kwalokho, sigqamisa ikheli lendawo yetafula, kuhlanganise nezihloko. Iya kuthebhu "Idatha" phezulu kwamathuluzi. Sithola "Isihlungi" (likhonjiswa ngendlela yefaneli) bese uchofoza kuso nge-LMB. Isihlungi kumaheda aphezulu kufanele senziwe sisebenze.

• Ukwenza kusebenze okuzenzakalelayo kokuhlunga. Kulokhu, ithebula liphinde ligcwaliswe ngaphambili, ngemva kwalokho kuthebhu ethi "Izitayela" sithola ukusebenza komugqa othi "Hlunga njengetafula". Kufanele kube nokubekwa okuzenzakalelayo kwezihlungi ezihlokweni zethebula.

Esimweni sesibili, udinga ukuya kuthebhu ethi "Faka" bese uthola ithuluzi elithi "Ithebula", chofoza kulo nge-LMB bese ukhetha "Ithebula" kulezi zinketho ezintathu ezilandelayo.

Ewindini lesixhumi esibonakalayo elilandelayo elivulekayo, ikheli letafula elidaliwe lizovezwa. Kuhlala kuphela ukuyiqinisekisa, futhi izihlungi ezihlokweni ezingezansi zizovuleka ngokuzenzakalelayo.

Iseluleko sochwepheshe! Ngaphambi kokulondoloza ithebula eliqediwe, qiniseka ukuthi idatha ifakwe ngendlela efanele nokuthi izihlungi zinikwe amandla.

Izibonelo zokusebenza ngesihlungi ku-Excel

Ake sishiye ukuze kucatshangelwe ithebula lesampula elifanayo elakhiwe ekuqaleni kwamakholomu amathathu.

• Khetha ikholomu lapho ufuna ukwenza khona ukulungisa. Ngokuchofoza umcibisholo kuseli eliphezulu, ungabona uhlu. Ukuze ususe elinye lamanani noma amagama, susa ukumaka ibhokisi eliseduze kwalo.
• Ngokwesibonelo, sidinga imifino kuphela ukuze sihlale etafuleni. Efasiteleni elivulayo, ungahloli ibhokisi elithi "izithelo", bese ushiya imifino isebenza. Vumelana ngokuchofoza inkinobho ethi "KULUNGILE".

• Ngemva kokwenza kusebenze, uhlu luzobukeka kanje:

Cabangela esinye isibonelo sendlela isihlungi esisebenza ngayo:

• Ithebula lihlukaniswe ngamakholomu amathathu, kanti elokugcina liqukethe amanani ohlobo ngalunye lomkhiqizo. Idinga ukulungiswa. Ake sithi sidinga ukuhlunga imikhiqizo enani layo lingaphansi kwenani elithi “45”.
• Chofoza isithonjana sesihlungi kuseli ekhethiwe. Njengoba ikholomu igcwele amanani ezinombolo, ungabona efasiteleni ukuthi umugqa othi "Izihlungi zezinombolo" usesimweni sokusebenza.
• Ngokuhambisa phezulu kuyo, sivula ithebhu entsha enezinketho ezihlukahlukene zokuhlunga ithebula ledijithali. Kuyo, khetha inani "elincane".

• Okulandelayo, faka inombolo ethi “45” noma khetha ngokuvula uhlu lwezinombolo kusihlungi esizenzakalelayo.

Qaphela! Ukufaka amanani ”ngaphansi kuka-45″, udinga ukuqonda ukuthi wonke amanani angaphansi kwalesi sibalo azofihlwa yisihlungi, okuhlanganisa nenani elithi “45”.

Futhi, ngosizo lwalo msebenzi, amanani ahlungwa ebangeni elithile ledijithali. Ukuze wenze lokhu, kusihlungi esizenzakalelayo sangokwezifiso, kufanele uvule inkinobho ethi "NOMA". Bese usetha inani "elincane" phezulu, futhi "likhulu" ngezansi. Emigqeni ye-interface engakwesokudla, imingcele edingekayo yohlu lwamanani isethiwe, okumele ishiywe. Isibonelo, ngaphansi kuka-30 nangaphezulu kuka-45. Ngenxa yalokho, ithebula lizogcina amanani ezinombolo 25 kanye no-150.

Amathuba okuhlunga idatha yolwazi empeleni abanzi. Ngaphezu kwezibonelo ezingenhla, ungalungisa idatha ngombala wamaseli, ngezinhlamvu zokuqala zamagama namanye amanani. Manje njengoba senze ukujwayelana okujwayelekile nezindlela zokwenza izihlungi kanye nezimiso zokusebenza nazo, ake siqhubekele ezindleleni zokususa.

Ikhipha isihlungi sekholomu

1. Okokuqala, sithola ifayela eligciniwe elinetafula kukhompyutha yethu bese sichofoza kabili i-LMB ukuze silivule kuhlelo lokusebenza lwe-Excel. Eshidini elinethebula, ungabona ukuthi isihlungi sisesimweni sokusebenza kukholamu “Yamanani”.

Iseluleko sochwepheshe! Ukwenza kube lula ukuthola ifayela kukhompyutha yakho, sebenzisa iwindi elithi "Sesha", elitholakala kumenyu ethi "Qala". Faka igama lefayela bese ucindezela inkinobho ethi "Enter" kukhibhodi yekhompyutha.

2. Chofoza isithonjana somcibisholo oya phansi.
3. Ebhokisini lengxoxo elivulayo, ungabona ukuthi umaki obhekene nenombolo “25” awuthikhiwe. Uma ukuhlunga okusebenzayo kukhishwe endaweni eyodwa kuphela, indlela elula iwukusetha ibhokisi lokuhlola futhi bese uchofoza inkinobho ethi "KULUNGILE".
4. Uma kungenjalo, isihlungi kufanele sikhutshazwe. Ukuze wenze lokhu, kuwindi elifanayo, udinga ukuthola umugqa "Susa isihlungi kukholomu "..."" bese uchofoza kuso nge-LMB. Ukuvalwa okuzenzakalelayo kuzokwenzeka, futhi yonke idatha efakwe ngaphambilini izokhonjiswa ngokugcwele.

Ikhipha isihlungi eshidini lonke

Ngezinye izikhathi izimo zingase ziphakame lapho kudingekile ukususa isihlungi kuthebula lonke. Ukuze wenze lokhu, uzodinga ukwenza lezi zinyathelo ezilandelayo:

1. Vula ifayela ledatha elilondoloziwe ku-Excel.
2. Thola ikholomu eyodwa noma ngaphezulu lapho isihlungi sisebenza khona. Kulokhu, yikholomu Yamagama.

3. Chofoza kunoma iyiphi indawo etafuleni noma uyikhethe ngokuphelele.
4. Phezulu, thola “Idatha” bese uyisebenzise nge-LMB.

5. Thola "Hlunga". Ngokuphambene nekholomu kunezimpawu ezintathu ezisesimweni sefaneli enamamodi ahlukene. Chofoza inkinobho yomsebenzi "Sula" lapho kuboniswa ifaneli kanye ne-crosshair ebomvu.
6. Okulandelayo, izihlungi ezisebenzayo zizokhutshazwa kulo lonke ithebula.

Isiphetho

Ukuhlunga izakhi namanani etafuleni kwenza ukusebenza ku-Excel kube lula kakhulu, kodwa, ngeshwa, umuntu uthambekele ekwenzeni amaphutha. Kulokhu, uhlelo lwe-Excel olusebenzayo lusiza, oluzosiza ukuhlunga idatha futhi lususe izihlungi ezifakwe ngaphambilini ezingadingekile ngenkathi kugcinwa idatha yangempela. Lesi sici siwusizo ikakhulukazi lapho ugcwalisa amatafula amakhulu.