Nigute wandukure ameza kuva excel muri excel

Kubakoresha Excel benshi, inzira yo gukoporora ameza ntabwo ari ingorane zikomeye. Ariko, ntabwo abantu bose bazi nunces zigufasha gukora ubu buryo muburyo bwiza bushoboka kubundi buryo butandukanye bwamakuru nuburyo butandukanye. Reka dusuzume birambuye ibintu bimwe na bimwe biranga gukoporora amakuru muri gahunda ya Excel.

Gukoporora kurenza urugero

Gukoporora ameza muri Excel nubwashinze ikoreshwa ryayo. Muburyo bwinshi, nta tandukaniro mubyukuri bishingiye aho ugiye gushyiramo amakuru: mubindi bice byimpapuro imwe, kurupapuro rushya cyangwa ikindi gitabo (dosiye). Itandukaniro nyamukuru riri hagati yuburyo bwo gukoporora nuburyo ushaka gukoporora amakuru: hamwe na formulaire cyangwa gusa hamwe namakuru yerekanwe gusa.

Isomo: Gukoporora Imbonerahamwe muri Mirosoft Ijambo

Uburyo 1: Gukoporora bisanzwe

Kwandukura byoroshye na deflot to Excel bikubiyemo gushinga kopi yimeza hamwe hamwe na formulaire zose zashyizwemo no gutunganya.

1. Twerekana agace dushaka gukoporora. Kanda ahanditse yahinduwe hamwe na buto yimbeba iburyo. Ibikubiyemo biragaragara. Hitamo muri "kopi".

   

   Hariho ubundi buryo bwo gukora iyi ntambwe. Ubwa mbere muribo bugizwe no gukanda clavier ya CTRL + C nyuma yo gutoranya ako gace. Ihitamo rya kabiri ririmo buto ya "kopi", iherereye kuri kaseti muri tab "murugo" muri "Guhana Buffer".



2. Fungura ahantu dushaka gushyiramo amakuru. Birashobora kuba urupapuro rushya, indi dosiye idasanzwe cyangwa ahandi hantu h'ingirabuzimafatizo kurupapuro rumwe. Kanda kuri selire igomba kuba hejuru yinyuma yashizwemo ameza. Mubice bikubiyemo ibipimo byinjiza, hitamo "paste".

   

   Hariho ubundi buryo bwo gukora ibikorwa. Urashobora kwerekana Ctrl + v claviya yanditswe kuri clavier. Byongeye kandi, urashobora gukanda kuri buto "Paste", iherereye kuruhande rwibumoso bwa kaseti kuruhande rwa "kopi".

Nyuma yibyo, kwinjiza amakuru bizakorwa mugihe kibungabunga imiterere na formulaire.

Uburyo 2: Gukoporora indangagaciro

Uburyo bwa kabiri butanga bwo kwirinda indangagaciro zifatika zerekanwa kuri ecran, ntabwo ari formula.

1. Gukoporora amakuru muri bumwe mu buryo bwasobanuwe haruguru.
2. Mugukanda buto yimbeba iburyo ahantu ukeneye gushyiramo amakuru. Mubice bikubiyemo ibice byinjizwamo, hitamo "indangagaciro".

Nyuma yibyo, ameza azongerwa kurupapuro atabitseho imiterere na formulaire. Nibyo, gusa amakuru yerekanwe kuri ecran azakopororwa.

Niba ushaka kwigana indangagaciro, ariko mugihe kimwe uzigame imiterere yumwimerere, noneho ugomba kujya kuri menu "kwinjiza bidasanzwe" mugihe cyo kwinjiza. Ngaho, muri "Shyiramo indangagaciro", ugomba guhitamo "indangagaciro hamwe nuburyo bwumwimerere".

Nyuma yibyo, ameza azerekanwa muburyo bwambere, ariko aho kuba formulaire ya selile izuzuza indangagaciro zihoraho.

