Uburyo bwo guhuza inkingi mu buhungiro

Iyo ukorera muri gahunda, Excel rimwe na rimwe uza guhuza inkingi ebyiri cyangwa nyinshi. Abakoresha bamwe ntibazi kubikora. Abandi bamenyereye gusa nuburyo bworoshye. Tuzaganira ku buryo bwose bushoboka bwo guhuza ibi bintu, kuko kuri buri muntu ku giti cye gukoresha amahitamo atandukanye.

Guhuza inzira

Inzira zose zo guhuza inkingi zirashobora kugabanywamo mumatsinda abiri manini: koresha imiterere no gukoresha imirimo. Uburyo bwo gutunganya buroroshye, ariko ibibazo bimwe byo guhuza inkingi birashobora gukemurwa gusa ukoresheje imikorere idasanzwe. Reba uburyo bwose muburyo burambuye kandi usobanure, muburyo imanza zihariye ni byiza gushyira muburyo runaka.

Uburyo 1: Huza ukoresheje ibikubiyemo

Inzira isanzwe yo guhuza inkingi nugukoresha ibikoresho bya menu.

1. Turagaragaza urwego rwa mbere rwa selile yabavuga ko dushaka guhuza. Kanda kubintu byeguriwe hamwe na buto yimbeba iburyo. Ibikubiyemo bifungura. Hitamo muri IT "imiterere ngendanwa ...".



2. Idirishya rya selile rifungura. Jya kuri tab "guhuza". Mu itsinda rya Igenamiterere "Erekana" Hafi "ihuriro rihuza", dushyira akamenyetso. Nyuma yibyo, kanda kuri buto "OK".



3. Nkuko mubibona, twahujije selile zo hejuru gusa. Tugomba guhuza ingirabuzimafatizo zose z'umurongo ibiri. Hitamo selile ihuriweho. Kuba muri tab "urugo" kuri kaseti kanda kuri buto "icyitegererezo". Iyi buto ifite imiterere ya brush kandi iherereye muri "kuvunja buffer". Nyuma yibyo, gusa utanga ahantu hasigaye, ukeneye guhuza inkingi.



4. Nyuma yo kumiterere ukurikije icyitegererezo, inkingi z'ameza zizanywanywa muri imwe.

Icyitonderwa! Niba amakuru yahujwe mumiseporo hamwe, gusa amakuru aherereye mu nkingi yibumoso yintambwe yatoranijwe izakizwa. Andi makuru yose azarimburwa. Kubwibyo, hamwe nibidasanzwe, ubu buryo burasabwa gukoreshwa mugukorana na selile irimo ubusa cyangwa hamwe nabavuga bafite amakuru make.

Uburyo 2: Huza ukoresheje buto ya kaseti

Guhuza kandi inkingi zirashobora gukorwa ukoresheje buto ya kaseti. Muri ubu buryo, biroroshye gukoresha niba ushaka guhuza ntabwo ari inkingi gusa kumeza itandukanye, ahubwo ni urupapuro muri rusange.

1. Kugirango duhuze inkingi kurupapuro rwose, bakeneye kubigaragaza mbere. Twabaye hafi yitsinda rya horizontal ya excel bahuza, aho amazina yinkingi ifite inyuguti z'inyuguti z'ikilatini zanditswe. Shyira umuringa wibumoso wimbeba hanyuma ugaragaze inkingi dushaka guhuza.



2. Jya kuri tab "urugo", niba uri muriki gihe turi muyindi tab. Kanda kuri Pictogram muburyo bwa mpandeshatu, inkombe yicyerekezo hasi, iburyo bwa "guhuza no gushyira kuri kaseti", iherereye kuri kaseti yo guhuza ibikoresho. Ibikubiyemo bifungura. Hitamo muri yo ikintu "gihuza n'imirongo".

Nyuma yibi bikorwa, inkingi zagenewe urupapuro rwose zizahuzwa. Mugihe ukoresheje ubu buryo, nko muri enbodiment yabanjirije, amakuru yose, usibye abari mubumwe mu nkingi ikabije, izatakara.

Uburyo 3: Huza ukoresheje imikorere

Mugihe kimwe, birashoboka guhuza inkingi nta gutakaza amakuru. Ishyirwa mu bikorwa ry'ubu buryo rigoye cyane n'uburyo bwa mbere. Byakozwe ukoresheje imikorere yo gufata.

1. Hitamo selile iyo ari yo yose mu nkingi yubusa kurupapuro rwa Excel. Kugirango habeho imikorere wizard, kanda kuri buto "Shyiramo Imikorere", iherereye hafi yumurongo wa formula.



2. Idirishya rifungura urutonde rwimirimo itandukanye. Dukeneye muri bo gushaka izina "gufata". Nyuma yo kubona, hitamo iki kintu hanyuma ukande buto ya "OK".



3. Nyuma yibyo, ingingo zidirishya ryimpaka rifungura. Ibitekerezo byayo ni aderesi ngendanwa, ibikubiye muri byo bigomba guhuzwa. Mu murima "Inyandiko1", "inyandiko2", nibindi. Tugomba gukora aderesi za selile umurongo wo hejuru winkingi zunze ubumwe. Urashobora kubikora winjiza adresse intoki. Ariko biroroshye cyane gushyira indanga mumwanya w'impaka zijyanye, hanyuma uhitemo selile kugirango ihuze. Muri ubwo buryo, mubyukuri dukora hamwe nabandi selile yumurongo wambere winkingi zahujwe. Nyuma yo guhuza imirima "ikizamini1" "," inyandiko2 ", nibindi, kanda buto" OK ".



