Nigute ushobora kuvana formula muri excel

Gukorana na formulaire muri Excel birashobora koroshya cyane no gufatanya kubara bitandukanye. Muri icyo gihe, ntabwo buri gihe ari ngombwa ko ibisubizo bihujwe no kuvuga. Kurugero, mugihe uhindura indangagaciro muburyo bujyanye, amakuru make azahinduka, kandi mubihe bimwe ntabwo ari ngombwa. Mubyongeyeho, mugihe wimuye ameza yimuwe hamwe na formulaire zijya ahandi hantu, indangagaciro zirashobora gutakara. Indi mpamvu yo kubihisha irashobora kuba uko udashaka ko abandi bantu babona uko kubara bifatwa mumeza. Reka tumenye uburyo bushobora gukurwaho na formula iri mu tugari, hasigara gusa ibisubizo byibarura.

Gukuraho inzira

Kubwamahirwe, nta gikoresho cya Excel, cyahita kikuraho formula kuva ka selile, hanyuma ibumoso gusa. Kubwibyo, ugomba gushakisha inzira zigoye zo gukemura ikibazo.

Uburyo 1: Gukoporora indangagaciro ukoresheje ibice

Gukoporora amakuru udafite formulaire mubindi bice birashobora bishoboka ukoresheje ibice.

1. Turagaragaza imbonerahamwe cyangwa intera, kugirango tuyitanga hamwe na indanga hamwe na buto yimbeba yibumoso. Kuguma muri tab "urugo", kora gukanda kuri "kopi" ya "kopi", iherereye kuri kaseti muri "buffer".



2. Hitamo selile zizaba hejuru ya selile yo hejuru yashizwemo ameza. Kora kanda kuri youse iburyo. Ibikubiyemo bizakorwa. Muri "Shyiramo ibipimo", hagarika guhitamo igika cya "Agaciro". Ihagarariwe nkishusho ifite ishusho yimibare "123".

Nyuma yo gukora ubu buryo, intera izinjizwa, ariko muburyo bwindangagaciro nta formulaire. Nukuri, imiterere yambere nayo irazimiye. Kubwibyo, kora ameza azaba agomba.

Uburyo 2: Gukoporora kwinjiza bidasanzwe

Niba ukeneye kuzigama imiterere yumwimerere, ariko ntushaka kumara umwanya mubikoresho byintoki byameza, noneho birashoboka gukoresha "kwinjiza bidasanzwe" kuri izo ntego.

1. Gukoporora muburyo bumwe nkigihe cyanyuma ibikubiye mumeza cyangwa intera.
2. Turagaragaza ahantu hose gushingiramo cyangwa selile yo hejuru. Twahagaritse kuri buto yimbeba iburyo, bityo duhamagare ibikubiyemo. Kurutonde rufungura, hitamo ikintu kidasanzwe ". Ibikurikira, muri menu yinyongera, kanda kuri "indangagaciro hamwe na buto yambere", shyiramo indangagaciro "zinjizamo" hamwe nishusho ya kare, aho imibare na brush bigaragazwa.

Nyuma yiki gikorwa, amakuru azakopororwa nta forméulation, ariko icyarimwe imiterere yambere izakizwa.

Uburyo 3: Gukuraho formula kuva kumeza yinkomoko

Mbere yibyo, twabwiye uburyo bwo kuvana formula mugihe cyo gukoporora, none reka tumenye uburyo bwo kubikuraho inkomoko.

1. Dutanga kopi yimeza nubwoko ubwo aribwo bwose ikiganiro cyari hejuru, mubutaka bwubusa bwurupapuro. Guhitamo inzira runaka murubanza indangagaciro ntiziza.
2. Hitamo urwego rwandukuwe. Kanda kuri buto "Kopi" kuri kaseti.



3. Hitamo intera yambere. Kanda kuri Iburyo bwimbeba. Mu rutonde rw'ibivugwamo mu itsinda ryashyizweho, hitamo "indangagaciro".



4. Nyuma yamakuru yinjijwe, urashobora gusiba intera yo gutambuka. Turabigaragaza. Hamagara imiterere ya menu ukanze buto yimbeba iburyo. Hitamo ikintu "Gusiba ...".



