Ungabuyiselwa Kanjani Amafayela E-Excel Alimele

Amafayili wethebula le-Excel angonakalisiwe. Lokhu kungenzeka ngezizathu ezihluke ngokuphelele: Ukwehluleka okubukhali kokuhlinzekwa kwamandla ngesikhathi sokusebenza, ukulondolozwa okungafanele kwedokhumenti, amagciwane ekhompyutha, njll. Vele, akumnandi kakhulu ukulahlekelwa imininingwane erekhodwe ezincwadini ze-Excel. Ngenhlanhla, kunezinketho ezisebenzayo zokululama kwayo. Ake sibheke ngqo ukuthi ungabuyisela kanjani amafayela alimele.

Inqubo yokubuyisa

Kunezindlela eziningi zokubuyisela incwadi eyonakele (ifayela) Excel. Ukukhethwa kwendlela ethile kuya ngezinga lokulahleka kwedatha.

Indlela 1: Amashidi ekopisha

Uma incwadi ye-Excel ilimele, kodwa, noma kunjalo, isazovulwa, indlela esheshayo futhi elula kunazo zonke yokubuyisela kuzoba yiyona echazwe ngezansi.

1. Qhafaza kwesokudla egameni lanoma yiliphi ishidi ngaphezulu kwebha yesimo. Kumenyu yokuqukethwe, khetha into ethi "Khetha wonke amashidi".



2. Futhi, ngendlela efanayo, yenza kusebenze imenyu yokuqukethwe. Kulokhu, khetha u- "Hambisa noma Kopisha" into.



3. Ukunyakaza newindi lekhophi kuvula. Vula "ukuhambisa amashidi akhethiwe enkundleni ethi" field bese ukhetha i-New Parameter. Sibeka umkhaza obhekene ne-parameter ye- "Dala" ezansi kwewindi. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".

Ngakho-ke, incwadi entsha yadalwa ngesakhiwo esingaqondile, esizoqukatha idatha evela kufayela lenkinga.

Indlela 2: Ukuguqulwa kabusha

Le ndlela nayo ifanele kuphela uma incwadi eyonakele ivulwa.

1. Vula incwadi ku-Excel. Iya kuthebhu ethi "File".



2. Ngakwesobunxele kwewindows evule iwindi ngokuchofoza ku- "Gcina njenge ...".



3. Iwindi longa livula. Khetha noma yimuphi umkhomba lapho incwadi izophikelela khona. Kodwa-ke, ungashiya indawo uhlelo oluzocacisa khona ngokuzenzakalelayo. Into esemqoka kulesi sinyathelo ukuthi ku-parameter "yohlobo lwefayela" udinga ukukhetha into ethi "Ikhasi le-Web". Qiniseka ukuthi ubheka ukuthi inkinobho yokulonda ime ku "ncwadi yonke" isikhundla, hhayi "ukunikezelwa: uhlu". Ngemuva kokukhethwa kwenziwa, chofoza inkinobho ethi "Gcina".



4. Vala uhlelo lwe-Excel.
5. Sithola ifayela eligciniwe ngefomethi ye-HTML kwisikhombi lapho silondoloze khona ngaphambili. Chofoza kuyo chofoza kwesokudla bese ukhetha "Vula nge" kumenyu yokuqukethwe. Uma into ye- "Microsoft Excel" itholakala ohlwini lwemenyu ongakukhetha, bese uyidlula kuyo.

   

   Esimweni esiseduze, chofoza ku- "Khetha uhlelo ...".



6. Kuvulwa iwindi lokukhetha uhlelo. Futhi, uma uthola "iMicrosoft Excel" ohlwini lwezinhlelo, khetha le nto bese uqhafaza inkinobho ethi OK.

   Esimweni esiphambene, chofoza inkinobho ethi "Overview ...".



7. Iwindi lomqhubiyali livulwa kwisikhombi esifakiwe. Kufanele udlule kwithempulethi yekheli elandelayo:

   C: \ Amafayela Ohlelo \ Microsoft Office \ Office№

   Kulesi sifanekiso, esikhundleni sophawu lwe- "Cha.", Udinga ukufaka esikhundleni iphakethe lakho le-Microsoft Office.

   Ewindini elivula, khetha ifayela le-Excel. Chofoza inkinobho ethi "Vula".



8. Ukubuyela ewindini lokukhetha kohlelo ukuvula idokhumenti, khetha isikhundla esithi "Microsoft Excel" bese uqhafaza inkinobho ethi OK.
9. Ngemuva kokuthi idokhumenti ivuliwe, iya kuthebhu "yefayela". Khetha into "Gcina njenge ...".



