Hariho ibihe aho inyandiko cyangwa imbonerahamwe byatsinzwe mu Ijambo rya Microsoft bigomba guhinduka kuri Excel. Kubwamahirwe, Ijambo ntabwo ritanga ibikoresho byubatswe kubisobanuro nkibi. Ariko, icyarimwe, hariho uburyo butari buke bwo guhindura dosiye muriki cyerekezo. Reka tumenye uburyo byakorwa.
Uburyo bwibanze bwo guhindura
Urashobora guhitamo uburyo butatu bwo guhindura ijambo dosiye kuri excel:- Amakuru yoroshye yo kwigana;
- Gukoresha ibya gatatu byihariye porogaramu;
- Ikoreshwa rya serivisi zihariye kumurongo.
Uburyo 1: Gukoporora amakuru
Niba wiyoko amakuru ava mumyandiko kugirango wirinde, ibikubiye mu nyandiko nshya ntibizabona ibintu byiza cyane. Buri gika kizashyirwaho mu kagari gatandukanye. Kubwibyo, nyuma yinyandiko yandukuwe, ugomba gukora kumiterere yubuso bwayo kurubuga rwa Excel ubwayo. Ikibazo cyihariye ni ugukoporora ameza.
- Hitamo igice cyifuzwa cyinyandiko cyangwa inyandiko rwose mwijambo rya Microsoft. Hamwe na buto yimbeba iburyo, bisaba ibikubiyemo. Hitamo ikintu "kopi". Urashobora aho gukoresha ibikubiyemo, nyuma yo guhitamo inyandiko, kanda kuri buto "kopi", bishyirwa muri tab ya "Guhana Buffer". Ubundi buryo nyuma yo guhitamo inyandiko. Kanda urufunguzo rwo guhuza clavier Ctrl + C.
- Fungura gahunda ya Microsoft Excel. Kanda ahagana hafi ya Ahantu kurupapuro, aho kujyamo ingingo. Imbeba iburyo kanda guhamagara ibikubiyemo. Muri yo muri "Shyiramo ibipimo", hitamo "kubika inyuguti zambere".
Kandi, aho kugirango ibyo bikorwa, urashobora gukanda kuri buto ya "Paste", ishyirwa kuruhande rwibumoso bwa kaseti. Ubundi buryo ni ugutangaza CTRL + v urufunguzo.
Nkuko mubibona, inyandiko yinjijwe, ariko, nkuko byavuzwe haruguru, ifite isura idasanzwe.
Kugirango twemere ubwoko dukeneye, gusunika selile mubugari bwifuzwa. Niba hari icyifuzo cyongeyeho.
Uburyo 2: Amakuru Yambere Gukoporora
Hariho ubundi buryo bwo guhindura amakuru kuva ijambo kugirango Verssl. Birumvikana ko ari kugorana na verisiyo ibanza, ariko, icyarimwe, kwimurwa akenshi bikosowe.
- Fungura dosiye muri gahunda yijambo. Kuba muri tab ya Murugo, kanda ahanditse "Erekana Ibimenyetso byose", biherereye kuri kaseti mugikoresho cyibika. Aho kugirango ibyo bikorwa, urashobora gukanda gusa CTRL + *.
- Markup idasanzwe izagaragara. Kurangiza buri gika gihagarara ikimenyetso. Ni ngombwa gukurikirana kugirango nta paragarafu irimo ubusa, bitabaye ibyo guhinduka ntikbyo. Ibika nkibi bigomba kuvaho.
- Jya kuri tab "dosiye".
- Hitamo ikintu "uzigame".
- Idirishya rikiza dosiye rifungura. Muri "Ubwoko bwa dosiye", hitamo "inyandiko isanzwe". Kanda kuri buto "Kubika".
- Mu idirishya ryo guhinduka idirishya rifungura, nta mpinduka zidakeneye. Kanda buto ya "OK".
- Gufungura gahunda ya Excel muri tab "dosiye". Hitamo ikintu "fungura".
- Muri "Inyandiko ifungura" idirishya muri ibipimo bya dosiye fungura, shiraho "dosiye zose". Hitamo dosiye mbere yuko igumana mu Ijambo nkinyandiko isanzwe. Kanda kuri buto "Gufungura".
- Umwigisha wo gutumiza mu mahanga. Erekana imiterere yamakuru "hamwe na Delimiters". Kanda kuri buto "ikurikira".
- Muri "ikimenyetso-gitandukanijwe", cyerekana agaciro "koma". Kuva mubindi bintu byose, kura agasanduku k'isanduku niba uhari. Kanda kuri buto "ikurikira".
- Mu idirishya ryanyuma, hitamo imiterere yamakuru. Niba ufite inyandiko isanzwe, birasabwa guhitamo imiterere "isangwa" (gushyirwaho muburyo busanzwe) cyangwa "inyandiko". Kanda kuri buto "Kurangiza".
- Nkuko mubibona, ubu buri gika cyinjijwemo mu kagari gatandukanye, nko muburyo bwambere, ariko mumurongo wihariye. Noneho ugomba kwagura iyi mirongo kugirango amagambo yumuntu adatakaye. Nyuma yibyo, urashobora gushiraho selile mubushishozi bwawe.
Hafi ya gahunda imwe urashobora gukoporora ameza uhereye ijambo kugirango berekeza. Ibikoresho byubu buryo byasobanuwe mumasomo atandukanye.
Isomo: Nigute washyiramo imbonerahamwe uhereye kumagambo muri excel
Uburyo 3: Gusaba gusaba guhinduka
Ubundi buryo bwo guhindura inyandiko inyandiko kuri Excel nugukoresha porogaramu zihariye kugirango uhindure amakuru. Kimwe mubyoroshye cyane ni abE excel kugirango ijambo rihindura.
- Fungura akamaro. Kanda kuri "Ongera dosiye".
- Mu idirishya rifungura, hitamo dosiye igomba guhinduka. Kanda kuri buto "Gufungura".
- Muburyo bwo gusohoka bwo guhagarika, hitamo imwe muri format eshatu excel:
- Xls;
- XLSX;
- XLSM.
- Mubisohoka gushiraho igenamiterere, hitamo aho dosiye izahinduka.
- Iyo igenamiterere ryose ryerekanwe, kanda kuri buto "Guhindura".
Nyuma yibyo, inzira yo guhinduka ibaho. Noneho urashobora gufungura dosiye muri gahunda ya Excel, hanyuma ukomeze gukorana nayo.
Uburyo 4: Guhindura ukoresheje serivisi kumurongo
Niba udashaka gushiraho software yinyongera kuri PC yawe, urashobora gukoresha serivisi zihariye kumurongo kugirango uhindure dosiye. Imwe mubantu boroheje kumurongo mwijambo - Excel ni umutungo wahinduwe.
Kumurongo uhindura kumurongo
- Jya kurubuga rwahinduwe hanyuma uhitemo dosiye zo guhinduka. Ibi birashobora gukorwa muburyo bukurikira:
- Hitamo kuri mudasobwa;
- Kurura muri Windows Explorer ifunguye idirishya;
- Kuramo kuva kuri serivisi yo kugabanuka;
- Kuramo kuva kuri Google;
- Shyira umurongo.
- Nyuma yinkomoko yinkomoko yikorewe kurubuga, hitamo imiterere yo kubungabunga. Kugirango ukore ibi, kanda kurutonde rwamanutse ibumoso bwanditse "byateguwe". Jya kuri "Inyandiko", hanyuma uhitemo imiterere ya XL cyangwa XLSX.
- Kanda ahanditse "Guhindura".
- Nyuma yo guhinduka birangiye, kanda buto ya "Gukuramo".
Nyuma yibyo, inyandiko ya Excel izakururwa kuri mudasobwa yawe.
Nkuko mubibona, hariho uburyo bwinshi bwo guhindura ijambo dosiye kuri Excel. Iyo ukoresheje gahunda zihariye cyangwa ihindura kumurongo, impinduka zibaho muburyo bwinshi. Mugihe kimwe, intoki zo gukoporora, nubwo bisaba igihe kinini, ariko biragufasha gushiraho dosiye neza bishoboka.