Susa ukuvikelwa kufayela le-Excel

Ukufaka ukuvikelwa kumafayela we-Excel kuyindlela enhle yokuzivikela kuzo zombili izigebengu kanye nezenzo zakho ezimbi. Inkinga ukuthi akubona bonke abasebenzisi abakwaziyo ukususa ilokhi, ukuze kuthi uma kunesidingo, bakwazi ukuhlela ibhuku noma ngisho nokubuka okuqukethwe kwayo. Umbuzo usebenza nakakhulu uma iphasiwedi isethiwe hhayi ngumsebenzisi uqobo, kodwa ngomunye umuntu owadlulisela igama lekhodi, kepha umsebenzisi ongenalwazi akwazi ukuwusebenzisa. Ngaphezu kwalokho, kunezimo zokulahlekelwa kwephasiwedi. Ake sithole ukuthi, uma kunesidingo, susa ukuvikelwa kwidokhumenti ye-Excel.

Isifundo: Indlela yokuvimbela idokhumenti ye-Microsoft Word

Izindlela zokuvula

Kunezinhlobo ezimbili ze-lock yefayela le-Excel: ukuvikelwa kwencwadi nokuvikelwa kweshidi. Ngakho-ke, i-algorithm engavundile incike ekutheni inqubo yokuvikela ikhethiwe.

Indlela 1: vula le ncwadi

Okokuqala, thola ukuthi ungasusa kanjani ukuvikelwa encwadini.

1. Uma uzama ukuqhuba ifayela le-Excel evikelwe, iwindi elincane livula ukufaka igama lekhodi. Ngeke sikwazi ukuvula le ncwadi kuze sikucacise. Ngakho, faka iphasiwedi ensimini efanele. Chofoza inkinobho ethi "Kulungile".



2. Emva kwalokho le ncwadi ivula. Uma ufuna ukususa ukuvikelwa nhlobo, iya kuthebhu "Ifayela".



3. Hambisa kusigaba "Imininingwane". Engxenyeni ephakathi kwefasitela chofoza inkinobho. "Vikela incwadi". Emenyu yokudonsa, khetha into "Bhala ngephasiwedi".



4. Iphinde iwindi ivula ngekhodi yekhodi. Vele ususe iphasiwedi kusuka kumkhakha wokufaka bese uchofoza inkinobho ethi "Kulungile"



5. Londoloza izinguquko zefayela ngokuya kuthebhu "Ikhaya" ucindezele inkinobho "Gcina" ngendlela ye-floppy disk ekhoneni eliphezulu elingakwesokunxele lewindi.

Manje, uma uvula incwadi, ngeke udinga ukungena iphasiwedi futhi izophela ukuvikelwa.

Isifundo: Indlela yokufaka iphasiwedi kufayela le-Excel

Indlela 2: vula ishidi

Ukwengeza, ungabeka iphasiwedi ephepheni elihlukile. Kulolu cala, ungavula incwadi bese ubukela ulwazi eshadini elikhiyiwe, kodwa ukushintsha amaseli kulo ngeke kuphinde kusebenze. Uma uzama ukuhlela, umlayezo ubonakala ebhokisini lengxoxo ukukwazisa ukuthi iseli livikelwe kusuka ekushintsheni.

Ukuze ukwazi ukuhlela nokususa ngokuphelele ukuvikelwa kushidi, kuzodingeka wenze uchungechunge lwezenzo.

1. Iya kuthebhu "Ukubukeza". On the tape ebhodini amathuluzi "Izinguquko" cindezela inkinobho "Iphepha elingavumelekile".



2. Ifasitela ivuleka emkhakheni okudingayo ukufaka iphasiwedi ehleliwe. Bese uchofoza inkinobho "Kulungile".

Ngemva kwalokho, ukuvikelwa kuzosuswa futhi umsebenzisi uzokwazi ukuhlela ifayela. Ukuze uphinde uvikele leli shidi, kuzodingeka ufake ukuvikeleka kwalo futhi.