4. Mu kagari, byerekana ibisubizo byo gutunganya indangagaciro zikora, amakuru ahuriweho numurongo wambere winkingi zagaragaye. Ariko, nkuko tubibona, amagambo yo muri seliji yahujwe nibisubizo, nta mwanya uri hagati yabo.

   

   Kugirango uyigabanye muri formulaire umurongo nyuma yingingo hamwe na koma hagati yimigabane ya selile, dushyiramo inyuguti zikurikira:

   " ";

   Mugihe kimwe, hagati yinyuguti zombi muri ibi bimenyetso byinyongera, dushyira icyuho. Niba tuvuga kurugero rwihariye, noneho kuri twe inyandiko:

   = Gufata (B3; C3)

   Byahinduwe kuri ibi bikurikira:

   = Gufata (B3; ""; C3)

   Nkuko tubibona, hari umwanya hagati yamagambo, kandi ntibaba bagihuje. Niba ubishaka, hamwe numwanya, urashobora gushira koma cyangwa undi utandukanijwe.



5. Ariko, mugihe tubonye ibisubizo kumurongo umwe gusa. Kugirango ubone agaciro gahujwe ninkingi no mu zindi selile, dukeneye kwigana imikorere kugirango dushyire inyuma. Kugirango ukore ibi, shiraho indanga kuruhande rwiburyo bwiburyo bwa selile irimo formula. Ikimenyetso cyo kuzura muburyo bwumusaraba. Kanda buto yimbeba yibumoso hanyuma urambure kugeza kumpera yameza.



6. Nkuko tubibona, formula yandukuwe murwego rukurikira, kandi ibisubizo bihuye byerekanwe muri selile. Ariko twakoze indangagaciro gusa. Noneho ugomba guhuza selile zambere hanyuma usubize amakuru ahantu h'umwimerere. Niba uhuza cyangwa usibe inkomoko yinkomoko, noneho formula yo gufata izavunika, kandi turacyatakaza amakuru. Kubwibyo, tuzakora ukundi. Hitamo inkingi hamwe nibisubizo hamwe. Muri tab ya Murugo, kanda kuri buto "Kopi", shyirwa kuri kaseti muri "kuvunja buffer". Nkibindi bikorwa, urashobora gukuramo Ctrl + C nyuma yo guhitamo inkingi.



7. Shyira indanga kumurima uwo ariwo wose. Kanda buto yimbeba iburyo. Mubikubiyemo bigaragara muri Igenamiterere rya Igenamiterere, hitamo "agaciro".



8. Twakijije indangagaciro z'inkingi yahujwe, kandi ntizishingiye kuri formula. Nongeye gukoporora amakuru, ariko usanzwe uva ahantu hashya.



9. Turagaragaza inkingi yambere yurwego rwambere, izakenera guhuzwa nabandi bavuga. Twakanze kuri buto "Paste" yashyizwe kuri tab yo murugo muguhana amakuru ya buffer. Urashobora, aho kuba intambwe yanyuma, kanda kuri clavier shortcut ctrl + v urufunguzo.



10. Hitamo inkingi zambere zigomba guhuzwa. Muri tab ya Tool, muri "guhuza" Toolbar, umaze gufungura uburyo bwabanje kuri menu hanyuma uhitemo "guhuza umurongo" ikintu muricyo.



11. Nyuma yibyo, idirishya hamwe nubutumwa bwamakuru kubifaraho byamakuru bizagaragara inshuro nyinshi. Kanda buto ya "Ok" buri gihe.



12. Nkuko mubibona, amakuru arangije ahujwe ninkingi imwe ahantu byasabwaga mbere. Noneho ugomba gusukura urupapuro ruva mumakuru yo gutambuka. Dufite uduce tubiri: inkingi hamwe na formula ninkingi hamwe nindangagaciro zandukuye. Tugenera ubundi buryo bwa mbere na kabiri. Kanda iburyo ahanditse. Mubice bikubiyemo, hitamo "Isuku Ibirimo".



13. Tumaze gukuraho amakuru yo gutambuka, gutunganya inkingi ihuriweho mubushake bwabo, nkuko bitewe na manipulations, imiterere yacyo yasubiwemo. Byose biterwa nintego yimbonerahamwe yihariye kandi iguma mubushishozi bwumukoresha.

Kuri ubu buryo, guhuza inkingi nta gutakaza amakuru birashobora gufatwa hejuru. Nibyo, ubu buryo bugoye cyane nuburyo bwabanjirije, ariko mubihe bimwe ni ngombwa.

Isomo: Umukozi wa Wizard muri Excel

Nkuko mubibona, hariho inzira nyinshi zo guhuza inkingi muri excel. Urashobora gukoresha kimwe muri bo, ariko mubihe bimwe, ugomba gutanga uburyo runaka.

Rero, abakoresha benshi bahitamo gukoresha guhuza binyuze muri menu, nkibyingenzi. Niba ukeneye gukora guhuza inkingi atari mumeza gusa, ahubwo no ku rupapuro, noneho bizahindurwa binyuze muri menu kuri lente ya Rubse. Niba ukeneye guhuza nta gutakaza amakuru, noneho urashobora guhangana niki gikorwa ukoresheje imikorere yafashwe gusa. Nubwo niba amakuru akize amakuru adashyirwa, ndetse nibindi byinshi, niba selile zunze ubumwe zirimo ubusa, ntabwo zisabwa gukoresha ubu buryo. Ibi biterwa nuko bigoye kandi kubishyira mubikorwa bitwaye igihe kirekire.