Ifayile ye-Excel ayivuli

Ukusilela kwinzame yokuvula incwadi ye-Excel ayikho rhoqo, kodwa, nangona kunjalo, ifunyanwa. Ezo ngxaki zinokubangelwa zona nobabini omonakalo kuxwebhu kunye neengxaki emsebenzini wenkqubo okanye inkqubo yeWindows xa iyonke. Masihlalutye ngezizathu ezithile zeengxaki zokuvulwa kweefayile, kunye nokufumanisa ukuba zeziphi iindlela onokuzilungisa imeko.

Unobangela kunye nezisombululo

Njengalo naliphi na elinye ixesha lengxaki, ukukhangela ukuphuma kwemeko kunye nokungasebenzi kakuhle xa kuvulwa incwadi i-Excel, ilele kwimeko yangoku. Ke ngoko, okokuqala, kuyafuneka ukumisela izinto ezibangele ukusilela kwisicelo sesicelo.

Ukuqonda ukuba yintoni unobangela: kwifayile ngokwayo okanye kwiingxaki zesoftware, zama ukuvula amanye amaxwebhu kwisicelo esinye. Ukuba bayavuleka, kungagqitywa ukuba unobangela weengxaki ngomonakalo kwincwadi. Ukuba umsebenzisi aze emva koko awele xa ekuvulwa, kuthetha ukuba ingxaki ilele kwiingxaki ze-Excel okanye inkqubo yokusebenza. Inokwenziwa ngokwahlukileyo: zama ukuvula incwadi yengxaki kwesinye isixhobo. Kule meko, ukufunyanwa kwempumelelo kwempumelelo kuya kubonisa ukuba yonke into ilungelelene noxwebhu, kwaye neengxaki kufuneka zifunwe kwenye.

Unobangela woku-1: Iingxaki zokuhambelana

Esona sizathu siqhelekileyo sokusilela xa kuvulwa incwadi ye-Excel, ukuba ayilele komonakalo kuxwebhu ngokwayo, le yingxaki yokuhambelana. Ayibangelwa kukuqhekeka kwesoftware, kodwa usebenzisa uhlobo lwakudala lwenkqubo ukuvula iifayile ezenziwe kwinguqulo entsha. Kwangelo xesha, kufuneka kuqatshelwe ukuba ayingabo bonke abantu abasekwe kwinguqulo entsha baya kuba neengxaki xa kuvulwa kwizicelo zangaphambili. Endaweni yoko, ngokuchaseneyo, uninzi lwazo luya kupheliswa ngesiqhelo. Ngaphandle koko kuya kuba kuphela apho itekhnoloji yenziwe khona iinguqulelo ezindala ze-Excel ayinakusebenza. Umzekelo, ikopi yokuqala yeli prosebor ye-tabium ayikwazanga ukusebenza ngeereferensi ze-cyclic. Ke ngoko, incwadi equlathe inqaku ayizukukwazi ukuvula isicelo esidala, kodwa iya kuqalisa uninzi lwamanye amaxwebhu awenziwe kwinguqulo entsha.

Kule meko, izisombululo zesisombululo zinokuba zimbini kuphela: nokuba zivulele amaxwebhu afanayo kwezinye iikhompyuter ezihlaziyiweyo isoftware, okanye ufake enye yeenguqulelo ezintsha ze-Microsoft endaweni ye-Ofisi ye-Microsoft.

Ingxaki echaseneyo xa ivulwa kwenkqubo entsha yamaxwebhu asekwe kwiinguqulelo ezindala zesicelo awabonwa. Ke, ukuba ufake uhlobo lwakutshanje lwe-Excel, emva koko iindawo ezinengxaki ezinxulumene nokuhambelana xa ukuvula iifayile zeenkqubo zangaphambili akunakuba njalo.

Ngokwahlukeneyo, kufuneka kuthiwe malunga nefomathi ye-XLSX. Inyani yile yokuba iphunyezwe kuphela kwi-Excel 2007. Zonke izicelo zangaphambili azinakusebenza nayo, kuba ifomathi "yoMdali" yi-XLS. Kodwa kule meko, ingxaki yokuphehlelelwa kolu hlobo loxwebhu lunokuconjululwa ngaphandle kokuhlaziya isicelo. Oku kungenziwa ngokufaka isiqwenga esikhethekileyo ukusuka kwiMicrosoft kwinguqulelo endala yenkqubo. Emva koko, incwadi enokwandiswa kweXalsx iya kuvula ngesiqhelo.

Faka i-patch

Unobangela 2: Useto olungachanekanga

Ngamanye amaxesha unobangela weengxaki xa uvula uxwebhu lunokuba luxanduva olungachanekanga lwenkqubo ngokwayo. Umzekelo, xa uzama ukuvula nayiphi na incwadi ye-Excel ngokunqakraza kabini kwiqhosha lasekhohlo, umyalezo unokuvela: "Impazamo xa uthumele isicelo somyalelo".