Niba ushaka gukora iki gikorwa gusa hamwe no kubungabunga imiterere yimibare, ntabwo ari imbonerahamwe yose, hanyuma muburyo budasanzwe ukeneye guhitamo ikintu "indangagaciro hamwe nimiterere yimibare".

Uburyo 3: Kora kopi mugihe uzigama inkingi

Ariko, ikibabaje, ndetse no gukoresha inkomoko yinkomoko ntabwo bikwemerera gukora kopi yimeza hamwe nubugari bwambere. Ni ukuvuga, akenshi hari ibibazo mugihe amakuru adashyizwe mu tugari nyuma yo kwinjiza. Ariko muri Excel, birashoboka kubungabunga ubugari bwinkingi yumwimerere ukoresheje ibikorwa bimwe.

1. Gukoporora ameza muburyo bumwe busanzwe.
2. Ahantu ukeneye kwinjiza amakuru, hamagara ibikubiyemo. Duhora dunyuze mubintu "gushiramo bidasanzwe" kandi "ukize ubugari bwinkingi yumwimerere."

   

   Urashobora kwiyandikisha mubundi buryo. Kuva kuri ibikubiyemo kabiri jya ku kintu hamwe nizina rimwe "Kwinjiza bidasanzwe ...".

   

   Idirishya rifungura. Muri "Shyiramo ibikoresho byabikoresho, twongerera gahunda kumwanya" ubugari "bwinkingi". Kanda kuri buto ya "OK".

Ibyo ari byo byose wahisemo muburyo bubiri byavuzwe haruguru, uko byagenda kose, kumeza gukoporora bizagira ubugari bumwe ninkomoko.

Uburyo 4: Shyiramo ishusho

Hariho ibibazo mugihe ameza agomba kwinjizwa muburyo busanzwe, ariko nkigishusho. Iki gikorwa nacyo cyakemutse ukoresheje ibikoresho bidasanzwe.

1. Kora kopi yifuzwa.
2. Hitamo ahantu ho gushiramo no guhamagara ibikubiyemo. Jya ku kintu "shyiramo bidasanzwe". Muri "Ibindi shyiramo igenamiterere" guhagarika, hitamo ikintu "Igishusho".

Nyuma yibyo, amakuru azinjizwa kurupapuro nkishusho. Mubisanzwe, ntibizashoboka guhindura ameza.

Uburyo 5: Gukopera

Niba ushaka kwigana ameza yose kurundi rupapuro, ariko icyarimwe ubike soko isa rwose, noneho muriki gihe, nibyiza kopikira urupapuro rwose. Muri iki gihe, ni ngombwa kumenya ko ushaka rwose kohereza ibintu byose biri ku rupapuro rwinkomoko, bitabaye ibyo ubu buryo ntibuzakwira.

1. Kurwanya intoki kuntoki zose zurupapuro, kandi ibi byafata umwanya munini, kanda kuri urukiramende giherereye hagati yitsinda ryagateganyo na vertical. Nyuma yibyo, urupapuro rwose ruzagaragazwa. Gukoporora ibirimo, andika Ctrl + c guhuza kuri clavier.



2. Kwinjiza amakuru, fungura urupapuro rushya cyangwa igitabo gishya (dosiye). Mu buryo nk'ubwo, kanda kuri urukiramende rwashyizwe ku masangano y'imitwe. Kugirango ushiremo amakuru, andika CTRL + V Button.

Nkuko mubibona, nyuma yo gukora ibi bikorwa, twashoboye gukoporora hamwe kumeza hamwe nibice bisigaye. Byaragaragaye ko bidakizwa gusa imiterere yambere gusa, ariko kandi ubunini bwa selile.

Ubwanditsi bwa Exel Exel afite ibikoresho byinshi byo gukoporora imbonerahamwe neza nkuko umukoresha asabwa. Kubwamahirwe, ntabwo abantu bose bazi imiterere yo kwinjiza bidasanzwe nibindi bikoresho byo gukoporora bigufasha kwagura amakuru kubishoboka byo kwimura amakuru, kimwe no gukora imyitozo ibikorwa byumukoresha.