Nigute ushobora gukora ibisobanuro bikora mubuhungiro

Uburyo 1: Gukoporora amahuza binyuze muri mushakisha

Ntugomba guhindura umurongo niba ubanza kumenya ukongeraho kuba indashyikirwa neza. Niba ufite ubushobozi bwo gukoporora aderesi ukoresheje umugozi muri mushakisha, nibyiza guhita ubikora, hanyuma ujye mu ihuriro ryinjizwa kumeza.

Kugirango ukore ibi, urashobora gukoresha mushakisha zose zurubuga mugukoresha gukoporora binyuze muri menu cyangwa urufunguzo rushyushye Ctrl + C.

Mumeza ya Excel, hitamo akagari keza hanyuma ukande Ctrl + V kugirango ushiremo igitabo cyandukuwe mbere. Hindura ku zindi selile iyo ari yo yose kugirango urebe uko umurongo ugaragara mubururu, bivuze ko umurongo ukora.

Uburyo 2: Gukoresha igikoresho cyo guhuza

Ukoresheje uburyo bwambere ndetse no gusimbuza umurongo umaze kongerwaho - ntabwo buri gihe ari uburyo bwiza, cyane cyane mugihe cyo gukora amahuza menshi ako kanya. Muri uru rubanza, "Reba" yerekana muri gahunda irimo gusuzumwa ifatwa nkuburyo bworoshye.

1. Shakisha umugozi aho umurongo ugomba kuba umurongo ukora, hanyuma ukande kuri yo kanda iburyo.



2. Muri menu igaragara, kanda kumurongo wanyuma "Ihuza".



3. Mubihe byubu, uzakenera guhitamo amahitamo "dosiye, urubuga, kurubuga" muri "karuvati c:" guhagarika.



4. Gukoporora inyandiko iriho niba bimaze kuba ngombwa guhindura umurongo, hanyuma uyinjire mumwanya wa aderesi hanyuma ugashyira mu bikorwa impinduka.



5. Garuka kumeza kandi urebe neza ko ibikorwa bikorwa. Kora kimwe hamwe nutugingo ngene zisigaye, bigomba gukorwa.



6. Muri ubwo buryo, hamwe na selile, aho ubanza aho kuba umurongo wanditse hari inyandiko isanzwe. Shyiramo izina ryurubuga muri "Aderesi" kugirango ujye gukoresha igenamiterere rishya.

Uburyo 3: Gukora macro kugirango ukore vuba amahuza

Umukoresha Macro ikoreramo inkingi yihariye muburyo bwihariye ni ingirakamaro kubakoresha bahuye nigikorwa cyo guhindura itsinda udashobora kuva mumeza. Muri iki gihe, ibikoresho byabanjirije ibinyabiziga bizakenerwa, bityo ubishyire mbere kuburyo bukurikira:

1. Nyuma yo gufungura ameza, jya kuri dosiye yambere ".



2. Ku gice cy'ibumoso, hitamo igice "parameter".



3. Fungura "Kugena karanti".



4. Shyira ahagaragara "uwateguwe" hamwe na marike kugirango wongere kuri kaseti.

Funga idirishya igenamiterere hanyuma ukomeze kurema macro, tuzavuga mumabwiriza hepfo.

1. Kurema macros muri excel, module itandukanye ijyanye nintangiriro zijya kuri tab yiterambere.



2. Kuva aho, koresha "ishusho y'ibanze".



3. Kanda inshuro ebyiri kuri stajnig umurongo, ufungura idirishya rya macro.



4. Shyiramo ibikurikira hanyuma usimbuze "C2" na "C" kumurongo watoranijwe kumurongo wamabaruwa nintangiriro yinkingi, aho amahuza atondekanye gukora.

   Sub hypersylka ()

   Akagari ka Dim nkurwego, Ra Nka Range: Gusaba.scupdating = Ikinyoma

   Shiraho Ra = Urwego ([C2], urwego ("c" & imirongo.umurongo.end) .end (Xlup))

   Kuri buri selile i Ra.Rells

   Niba len (selile) noneho selile.lperlinks.add selile, selile

   Selile ikurikira.

   Kurangiza.

   Subpersylk baselect ()

   Akagari ka Dim nkurwego: gusaba.scupdating = ibinyoma

   Kuri buri selire muguhitamo

   Niba len (selile) noneho selile.lperlinks.add selile, selile

   Selile ikurikira.

   Kurangiza.



5. Iguma gusa gukanda "kubika" cyangwa gukoresha urufunguzo rushyushye, hanyuma ufunge igikoresho cya macro cyo kurema.



6. Noneho igenamiterere ntirikoreshwa, fungura idirishya rya "macroros".



7. Muri yo, kora macro yaremye munsi yizina "hypersylka".



8. Garuka kumeza kandi urebe neza ko ubu ihuza ryose ryerekanwe neza.