Kule meko, isicelo siza kuqala, kodwa incwadi ekhethiweyo ayizukuvula. Kwangelo xesha, ngefayile "yefayile" kwiNkqubo ngokwayo, uxwebhu luvula ngokwesiqhelo.

Kwiimeko ezininzi, le ngxaki inokusonjululwa ngale ndlela ilandelayo.

1. Yiya kwi "Ifayile" yethebhu. Emva koko, fudukela kwicandelo "leParameter".



2. Emva kokuba ifestile yeparamitha ivuliwe, kwinxalenye yasekhohlo idluliselwe kwicandelwana elithi "Africa". Kwicala lasekunene lefestile ekhangela iqela "ngokubanzi". Kufanele ukuba "yimali izicelo zeDDE kwezinye iinkqubo". Kuya kufuneka uyisuse ibhokisi yokukhangela kuyo, ukuba ifakiwe. Emva koko, ukugcina ubumbeko lwangoku, cofa iqhosha u- "Kulungile" ezantsi kwefestile esebenzayo.

Emva kokwenza lo msebenzi, ukuzama kwakhona ukuvula uxwebhu kabini ukucofa kufuneka kugqitywe ngempumelelo.

Unobangela wesi-3: Ukumisela ukuthelekisa

Isizathu sokuba ungakwazi ukwenza ngendlela esemgangathweni, oko kukuthi, ukunqakraza kabini kwiqhosha lasekhohlo, vula uxwebhu lwe-Excel, lungafumana ngoqwalaselo olungachanekanga lwezixhobo ezingachanekanga. Umqondiso woku, umzekelo, umzamo wokuqalisa uxwebhu kwesinye isicelo. Kodwa le ngxaki ikwalula ukusombulula.

1. Ngemenyu yokuqala, yiya kwiphaneli yokulawula.



2. Emva koko, sifudukela kwicandelo "lenkqubo".



3. Kwisicelo sefestile yesicelo esivula, yiya ku-"wabela inkqubo ukuvula ezi fayile zohlobo".



4. Emva koko, uluhlu lweentlobo ezahlukeneyo zefomati ezinokuzivula izicelo ezichaziweyo. Sijonge kolu luhlu lwe-GEX, i-XLSX, xlsb okanye ezinye ezifanele zivulwe kule nkqubo, kodwa azivuli. Xa uthatha ngamnye kwezi zinto zandisiweyo, iMicrosoft Excel kufuneka iphakame ngaphezulu kwetafile. Oku kuthetha ukuba ukubekwa kwemvumelwano kuchanekile.

   

   Kodwa, ukuba, xa ibalaselisa ifayile ye-Excel ye-Excel, esinye isicelo sichaziwe, oku kubonisa ukuba le nkqubo ilungiselelwe ngokungachanekanga. Ukucwangcisa useto, cofa kwi "Inkqubo yoTshintsho" kwindawo ephezulu yefestile.



5. Njengommiselo, kwiNkqubo "Khetha" Window, igama le-Excel kufuneka libe kwiqela leenkqubo ezicetyiswayo. Kule meko, qalisa igama lesicelo kwaye ucofe iqhosha "Kulungile".

   Kodwa, ukuba ngokunxulumene nezinye iimeko yayingakuluhlu, ke kule meko sicinezela "uphononongo ...".



6. Emva koko, iwindow yenkqubo ivula apho kufuneka uchaze indlela eya kwifayile ephambili yenkqubo ye-Excel. Kule folda kule dilesi ilandelayo:

   C: \ Iifayile zeNkqubo ye-Microsoft \ Office \ Office

   Endaweni ye "No." isimboli, kufuneka uchaze inani lephakheji yakho ye-Microsoft ye-Microsoft. Ukuthotyelwa kweenguqulelo ze-Excel kunye neenombolo zeofisi zezi zilandelayo:

   • I-Excel 2007 - 12;
   • I-Excel ka-2010 ukuya kwe-14;
   • I-Excel 2013 - 15;
   • I-Excel 2016 - 16.

   Emva kokuba uqale kwifolda efanelekileyo, khetha ifayile ye-Excel.exe (ukuba i-oxmees show ayivunyelwanga, iya kubizwa ngokuba yi-Excel ebalaseleyo). Cofa kwiqhosha elithi "Vula".



7. Emva koko, kubuyela kwifestile yokhetho yenkqubo, apho kufuneka ukhethe igama "le-Microsoft i-Excel" kwaye ucofe iqhosha "Kulungile".
8. Emva koko uya kuvuma isicelo ukuvula uhlobo lwefayile ekhethiweyo. Ukuba injongo engalunganga ine-istel yandisa i-Enttel yangaphakathi, ke le nkqubo ingentla kufuneka yenziwe nganye nganye nganye. Emva kokufumana amanqaku angachanekanga, kuhlala ukugqiba umsebenzi ngale festile, cofa iqhosha "elikufutshane".

