Inzibacyuho Excel Utunganya nimwe mubisabwa byinshi bikubiye mubiro bya Microsoft. Ibigize byose bifitanye isano rya bugufi kandi bifite ibintu byinshi bisanzwe, amahirwe. Rero, ijambo ryanditse ryanditse rigufasha gukorana nameza, ubatere guhera no guhindura. Ariko rimwe na rimwe hariho umurimo wo kohereza ibintu byubu bwoko kuva kuri gahunda imwe mubindi. Ibyerekeye uko bikorwa, tuzabibwira uyu munsi.
Ihererekanyabubasha kuva Excel kumagambo
Nkuko byavuzwe haruguru, hari uburyo bwo kwishyira hamwe hagati ya Excel na Porogaramu. Ibi bitanga byoroshye gutumiza no kohereza ibicuruzwa bihuye na dosiye, gusangira no gukoresha imirimo ya gahunda imwe mubindi. Ihererekanyabubasha ryameza ryakozwe muburyo bwihariye kugirango tubarebe cyane cyane cyane gukorana ninyandiko nyinshi icyarimwe icyarimwe, kandi buri wese muri bo tuzareba mu buryo burambuye.Uburyo 1: Gukoporora no gushyiramo
Igisubizo cyiza kandi kigaragara kizaba kopi yoroshye yimeza kuva indabyo.
- Hitamo ameza ukoresheje imbeba kugirango wimurirwe mumyandiko.
Icyitonderwa: Mbere yo gukomeza kugenda kw'imeza, bigomba kubitangaza hamwe nubunini, cyangwa ahubwo, menya neza ko bitarenze inyandiko yinyandiko. Mugihe hakenewe cyane, ntushobora kugabanya (cyangwa, ku buryo, kwaguka) mu buryo butaziguye, ariko nanone gushiraho icyerekezo cyurupapuro nigitabo gisanzwe ku nyamaswa.
Soma Byinshi:
Nigute ushobora guhindura ingano yimeza muri excel
Gushiraho imirima mu Ijambo
Nigute ushobora gukora urupapuro rusanzwe mu Ijambo
- Gukoporora imbonerahamwe yateguwe ukoresheje buto kuri kaseti, ibikubiyemo cyangwa urufunguzo rushyushye "Ctrl + c".
- Noneho jya kuri MS W'IJAMBO. Fungura inyandiko kugirango wimurirwe kumeza, shyira indanga yerekana (gutwara) aho bigomba kuba, hanyuma ukore kimwe muri ibi bikurikira:
- Kwagura buto ya "Shyiramo" hanyuma ukande ku gishushanyo cya mbere murutonde - "Bika imiterere yumwimerere";
- Kanda iburyo (PCM) kumeza yameza, kandi muri menu yibice bigaragara, hitamo buto yavuzwe haruguru hamwe nishusho ya tablet no guswera;
- Koresha "CTRL + V" cyangwa, byiza, "Hindura + Shyiramo".
Imbonerahamwe yandukuwe muri Excel izinjizwa mu Ijambo muburyo bwumwimerere, nyuma ushobora gukomeza gukorana nayo - kuzuza, gushushanya, guhindura.
Nkuko ushobora kubibona, hariho ubundi buryo muri menu yashizwemo. Reba muri make buri kimwe muri byo.
- Koresha uburyo bw'inyandiko yanyuma. Ameza azinjizwa nta nkomoko yatunganijwe kandi akorwa muburyo ukoresha muri MS ijambo. Ni ukuvuga, niba wowe, kurugero, imyandikire ya tahoma ifite ubunini 12 yashyizweho nkiyi nkuru, iri muri yo ko ibiri mumeza bizandikwa.
- Guhambira no kubika imiterere yambere. Imbonerahamwe yinjijwe muburyo bumwe ryakozwe muri Excel kandi ikiza itumanaho hamwe nameza yameza - impinduka zatangijwe zizerekanwa mu magambo no mubyerekanwe bizerekanwa mu magambo no mubyerekanwe bizerekanwa mu magambo no mubyerekanwe bizerekanwa mu magambo no mubyerekanwe bizerekanwa mu magambo no mu magambo.
- Karuvati kandi ukoreshe imiterere yanyuma. Ihitamo ni synthesis yabanjirije ibibanza - imbonerahamwe ifata uburyo bwo kwiyandikisha inyandiko yijambo
- Gushushanya. Ameza azongerwa nkishusho idakwiriye guhindura.
- Bika inyandiko gusa. Imbonerahamwe yinjijwe nkinyandiko, ariko igumana imiterere yumwimerere (idafite imipaka igaragara, inkingi nu selile).
Reba kandi: Nigute ushobora guhindura imbonerahamwe kurutonde rwijambo
Ubu buryo bwo gukemura umurimo wacu bworoshye cyane mubikorwa byayo, wongeyeho ko hatanga amahitamo menshi yo kwinjiza icyarimwe, akwemerera guhitamo ikintu kimwe. Ariko, ubu buryo ntabwo butagira inenge: ameza manini cyane azimurirwa kwimurwa - bazarenga imirima yinyandiko yinyandiko.
Soma kandi: Gukora imbonerahamwe yo mu Ijambo rya Microsoft
Uburyo 2: Gukoporora no gushiramo bidasanzwe
Muri Microsoft Pacrations Porogaramu, hari ikintu cyingirakamaro kiranga "kwinjiza bidasanzwe", kigufasha kohereza imbonerahamwe muburyo bwikintu cyabigenewe, mugihe cyo kuzigama indabyo hamwe na excel (nka porogaramu ya dosiye). Ubu buryo butandukanye bukemura ikibazo cyuburyo bwabanje, kukwemerera gushyira ameza manini (yagutse) kurupapuro rwinyandiko, ariko, mwijambo ubwaryo, barashobora kwerekanwa nabi.
- Shyira ahagaragara kandi wandukure imbonerahamwe kuva excel nkuko twabikoze mu ntambwe yambere yuburyo bwabanje.
- Jya kumyandikire wanditse kandi muri tab yayo "nyamukuru", kanda kuri buto "Paste". Hitamo "Kwinjiza bidasanzwe" uhereye kurutonde rwamanutse.
- Mu idirishya ridasanzwe ", hitamo urupapuro rwa mbere" Microsoft (ikintu) Urupapuro ", hanyuma ushyire ikimenyetso giteganye n'imwe mu ngingo zombi:
- "Shyiramo" - wongeyeho muri ubu buryo iyo ugerageje kuyihindura (kanda kabiri yo gukanda umurongo wibikoresho bya Excel, bigufasha gukoresha imikorere yibanze yameza utavamo ibidukikije.
- "TIE" - Imbonerahamwe yinjijwe neza muburyo bumwe nkuko bimeze mu rubanza rwabanjirije, ariko guhindura byose (birashoboka cyane koperatike ya LKM) izakorerwa muri dosiye ya Excel zikorwa Byongeye, niba hari ibyo uhindura kuri yo muburyo bwa pular, bizerekanwa mumyandikire. Mubyukuri, ni kimwe nuburyo bwo gushyiramo "umurongo no gukomeza imiterere yumwimerere", yasuzumwe muburyo bwambere.
Guhitamo guhitamo, kanda "OK" kugirango wemeze, nyuma yikintu cyandukuwe kizagaragara kurupapuro rwinyandiko.
Guhindura, birahagije gukanda LX kumeza kabiri, no gusohoka muri ubu buryo - kanda hanze yameza.
Jya Guhindura, urashobora kandi binyuze muri menu
- Shyiramo icyerekezo ahantu h'ijambo ushaka gushyira ameza kuva excel hanyuma ujye kuri tab "shyiramo".
- Muburyo bwibikoresho, kanda kuri buto "ikintu" (cyangwa uhitemo ikintu cyatoranijwe kurutonde rwacyo cyamanutse).
- Muri "Shyiramo dosiye" idirishya rifungura, jya kuri "gukora dosiye".
Kanda kuri buto "Incamake" hanyuma unyuze muri sisitemu "Explorer" mububiko bwa dosiye ibitswe hamwe nurupapuro. Shyira ahagaragara hanyuma ukande "Paste".
- Ibikurikira, urashobora gukora muri kimwe muri algorithms eshatu:
- Kanda gusa "OK". Ameza azinjizwa muburyo bwikintu, ibipimo byabyo bishobora guhinduka, ariko ibirimo ntibishobora guhindurwa.
- Shyiramo agasanduku gahuye na dosiye hamwe na dosiye - Imbonerahamwe yinjijwe izahuzwa na Excel kandi ibereye guhindura haba muri yo no mu Ijambo. Impinduka zakozwe muri gahunda imwe zizahita zerekanwa mubindi (nyuma yo kugarura amahuza).
- Ikimenyetso cya cheque kirwanya "muburyo bwikimenyetso" - ikirango cya dosiye ya Exel kizongerwaho inyandiko yinyandiko. Niba udatangaye "itumanaho hamwe na dosiye", ameza azakingurwa muburyo bwari bufite mugihe cyo kwinjiza. Niba iki kimenyetso cyashyizweho, shortcut izakira imitungo imwe yasobanuwe mu gika kibanziriza iki, hamwe no kuvugurura gusa ko bidashoboka kuyihindura mu Ijambo.
Icyitonderwa: Niba Microsoft Extrel Inyandiko, shyiramo zikorwa mu Ijambo rya Microsoft, zizafungura, imenyesha ry'ikosa ryerekanwa mu ishusho hepfo. Muri iki kibazo, birakenewe gufunga gahunda no gusubiramo ibikorwa byasobanuwe haruguru.
- Umaze guhitamo guhitamo hanyuma ukande "OK" muri "dosiye",
Ku rubuga rwinyandiko, ikintu cyitwa cyangwa ameza bizagaragara, cyangwa ikirango cyacyo, ukurikije uburyo wahisemo.
- Menya ikibanza mu nyandiko kumeza kizaza hanyuma ujye kuri tab "shyiramo".
- Kanda ahanditse "ikintu" kugirango ufungure idirishya "Shyiramo dosiye" yamaze kumenyera.
- Muri tab ye yambere, hitamo "Microsoft Excel Urupapuro rwakazi", nyuma yo gukanda "OK" kugirango wemeze.
- Mugushira indanga ahantu hateganijwe aho uteganya gushyira kumeza, jya kuri tab "shyiramo".
- Kwagura buto ya "Imbonerahamwe" ya buto hanyuma uhitemo "Extl Ameza".
- Uzagira miniature yubusanzwe kandi kugeza ubu ikibabi cyubusa cya excel kirasa nubwi buryo hejuru. Ibindi bikorwa hamwe bikorwa kuri algorithm imwe.
Ubu buryo bwo kwimura imbonerahamwe kuva kuba indashyikirwa mumagambo mubipimo bimwe biruta ibyavuzwe haruguru. Iragufasha gukoresha ibintu byose biranga ibikoresho byagutunguye, birenze cyane abari mumyandikire.
Uburyo 3: Shyira muri dosiye
Hariho uburyo bwo kwimura ameza mumagambo kuva indako neza nta mpamvu yo gufungura ibya nyuma. Birahagije kumenya gusa aho dosiye yifuzwa iherereye. Ikindi kintu cyingenzi - ntigikwiye kubamo ibintu bitari ngombwa.
Ibindi bikorwa hamwe nimbonerahamwe bikorwa muburyo bumwe nkuko bimeze hejuru, keretse iyo byinjijwe nkikintu kidafitanye isano na dosiye yumwimerere.
Uburyo 4: Imbonerahamwe yubusa
Bisa nuburyo bwambere bwo kohereza kuri dosiye ya Excel ku Ijambo, urashobora kwinjizamo muri nyuma atari yuzuyemo amakuru gusa, ahubwo unone ameza yubusa. Byakozwe hafi kimwe, imbere mumyandiko.
Urupapuro rwa Excel ruzinjizwa mumagambo ushobora gukora ameza yawe kuva gushushanya ukoresheje ibikoresho byibanze byibikoresho bizagaragara kumurongo wibikoresho.
Gusohoka muburyo bwo guhindura, kanda gusa LKM hanze yikintu cyinjijwemo.
Uburyo 5: Kurema byigenga
Hariho ubundi buryo bwo kurema imbonerahamwe yubusa mu Ijambo, kandi mugushyira mubikorwa byayo biroroshye kuruta ibyavuzwe haruguru.
Nubwo iyi ngingo ivuga ko iyi ngingo yitangira cyane cyane kwimura imbonerahamwe kuva kuba indashyikirwa ku magambo, twakomeje gusuzuma ko ari ngombwa kuzirika no kubarebera. Muri icyo gihe, mu gitabo cya Microsoft wa Microsoft, urashobora gukora imbonerahamwe yoroshye, kandi yigenga ku mapaki agezweho yo mu biro byateye imbere muri iyi gahunda. Ni iki kindi hari ubundi buryo bwo gukemura umurimo wacu wuyu munsi, urashobora kwigira kumurongo uri hepfo hepfo.
Soma birambuye: Uburyo bwo gukora ameza mu Ijambo
Umwanzuro
Twarebye inzira zose zishoboka kugirango twohereze imbonerahamwe kuva kuba indashyikirwa mu magambo, kandi nanone yakoze ku bindi bice bitanga ubushobozi bwo gutanga ubushobozi bwo kwigenga gukora ibintu nkibi.
Reba nanone: Nigute ushobora kohereza ibiri muri dosiye ya dosiye kugirango wirinde