Ukufakwa kokuvikelwa kumafayela we-Excel kuyindlela enhle yokuzivikela, kusuka kubahlaseli kanye nasezenzweni zakho eziyiphutha. Kunezinhlobo ezimbili zokuvimba ifayela Excel: ukuvikelwa encwadini nokuvikelwa eshidini. Ngokuvumelana nalokho, i-algorithm yokuvula incike kunikezwe yiphi indlela yokuvikela.
Isifundo: Ungasusa Kanjani Ukuvikelwa KuMicrosoft Word
Ukufundiswa kwevidiyo
Indlela 1: Vula izincwadi
Okokuqala, thola ukuthi ungazisusa kanjani isivikelo nencwadi.
- Lapho uzama ukuqala ifayili elivikelekile, i-Excel ivula iwindi elincane lokufaka igama lekhodi. Ngeke sikwazi ukuvula le ncwadi kuze kube yilapho sikucacisa. Ngakho-ke, faka iphasiwedi enkombeni ehambisanayo. Chofoza inkinobho ethi "KULUNGILE".
- Emva kwalokho, incwadi iyavuleka. Uma ufuna ukususa ngokuphelele ukuvikelwa, khona-ke iya kuthebhu ethi "Ifayela".
- Sithuthela engxenyeni ethi "Imininingwane". Engxenyeni ephakathi yewindi esichofozayo enkingeni ethi "Vikela incwadi". Kumenyu eyehlayo, khetha into ethi "Encrypt Iphasiwedi".
- Iwindi livula ngegama lekhodi. Vele ususe iphasiwedi kusuka enkombeni yokufaka bese uchofoza inkinobho ethi "Kulungile"
- Gcina izinguquko zefayela ngokuchofoza kwithebhu ethi "Ikhaya" ngokuchofoza inkinobho ethi "Gcina" njengediski yefloppy ekhoneni eliphezulu kwesokunxele sewindi.
Manje, lapho uvula incwadi, ngeke udinge ukufaka iphasiwedi futhi uzoyeka ukuvikeleka.
Isifundo: Ungayibeka kanjani iphasiwedi kufayela le-Excel
Indlela 2: Vula ishidi
Ngaphezu kwalokho, ungabeka iphasiwedi ephepheni elihlukile. Ngasikhathi sinye, ungavula incwadi futhi ubheke imininingwane eshidini elivinjiwe, kepha ngeke kwenzeke ukushintsha amaseli kuwo. Lapho uzama ukuhlela, umyalezo uvela ebhokisini lengxoxo elazisa ukuthi iseli livikelekile ezinguquko.
Ukuze uhlele ngokuzikhethela futhi ususe ngokuphelele ukuvikelwa eshidini, kuzofanele wenze izenzo eziningi.
- Iya kuthebhu ethi "Ukubukeza". Ku-Ribbon ku-Tool Block ye- "Shintsha", sichofoza inkinobho ethi "Susa Ukuvikelwa Kweshidi".
- Iwindi liyavula, emkhakheni walo ofuna ukufaka iphasiwedi ebekiwe. Bese uchofoza inkinobho ethi "KULUNGILE".
Ngemuva kwalokho, ukuvikelwa kuzosuswa futhi umsebenzisi uzokwazi ukuhlela ifayela. Ukuvikela ishidi futhi, kuzodingeka ufake futhi.
Isifundo: Ungayivikela kanjani iseli kusuka ekushintsheni kuya ku-Excel
Indlela 3: Ukususa ukuvikelwa ngokushintsha ikhodi yefayela
Kepha, kwesinye isikhathi kunezimo lapho umsebenzisi abethembela iphepha ngephasiwedi ukuze ngengozi awenzi izinguquko kulo, kodwa angakwazi ukukhumbula i-cipher. Kuphazamise kakhulu amafayela anemininingwane ebalulekile kanye nokulahleka kwephasiwedi kungabiza ukwenza umsebenzisi. Kepha, kukhona indlela yokuphuma ngisho nakulesi sikhundla. Kuliqiniso, kufanele ubheke ngekhodi yedokhumenti.
- Uma ifayela lakho line-XLSX (Book Excel), bese liya esigabeni sesithathu semfundo. Uma ukunwetshwa kwayo kwe-XLS (Book Excel 97-2003), kufanele kubunwe. Ngenhlanhla, uma ngabe ishidi libhalwe ngemfihlo, akuyona yonke incwadi, ungavula idokhumenti bese ugcine kunoma iyiphi ifomethi efinyelelekayo. Ukuze wenze lokhu, iya kuthebhu ethi "File" bese uqhafaza ku- "Gcina njenge ...".
- Iwindi longa livula. Okuphoqelekile ku-parameter "yohlobo lwefayela" Setha inani "le-Excel Book" esikhundleni se- "Book Excel 97-2003". Chofoza inkinobho ethi "KULUNGILE".
- I-XLSX Book ingumlando we-zip. Sizodinga ukuhlela elinye lamafayela alobo bumlando. Kepha kulokhu kudingeka kuguqulwe ukwanda nge-XLSX ku-zip. Dlula kumqhubi kulolo mkhombandlela we-hard disk lapho idokhumenti itholakala khona. Uma izandiso zefayela zingabonakali, bese uchofoza inkinobho ethi "Hlunga" ngaphezulu kwefasitela, ukhethe into "ifolda kanye ne-parameters" yemenyu evulekile.
- Iwindi le-Folder Parameter livulwa. Iya kuthebhu ethi "View". Sifuna into ethi "Fihla Izandiso zezinhlobo zefayela ezibhalisiwe". Susa ibhokisi lokuhlola kulo bese uqhafaza inkinobho ethi "KULUNGILE".
- Njengoba ubona, emva kwalezi zenzo, uma izandiso zingakhonjiswanga, kwavela. Chofoza kufayela chofoza kwesokudla nakumenyu yokuqukethwe okuvela ku-The Contect, khetha i- "Rerame" into.
- Shintsha ukwanda nge-XLSX ku-zip.
- Ngemuva kokuqanjwa kabusha kwenziwa, amawindi abona lo mbhalo njengengobo yomlando futhi angavele avule usebenzisa umqhubi wesifundo esifanayo. Yenza i-Double Mouse chofoza kuleli fayela.
- Iya ekhelini:
Igama lefayela / ama-XL / amakhasi okusebenza /
Amafayela anesandiso se-XML kulo mkhombandlela aqukethe imininingwane ngamashidi. Sivula owokuqala nanoma yisiphi isihleli sombhalo. Ungasebenzisa i-Notepad yeWindows eyakhelwe ngaphakathi kwalezi zinhloso, futhi ungafaka uhlelo oluthuthuke kakhulu, njenge-Notepad ++.
- Ngemuva kokuthi uhlelo luvuliwe, thayipha okhiye be-CTRL + F kwikhibhodi kunokushayela usesho lwangaphakathi. Sishayela ebhokisini lokusesha. Inkulumo:
Shiftprotection.
Siyayifuna embhalweni. Uma ungakutholi, sivula ifayela lesibili, njll. Sikwenza inqobo nje uma into itholakala. Uma amashidi amaningana e-Excel evikelwe, into izoba ngamafayela amaningana.
- Ngemuva kwale nto kutholwe, yisuse kanye nalo lonke ulwazi kusuka kuthegi yokuvula kuya ekuvaleni. Gcina ifayili bese uvala uhlelo.
- Sibuyela kwisikhombisi sendawo yokugcina umlando futhi siguqule ukwanda kwayo nge-zip ku-xlsx futhi.
Manje, ukuhlela ishidi le-Excel, ngeke udinge ukwazi iphasiwedi ekhohliwe umsebenzisi.
Indlela 4: Kusetshenziswa izinhlelo zokusebenza zeqembu lesithathu
Ngaphezu kwalokho, uma ukhohlwe igama lekhodi, ukuvimba kungasuswa kusetshenziswa izinhlelo zokusebenza ezikhethekile zangaphandle. Ungasusa iphasiwedi yomabili kusuka ekhasini elivikelwe futhi kulo lonke ifayela. Enye yezicelo ezithandwa kakhulu zale ndawo lapho uya khona ukululama kwephasiwedi yehhovisi. Cabanga ngenqubo yokusetha kabusha kwezokuvikela esibonelweni salolu hlelo.
Landa ukululama kwephasiwedi ye-Accent Office Iphasiwedi kusuka esizeni esisemthethweni
- Qalisa uhlelo lokusebenza. Chofoza entweni yemenyu "Ifayela". Ohlwini olwehliswayo, khetha isikhundla "esivulekile". Esikhundleni salezi zenzo, ungamane ushayele okhiye be-CTRL + O kwikhibhodi.
- Kuvulwa ibhokisi lokusesha lefayela. Ngosizo lwayo, iya ku-Directory lapho incwadi ye-Excel oyidingayo itholakala khona, lapho iphasiwedi ilahlekile. Siyigqabisisa bese uchofoza inkinobho ethi "Open".
- I-Wizard Yokubuyisa Iphasiwedi iyavula, ebika ukuthi ifayili livikelwe ngephasiwedi. Chofoza inkinobho "elandelayo".
- Ngemuva kwalokho imenyu iyavuleka lapho kufanele ukhethe khona ukuthi yisiphi isimo esizosuswa. Ezimweni eziningi, inketho ephelele kakhulu ukushiya izilungiselelo ezizenzakalelayo futhi uma kuphela uma wehluleka, zama ukuzishintsha kumzamo wesibili. Chofoza inkinobho ethi "Qeda".
- Inqubo yokukhetha amaphasiwedi iyaqala. Kungathatha isikhathi eside, kuya ngobulukhuni begama lekhodi. Amandla wenqubo angabonakala ezansi kwewindi.
- Ngemuva kokuthi idatha iqhume, iwindi lizokhonjiswa lapho iphasiwedi yangempela izorekhodwa. Uzohlala ugijima kuphela ifayela le-Excel kumodi ejwayelekile bese ufaka ikhodi enkundleni ehambisanayo. Masinyane ngemuva kwalokhu, ithebula le-Excel lizovulwa.
Njengoba ubona, kunezindlela eziningana zokususa ukuvikelwa embhalweni we-EXEL. Ungawusebenzisa kanjani umsebenzisi kumele akhethe ngokuya ngohlobo lokuvinjwa, kanye nakwizinga lamakhono alo nokuthi udinga ngokushesha kangakanani ukuthola umphumela ogculisayo. Indlela yokususa ukuvikela usebenzisa umhleli wombhalo ngokushesha, kepha idinga ulwazi nomzamo othile. Ukusetshenziswa kwezinhlelo ezikhethekile kungadinga inani elibalulekile lesikhathi, kepha uhlelo lokusebenza lwenza cishe zonke.