Emva koko, incwadi ye-Excel kufuneka ivulwe ngokuchanekileyo.

Isizathu 4: Umsebenzi ongachanekanga we-onns

Esona sizathu sokuba incwadi ye-Excel ayiqali, inokuba ukusebenza okungachanekanga kwe-on-on yongquzulwano okanye omnye komnye, okanye ngenkqubo. Kule meko, ukukhutshwa kwesikhundla kukukhubaza ukwakhiwa okungachanekanga.

1. Njengakwindlela yesibini yokusombulula ingxaki kwi "Ifayile" yethebhu, yiya kwifestile yeparamitha. Sifudukela kwicandelo "Yongeza". Ezantsi kwefestile kukho ulawulo "lolawulo". Cofa kuyo kwaye ukhethe i-parameter ye- "COCTACT. Cofa kwi "Yiya ..." iqhosha.



2. Kwifestile evula, susa iibhokisi zokukhangela kuzo zonke izinto. Cofa kwiqhosha "Kulungile". Ke, lonke uhlobo lwe-combs liza kukhubazeka.



3. Sizama ukuvula ifayile ngemouse kabini. Ukuba ayivulekanga, oko akuselokukhohliswa, ungaphinda uvele, kodwa isizathu sokujonga kwelinye. Ukuba uxwebhu luvulwe ngokwesiqhelo, ke oko kuthetha ukuba enye ye-on-ons yomsebenzi ngokuchanekileyo. Ukujonga kanye, sibuya kwakhona kwifestile ye-onns, faka i-tick enye yazo kwaye ucinezele iqhosha u "Kulungile".



4. Jonga ukuba amaxwebhu avulwa njani. Ukuba yonke into ihamba kakuhle, emva koko siphendukela kwindawo yesibini ye-Superst, njl njl. Side siyenze ngaphambi koko xa uvula ukufunyanwa. Kule meko, kufuneka ikhubazekile kwaye ingasafaki, kwaye icime ngakumbi, iqaqambisa kwaye icinezele iqhosha elifanelekileyo. Bonke abanye abantu bentlupheko, ukuba iingxaki emsebenzini akwenzeki, unokuvula.

Unobangela we-5: I-Hardware Intya

Iingxaki zokuvulwa kweefayile e-Excel zinokwenzeka xa isantya se-hardware sivuliwe. Nangona le nto ayiyonto isithintelo ekuvulekeni kwamaxwebhu. Ke ngoko, okokuqala, kubalulekile ukuba ujonge ukuba ngaba sisizathu okanye hayi.

1. Yiya kwiiparamitha ze-Excel esele yaziwa kakuhle kwicandelo "elikhawulezayo". Kwicala lasekunene lefestile likhangela ibhloko "yesikrini". Ineparameter "khubaza ukukhawulezisa ukukhawulezisa ukulungiswa kwemifanekiso". Faka ibhokisi yokujonga kwaye ucofe iqhosha "Kulungile".



2. Jonga indlela iifayile ezivulekileyo. Ukuba bavula ngokwesiqhelo, sukutshintsha useto kwakhona. Ukuba ingxaki igcinwe, unokuvula isantya seHardware kwakhona kwaye uqhubeke ukukhangela unobangela weengxaki.

Unobangela 6: Umonakalo wencwadi

Njengoko bekutshiwo ngaphambili, uxwebhu alunakuvulwa okwangoku kuba lonakalisiwe. Oku kunokubonisa ukuba ezinye iincwadi ngendlela efanayo yenkqubo zisungulwe ngokwesiqhelo. Ukuba awukwazi ukuvula le fayile kwaye kwesinye isixhobo, emva koko siqiniseke kunokutshiwo ukuba isizathu iyo kanye. Kule meko, ungazama ukubuyisela idatha.

1. Gijimani iprosesa ye-Excel kwileyibhile ye-desktop okanye kwimenyu yokuqala. Yiya kwi "Ifayile" yethebhu kwaye ucofe iqhosha "Vula".



2. Ifestile evulekileyo yefayile ivuliwe. Kufuneka uye kulawulo apho uxwebhu lwengxaki lufumaneka khona. Siyichaza. Emva koko cinezela i icon ngohlobo lonxantathu ongena ngaphakathi kwiqhosha "Vula". Uluhlu luvela apho kufuneka ukhethe khona "Vula kwaye ubuyisele ...".



3. Ifestile iqalile, ebonelela ngezenzo ezininzi ukuba zikhethe kuzo. Okokuqala, zama ukwenza ukubuyiswa kwedatha ngokulula. Ke ngoko, nqakraza kwiqhosha elithi "Buyisela".



