Ungayisusa Kanjani Ifomula Ku-Excel

Ukusebenza ngamafomula ku-Excel kungasiza kakhulu futhi kuguqule izibalo ezahlukahlukene. Ngasikhathi sinye, akudingeki ngaso sonke isikhathi ukuthi umphumela uhlanganiswe ukuveza. Isibonelo, lapho ushintsha amanani kumaseli ahlobene, idatha efingqiwe izoshintsha, futhi kwezinye izikhathi akudingekile. Ngaphezu kwalokho, lapho kudluliswa itafula elikopishwe ngamafomula kwenye indawo, amanani angalahleka. Esinye isizathu sokuzifihla kungaba isimo lapho ungafuni abanye abantu babone ukuthi ukubala kubanjelwa kanjani etafuleni. Ake sibheke ukuthi yiziphi izindlela ezingasuswa ngefomula kumaseli, zishiya kuphela umphumela wokubala.

Inqubo Yokususa

Ngeshwa, alikho ithuluzi eliku-Excel, elizosusa ngokushesha ifomula elivela kumaseli, futhi lashiya kuphela amagugu lapho. Ngakho-ke, kufanele ubheke izindlela eziyinkimbinkimbi zokuxazulula inkinga.

Indlela 1: Ukukopisha amanani ngokusebenzisa amapharamitha wokufaka

Kopisha idatha ngaphandle kwefomula kwenye indawo kungenzeka kusetshenziswe amapharamitha wokufaka.

1. Sigqamisa itafula noma ibanga, esilinikeza ngalo isikhombisi ngenkinobho yegundane kwesobunxele. Ukuhlala kuthebhu "Yasekhaya", chofoza isithonjana se- "Copy", esitholakala ethepheni ku- "Buffer".



2. Khetha iseli elizoba yiseli eliphezulu kwesokunxele elifakiwe. Yenza Chofoza ku-IT ROUNT MOOM MUSE. Imenyu yomongo izosebenza. Evikini le- "Insert parameter" block, yeka ukukhetha endimeni "yenani". Imelelwa njengesithonjana ngesithombe sezinombolo "123".

Ngemuva kokwenza le nqubo, uhla luzofakwa, kepha kuphela ngesimo samanani ngaphandle kwamafomula. Iqiniso, ukufometha kokuqala nakho kulahlekile. Ngakho-ke, ifomethi ithebula lizofanela ngesandla.

Indlela 2: Ukukopisha ukufakwa okukhethekile

Uma udinga ukonga ukufomatha kwangempela, kepha awufuni ukuchitha isikhathi ekucutshungweni okwenziwa yincwadi yetafula, khona-ke kungenzeka ukusebenzisa "ukufakwa okukhethekile" ngalezi zinhloso.

1. Kopisha ngendlela efanayo kusukela okokugcina okuqukethwe kwetafula noma ibanga.
2. Sigqamisa yonke indawo yokufaka noma iseli yayo yangakwesobunxele. Sichofoza inkinobho yegundane efanele, ngaleyo ndlela sibize imenyu yokuqukethwe. Kuluhlu oluvula, khetha into "ekhethekile yokufaka". Okulandelayo, kumenyu eyengeziwe, chofoza inkinobho ethi "Amanani Nemiqala Yokufometha", ebekwe ku- "Insert Values" iqembu futhi iyisithonjana ngesimo sesikwele, lapho kuboniswa khona izinombolo kanye nebhulashi.

Ngemuva kwalokhu kuhlinzwa, imininingwane izokopishwa ngaphandle kwamafomula, kepha ngasikhathi sinye ukufometha kokuqala kuzosindiswa.

Indlela 3: Ukususwa kwefomula kusuka etafuleni lomthombo

Ngaphambi kwalapho, satshela ukuthi singayisusa kanjani ifomula lapho sikopisha, futhi manje ake sithole ukuthi singayisusa kanjani ebangeni lomthombo.

1. Siveza ikhophi yetafula nganoma iyiphi yalezo zindlela izingxoxo ezazingaphezulu, endaweni engenalutho yeshidi. Ukukhethwa kwendlela ethile kithi amanani angeke abe nakho.
2. Khetha ibanga elikopishwe. Chofoza inkinobho ethi "Kopisha" ethepheni.



3. Khetha ububanzi bokuqala. Chofoza inkinobho yegundane kwesokudla. Uhlu lomongo ku-Insert Izilungiselelo Group, khetha into ethi "Amanani".



4. Ngemuva kokuthi idatha ifakiwe, ungasusa uhla lweTransit. Siyakugqama. Shayela imenyu yokuqukethwe ngokuchofoza inkinobho yegundane kwesokudla. Khetha into ethi "Susa ...".



