Ungayikhipha kanjani ifomula kuseli ku-Excel

I-Excel inenani elikhulu lemisebenzi engasetshenziswa ukwenza izibalo eziyinkimbinkimbi kakhulu. Asetshenziswa ngendlela yamafomula abhalwe kumaseli. Umsebenzisi uhlala enethuba lokuwahlela, amiselele eminye imisebenzi noma amanani.

Njengomthetho, ukugcina ifomula esitokisini kulula, kodwa hhayi njalo. Kwezinye izimo, kuba nesidingo sokulondoloza idokhumenti ngaphandle kwamafomula. Isibonelo, ukuze kuvinjwe abanye abasebenzisi ukuthi baqonde ukuthi izinombolo ezithile zitholwe kanjani. 

Mangisho ukuthi lo msebenzi ulula ngokuphelele. Kwanele ukulandela izinyathelo ezimbalwa ezilula ukuze uphile: Ngesikhathi esifanayo, kunezindlela eziningana, ngayinye elula kakhulu ukuyisebenzisa esimweni esithile. Ake sizibheke ngokuningiliziwe. 

Indlela 1: Ukusebenzisa Izinketho zokunamathisela

Le ndlela ilula kakhulu, ngisho nosaqalayo angayisebenzisa. Udinga nje ukulandela lezi zinyathelo:

1. Okokuqala udinga ukwenza ukuchofoza kwegundane kwesokunxele bese ngokuhudula ukhethe amaseli lapho umsebenzi kuwukususa amafomula. Awu, noma eyodwa. Bese ukuchofoza okukodwa nje kwanele.
   

   

2. Ngemuva kwalokho kufanele uvule imenyu yokuqukethwe bese uthola into ethi "Kopisha". Kodwa ngokuvamile inhlanganisela Ctrl + C isetshenziswa ukufeza lo mgomo. Lokhu kulula kakhulu futhi kuyashesha kunokuchofoza kwesokudla ngokuqondile ebangeni elidingekayo, bese uchofoza enye into. Lokhu kuwusizo ikakhulukazi kumalaptop, lapho kusetshenziswa iphedi yokuthinta esikhundleni segundane.
   

   

3. Kukhona nendlela yesithathu yokukopisha, okuthi ukuze kube lula, iphakathi ncamashi nalokhu okubili okungenhla. Ukuze wenze lokhu, thola ithebhu "Ekhaya", bese uchofoza inkinobho egqanyiswe esikweleni esibomvu.
   

   

4. Okulandelayo, sinquma iseli lapho idatha ezokopishwa kuthebula lomthombo kufanele iqale khona (zizotholakala engxenyeni engenhla kwesokunxele yobubanzi besikhathi esizayo). Ngemuva kwalokho, sichofoza kwesokudla bese uchofoza inketho ekhonjiswe isikwele esibomvu (inkinobho ibukeka njengesithonjana esinezinombolo).
   

   

5. Ngenxa yalokho, itafula elifanayo lizovela endaweni entsha, kuphela ngaphandle kwamafomula.
   

   

Indlela yesi-2: Faka Okunamathiselwe Okukhethekile

Ububi bendlela yangaphambilini ukuthi ayikugcini ukufometha kwasekuqaleni. Ukuze ulahlekelwe yile minus, udinga ukusebenzisa enye inketho enegama elifanayo - "Namathisela Okukhethekile". Kwenziwa kanje:

1. Futhi, khetha ububanzi okufanele sibukopishe. Masisebenzise inkinobho yokukopisha kubha yamathuluzi kulokhu. Ithebula lonke selizosetshenziswa kakade njengobubanzi, njengoba izihloko zalo ziqukethe ukufometha okuyinkimbinkimbi okudingeka sikukopishe.
   

   

2. Izinyathelo ezilandelayo ziyefana. Udinga ukuya esitokisini lapho kuzotholakala khona itafula ngaphandle kwamafomula. Noma kunalokho, kuseli elingaphezulu kwesokunxele, ngakho-ke udinga ukwenza isiqiniseko sokuthi awekho amanani engeziwe esikhundleni setafula lesikhathi esizayo. Chofoza kwesokudla kuso bese uthola inketho ethi "Namathisela Okukhethekile". Eduze kwayo kunesithonjana esingunxantathu, esiqondiswe kwesokudla nesiphezulu saso. Uma uchofoza kuyo, kuzovela elinye iphaneli, lapho sidinga khona ukuthola iqembu elithi "Faka Amanani" bese ukhetha inkinobho egqanyiswe ngokubomvu kulesi sithombe-skrini.
   

   