4. Inkqubo yokubuyisela kwimeko yesiqhelo yenziwa. Kwimeko yokupheliswa kwayo ephumeleleyo, i-Window yoLwazi ibonakala iyothetha le ngxelo. Kufuneka nje ukucofa kwiqhosha elisondeleyo. Emva koko, gcina idatha ebuyiselweyo ngendlela eqhelekileyo-ngokucinezela iqhosha kwifom yediski yefloppy kwikona ephezulu yefestile.



5. Ukuba le ncwadi ayinikezeli ekubuyiseleni ngale ndlela, emva koko sibuyela kwifestile yangaphambili kwaye ucofe iqhosha elithi "ERTATE".



6. Emva koko, enye iwindow ivula, apho kuya kucetywa khona okanye ukuguqula ifomula kwixabiso okanye ukubuyisela. Kwimeko yokuqala, zonke iifomula kuxwebhu ziyanyamalala, kodwa kuphela iziphumo zokubala ziya kuhlala. Kwimeko yesibini, kuya kwenziwa umzamo wokugcina amabinzana, kodwa akukho mpumelelo iqinisekisiweyo. Senza ukhetho, emva koko idatha kufuneka ibuyiselwe.



7. Emva koko, sibasindisa ngefayile eyahlukileyo ngokunqakraza kwiqhosha kwifom yediski yefloppy.

Kukho ezinye iindlela zokufumana kwakhona ezi ncwadi ziyonakele ingozi. Bathethile malunga nabo kwisihloko esahlukileyo.

Isifundo: Ungayibuyisela njani iFayile ye-Exprel eyonakeleyo

Unobangela 7: Umonakalo we-Excel

Esinye isizathu sokuba inkqubo ivule iifayile zinokuba ngumonakalo wayo. Kule meko, kufuneka uzame ukuyibuyisela. Indlela yokubuyisela kwimeko yesiqhelo ilungele kuphela ukuba unonxibelelwano oluzinzileyo lwe-Intanethi.

1. Yiya kwiphaneli yokulawula ngeqhosha lokuqala, njengoko sele ichaziwe ngaphambili. Kwifestile evula, cofa kwi "Cima inkqubo" ".



2. Ifestile ivula noluhlu lwazo zonke izicelo ezifakwe kwikhompyuter. Sijonge kuyo "IMicrosoft Excel", Yabela olungelo kwaye ucofe iqhosha le "Guqula" elikwiphaneli ephezulu.



3. Iwindows yangoku yokufaka ivulwa. Sibeka i-switch kwi "Buyisela" isikhundla kwaye ucofe iqhosha "Qhubeka".



4. Emva koko, ngokudibanisa kwi-Intanethi, isicelo siya kuhlaziywa, kwaye iimpazamo ziyapheliswa.

Ukuba awunalo uqhagamshelo lwe-Intanethi okanye ngezinye izizathu, awunakusebenzisa le ndlela, kule meko kuya kufuneka uphinde uphinde usebenzise idiski yokufaka.

Unobangela 8: Iingxaki zenkqubo

Isizathu sokungabinakho ukuvula ifayile ye-Excel kunokubakho iimpazamo ezibanzi kwinkqubo yokusebenza. Kule meko, kufuneka wenze inani lezenzo ukubuyisela ugcino lweWindows os.

1. Okokuqala, jonga ikhompyuter nge-antivirus. Kuyacetyiswa ukuba uyenze kwenye isixhobo, okuqinisekisiweyo ukuba abosulelwe yintsholongwane. Kwimeko yokufumana izinto ezikrokrelayo, Landela iingcebiso ze-antivirus.



2. Ukuba ukukhangela kunye nokususwa kweentsholongwane akuyisombulula ingxaki, emva koko zama ukubuyisa inkqubo kwindawo yokugqibela yokubuyela kwimeko yesiqhelo. Kuyinyani, ukuze uthathele ingqalelo eli thuba, kufuneka zenziwe ngaphambi kokuvela kweengxaki.



3. Ukuba ezi nezinye iindlela ezinokwenzeka zokusombulula ingxaki azizange zinike isiphumo esifanelekileyo, ungazama ukwenza inkqubo yokufaka inkqubo yokusebenza.

Isifundo: Ukwenza njani inqaku lokubuyisela le windows

Njengoko ubona, ingxaki yokuvula kweencwadi i-Excel inokubangelwa zizizathu ezahlukeneyo. Banokugutyungelwa komonakalo kwifayile nakwiseto engachanekanga okanye ukulungisa ingxaki yenkqubo ngokwayo. Ngamanye amaxesha, unobangela wenkqubo yokusebenza ikwangunobangela. Ke ngoko, ukubuyisela intsebenzo epheleleyo kubaluleke kakhulu ukumisela isizathu sengcambu.