Iifayile zetafile ze-Excel zinokonakala. Oku kunokwenzeka ngezizathu ezahlukeneyo ngokupheleleyo: Ukusilela okukhaliselekileyo kunikezelo lwamandla ngexesha lokusebenza, ukugcinwa okungafanelekanga koxwebhu, intsholongwane yekhompyuter, njl. Ewe kunjalo, ayithandeki kakhulu ukuphulukana nolwazi olubhalwe kwiincwadi ze-Excel. Ngethamsanqa, kukho iindlela ezisebenzayo zokuphila kwakhona. Makhe sifumanise ukuba ukubuyisela njani iifayile ezonakalisiweyo.
Inkqubo yokubuyisela kwimeko yesiqhelo
Kukho iindlela ezininzi zokubuyisela incwadi eyonakeleyo (ifayile) i-Excel. Ukukhetha kwendlela ethile kuxhomekeke kwinqanaba lokulahleka kwedatha.Indlela yoku-1: Ukukhuphela amaphepha
Ukuba incwadi ye-Excel yonakele, kodwa, nangona kunjalo, izakuvulwa, eyona ndlela ifihlakeleyo neyona ilula yokubuyisa iya kuba yile ichazwe ngezantsi.
- Cofa ekunene kwigama laliphi na iphepha elingaphezulu kwebar yendawo. Kwimenyu yenguqu, khetha into "Khetha onke amaphepha".
- Kwakhona, ngendlela efanayo, yenza imenyu yemeko. Ngeli xesha, khetha "Hambisa okanye Khuphela" Into.
- Intshukumo kunye nekopi yefestile ivuliwe. Vula i "Hambisa amaphepha akhethiweyo kwincwadi ethi" Intsimi kwaye ukhethe iParameter yencwadi entsha. Sibeka uphawu malunga ne "Yenza ikopi" ezantsi kwefestile. Emva koko, cofa kwiqhosha "Kulungile".
Ngenxa yoko, incwadi entsha yadalwa enesakhiwo esingasebenziyo, esiya kuba nedatha kwifayile yengxaki.
Indlela 2: Ukuhlaziywa
Le ndlela ikwafanelekile kuphela ukuba incwadi eyonakeleyo ivula.
- Vula incwadi e-Excel. Yiya kwi "Ifayile" yethebhu.
- Kwicala lasekhohlo lefestile evule ifestile ngokunqakraza kwi "Gcina njenge ...".
- I-Window ivuliwe. Khetha nasiphi na isikhombisi apho incwadi iyaqhubeka khona. Nangona kunjalo, ungayishiya le ndawo inkqubo eya kuqwalaselwa ngokuzenzekelayo. Into ephambili kweli nqanaba kukuba "uhlobo lwefayile" kufuneka ukhethe into "yephepha". Qiniseka ukuba ujonge ukuba i-SIDS Supy Swis "Yonke incwadi", kwaye ayizinikezeli: Uluhlu ". Emva kokhetho lwenziwe, cofa iqhosha u "Gcina".
- Inkqubo esondeleyo ye-Excel.
- Sifumana ifayile egciniweyo kwifomathi ye-HTML kwisalathiso apho sigcinile khona ngaphambili. Cofa kuyo ekunene-nqakraza kwaye ukhethe "Vula" kwimenyu yemeko. Ukuba into "yeMicrosoft Exverl" ifumaneka kuluhlu lwemenyu yokhetho, emva koko hamba ngayo.
Kwimeko ebuhlungu, cofa kwi "Khetha inkqubo ...".
- Ifestile yokhetho yenkqubo ivulwa. Kwakhona, ukuba ufumana "iMicrosoft Excel" kuluhlu lweenkqubo, khetha le nto kwaye ucofe kwiqhosha le-Ok.
Kwimeko echaseneyo, cofa kwi "Ushwankathelo ..." iqhosha.
- Ifestile yenkqubo ivula kulawulo olufakiweyo. Kuya kufuneka uye kule template yedilesi ilandelayo:
C: \ Iifayile zeNkqubo ye-Microsoft \ Office \ Office
Kule template, endaweni ye "No." Symbol, kuya kufuneka ufake endaweni yephakheji yakho ye-Microsoft ye-Microsoft.
Kwifestile evula, khetha ifayile ye-ECVEL. Cofa kwiqhosha elithi "Vula".
- Ukubuyela kwifestile yokhetho lwenkqubo ukuvula uxwebhu, khetha i "Microsoft Excel" kwaye ucofe iqhosha leqhosha.
- Emva kokuba uxwebhu luvulekile, kwakhona yiya kwi "Ifayile" yethebhu. Khetha into ethi "Gcina i ...".
- Kwifestile evula, setha isikhombisi apho iNcwadi ehlaziyiweyo iya kugcinwa khona. Kuluhlu "Uhlobo lweFayile", sibeka enye yeefomathi ze-Excel, kuxhomekeka kwindlela ukongezwa kungowona mthombo owonakeleyo:
- Incwadi ye-Excel (xlsx);
- I-Excel 97-2003 Incwadi (xls);
- Incwadi ye-Excel ngeNkxaso yeMacros, njl.
Emva koko, cofa kwiqhosha "longa".
Ke, siguqula ifayile eyonakeleyo ngefomathi ye-HTML kwaye igcine ulwazi kwincwadi entsha.
Ukusebenzisa i-algorithm efanayo, ungasebenzisa i-html kuphela njengefomathi yokuhamba, kodwa i-XML kunye neSylk.
QAPHELA! Le ndlela ayisoloko ikwazi ukugcina yonke idatha ngaphandle kwelahleko. Oku kuyinyani ngakumbi kwiifayile ezinemifanekiso enzima kunye neetafile.
Indlela 3: Ukubuyiselwa kwencwadi yokuvula
Ukuba awukwazi ukuvula incwadi enendlela esemgangathweni, ke kukho ukhetho olwahlukileyo ukubuyisela ifayile enjalo.
- Sebenzisa inkqubo ye-Excel. Kwi "Ifayile" yethebhu, cofa kwi "Vula" Into.
- Ifestile yokuvula iya kuqala. Yiya kwi-In kwisalathiso apho ifayile eyonakeleyo ifumaneka khona. Khaqoba. Cofa i icon ngohlobo lonxantathu ongena ngaphakathi kwi "Vula" iqhosha. Kuluhlu olusezantsi, khetha Vula kwaye ubuyisele.
- Iwindow ivulwa apho inkqubo iza kwenza khona uhlalutyo lomonakalo kwaye izakuzama ukubuyisela idatha. Cofa kwindawo ethi "Buyisela".
- Kwimeko apho ukubuyela kwimeko yesiqhelo kugqityiwe ngempumelelo, umyalezo ubonakala malunga nayo. Cofa kwiqhosha elithi "Vala".
- Ukuba awukwazi ukubuyisela ifayile, ubuyela kwifestile yangaphambili. Cofa kwiqhosha elithi "ERTATRE".
- Okulandelayo, ibhokisi yencoko yababini ivulwa ukuba umsebenzisi kufuneka enze ukhetho: Zama ukubuyisela zonke iifomula okanye ubuyisele kuphela amaxabiso abonisiweyo. Kwimeko yokuqala, le nkqubo iya kuzama ukuhambisa yonke ifomula ekhoyo kwifayile, kodwa ezinye zazo ngenxa ye-pecaralisivery yento yokudluliselwa kuya kulahleka. Kwicala lesibini, umsebenzi awuzukususwa, kodwa ixabiso kwiseli elibonisiweyo. Senza ukhetho.
Emva koko, idatha iya kuvulelwa kwifayile entsha, enesihloko kwigama lokuqala liya kongezwa igama elithi "[ibuyisiwe]".
Indlela yesi-4: Ukubuyiselwa kwamatyala anzima
Ukongeza, kukho iimeko apho akukho nanye kwezi ndlela encedisa ukufumana ifayile. Oku kuthetha ukuba isakhiwo sencwadi siphulwe kakhulu okanye siphazamise. Ungazama ukufumana kwakhona, ukwenza amanyathelo ongezelelweyo. Ukuba inyathelo elidlulileyo alincedi, emva koko uye kwezi zinto zilandelayo:
- Phuma ngokupheleleyo kwi-Excel kwaye uqalise inkqubo;
- Qalisa ikhompyuter;
- Cima umxholo wefolda ye-temp, efumaneka kulawulo lweWindows kwiDiski yeNkqubo, qala kwakhona emva kwale PC;
- Jonga ikhompyuter kwiintsholongwane kwaye, kwimeko yokufunyanwa, yisuse;
- Khuphela ifayile eyonakeleyo kwenye indawo, kwaye sele ivela apho, zama ukubuyisela enye yezi ndlela zingasentla;
- Zama ukuvula incwadi eyonakeleyo kwinguqulelo entsha ye-Excel ukuba awunayo inketho yokugqibela. Iinguqulelo ezintsha zenkqubo zinamathuba amaninzi okubuyisela umonakalo.
Njengoko ubona, ukonakaliswa kwencwadi ye-Excel asisosizathu sokuphelelwa lithemba. Kukho iindlela ezininzi zokhetho onokuyibuyisa ngayo idatha. Abanye babo basebenza nokuba ifayile ayivulwanga konke konke. Eyona nto iphambili kukungaphantsi kwezandla zakho kwaye uzame ukulungisa imeko ngoncedo lwenye ukhetho.