Ukuba i-Excel ibandakanya ukugcina ngokuzenzekelayo, le nkqubo igcina igcina iifayile zethutyana kwikhompyutha ethile. Kwimeko yeemeko ezingalindelekanga okanye ukusilela kwalo msebenzi emsebenzini wenkqubo, banokubuyiselwa. Ngokungagqibekanga, ukugcinwa ngokuzenzekelayo kunxamnye nemizuzu eli-10, kodwa eli xesha linokutshintshwa okanye ngokubanzi kukhubaza eli nqaku.
Njengomthetho, emva kokusilela, ngemvume, inika umsebenzisi ukuba ivelise inkqubo yokubuyisela kwimeko yesiqhelo. Kodwa, kwezinye iimeko, ngeefayile zethutyana ekufuneka usebenze ngqo. Emva koko kuzazi apho bakhoyo. Makhe siyifumane nalo mbuzo.
Indawo yeefayile zethutyana
Kwangoko kufuneka utsho ukuba iifayile zethutyana e-Excel zahlulwe zangamacala amabini:- Izinto zokugcina ezenzekelayo;
- Iincwadi ezingagcinwanga.
Ke, nokuba awuyigcinayo ngokuzenzekelayo, usenokubanakho ukubuyisela incwadi. Kuyinyani, iifayile zezi ntlobo zimbini zibekwe kwiikhola ezahlukeneyo. Makhe sifumanise ukuba babeka phi.
Ukubeka iifayile ze-autoshry
Ubunzima bokuchaza idilesi ethile kukuba kwiimeko ezahlukeneyo kusenokubakho kuphela ingxelo eyahlukileyo yenkqubo yokusebenza, kodwa negama leakhawunti yomsebenzisi. Kwaye ukusuka kwinto yokugqibela kuxhomekeke, apho ifolda ifumaneka khona nezinto eziyimfuneko kuthi. Ngethamsanqa, kukho indlela efanelekileyo yokufunda olu lwazi. Ukwenza oku, kufuneka wenze la manyathelo alandelayo.
- Yiya kwi "Ifayile" ye-Excel ye-Excel. Cofa kwigama le "parameter".
- Ifestile ye-Excel Parameter ivula. Yiya kwicandelwana ". Kwicala lasekunene lefestile kwi "Gcina incwadi" yeqela leseto, kufuneka ufumane ukhetho "lwekhathalogu". Yidilesi echazwe kule ntsimi ibonisa isikhombisi sesikhundla seefayile zethutyana.
Umzekelo, kubasebenzisi benkqubo yokusebenza yeWindows 7, itemplate yedilesi iya kuba ngolu hlobo lulandelayo:
C: \ Abasebenzisi \ Umsebenzisi_Name \ AppData \ ukuhambisa iMicrosoft \ Excel \
Ngokwemvelo, endaweni yexabiso "lomsebenzisi", kufuneka uchaze igama leakhawunti yakho kulo mzekelo weWindows. Nangona kunjalo, ukuba wenza yonke into njengoko kubonisiwe apha ngasentla, awudingi okuthile okuthile endaweni yoko, kuba indlela epheleleyo kulawulo iya kuboniswa kwicandelo elihambelanayo. Ukusuka apho ungayikhuphela uyincamathisele kumqhubi okanye wenze naliphi na elinye izenzo ocinga ukuba.
QAPHELA! Indawo yeefayile ze-autosave ngokujonga kwi-Excel kubalulekile ukuba ijongeke ngakumbi kwaye inokutshintsha ngesandla kwi "Ikhathalogu yedatha ye-Autosoremount" yeKhathalogu ye-Autosoremount "yendawo, kwaye ke ayinakuthelekisa i-template echazwe apha ngasentla.
Isifundo: Ungayibeka njani isigxina se-Auto kwi-Excel
Ukubekwa kweencwadi ezingagcinwanga
Into enzima ngakumbi yimeko yeencwadi ezingagcinwanga ngokuzenzekelayo. Ungayifumana idilesi yendawo yogcino lweefayile ezinjalo ngomnxibelelanisi we-Excel ngokufaka inkqubo yokubuyisela kwimeko yesiqhelo. Azikho kwifolda ye-Excel eyahlukileyo, njengakwicala elidlulileyo, kwaye ngokubanzi ukugcina iifayile ezingachazwanga kuzo zonke iiphakheji zesoftware yeMicrosoft. Iincwadi ezingafakwanga ziya kuba kwindawo ekhompyutheni, ezifumaneka kwezi template zilandelayo:
C: \ Abasebenzisi \ Umsebenzisi_Name \ AppData \ I-Microsoft \ ye-microsoft Microsoft \ offir \ i-engafikiyo
Endaweni yexabiso "lomsebenzisi", njengakwixesha elidlulileyo, kufuneka endaweni yegama leakhawunti. Kodwa, ukuba asikhathazi ngokucacisa igama leakhawunti, njengoko benokufumana idilesi epheleleyo yolawulo, emva koko kuya kuthi kule meko kubalulekile ukwazi.
Ulula kakhulu ukufumana igama leakhawunti yakho. Ukwenza oku, cofa iqhosha lokuqalisa kwikona esezantsi yesosi sikrini. Phezu kwephaneli evelayo kwaye iakhawunti yakho iya kuchazwa.
Faka nje itemplate endaweni yegama elithi "igama lomsebenzisi".
Idilesi ekhuthazayo inokuba, umzekelo, faka kumqhubi wesifundo ukuya kulawulo olufunwayo.
Ukuba ufuna ukuvula indawo yokugcina iincwadi ezingafakwanga kule khompyuter phantsi kweakhawunti eyahlukileyo, uluhlu lwamagama asebenzisi lunokufunyanwa ngokulandela le miyalelo ilandelayo.
- Vula imenyu "yokuqala". Yiya kwiphaneli yokulawula.
- Kwifestile evula, fudukela kwindawo ethi "Yongeza kwaye ucime icandelo lokurekhoda umsebenzisi".
- Kwifestile entsha, akukho manyathelo ongezelelweyo akufuneki ayenze. Ungabona apho, amagama abasebenzisi kule PC ayafumaneka kwaye akhethe okufanelekileyo ukuze ayisebenzise ukuya kulawulo lwencwadi engagcinwanga ye-Exverl, endaweni yetemplate yedilesi endaweni yokuchaza igama lomsebenzisi.
Njengoko kuchaziwe apha ngasentla, indawo yokugcina iincwadi ezingafakwanga nazo zinokufunyanwa, qhuba inkqubo yokufumana ulwazi.
- Yiya kwinkqubo ye-Excel kwithebhu yefayile. Emva koko, sifudukela kwicandelo "leenkcukacha". Kwicala lasekunene lefestile sicofa iqhosha "lenguqulo". Kwimenyu evula, khetha "Buyisela iincwadi ezingakhuselekanga".
- Ifestile yokubuyisa iwindow ivulwa. Ngaphezu koko, ivula lo ncwadi ugcinwe apho iifayile zeencwadi ezingagcinwanga zigcinwa khona. Kufuneka sibalaselise i-dilesi yedilesi yale festile. Yimxholo wayo kwaye iya kuba yidilesi yolawulo lwendawo ekungakhuselekanga.
Okulandelayo, sinokwenza inkqubo yokubuyisela kwimeko yesiqhelo kwifestile enye okanye isebenzise ulwazi olufunyenweyo ngezinye iinjongo. Kodwa kuyimfuneko ukuqaphela ukuba olu khetho lufanelekile ukufumana idilesi yendawo yeencwadi ezingafakwanga phantsi kweakhawunti, phantsi kwento osebenza ngayo ngoku. Ukuba ufuna ukwazi idilesi kwenye iakhawunti, uze usebenzise indlela eyachazwa kancinci.
Isifundo: Ukubuyisela iNcwadi ye-Exprel eMgangathweni
Njengoko ubona, eyona dilesi yendawo yendawo ye-Excel yethutyana inokufumaneka ngenkqubo yenkqubo. Kwiifayile zokugcina ezenzekelayo, oku kwenziwa ngeparamitha yenkqubo, kunye neencwadi ezingagcinwanga ngokuxeliswa kwakhona. Ukuba ufuna ukwazi indawo yefayile yethutyana eyayisenziwa phantsi kwenye i-akhawunti, ke kule meko kufuneka uyazi kwaye uchaze igama lomsebenzisi elithile lomsebenzisi.