Isifundo: Indlela yokuvikela iseli kusuka ekushintsheni ku-Excel

Indlela 3: Ungavimbeleli ngokushintsha ikhodi yefayela

Kodwa, ngezinye izikhathi kunezimo lapho umsebenzisi ebhala ishidi ngephasiwedi, ukuze angenzi ngephutha izinguquko kuwo, kodwa akakwazi ukukhumbula lokho. Kuyinto edabukisayo ukuthi, njengoba umthetho, amafayela anolwazi olubalulekile abhalisiwe futhi ukulahlekelwa iphasiwedi kubo kungabiza umsebenzisi. Kodwa kukhona indlela yokuphuma kule ndawo. Kuyiqiniso, kubalulekile ukucubungula ikhodi yedokhumenti.

1. Uma ifayela lakho linesandiso xlsx (Ibhuku le-Excel), bese uya ngqo esigabeni sesithathu semilayezo. Uma isandiso sayo xls (Ibhuku lokusebenzela i-Excel 97-2003), kufanele lihlelwe kabusha. Ngenhlanhla, uma kuphela ishidi libethelwe, hhayi lonke ibhuku, ungavula idokhumenti futhi ulondoloze kunoma iyiphi ifomethi etholakalayo. Ukuze wenze lokhu, iya kuthebhu "Ifayela" bese uchofoza into "Londoloza njengo ...".



2. Iwindi lokugcina livula. Kudingeka kupharamitha "Uhlobo lwefayela" setha inani "Incwadi ye-Excel" esikhundleni "Incwadi yokusebenzela ye-Excel 97-2003". Sicindezela inkinobho "Kulungile".



3. Incwadi ye-xlsx iyinqolobane yokugcina ye-zip. Sizodinga ukuhlela enye yamafayela kule archive. Kodwa ngenxa yalokhu kuzodingeka ushintshe ngokushesha isandiso kusuka ku-xlsx kuya ku-zip. Sidlula ku-explorer kuya kusiqondisi kwidiski enzima lapho idokhumenti itholakala khona. Uma izandiso zefayela zingabonakali, bese uchofoza inkinobho. "Hlunga" Phezulu kwewindi, kwimenyu yokudonsela phansi, khetha into "Ifolda nezinketho zokusesha".



4. Iwindi lokukhetha ifolda ivuleka. Iya kuthebhu "Buka". Ukufuna into "Fihla izandiso zezinhlobo zefayela ezibhalisiwe". Ungawuhloli futhi uchofoze inkinobho. "Kulungile".



5. Njengoba ubona, ngemuva kwalezi zenzo, uma isandiso singaboniswa, savela. Sichofoza efayeleni ngenkinobho yegundane elilungile nasemenyu yemenyu ebonakalayo sikhetha into Qamba kabusha.



6. Shintsha isandiso nge xlsx kuqhubeke zip.



7. Ngemuva kokuqamba kabusha, i-Windows ibona le dokhumenti njengengobo yomlando futhi ingavele ivuliwe ngokusebenzisa i-explorer efanayo. Chofoza kabili leli fayela.



8. Iya ekhelini:

   igama lefayela / xl / amashidi /

   Amafayela anesandiso xml Kule ncwadi uqukethe ulwazi mayelana namashidi. Vula owokuqala nganoma yimuphi umhleli wombhalo. Ungasebenzisa i-Notepad ye-Windows eyakhelwe kulezi zinhloso, noma ungasebenzisa uhlelo oluphambili kakhulu, isibonelo, i-Notepad ++.



9. Ngemuva kokuthi uhlelo luvule, siyiphayipha inhlanganisela yekhibhodi ekhibhodi Ctrl + FYini ebangela ukusesha kwangaphakathi kwesicelo. Sishayela ebhokisini lokusesha ibhokisi:

   sheetProtection

   Sifuna itheksthi. Uma kungatholakali, vula ifayela lesibili, njll. Yenza lokhu kuze kutholakale into. Uma ama-multiple Excel amashidi evikelwe, into izoba ngamafayela amaningi.



