Kunanirwa kugerageza gufungura igitabo cya Excel ntabwo ari kenshi, ariko, nyamara, nabyo biraboneka. Ibibazo nkibi birashobora guterwa no kwangiriza inyandiko nibibazo mugikorwa cya gahunda cyangwa na sisitemu ya Windows muri rusange. Reka dusesengure impamvu zihariye zibibazo hamwe no gufungura dosiye, kimwe no kumenya uburyo ushobora gukosora ibintu.
Impamvu n'ibisubizo
Nko mukindi kibazo icyo ari cyo cyose, gushakisha gusohoka mubihe bifitanye isano na mibunire mugihe cyo gufungura igitabo cyiza, bibeshya mugihe cyayo gihita kibaho. Kubwibyo, mbere ya byose, birakenewe gushiraho ibintu byateje gutsindwa mugusabwe.Kugirango wumve niyihe mizi: muri dosiye ubwayo cyangwa mubibazo bya software, gerageza gufungura izindi nyandiko muburyo bumwe. Niba barakinguye, birashobora kwemeza ko intandaro yibibazo yangiza igitabo. Niba umukoresha hanyuma agwa kunanirwa iyo afunguye, bivuze ko ikibazo kiri mubibazo byukuri cyangwa sisitemu y'imikorere. Irashobora gukorwa muburyo butandukanye: gerageza gufungura igitabo cyikindi gikoresho. Muri iki kibazo, kuvumbura neza bizagaragaza ko ibintu byose biri murutonde rwinyandiko, nibibazo bigomba gushakishwa undi.
Impamvu 1: Ibibazo bihuje
Impamvu isanzwe yo kunanirwa iyo ifungura igitabo cyitwa Excel, niba kimeze kwangirika kubyanditswe ubwabyo, iki nikibazo cyo guhuza. Ntabwo biterwa no gusenyuka kwa software, ariko ukoresheje verisiyo ishaje ya gahunda yo gufungura dosiye zakozwe muri verisiyo nshya. Muri icyo gihe, twakagombye kumenya ko abantu bose batakoze muri verisiyo nshya bazagira ibibazo mugihe bafunguye mubisabwa mbere. Ahubwo, kubinyuranye, benshi muribo bazatangizwa bisanzwe. Ibidasanzwe bizaba gusa aho tekinoroji yashyizwe mubikorwa hamwe nuburyo bwa kera bya Excel bidashobora gukora. Kurugero, kopi zambere zuyu mukoresha wabigenewe ntigishobora gukorana na cyclic. Kubwibyo, igitabo kirimo iki kintu ntigishobora gufungura porogaramu ishaje, ariko izatangira izindi nyandiko zikozwe muri verisiyo nshya.
Muri iki gihe, ibisubizo byibisubizo birashobora kuba bibiri gusa: hafungurwa inyandiko zisa gusa kurindi makuru yavuguruye software, cyangwa shyiramo imwe mumishuro mishya ya Microsoft aho kunywa.
Ikibazo gitandukanye mugihe gifunguye muri gahunda nshya yinyandiko zakozwe muri verisiyo zishaje za porogaramu ntizigaragara. Rero, niba washyizeho verisiyo yanyuma ya Excel, hanyuma ubone ibibazo bifitanye isano no guhuza mugihe gahunda za porogaramu zambere zidashobora kuba.
Ukwayo, bigomba kuvugwa ku XLSX format. Kuba ari ko bikorwa gusa mu Excel 2007. Porogaramu zose z'amategeko badashobora gukorana, kuko kuri bo ari "kavukire" format ni XLS. Ariko mu rubanza, ikibazo na mugaragaro iyi Ubwoko: Bya Inyandiko zirashobora gutorerwa umuti ndetse nta gikenewe Porogaramu. Ibi bishobora gukorwa na iyinjizaporogaramu ikiremo yihariye Microsoft ku bishaje Verisiyo gahunda. Nyuma, igitabo kumwe kwagura XLSX Gufungura ubusanzwe.
install kiremo
Impamvu 2: Igenamiterere BIBESHYA
Rimwe nyirabayazana w'ibibazo igihe gufungura inyandiko bishobora kuba bitari Iboneza gahunda ubwayo. Urugero, Ryari: Kugerageza Kuri Gufungura Book cyose Excel na MAHARAKUBIRI i Ibumoso: Imbeba Akabuto, ubutumwa kugaragarire: "Ikosa igihe kohereza itegeko Porogaramu".
Muri urwo rubanza, Porogaramu Tangira, ariko igitabo natoye bazokwinovora kubumbura. Mu kiseera kye kimu, mu "File" tab gahunda ubwayo, Inyandiko yugurura ubusanzwe.
Akenshi, iki kibazo gishobora gukemuka mu buryo bukurikira.
- Genda ku "File" tab. Next, kwimuka ku "Ibigenga" igice.
- Nyuma Ibigenga Idirishya ni mubikorwa, mu gice ibumoso ni yanyuze ku igika "Advanced". Ku ruhande rw'iburyo idirishya gushaka itsinda rya "Jenerali" Igenamiterere. Ikwiye kuba "kwirengagiza DDE gusaba kuva Ikindi Porogaramu". Ugomba gukuraho in kuva iyo, iyo ni yakorewe iyinjizaporogaramu. Nyuma, gukiza Iboneza ubu, Kanda "OK" Akabuto Ku i Hasi: Bya i Gikora Idirishya.
Nyuma akora ibikorwa iyi, mu re-kugerageza gufungura inyandiko MAHARAKUBIRI-bigomba kurangira neza.
Impamvu 3: Iboneza kugereranya
Impamvu ko udashobora na inzira ihame ni, ni ukuvuga MAHARAKUBIRI-i Ibumoso: Imbeba Akabuto, Gufungura Inyandiko Excel, bishobora kurwana mu Iboneza bitari wa mappings Idosiye. ikimenyetso iyi Urugero, kugerageza gutangiza A Inyandiko in Porogaramu. Ariko ikibazo ni na byoroshye gukemura.
- Binyuze Ibikubiyemo Start, kujya i Umwanya Igenzura.
- Ubukurikira, kwimukira mu "Programs" igice.
- Mu bikorwa Igenamiterere Idirishya ko gitangura kujya "Kugena gahunda yo gufungura Idosiye Ubwoko iyi".
- Nyuma yibyo, urutonde rwubwoko butandukanye bwimiterere ikoreshwa ifunguye. Turimo gushakisha muri uru rutonde rwa Excer XLs, Xlsx, Xlsb cyangwa Ibindi bigomba gufungurwa muriyi gahunda, ariko ibindi bigomba gufungurwa muriyi gahunda, ariko ibindi bigomba gufungurwa muriyi gahunda, ariko ibindi bigomba gufungurwa muriyi gahunda, ariko abandi bagomba gufungura. Iyo utanze buri semburo, Microsoft Excel igomba kuba hejuru yameza. Ibi bivuze ko igenamigambi rihuye nibyo.
Ariko, niba, mugihe ushimanze dosiye isanzwe ya Excel, ubundi buryo bwerekanwe, ibi byerekana ko sisitemu yashyizweho nabi. Kugena igenamiterere, kanda kuri buto "Hindura Porogaramu" kuruhande rwo hejuru yidirishya.
- Nk'uburyo, muri "gahunda hitamo" idirishya, izina Excel rigomba kuba mu itsinda rya gahunda zasabwe. Muri iki kibazo, gusa bitanga izina rya porogaramu hanyuma ukande buto ya "OK".
Ariko, niba bifitanye isano nibihe bimwe na bimwe byari biri kurutonde, noneho muriki kibazo tukanda "gusubiramo ...".
- Nyuma yibyo, idirishya ryumuyobora rifungura ugomba kwerekana inzira igana dosiye nkuru yubuyobozi bwa Excel. Ni mububiko kuri aderesi ikurikira:
C: \ Porogaramu Idosiye \ Microsoft Office \ biro№
Aho kugirango "Oya", ugomba kwerekana umubare wibiro bya Microsoft. Kubahiriza verisiyo nziza hamwe n'imibare y'ibiro ni izi zikurikira:
- Excel 2007 - 12;
- Excel 2010 - 14;
- Excel 2013 - 15;
- Excel 2016 - 16.
Umaze guhindura ububiko bukwiye, hitamo dosiye ya Excel.exe (niba kwagura bidashoboka, bizahamagarwa gusa excel). Kanda kuri buto "Gufungura".
- Nyuma yibyo, ugaruka kuri porogaramu yo gutoranya gahunda, aho ugomba guhitamo izina "Microsoft Excel" hanyuma ukande kuri buto ya "OK".
- Noneho bizamura porogaramu kugirango ufungure ubwoko bwa dosiye yatoranijwe. Niba intego itari yo ifite byinshi byagutse byagutse, noneho inzira yavuzwe haruguru igomba gukora kuri buri wese kugiti cye. Nyuma ya mappings itariyo, ikomeje kuzuza akazi hamwe niyi idirishya, kanda kuri buto "gufunga".
Nyuma yibyo, igitabo cyitwa Excel kigomba gufungura neza.
Impamvu 4: Igikorwa kitari cyo cyongeyeho
Imwe mumpamvu zituma igitabo cya Excel kitatangira, gishobora kuba imikorere itari yo yongeyeho ayo makimbirane cyangwa hagati yabo, cyangwa na sisitemu. Muri iki gihe, ibisohoka kuva kumwanya nuguhagarika imigezi itari yo.
- Nko munzira ya kabiri kugirango ukemure ikibazo ukoresheje tab "dosiye", jya kuri idirishya rya parameter. Twimukiye mu gice "twongeyeho". Munsi yidirishya hari umukozi "gucunga". Kanda kuri yo hanyuma uhitemo "kongeramo inyongera" muri "Parameter. Kanda kuri buto "Genda ...
- Mu idirishya rifungura, kura agasanduku k'ibikoresho byose. Kanda kuri buto ya "OK". Rero, ubwoko bwose bwibimaro biza bizahagarikwa.
- Turagerageza gufungura dosiye ifite imbeba ebyiri. Niba bidafunguye, ntabwo biri mubibazo byisura, urashobora kongera kubahindura, ahubwo ni impamvu yo kureba kurundi. Niba inyandiko yafunguye bisanzwe, noneho bivuze ko imwe muri on-ons ikora nabi. Kugenzura uko byagenda neza, tuzongera gusubira mu idirishya rya on-ons, shyiramo amatiku kuri kimwe muri byo no gukanda buto "OK".
- Reba uburyo inyandiko zafunguwe. Niba ibintu byose ari byiza, noneho duhindukire kubiciro bya kabiri, nibindi kugeza igihe tuzabikora mbere yibyo iyo ufunguye kuvumbura. Muri uru rubanza, igomba guhagarikwa kandi ntagishyiramo, ndetse no gusiba neza, kumurika no gukanda buto ikwiye. Ibindi bikoresho byose, niba ibibazo mubikorwa byabo bitabaho, urashobora gufungura.
Impamvu 5: Kwihuta kwibyuma
Ibibazo hamwe no gufungura dosiye muri Excel birashobora kubaho mugihe kwihuta kwibyuma biri. Nubwo iki kintu ntabwo cyanze bikunze inzitizi yo gufungura inyandiko. Kubwibyo, mbere ya byose, birakenewe kugenzura niba arimpamvu cyangwa idatera.
- Jya kuri Excel ibipimo bimaze kumenyeshwa neza mugice cya "Ambere". Kuruhande rwiburyo bwidirishya rishakisha "ecran". Ifite ibipimo "Hagarika kwihutisha ibikoresho byo gutunganya amashusho". Shyiramo agasanduku hanyuma ukande kuri buto "OK".
- Reba uko dosiye zifungura. Niba bafunguye bisanzwe, ntukigihindura igenamiterere. Niba ikibazo cyabitswe, urashobora kongera gufungura ibyuma byongeye kwihuta hanyuma ukomeze gushakisha icyateye ibibazo.
Impamvu 6: Ibyangiritse byanditse
Nkuko byavuzwe haruguru, inyandiko ntishobora gufungurwa kuko byangiritse. Ibi birashobora kwerekana ko ibindi bitabo murwego rumwe bya gahunda bitangizwa bisanzwe. Niba udashobora gufungura iyi dosiye no ku kindi gikoresho, noneho wizere birashobora kuvugwa ko impamvu iri muriyo. Muri iki kibazo, urashobora kugerageza kugarura amakuru.
- Koresha Excel Utunganya Utunganya muri label ya desktop cyangwa muri menu yo gutangira. Jya kuri tab "dosiye" hanyuma ukande buto "Gufungura".
- Idosiye ifunguye idirishya rikorwa. Ikeneye kujya mububiko aho inyandiko yikibazo iherereye. Turabigaragaza. Noneho kanda igishushanyo muburyo bwa mpandeshatu yahinduwe kuruhande rwa "fungura". Urutonde rugaragara aho ugomba guhitamo "gufungura no kugarura ...".
- Idirishya ritangira, ritanga ibikorwa byinshi byo guhitamo. Ubwa mbere, gerageza gukora amakuru yoroshye. Noneho, kanda kuri buto "Kugarura".
- Inzira yo kugarura irakorwa. Kubireba iherezo ryayo ryatsinze, idirishya rigaragara rivuga rivuga ibi. Ikeneye gusa gukanda kuri buto yo gufunga. Nyuma yibyo, uzigame amakuru yagaruwe muburyo busanzwe - ukanda buto muburyo bwa disiki yo hejuru yibumoso bwishyamba.
- Niba igitabo kitigeze cyo gusana muri ubu buryo, noneho turasubira mu idirishya ryabanjirije hanyuma tukande buto ya "Gukuramo amakuru".
- Nyuma yibyo, irindi idirishya rifungura, aho izasabwa cyangwa ihindura formulaire zikangagaciro cyangwa kuyisubiza. Mu rubanza rwa mbere, formulaire zose ziri mu nyandiko izashira, ariko ibisubizo by'imibare bizagumaho. Mu rubanza rwa kabiri, hazagerageza kugerageza kuzigama, ariko nta ntsinzi yemejwe. Duhisemo, nyuma yamakuru agomba gusubizwa.
- Nyuma yibyo, turabikiza hamwe na dosiye itandukanye ukanze kuri buto muburyo bwa disiki ya floppy.
Hariho ubundi buryo bwo kugarura ibyo bitabo byangiritse. Bavuzwe kuri bo mu ngingo itandukanye.
Isomo: Nigute ushobora kugarura dosiye yangiritse
Impamvu 7: Ibyangiritse bya Excel
Indi mpamvu ituma gahunda idashobora gufungura dosiye zishobora kuba ibyangiritse. Muri iki kibazo, ugomba kugerageza kubigarura. Uburyo bukurikira bwo kugarura burakwiriye gusa niba ufite umurongo uhamye wa interineti.
- Jya kuri gahunda yo kugenzura ukoresheje buto yo gutangira, nkuko bimaze gusobanurwa mbere. Mu idirishya rifungura, kanda kuri "Gusiba Porogaramu".
- Idirishya rifungura urutonde rwibisabwa byose byashizwe kuri mudasobwa. Turabishaka muri yo "Microsoft Excel", bugabanya iyi nyandiko hanyuma ukande kuri buto ya "Hindura" kuri Panel yo hejuru.
- Idirishya ryububiko. Twashyize ahagaragara umwanya "Kugarura" hanyuma ukande kuri buto "Komeza".
- Nyuma yibyo, uhuza na enterineti, gusaba bizavugururwa, kandi amakosa arakuweho.
Niba udafite umurongo wa interineti cyangwa kubwizindi mpamvu, ntushobora gukoresha ubu buryo, hanyuma muriki kibazo ugomba gukira ukoresheje disiki yo kwishyiriraho.
Impamvu 8: Ibibazo bya sisitemu
Impamvu idashoboka gufungura dosiye ya Excel irashobora rimwe na rimwe kuba n'amakosa yuzuye muri sisitemu y'imikorere. Muri iki gihe, ugomba gukora ibikorwa byinshi kugirango ugarure ibikorwa bya Windows OS muri rusange.
- Mbere ya byose, suzuma mudasobwa hamwe na antivirus. Nibyiza kubikora bivuye mubindi bikoresho, biremewe ko bitanduye virusi. Mugihe hagaragaye ibintu biteye amakenga, kurikiza ibyifuzo bya antivirus.
- Niba gushakisha no gukuraho virusi bitakemuye ikibazo, hanyuma ugerageze kugarura sisitemu murwego rwanyuma rwo gukira. Nibyo, kugirango tubone amahirwe, bigomba gukorwa mbere yibibazo.
- Niba iyi nubundi buryo bushoboka bwo gukemura ikibazo idatanze ibisubizo byiza, urashobora kugerageza gukora inzira yo kongera gukoresha sisitemu y'imikorere.
Isomo: Nigute wakora inyandiko yo kugarura Windows
Nkuko mubibona, ikibazo cyo gufungura ibitabo birenze birashobora guterwa nimpamvu zitandukanye. Birashobora gutwikirwa haba kwangiza dosiye no muburyo butari bwo cyangwa mugukemura ibibazo ubwabyo. Rimwe na rimwe, impamvu ya sisitemu y'imikorere nayo niyo mpamvu. Kubwibyo, kugirango ugarure imikorere yuzuye ni ngombwa cyane kumenya intandaro.