3. Umphumela uyithebula elifanayo elisesiqeshini esikopishwe ekuqaleni, kuphela esikhundleni sefomula, amanani uXNUMXbuXNUMXbare asevele esohlwini lapho.
   

   

Indlela yesi-3: Susa Ifomula Kuseli Lomthombo

Ububi bazo zombili izindlela ezingenhla ukuthi azinikezi ikhono lokususa ifomula ngqo kuseli. Futhi uma udinga ukwenza ukulungisa okuncane, kuzodingeka ukopishe, unamathisele ngemingcele ethile kwenye indawo, bese udlulisela leli thebula noma amaseli ngamanye endaweni yawo yasekuqaleni. Ngokusobala, lokhu akulungile kakhulu.

Ngakho-ke, ake sibhekisise indlela ekuvumela ukuthi ususe amafomula ngokuqondile kumaseli. Landela lezi zinyathelo:

1. Kopisha ububanzi obudingekayo usebenzisa noma yiziphi izindlela ezingenhla. Ukuze ucacise, sizokwenza ukuchofoza kwegundane kwesokudla bese ukhetha inketho ethi "Kopisha" lapho.
   

   

2. Ngokufanayo nendlela yangaphambilini, sidinga ukunamathisela indawo esiyikopishe ngaphambilini endaweni entsha. Futhi ngesikhathi esifanayo shiya ukufometha kwangempela. Okulandelayo, sidinga ukunamathisela leli thebula ngezansi.
   

   

3. Ngemva kwalokho, siya esitokisini esiphezulu kwesokunxele setafula okwakukhona ekuqaleni (noma khetha ububanzi obufanayo obusesinyathelo 1), ngemva kwalokho sibiza imenyu yokuqukethwe bese sikhetha ukufakwa kokuthi "Amanani".
   

   

4. Ngemuva kokuthi kuvele ukukopisha ngokuphelele amaseli owafunayo ngaphandle kokulondoloza amafomula, kodwa ngamavelu afanayo, udinga ukususa impinda. Ukuze wenze lokhu, udinga ukukhetha uhla lwedatha ofuna ukuyisusa, bese uchofoza kuyo kwesokudla bese uchofoza into ethi "Susa".
   

   

5. Okulandelayo, kuzovela iwindi elincane lapho kufanele ukhethe khona into ethi "umugqa" futhi uqinisekise ukususwa ngokucindezela inkinobho ethi "KULUNGILE".
   

   

6. Ungaphinda ukhethe enye into. Isibonelo, "amaseli, ahanjiswe kwesokunxele" asetshenziselwa ukususa inombolo ethile yamaseli angakwesokunxele, ngaphandle kokuthi awekho amanani acacisiwe kwesokudla.

Konke, manje sinetafula elifanayo, ngaphandle kwamafomula kuphela. Le ndlela ifana nokukopisha nokunamathisela ithebula elitholwe indlela yesibili endaweni yalo yasekuqaleni, kodwa lilula kakhulu uma liqhathaniswa nalo. 

Indlela yesi-4: Gwema ukukopishela kwenye indawo nhlobo

Yiziphi izinyathelo ongazithatha uma kungekho sifiso sokukopisha itafula kwenye indawo nhlobo? Lena indlela enzima kakhulu. Ububi bayo obuyinhloko ukuthi amaphutha angonakalisa kakhulu idatha yoqobo. Vele, ungazibuyisela usebenzisa inhlanganisela ye-Ctrl + Z, kodwa ukuphinda ukwenze lapho kuzoba nzima kakhulu. Eqinisweni, indlela ngokwayo imi kanje:

1. Sikhetha iseli noma ububanzi okudingeka sibususe kumafomula, bese siwakopisha sisebenzisa noma yiziphi izindlela ezingenhla. Ungakhetha lowo omthanda kakhulu. Sizosebenzisa indlela ehlanganisa ukusebenzisa inkinobho kubha yamathuluzi kuthebhu ethi Ekhaya.
   

   

2. Asikususi okukhethiwe endaweni ekopishiwe, futhi ngesikhathi esifanayo sichofoza kwesokudla kukho, bese ukhetha into ethi "Values" eqenjini elithi "Namathisela Izinketho".
   

   

3. Ngenxa yalokho, amanani athile afakwa ngokuzenzakalelayo kumaseli alungile.
   

   

