Amafayela we-Excel wespredishithi angonakaliswa. Lokhu kungenzeka ngezizathu ezihluke ngokuphelele: ukuhluleka kwamandla ngokushesha ngesikhathi sokusebenza, ukulondolozwa kwamadokhumenti okungalungile, amagciwane wekhompyutha, njll. Yiqiniso, akukubi kakhulu ukulahlekelwa ulwazi olulotshwe ezincwadini ze-Excel. Ngenhlanhla, kunezinketho eziphumelelayo zokuthola kabusha. Ake sithole ukuthi ungabuyiselwa kanjani amafayela awonakele.
Inqubo yokubuyisela
Kunezindlela eziningana zokulungisa incwadi ye-Excel eyonakele (ifayela). Ukukhethwa kwendlela ethile kuxhomeke ezingeni lokulahlekelwa kwedatha.
Indlela 1: Ukushicilela AmaSpredishithi
Uma incwadi ye-Excel ibonakalisiwe, kodwa, noma kunjalo, ivulekile, ke indlela yokuthola kabusha esheshayo futhi elula kakhulu iyoba echazwe ngezansi.
- Chofoza inkinobho yesokudla yegundane egameni laso noma yiliphi ishidi ngenhla ibha yesimo. Kumenyu yesimo, khetha into "Khetha wonke amashidi".
- Futhi futhi ngendlela efanayo siyavula imenyu yesimo. Okwamanje, khetha into "Hambisa noma ukopishe".
- Ukuhambisa nokukopisha iwindi kuvulwa. Vula insimu "Hambisa amashidi akhethiwe ukubhuka" bese ukhetha ipharamitha "Incwadi Entsha". Beka uphawu phambi kwepharamitha "Yakha ikhophi" phansi kwefasitela. Emva kwalokho, chofoza inkinobho "Kulungile".
Ngakho-ke, incwadi entsha enesakhiwo esilungile idalwe, okuzoqukatha idatha kusuka efayeleni yenkinga.
Indlela 2: I-Reformat
Le ndlela ibuye ifanele kuphela uma incwadi ewonakele ivuliwe.
- Vula ibhuku lokusebenzela ku-Excel. Chofoza ithebhu "Ifayela".
- Engxenyeni engakwesokunxele kwewindi evula, chofoza entweni "Londoloza njengo ...".
- Iwindi lokugcina livula. Khetha noma iyiphi isiqondisi lapho incwadi izogcinwa khona. Noma kunjalo, ungashiya indawo uhlelo olucacisa ngokuzenzakalelayo. Into esemqoka kulesi sinyathelo yilokho kupharamitha "Uhlobo lwefayela" kudingeka ukhethe into "Ikhasi leWebhu". Qiniseka ukuthi uhlola ukuthi inkinobho yokugcina isesikhundleni. "Incwadi yonke"futhi cha "Okukhethiwe: Ishidi". Emva kokukhetha, cindezela inkinobho. "Gcina".
- Vala uhlelo lwe-Excel.
- Thola ifayela elilondoloziwe kufomethi i-html esiqondisweni lapho sasilondolozile ngaphambilini. Sichofoza kuso ngenkinobho yegundane efanele futhi kumenyu yokuqukethwe ukhethe into "Vula nge". Uma ohlwini lwemenyu eyengeziwe kukhona into "I-Microsoft Excel"bese uhamba ngayo.
Esimweni esihlukile, chofoza ku-intwana "Khetha uhlelo ...".
- Iwindi yokukhetha uhlelo ivula. Futhi, uma uthola ohlwini lwezinhlelo "I-Microsoft Excel" khetha le nto bese ucindezela inkinobho "Kulungile".
Uma kungenjalo, chofoza inkinobho. "Buyekeza ...".
- Iwindi ye-Explorer ivuleka ku-lwemibhalo yezinhlelo ezifakiwe. Kufanele ulandele iphethini elilandelayo lekheli:
C: Uhlelo Lamafayela Microsoft Office Office№Kulesi template esikhundleni sophawu "№" Udinga ukufaka inombolo yephakheji yakho ye-Microsoft Office.
Ewindini evulekile khetha ifayela le-Excel. Sicindezela inkinobho "Vula".
- Ukubuyela ewindini lokukhetha uhlelo lokuvula idokhumenti, khetha isikhundla "I-Microsoft Excel" bese uchofoza inkinobho "Kulungile".
- Ngemuva kokuba idokhumenti ivuliwe, godu iya kuthebhu "Ifayela". Khetha into "Londoloza njengo ...".
- Ewindini evula, setha isiqondisi lapho ibhuku olusha lizogcinwa khona. Ensimini "Uhlobo lwefayela" Faka enye yefomethi ye-Excel, kuye ngokuthi isandiso sinomthombo owonakele:
- Ibhuku le-Excel (xlsx);
- I-Excel 97-2003 (xls);
- Incwadi ye-Excel enokusekelwa okuphezulu, njll.
Emva kwalokho, chofoza inkinobho "Gcina".
Ngakho sivuselela ifayela elonakalisiwe ngokusebenzisa ifomethi. i-html bese ulondoloza ulwazi encwadini entsha.
Ukusebenzisa i-algorithm efanayo, kungenzeka ukusebenzisa kuphela i-htmlkodwa futhi xml futhi I-Sylk.
Qaphela! Le ndlela ayikwazi njalo ukulondoloza yonke idatha ngaphandle kokulahlekelwa. Lokhu kuyiqiniso ikakhulukazi kumafayili anomfomula amafomu kanye namatafula.
Indlela 3: Buyisela incwadi engeyona yokuvula
Uma ungeke ukwazi ukuvula incwadi ngendlela ejwayelekile, khona-ke kunenketho ehlukile yokubuyisela ifayela elinjalo.
- Run Excel. Kuthebhu ethi "Ifayela", chofoza entweni. "Vula".
- Ifasitelana evulekile yedokhumenti lizovula. Hlulela kulo ku-directory lapho ifayela elikhohlisiwe litholakala khona. Qinisekisa. Chofoza kusithonjana soxantathu oluphikisiwe eduze kwenkinobho. "Vula". Kuhlu lokudonsa phansi, khetha "Vula futhi Ulungise".
- Iwindi livula lapho lithi khona uhlelo luzohlaziya umonakalo bese uzama ukuthola idatha. Sicindezela inkinobho "Buyisela".
- Uma ukubuyiswa kuphumelele, umlayezo uvela ngakho. Sicindezela inkinobho "Vala".
- Uma ukubuyiselwa kwefayela kuhlulekile, bese ubuyela ewindini langaphambilini. Sicindezela inkinobho "Susa idatha".
- Okulandelayo, ibhokisi lengxoxo livula lapho umsebenzisi kufanele akhethe khona: zama ukubuyisela wonke amafomula noma ubuyisele kuphela amanani abonisiwe. Esikhathini sokuqala, lolu hlelo luzozama ukudlulisa zonke amafomula atholakalayo efayeleni, kodwa ezinye zazo zizolahleka ngenxa yemvelo yesizathu sokudluliselwa. Esikhathini sesibili, umsebenzi ngokwawo ngeke utholakale, kodwa inani eliselikalini eliboniswayo. Ukwenza ukukhetha.
Ngemuva kwalokho, idatha izovulwa kufayela elisha, lapho igama "[elibuyiselwe]" lizofakwa egameni langempela egameni.
Indlela 4: ukutakula emacaleni enzima kakhulu
Ngaphezu kwalokho, kunezikhathi lapho kungekho nenye yalezi zindlela ezisizwa ukubuyisela ifayela. Lokhu kusho ukuthi isakhiwo sencwadi silimale kakhulu noma into iphazamisa ukubuyiswa. Ungazama ukubuyisela ngokwenza izinyathelo ezengeziwe. Uma isinyathelo sangaphambilini singasisi, yiya kokulandelayo:
- Phuma ngokuphelele i-Excel bese uqala kabusha uhlelo;
- Qala kabusha ikhompyutha;
- Susa okuqukethwe kufolda Yesikhashana, elisekhompheni "ye-Windows" kwisistimu yediski, bese uqale kabusha i-PC;
- Hlola ikhompyutha yakho ngamagciwane futhi, uma itholakala, yiqede;
- Kopisha ifayela elimele kwenye isiqondisi, futhi ukusuka lapho zama ukuyibuyisela usebenzisa enye yezindlela ezichazwe ngenhla;
- Zama ukuvula ibhulogi ewonakele ngenguqulo entsha ye-Excel, uma ufake ifomu lokugcina. Izinguqulo ezintsha zohlelo zinamathuba amaningi okulungisa umonakalo.
Njengoba ungabona, ukulimala kubhuku le-Excel akuyona isizathu sokuphelelwa ithemba. Kukhona izinketho eziningi ongayithola ngazo idatha. Abanye babo basebenza ngisho noma ifayela lingavumeli nhlobo. Into esemqoka akukhona ukuyeka futhi uma uhluleka, zama ukulungisa isimo ngosizo lwenye indlela.
