Susa ifomula kuMicrosoft Excel

Ukusebenza namafomula ku-Excel kukuvumela ukuthi wenze lula futhi usebenzise izibalo ezahlukene. Kodwa-ke, akuhlali njalo kudingekile ukuthi umphumela uhambisane nkulumo. Isibonelo, lapho kushintsha amanani kumaseli axhunyiwe, idatha evelayo izoshintsha futhi, kwezinye izimo lokhu akudingekile. Ngaphezu kwalokho, lapho udlulisa itafula elikopishiwe ngamafomula kwenye indawo, amanani angahle "alahleke". Esinye isizathu sokuzifihla kungaba yisimo lapho ungafuni ukuthi abanye abantu babone ukuthi ukubalwa kwenziwa kanjani etafuleni. Ake sibheke ukuthi yiziphi izindlela ongasusa ngayo ifomula kumaseli, ushiye umphumela wokubala kuphela.

Inqubo yokususa

Ngeshwa, i-Excel ayinathuluzi elisusa ngokushesha amafomula kumaseli, futhi ishiya amanani kuphela lapho. Ngakho-ke, kufanele sibheke izindlela eziyinkimbinkimbi zokuxazulula inkinga.

Indlela yoku-1: kopisha amanani ngokusebenzisa izinketho zokunamathisela

Ungakopisha idatha ngaphandle kwefomula uye kwenye indawo usebenzisa izinketho zokunamathisela.

1. Khetha itafula noma ibanga, esilizungeza ngesikhombisi ngenkathi siphethe inkinobho yegundane kwesokunxele. Ukuhlala kuthebhu "Ikhaya"chofoza isithonjana Kopisha, ebekwe ethepheni ebhlokini Ibhodi yokunamathisela.



2. Khetha iseli elizoba yiseli ephezulu kwesokunxele kwetafula elifakiwe. Chofoza kuso ngenkinobho yegundane elifanele. Imenyu yokuqukethwe izosetshenziswa. Ebhlokini Faka Izinketho yeka ukukhetha ku "Amanani". Kuthulwa njenge-pictograph enezinombolo "123".

Ngemuva kokuqeda le nqubo, ibanga lizofakwa, kepha kuphela njengamanani angenawo amafomula. Kuliqiniso, ukufometha kokuqala nakho kuzolahleka. Ngakho-ke, kuzofanela ukufometha itafula ngesandla.

Indlela 2: kopisha ngokunameka okukhethekile

Uma udinga ukugcina ukufometha kwasekuqaleni, kepha ungafuni ukuchitha isikhathi ukucubungula kwetafula, khona-ke kukhona ithuba lokusebenzisa "Faka okhethekile".

1. Kopisha ngendlela efanayo nesikhathi sokugcina okuqukethwe kwetafula noma ububanzi.
2. Khetha yonke indawo yokufaka noma iseli yayo ephezulu kwesokunxele. Sichofoza kwesokudla, ngaleyo ndlela sinxusa imenyu yokuqukethwe. Kuluhlu oluvulayo, khetha "Faka okhethekile". Okulandelayo, kumenyu eyengeziwe, chofoza inkinobho "Amanani nokufomethwa komthombo"elibekwe eqenjini Faka Amanani futhi uphawu lwesikwele olunezinombolo nebhulashi.

Ngemuva kwalokhu kusebenza, imininingwane izokopishwa ngaphandle kwamafomula, kepha ukufometha kwasekuqaleni kuzogcinwa.

Indlela 3: susa ifomula etafuleni lomthombo

Ngaphambi kwalapho, sikhulume ngokuthi singayisusa kanjani ifomula lapho sikopisha, manje ake sibheke ukuthi singayisusa kanjani ebangeni lokuqala.

1. Silingisa etafuleni nganoma yiziphi izindlela ezixoxwe ngenhla endaweni engenalutho eshidi. Ukukhetha indlela ethile kithi kungasho lutho.
2. Khetha ibanga elikopishiwe. Chofoza inkinobho Kopisha ekhasethini.



3. Khetha ibanga lokuqala. Sichofoza kukho inkinobho yegundane elifanele. Uhlu lomongo eqenjini Faka Izinketho khetha into "Amanani".



4. Ngemuva kokuthi idatha ifakiwe, ungasusa ibanga lokuhamba. Khetha. Sibiza imenyu yokuqukethwe ngokuchofoza inkinobho yegundane elifanele. Khetha into ekuyo "Susa ...".



5. Kuvulwa iwindi elincane lapho udinga khona ukuthola ukuthi yini ngempela efanele isuswe. Esimweni sethu esithile, ibanga lokuhamba litholakala ngaphansi kwetafula lomthombo, ngakho-ke kudingeka sisuse imigqa. Kepha uma ibitholakala ngasohlangothini lwayo, khona-ke amakholomu kufanele asuswe, kubaluleke kakhulu ukuthi ungazihlanganisi, ngoba itafula eliphambili lingabhujiswa. Ngakho-ke, sibeka izilungiselelo zokususa bese sichofoza inkinobho "Kulungile".

