Ukuphepha nokuvikelwa kwedatha kungenye yezinkomba eziphambili zokuthuthukiswa kobuchwepheshe bolwazi besimanje. Ukuhambisana kwale nkinga akwehli, kepha kukhula kuphela. Ukuvikelwa kwedatha kubaluleke kakhulu kumafayili etafula, avame ukugcina imininingwane ebalulekile yokuhweba. Masifunde ukuthi ungawavikela kanjani amafayela we-Excel nge-password.
Ukuhlelwa kwephasiwedi
Onjiniyela bohlelo bakuqonda kahle ukubaluleka kwekhono lokusetha iphasiwedi kumafayili e-Excel, ngenxa yalokho, basebenzise izinketho eziningana zokwenza le nqubo ngasikhathi sinye. Ngasikhathi sinye, kungenzeka ukusetha ukhiye, womabili wokuvula incwadi nokuyiguqula.
Indlela yoku-1: setha iphasiwedi lapho ugcina ifayili
Enye indlela ukusetha iphasiwedi ngqo lapho ugcina incwadi yokusebenza ye-Excel.
- Iya kuthebhu Ifayela Izinhlelo ze-Excel.
- Chofoza entweni Gcina Njengo.
- Ewindini elivula, gcina incwadi, chofoza inkinobho "Insizakalo"etholakala ezansi impela. Kumenyu evelayo, khetha "Izinketho ezijwayelekile ...".
- Kuvulwa elinye iwindi elincane. Vele kuyo ungacacisa iphasiwedi yefayela. Ensimini "Iphasiwedi ukuvula" faka igama elingukhiye ozodinga ukulichaza lapho uvula incwadi. Ensimini "Iphasiwedi ezoshintsha" faka ukhiye ozodinga ukufakwa uma udinga ukuhlela leli fayela.
Uma ufuna ukuvimba abantu besithathu ekuhleleleni ifayela lakho, kepha ufuna ukushiya ukufinyelela ekubukeni mahhala, khona-ke kuleli cala, faka iphasiwedi yokuqala kuphela. Uma kuchazwe izinkinobho ezimbili, lapho uvula ifayela, uzokwaziswa ukufaka zombili. Uma umsebenzisi azi owokuqala wabo, khona-ke ukufunda kuphela kuzotholakala kuye, ngaphandle kokuhlelwa kwedatha. Esikhundleni salokho, angahlela noma yini, kepha ukusindisa lezi zinguquko ngeke kusebenze. Ungagcina njengekhophi ngaphandle kokushintsha idokhumenti yangempela.
Ngaphezu kwalokho, ungabheka ngokushesha ibhokisi eliseduze "Ncoma ukufinyelela okufundwayo kuphela".
Kulokhu, noma umsebenzisi owazi womabili amaphasiwedi, ifayili lizovulwa ngokuzenzakalelayo ngaphandle kwamathuluzi. Kepha, uma efiswa, uyohlala ekwazi ukuvula leli phaneli ngokucindezela inkinobho ehambisanayo.
Ngemuva kokuthi wonke amasethingi efasiteleni lezilungiselelo ezijwayelekile aqediwe, chofoza inkinobho "Kulungile".
- Iwindi livula lapho udinga ukufaka khona ukhiye futhi. Lokhu kwenziwa ukuze umsebenzisi angaziphathi kabi okokuqala lapho kwenzeka iphutha lokuthayipha. Chofoza inkinobho "Kulungile". Uma amagama angukhiye angahambelani, uhlelo luzokushukumisela ukuthi uphinde ufake iphasiwedi.
- Ngemuva kwalokho, siphinda sibuyele efasiteleni lokulondolozwa kwefayela. Lapha ungakwazi ukukhetha igama lakhe bese ukhetha inkomba lapho izotholakala khona. Lapho konke lokhu kwenziwa, chofoza inkinobho Gcina.
Ngakho-ke, savikela ifayela le-Excel. Manje, ukuze uyivule futhi uyihlele, uzodinga ukufaka amaphasiwedi afanele.
Indlela 2: setha iphasiwedi esigabeni "semininingwane"
Indlela yesibili ifaka ukusetha iphasiwedi esigabeni se-Excel "Imininingwane".
- Njengokugcina, iya kuthebhu Ifayela.
- Esigabeni "Imininingwane" chofoza inkinobho Vikela Ifayela. Uhlu lokukhethwa kukho kokuvikela okunenkinobho yefayela luyavula. Njengoba ukwazi ukubona, lapha ungavikela iphasiwedi hhayi kuphela ifayili lilonke, kodwa futhi nephepha elihlukile, futhi usungule nokuvikelwa koshintsho ekwakhiweni kwebhuku.
- Uma siyeka "Bethela ngephasiwedi", kuvulwa iwindi lapho kufanele ufake igama elingukhiye. Le phasiwedi ihambelana nokhiye wokuvula incwadi, ebesiyisebenzisa ngendlela eyedlule lapho sigcina ifayili. Ngemuva kokufaka idatha, chofoza inkinobho "Kulungile". Manje, ngaphandle kokwazi ukhiye, akekho ongavula ifayela.
- Lapho ukhetha into Vikela Ishidi Lamanje kuvuleka iwindi elinezilungiselelo eziningi. Kukhona newindi lokufaka iphasiwedi. Leli thuluzi likuvumela ukuthi uvikele ishidi elithile ekuhlelweni. Ngasikhathi sinye, ngokungafani nokuvikelwa ekushintsheni ngokulondolozwa, le ndlela ayinikezi namandla okwenza ikhophi eshintshiwe yeshidi. Zonke izenzo ezikulo zivinjelwe, yize ngokuvamile incwadi ingasindiswa.
Umsebenzisi angabeka isilinganiso sokuzivikela ngokwakhe ngokufaka uphawu kuzinto ezihambisanayo. Ngokuzenzakalelayo, kuzo zonke izenzo zomsebenzisi ongeyona ipasiwedi, ukukhethwa kwamaseli kuphela kuyatholakala ephepheni. Kepha, umbhali wedokhumenti angavumela ukufometha, ukufaka nokususa imigqa nezinsika, ukuhlungwa, ukusebenzisa i-autofilter, ukuguqula izinto nemibhalo, njll. Ungasusa ukuvikelwa cishe kunoma yisiphi isenzo. Ngemuva kokusetha izilungiselelo, chofoza inkinobho "Kulungile".
- Uma uqhafaza entweni "Vikela ukwakhiwa kwencwadi" Ungasetha ukuvikelwa kwesakhiwo sedokhumenti. Izilungiselelo zihlinzeka ngezinguquko zesakhiwo esivimba, kokubili nephasiwedi futhi ngaphandle kwawo. Esimweni sokuqala, lokhu okubizwa ngokuthi "ukuvikela isiwula," okungukuthi, ezenzweni ezingahlosile. Esimweni sesibili, lokhu kuvikela ekushintsheni ngamabomu kudokhumenti kwabanye abasebenzisi.
Indlela 3: Setha iphasiwedi bese uyisusa kuthebhu ethi "Ukubuyekezwa"
Amandla wokusetha iphasiwedi nawo akhona kuthebhu "Buyekeza".
- Iya kuthebhu engenhla.
- Sifuna ibhulokhi yamathuluzi "Shintsha" ekhasethini. Chofoza inkinobho Vikela Ishidi, noma Vikela Incwadi. Lezi zinkinobho zihambisana ngokuphelele nezinto Vikela Ishidi Lamanje futhi "Vikela ukwakhiwa kwencwadi" esigabeni "Imininingwane"esesikushilo ngenhla. Izenzo ezengeziwe nazo ziyafana ngokuphelele.
- Ukuze ususe iphasiwedi, kufanele uchofoze inkinobho "Susa ukuvikelwa eshidini" kubambo bese ufaka igama elingukhiye elifanele.
Njengoba ukwazi ukubona, iMicrosoft Excel inikezela ngezindlela ezimbalwa zokuvikela ifayili nge-password, kokubini ekugenca ngamabomu nasezenzweni zamabomu. Ungavikela ngephasiwedi zombili ukuvula incwadi nokuhlela noma ushintshe izinto zalo zesakhiwo. Kulokhu, umbhali angazinqumela ngokwakhe ukuthi iziphi izinguquko afuna ukuvikela kuzo.