4. Uma bekukhona ukufometha kuseli, kuzomele usebenzise inketho ethi "Namathisela Okukhethekile".

Indlela 5: Ukusebenzisa iMacro

I-macro wuhlelo oluncane olwenza izenzo ezithile kudokhumenti yomsebenzisi. Kudingeka uma ngokuvamile kufanele wenze uhlobo olufanayo lwezenzo. Kodwa ngeke ukwazi ukusebenzisa amamakhro ngaso leso sikhathi, ngoba imodi yonjiniyela ayivunyelwe ngokuzenzakalelayo, okumele isebenze ngaphambi kokuthi ususe amafomula ngokuqondile.

Ukuze wenze lokhu, yenza ukulandelana kwezenzo ezilandelayo:

1. Chofoza "Ifayela".
   

   

2. Kuzovela iwindi lapho kumenyu etholakala ngakwesobunxele, sifuna into ethi "Izinketho" bese uyikhetha.
   

   

3. Kuzoba khona into ethi "Yenza ngokwezifiso i-Ribbon", futhi ngakwesokudla kwefasitela udinga ukuhlola ibhokisi eduze kwento ethi "Unjiniyela".
   

   

Ukuze ubhale i-macro, landela lezi zinyathelo:

1. Vula ithebhu "Unjiniyela", lapho uya khona kusihleli se-Visual Basic ngokuchofoza inkinobho yegama elifanayo.
   

   

2. Okulandelayo, sidinga ukukhetha ishidi elilungile, bese uchofoza inkinobho ethi "Buka Ikhodi". Inketho elula ukuchofoza kabili ngokulandelana ngokushesha ngenkinobho yegundane engakwesokunxele eshidini olifunayo. Lokhu kuzovula isihleli esikhulu.
   

   

Bese ikhodi enjalo ishuthekwa kunkambu yomhleli.

Amafomula_okususa_okulandelayo()

Selection.Value = Selection.Value

Qeda i-Sub

Inombolo encane kanjalo yemigqa ivele yanele ukususa amafomula ebangeni elikhethiwe. Ngemuva kwalokho udinga ukukhetha indawo esiyidingayo bese uchofoza inkinobho ethi "Macros". Ingatholakala eduze kwe-Visual Basic Editor. Iwindi lokukhetha ama-subroutines agciniwe liyavela, lapho udinga ukuthola khona iskripthi oyifunayo bese uchofoza "Run".

Ngemva kokuchofoza le nkinobho, ifomula ngayinye izothathelwa indawo umphumela. Kubukeka kunzima nje. Eqinisweni, lezi zinyathelo zithatha imizuzu embalwa kuphela. Inzuzo yale ndlela ukuthi ungakha uhlelo oluyinkimbinkimbi kakhulu, isibonelo, oluzozinqumela lona ngokwalo ukuthi yimaphi amaseli azokhipha ifomula ngokusekelwe kumibandela ethile. Kodwa lokhu kakade kuyi-aerobatics.

Indlela yesi-6: Susa kokubili ifomula nomphumela

Cishe wonke umuntu ngokushesha noma kamuva kufanele asuse ifomula kuphela, kodwa futhi umphumela. Nokho, okungukuthi, ukuze kungasali lutho esitokisini nhlobo. Ukuze wenze lokhu, khetha lawo maseli ofuna ukuwahlanza, chofoza kwesokudla kuwo bese ukhetha "Sula okuqukethwe".

Hhayi-ke, noma vele usebenzise i-backspace noma ukhiye we-del kukhibhodi. Ngamagama alula, lokhu kwenziwa ngendlela efanayo nokusula idatha kunoma iyiphi enye iseli. 

Ngemva kwalokho, yonke idatha izosulwa.

iziphetho

Njengoba ubona, kulula kakhulu ukususa amafomula kumaseli. Okuhle ukuthi kunezindlela eziningana zokufeza lo mgomo. Umuntu unelungelo lokukhetha noma iyiphi evumelana naye kakhulu ngenxa, isibonelo, ukunethezeka. Isibonelo, izindlela ezinempinda ziwusizo uma udinga ukuhlehlisa ngokushesha izinguquko noma wenze kabusha umphumela ukuze kugcinwe ulwazi lwangempela. Lokhu kungaba usizo kakhulu, isibonelo, uma udinga ukwenza isiqiniseko sokuthi ishidi elilodwa liqukethe amafomula, kanti elinye liqukethe amanani angenawo amandla okuhlela amafomula.