Ngemuva kokwenza lezi zinyathelo, zonke izinto ezingadingekile zizosuswa, futhi amafomula etafuleni lasekuqaleni azoshabalala.

Indlela 4: susa amafomula ngaphandle kokwenza ibanga lokuhamba

Ungenza kube lula kakhulu futhi ungakhi ibanga lokuhamba nhlobo. Kuliqiniso, kuleli cala, udinga ukuthatha isinyathelo ngokucophelela, ngoba zonke izenzo zizokwenziwa ngaphakathi kwetafula, okusho ukuthi noma iliphi iphutha lingaphula ubuqotho bemininingwane.

1. Khetha ibanga ofuna ukususa amafomula kulo. Chofoza inkinobho Kopishaibekwe kubambo noma ukuthayipha inhlanganisela yezinkinobho kukhibhodi I-Ctrl + C. Lezi zenzo ziyalingana.



2. Ngemuva kwalokho, ngaphandle kokususa okukhethiwe, chofoza kwesokudla. Imenyu yokuqukethwe yethulwe. Ebhlokini Faka Izinketho chofoza isithonjana "Amanani".

Ngakho-ke, yonke imininingwane izokopishwa bese inamathiselwa ngokushesha njengamanani. Ngemuva kwalezi zenzo, amafomula endaweni ekhethiwe ngeke aqhubeke.

Indlela yesi-5: sebenzisa i-macro

Ungasebenzisa futhi ama-macros ukususa amafomula kumaseli. Kepha ngalokhu udinga ukuqala ukusebenza kwithebhu yonjiniyela, futhi unikeze amandla ama-macro ngokwawo uma engasebenzi. Ukwenza kanjani lokhu kungatholakala ngesihloko esihlukile. Sizokhuluma ngqo ngokungeza nokusebenzisa i-macro ukususa amafomula.

1. Iya kuthebhu "Unjiniyela". Chofoza inkinobho "Okubonakalayo okuyisisekelo"ibekwe phezu kobambo kubhokisi lamathuluzi "Ikhodi".



2. Ukuhlelwa kwe-macro kuyaqala. Namathisela ikhodi elandelayo kuyo:

   
Susa Ifomula Engaphansi ()
Ukukhetha.Value = Selection.Value
Qeda sub

   Ngemuva kwalokho, vala iwindi lomhleli ngendlela evamile ngokuchofoza inkinobho ekhoneni eliphezulu kwesokudla.



3. Sibuyela kushidi lapho kwetafula khona lenzalo. Khetha isiqephu lapho amafomula azosuswa atholakala khona. Kuthebhu "Unjiniyela" chofoza inkinobho IMacrosibekwe etheyipini eqenjini "Ikhodi".



4. Kuvulwa iwindi lokuvula macro. Sifuna into ebizwa ngokuthi Ukususwa Kwefomula, ikhethe bese uchofoza inkinobho Gijima.

Ngemuva kwalesi senzo, wonke amafomula asendaweni ekhethiwe azosuswa, futhi kuzovela imiphumela yokubala kuphela.

Isifundo: Ungawenza kanjani amandla noma ukhubaze ama-macros ku-Excel

Isifundo: Ungayakha kanjani iMacro ku-Excel

Indlela 6: Susa ifomula kanye nomphumela

Noma kunjalo, kunezikhathi lapho udinga ukususa hhayi ifomula kuphela, kodwa futhi nomphumela. Kwenze kube lula kakhulu.

1. Khetha ibanga lapho amafomula abekwe khona. Qhafaza kwesokudla. Kumenyu yokuqukethwe, yeka ukukhetha entweni Sula okuqukethwe. Uma ungafuni ukubiza imenyu, ungamane ucindezele ukhiye ngemuva kokukhethwa Susa kwikhibhodi.



2. Ngemuva kwalezi zinyathelo, konke okuqukethwe amaseli, kufaka phakathi amafomula namanani, kuzosuswa.

Njengoba ukwazi ukubona, kunezindlela eziningi ongasusa amafomula ngazo, zombili lapho ukopisha idatha, futhi ngqo etafuleni uqobo. Kuliqiniso, ithuluzi elijwayelekile le-Excel, elingasusa ngokuzenzakalelayo le nkulumo ngokuchofoza okukodwa, ngeshwa, alikho. Ngale ndlela, ungasusa amafomula kuphela kanye namanani. Ngakho-ke, kufanele uthathe isinyathelo ngokusebenza ngezinketho zokufaka noma ngokusebenzisa ama-macros.