5. Kuvulwa iwindi elincane, lapho udinga ukufaka lokho okudingayo ukuze ususe. Ngokucacile, uhla lwethu lokuhamba luphansi kusuka etafuleni lomthombo, ngakho-ke sidinga ukususa imigqa. Kepha uma etholakala ohlangothini lwakhe, bekungadingeka ukususa amakholomu, kubaluleke kakhulu ukuthi ungadideki, njengoba ungabhubhisa itafula elikhulu. Ngakho-ke, setha izilungiselelo zokususa bese uqhafaza inkinobho ethi "Kulungile".

Ngemuva kokwenza lezi zenzo, zonke izinto ezingadingekile zizosuswa, futhi amafomula avela etafuleni lomthombo azonyamalala.

Indlela 4: Ukususwa kwamafomula ngaphandle kokudala iqembu lokuhamba

Kungenziwa kube lula kakhulu futhi hhayi ukudala ibanga lokuhamba nhlobo. Kuliqiniso, kulokhu, kufanele wenze ngokucophelela ngokucophelela, ngoba zonke izenzo zizokwenziwa ngaphakathi kwemingcele yetafula, okusho ukuthi noma yiliphi iphutha lingaphazamisa ubuqotho bedatha.

1. Sigqamisa uhla lapho udinga ukususa amafomula. Chofoza inkinobho ethi "Kopisha", ubekwe ethepheni noma uthole inhlanganisela yokhiye we-CTRL + C kwikhibhodi. Lezi zenzo ziyalingana.



2. Ngemuva kwalokho, ngaphandle kokususa ukukhetha ngokuchofoza inkinobho yegundane efanele. Imenyu yomongo yethulwa. Evikini le- "Insert Parameter" block, chofoza isithonjana se- "Values".

Ngakho-ke, yonke imininingwane izokopishwa futhi ifakwe ngokushesha njengamanani. Ngemuva kwalezenzo, amafomula endaweni egqanyisiwe ngeke aqhubeke.

Indlela 5: Ukusetshenziswa kweMacro

Ukususa amafomula kumaseli, ungasebenzisa futhi ama-macros. Kepha lokhu kudingeka kusebenze kuqala kusebenze ithebhu kanjiniyela, kanye nokufaka kanye umsebenzi we-macrom uma engasebenzi. Ungayenza kanjani, ungathola ngesihloko esihlukile. Sizokhuluma ngokuqondile ngokungeza nokusebenzisa i-macro ukususa amafomula.

1. Iya kuthebhu kanjiniyela. Chofoza inkinobho ethi "Visual Basic" etholakala ethepheni ku- "Code" yamathuluzi.



2. Isihleli se-Macro siqala. Faka ikhodi engezansi kuyo:

   Susa Sulete_Fordula ()

   Ukukhetha.Value = Ukukhetha.Value.

   Qeda sub.

   Ngemuva kwalokho, vala iwindi lomhleli ngendlela ejwayelekile ngokucindezela inkinobho ekhoneni eliphezulu kwesokudla.



3. Sibuyela ephepheni, elitholakala etafuleni isithakazelo kithi. Sigqamisa ukuqedwa lapho amafomula ofuna ukuwasusa khona atholakala khona. Kuthebhu yonjiniyela, chofoza inkinobho yeMacros, ebekwe etheyipu eqenjini lekhodi.



4. Iwindi lokuqalisa le-macros liyavula. Sifuna into ebizwa nge- "Delete_Forula", qokomisa bese ucindezela inkinobho ethi "Run".

Ngemuva kwalesi senzo, wonke amafomula endaweni ekhethiwe azosuswa, futhi kuphela imiphumela yokubalwa izosala.

Isifundo: Ungavumelanga Kanjani noma Ukhubaze ama-Macros Ku-Excel

Isifundo: Ungawakha kanjani i-macro ku-Excel

Indlela 6: Ukususwa kwefomula kanye nomphumela

Kodwa-ke, kunezimo lapho kunesidingo sokususa hhayi kuphela ifomula kuphela, kodwa futhi umphumela. Kwenze kube lula kakhulu.

1. Sigqamisa ububanzi lapho kufakwa khona amafomula. Chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe, yeka ukukhetha entweni ethi "Sula Okuqukethwe". Uma ungafuni ukubiza imenyu, ungamane ucindezele ukhiye wokususa ngemuva kokukhethwa.



2. Ngemuva kwalezi zenzo, konke okuqukethwe amaseli, kufaka phakathi amafomula namagugu, kuzosuswa.

Njengoba sibona, kunezindlela eziningi ongazikhipha ngazo amafomula, zombili lapho uyokopisha idatha bese etafuleni uqobo. Kuliqiniso, ithuluzi labasebenzi lihle kakhulu, elizosusa ngokuzenzakalelayo le nkulumo ngokuchofoza okukodwa, ngeshwa, kuze kube lapho. Ngale ndlela, amafomula kuphela anamanani angasuswa. Ngakho-ke, kufanele usebenze ngemikhondo ye-Bypass ngokusebenzisa amapharamitha wokufaka noma usebenzisa ama-macros.