10. Ewindini elivula, setha umkhombandlela lapho kuzogcinwa khona incwadi ebuyekeziwe. Ensimini "yohlobo lwefayela", sibeka enye yezindlela ze-Excel, kuya ngokuthi ukunwetshwa kunomthombo olimele kanjani:
    • Incwadi ye-Excel (XLSX);
    • I-Excel 97-2003 Book (XLS);
    • Incwadi ye-Excel ngeMacros Support, njll.

    Ngemuva kwalokho, chofoza inkinobho ethi "Gcina".

Ngakho-ke, siguqula ifayela elimele ngefomethi ye-HTML bese sigcina imininingwane encwadini entsha.

Ukusebenzisa i-algorithm efanayo, ungasebenzisa hhayi kuphela i-HTML njengefomethi yokuhamba, kodwa futhi ne-XML ne-Sylk.

QAPHELA! Le ndlela ayihlali ikwazi ukonga yonke idatha ngaphandle kokulahleka. Lokhu kunjalo ikakhulukazi ngamafayela anamafomula ayinkimbinkimbi namatafula.

Indlela 3: Ukuvuselelwa kwencwadi engavuli

Uma ungakwazi ukuvula incwadi ngendlela ejwayelekile, khona-ke kukhona inketho ehlukile yokubuyisa ifayela elinjalo.

1. Qalisa uhlelo lwe-Excel. Kuthebhu "File", chofoza entweni ethi "Vula".



2. Iwindi lokuvula lizoqala. Yiya kukho kusikhombi sokuthi ifayela elimele likhona. Qokomisa. Chofoza isithonjana ngesimo sonxantathu ongenele eduze kwenkinobho ethi "Vula". Ohlwini olwehliswayo, khetha u-Vula futhi ubuyisele.



3. Kuvulwa iwindi lapho uhlelo luzokwenza ukuhlaziya umonakalo futhi luzozama ukubuyisela idatha. Chofoza inkinobho ethi "Buyisela".



4. Esimweni lapho ukululama kuqediwe ngempumelelo, kuvela umyalezo ngakho. Chofoza inkinobho ethi "Vala".



5. Uma ungakwazi ukubuyisela ifayela, ubuyela efasiteleni edlule. Chofoza inkinobho ethi "Ukukhishwa Kwedatha".



6. Okulandelayo, ibhokisi lengxoxo livula lapho umsebenzisi afanele akhethe khona: zama ukubuyisa wonke amafomula noma ubuyise kuphela amanani akhonjisiwe. Esimweni sokuqala, uhlelo luzozama ukudlulisa wonke amafomula atholakalayo efayeleni, kepha abanye babo ngenxa yokungafani nembangela yokudluliselwa kuzolahleka. Esimweni sesibili, umsebenzi ngeke ususwe, kepha inani elisesitokisini eliboniswayo. Senza ukukhetha.

Emva kwalokho, imininingwane izovulwa kwifayela elisha, elizongezwa ngesihloko segama lokuqala igama elithi "[Libuyiselwe]".

Indlela 4: Ukubuyiselwa Kwezimo Ezinzima Ngokukhethekile

Ngaphezu kwalokho, kunezimo lapho kungekho kulezi zindlela ezisize ukubuyisa ifayili. Lokhu kusho ukuthi ukwakheka kwencwadi kwephulwa kakhulu noma kuphazamisa ukululama. Ungazama ukululama, ukwenza ezinye izinyathelo. Uma isinyathelo esedlule singasizi, khona-ke iya kokulandelayo:

• Phuma ngokuphelele i-Excel bese uqalisa kabusha uhlelo;
• Qala kabusha ikhompyutha;
• Susa okuqukethwe kwifolda ye-Temp, okutholakala kwisikhombi seWindows kwi-System Disk, qala kabusha ngemuva kwale PC;
• Hlola ikhompyutha ngamagciwane futhi, uma kwenzeka kutholwa, ukuwaqede;
• Kopisha ifayela elimele komunye umkhombandlela, bese usuvele usuka lapho, zama ukubuyisela enye yezindlela ezingenhla;
• Zama ukuvula incwadi eyonakele enguqulweni entsha ye-Excel uma unganayo inketho yokugcina. Izinhlobo ezintsha zohlelo zinamathuba amaningi wokubuyisela umonakalo.

Njengoba ubona, ukulimala kwencwadi egqamile akuseyona isizathu sokuphelelwa yithemba. Kunezinketho eziningi ongazibuyisela ngazo idatha. Abanye babo basebenza noma ngabe ifayili lingavuli nhlobo. Into esemqoka akuyona ukwehlisa izandla zakho bese uzama ukulungisa isimo ngosizo lwenye inketho.