5. Idirishya rito rifungura, ukeneye kwishyiriraho ibyo ukeneye gusiba. Muri byumwihariko, intera yacu yo gutambuka ni hasi kumeza yinkomoko, niko dukeneye gusiba imirongo. Ariko iyo yari aherereye kumutwe wa we, byaba ngombwa gukuraho inkingi, ni ngombwa cyane kutitiranya, nkuko ushobora gusenya ameza nkuru. Rero, shiraho igenamiterere ryo gukuraho hanyuma ukande buto "OK".

Nyuma yo gukora ibi bikorwa, ibintu byose bitari ngombwa bizakurwaho, kandi amabwiriza ava kumeza yinkomoko azashira.

Uburyo 4: Gukuraho formulaire idashyizeho itsinda ryitambuka

Birashobora gukorwa no koroha kandi ntabwo gukora intera ya transit na gato. Nibyo, muriki gihe, ugomba gukora witonze witonze, kuko ibikorwa byose bizakorwa mumipaka yimeza, bivuze ko ikosa iryo ari ryo ryose rishobora guhungabanya ubusugire bwamakuru.

1. Turagaragaza intera ukeneye gukuraho formulaire. Kanda kuri buto "kopi", ushyizwe kuri kaseti cyangwa amanota ya Ctrl + c urufunguzo rwo guhuza clavier. Ibi bikorwa bihwanye.



2. Noneho, udakuyeho guhitamo ukanze buto yimbeba iburyo. Ibikubiyemo byatangijwe. Muri "Shyiramo ibipimo", kanda ahanditse "indangagaciro".

Rero, amakuru yose azakopororwa kandi ahita yinjizwa nkindangagaciro. Nyuma yibi bikorwa, formula mubice yagaragaye ntizagumaho.

Uburyo 5: Gukoresha Macro

Gukuraho formula kuva selile, urashobora kandi gukoresha macros. Ariko kubwibi ukeneye kubanza gukora tab ya interineti, kimwe no kubamo imirimo ya macros niba idakora. Uburyo bwo kubikora, urashobora kumenya mu ngingo itandukanye. Tuzavuga mu buryo butaziguye kubyerekeye kongeramo no gukoresha macro kugirango dukureho formula.

1. Jya kuri tab yiterambere. Kanda kuri buto "Visual Shingiro" iherereye kuri kaseti yo muri Toolbar.



2. Macro Yatangiye. Shyiramo kode iri hepfo kuri yo:

   Sub delete_mula ()

   Guhitamo.ViziVizi = Guhitamo.Wizitizi.

   Kurangiza.

   Nyuma yibyo, funga umwanditsi widirishya ukoresheje inzira isanzwe ukanda buto mugice cyo hejuru.



3. Tugarutse ku rupapuro, ruherereye ku meza yo kudushishikaje. Turagaragaza agace aho formula ushaka gusiba iherereye. Muri tab yiterambere, kanda kuri buto ya Macros, ushyizwe kuri kaseti mumatsinda ya kode.



4. Idirishya rya Tacros rifungura. Turashaka ikintu cyitwa "Gusiba_muvamo", ndabigaragaza hanyuma ukande buto "Kwiruka".

Nyuma yibi bikorwa, formulaire zose mukarere katoranijwe izasibwa, kandi ibisubizo byibarwa bizagumaho.

Isomo: Nigute ushobora Gushoboza cyangwa Guhagarika Macros muri Excel

Isomo: Nigute wakora macro muri excel

Uburyo 6: Gukuraho formula hamwe nibisubizo

Ariko, hari ibibazo mugihe ari ngombwa gukuraho formula gusa, ahubwo nibibisubizo. Ongera byoroshye.

1. Dukerekana intera ishyizwemo. Kanda buto yimbeba iburyo. Mubice bikubiyemo, guhagarika guhitamo kuri "ibintu bisobanutse". Niba udashaka guhamagara menu, urashobora gukanda gusa urufunguzo rwo gusiba nyuma yo gutoranya.



2. Nyuma yibi bikorwa, ibikubiye muri selile, harimo formula nindangagaciro, bizasibwa.

Nkuko tubibona, hari uburyo butari buke ushobora gukuraho formulaire, haba mugihe cyo gukoporora amakuru kandi mumeza ubwayo. Nibyo, igikoresho cyumukozi Excel, cyahita kikuraho imvugo imwe kanda, Kubwamahirwe, kugeza igihe. Muri ubu buryo, gusa ibitekerezo bifite indangagaciro birashobora kuvaho. Kubwibyo, ugomba gukora muburyo bwa Bypass ukoresheje ibipimo cyangwa ukoresheje macros.