10. Ngemuva kwalesi sitho sitholakala, susa kanye nawo wonke ulwazi kusuka kuthegi yokuvula kuya kumathe wokuvala. Londoloza ifayela bese uvale uhlelo.



11. Buyela emuva kunqolobane yendawo yomlando futhi uphinde ushintshe isandiso salo kusuka ku-zip kuya ku-xlsx.

Manje, ukuhlela ishidi le-Excel, akudingeki ukwazi iphasiwedi elikhohliwe ngumsebenzisi.

Indlela 4: Sebenzisa Izicelo Zesithathu

Ngaphezu kwalokho, uma ukhohliwe igama lekhodi, khona-ke ukukhiya kungasuswa usebenzisa izinhlelo zokusebenza ezikhethekile zesithathu. Kulesi simo, ungakwazi ukususa iphasiwedi kusuka kokubili ishidi elivikelwe kanye nefayela lonke. Enye yezinhlelo zokusebenza ezidume kakhulu kule ndawo I-OFFICE ye-I-Recovery yephasiwedi evumelekile. Cabanga ngenqubo yokusetha kabusha isivikelo esibonelweni salesi Sevisi.

Landa i-ACCENT I-ACCICE I-Recovery yephasiwedi kusuka kusayithi elisemthethweni.

1. Sebenzisa uhlelo lokusebenza. Chofoza kwimenyu yemenyu "Ifayela". Kuhlu lokudonsa phansi, khetha isikhundla "Vula". Esikhundleni salezi zenzo, ungaphinda uthayiphe isinqamuleli sekhibhodi Ctrl + O.



2. Iwindi lokusesha ifayela livula. Ngesizo salo, hamba ku-directory lapho usebenzela khona i-Excel ibhuku, lapho iphasiwedi ilahlekile khona. Khetha bese uchofoza inkinobho. "Vula".



3. I-Password Recovery Wizard ivula, okubika ukuthi ifayela livikelwe iphasiwedi. Sicindezela inkinobho "Okulandelayo".



4. Khona-ke imenyu ivula lapho okumele ukhethe ukuthi yikuphi ukuvikelwa kuzovulwa. Ezimweni eziningi, inketho engcono kakhulu ukushiya izilungiselelo ezizenzakalelayo futhi kuphela uma kwenzeka ukwehluleka uzishintshe emzamweni wesibili. Sicindezela inkinobho "Yenzelwe".



5. Inqubo yokukhetha amaphasiwedi iqala. Kungathatha isikhathi eside kakhulu, kuye ngokuthi kunzima kangakanani igama lekhodi. I-dynamics yale nqubo ingabonwa phansi kwefasitela.



6. Ngemuva kokusesha kwedatha sekuphelile, iwindi lizoboniswa lapho iphasiwedi evumelekile izorekhodwa. Udinga nje ukugijima ifayela le-Excel kumodi evamile bese ufaka ikhodi ensimini efanelekile. Ngokushesha ngemva kwalokhu, ispredishithi se-Excel izovulwa.

Njengoba ubona, kunezindlela eziningana zokususa ukuvikelwa kusuka ku-Excel. Yimuphi kubo umsebenzisi okufanele asebenzise, ​​kuye ngokuthi uhlobo lokuvimbela, kanye nezinga lamakhono akhe nokuthi ufuna ngokushesha ukuthola umphumela owanelisayo. Indlela yokuvimbela ukusebenzisa umhleli wombhalo ihamba ngokushesha, kodwa idinga olunye ulwazi nemizamo. Ukusebenzisa izinhlelo ezikhethekile kungadinga isikhathi esiningi, kepha isicelo cishe cishe yonke into ngokwayo.