Ukufunda indlela yokubeka igama eliyimfihlo kwi-Excel luncedo kakhulu, ngakumbi xa usenza umsebenzi othile kwaye ungafuni ukuba ukopelwe. Ikwaluncedo kakhulu kwiimeko apho ufuna ukwabelana ngefayile, kodwa awufuni ukuba idatha ethile iguqulwe ngempazamo.
Kweli nqaku sikubonisa iindlela zokutshixa incwadi yokusebenzela ye-Excel okanye amaphepha athile efayile.
Amanyathelo okuba ufunde indlela yokubeka igama eliyimfihlo kwi-Excel workbook
Ukulawula ukukhusela incwadi ye-Excel ayintsonkothanga kangako, okoko nje usazi ukuba ngawaphi amanyathelo omawuwalandele ukuze uwufezekise. Okulandelayo, sikunika amanyathelo ukuze ukwazi ukufezekisa:
- Into yokuqala ekufuneka uyenzile vula ifayile ye-excel ukuba ufuna ukukhusela
- Nje ukuba uyivulile, kufuneka uye kwi menu "Oovimba” kwaye emva koko ujonge icandelo “Ulwazi".
- Emva koko kwicandelo lolwazi kufuneka ukhethe ukhetho "Khusela incwadi” kwaye ke kufuneka ukhethe “Ukufihlwa kunye nephasiwedi".
- Xa ukhetha u- "encrypt password" kukho ibhokisi ebuzwayo ngenisa igama lokugqithisa kwaye uyiphinda ukuyiqinisekisa.
- Nje ukuba uqinisekise igama eligqithisiweyo, incwadi iya kukhuselwa kwaye xa uyivula kwakhona kuya kufuneka uyifake.
Ngokulandela la manyathelo ma-5 uya kukwazi ukufunda indlela yokubeka igama eliyimfihlo kwi-Excel workbook kwaye ngaloo ndlela gcina ulwazi osebenza kulo lukhuselekile.
Kuya kufuneka ukhumbule ukuba igama eliyimfihlo kufuneka libhalwe phantsi kwindawo ekhuselekileyo, kuba ukuba awukwenzi oko, unokuphulukana nolwazi olwenzileyo kwincwadi yomsebenzi ye-Excel. Uguqulelo oluntsonkothileyo lunamandla kangangokuba nabantu bakwaMicrosoft abakwazanga ukufikelela kulwazi ngaphandle kwegama eliyimfihlo.
Kukwacetyiswa ukuba khetha igama lokugqitha elingaqikelelwa lula ngabantu besithathu. Ukuba awuyithatheli ngqalelo le nto, abanye banokuqikelela igama eligqithisiweyo kwaye ke ngoko babe nofikelelo kwidatha ongafuni ukuyixela.
Indlela yokuba ufunde indlela yokubeka igama lokugqitha kwiispredishithi
Inketho entle kakhulu kukufunda indlela yokubeka igama lokugqitha kwispredishithi, kuba oku kunokukunceda khusela idatha ongafuni ukuba iguqulwe ngengozi okanye ngabom.
Into ekufuneka uyikhumbule kukuba le yindlela yokwenza ayitshixa ngokupheleleyo ifayile, yaye ayibathinteli abasebenzisi abanokubona inkcazelo ekwincwadi. Ukuze ukwazi ukusebenzisa olu thintelo lwamaphepha e-Excel workbook kufuneka ulandele la manyathelo alandelayo:
- Okokuqala kufuneka uchonge ukuba kukho imihlathi oyifunayo, ukuba inokuguqulwa phambi kokuvimba abanye.
- Nje ukuba ugqibe iikholamu ongafuni itshixiwe, kufuneka uzikhethe kwaye ucofe ekunene ngemouse.
- Kwimenyu entsha kufuneka ujonge icandelo "Ifomathi yeseli” kwaye kwimenyu elandelayo kufuneka ujonge ukhetho "Khusela".
- Kanye kukhetho lokukhusela kufuneka uluvale olu khetho "Ivaliwe” esele ihloliwe.
- Ngoku kufuneka uye kwi menu "Uhlolo” ebekwe phezulu kwincwadi.
- Xa ungena kwicandelo lophononongo, kufuneka ukhethe ukhetho "Khusela iphepha".
- Xa ukhetha iphepha lokukhusela, iwindow iboniswa apho ucelwa ukuba ufake igama lokutshixa. Kodwa unokukhetha imisebenzi enokwenziwa ngabasebenzisi xa ulitshixile iphepha.
- Ngokufaka isitshixo kunye nokukhetha imisebenzi evunyelwe kubasebenzisi, kufuneka ucinezele ukwamkela ukuseta isitshixo.
Ngokulandela la manyathelo asi-8, awufundanga kuphela indlela yokubeka igama eliyimfihlo kwiphepha le-Excel, kodwa ukhusela idatha ongafuni ukuba iguqulwe kwincwadi yomsebenzi.
Ezinye iindlela zokhuseleko kunye nokhuseleko kwifayile ye-Excel
UMicrosoft wenze iindlela ezahlukeneyo zokukwazi ukukhusela ukhuseleko lwefayile ye-Excel, ukongeza kwezo sele sithethile ngazo. Okulandelayo, siza kuthetha ngezinye zezi ndlela ezizezinye.
- Phawula ifayile njengeyokugqibela. Olu lukhetho olunikezwa yi-Excel xa ufuna ukuphawula ifayile njengoguqulelo lokugqibela kwaye ungafuni ukuba ifumane uhlengahlengiso kwiqela lesithathu.
- Ulawulo lwamalungelo olwazi (IRM). Le yenye yeenketho onokuzisebenzisa ukuvala ifayile, kunye namalungelo olawulo lolwazi onokuyikhusela ekubeni ingalungiswa okanye isetyenziswe ngabanye abantu.
- Utyikityo lwedijithali. Ukusebenzisa utyikityo lwedijithali kunokuba lukhetho oluhle ukuze idatha yakho ingasetyenziswa okanye ibiwe ngabantu besithathu. Ngale ndlela kufuneka ube nesatifikethi esisebenzayo esivela kugunyaziwe woqinisekiso.
- inqanaba lencwadi. Olu lukhetho lokutshixa lwesakhiwo sencwadi yomsebenzi, oko kukuthi, ngayo unokuthintela abanye abasebenzisi ukuba bangakwazi ukushukuma, ukongeza, ukucima, ukufihla kunye nokubathiya ngokutsha amaphepha okusebenzela.
- Inqanaba lespreadsheet. Olu lukhuselo olukuvumela ukuba ukhusele ezinye izinto ezinje ngeeseli, uluhlu, iifomyula, ulawulo lwe-ActiveX, iifom. Oko kukuthi, inciphisa iinketho zokuguqulwa komsebenzisi kwiphepha le-Excel.
Ezi ndlela zingenye zinokuba luncedo kakhulu ngokuxhomekeke kuhlobo lolwazi osebenza ngalo kwincwadi yakho yokusebenza ye-Excel.
Izilumkiso xa ufunda indlela yokubeka igama eliyimfihlo kwi-Excel
Kukho inani le-caveats xa kuziwa ekufundeni indlela yokubeka i-password ye-Excel. Ngoko ke kubalulekile ukuba uzazi phambi kokuba usebenzise nayiphi na kwezi ndlela.
- Kubalulekile ukuba gcina igama lakho eliyimfihlo likhuselekile, kuba ukuba uyalibala, iMicrosoft ayikwazi ukufaka ifayile ukubuyisela ulwazi lwakho.
- Inyaniso yokuba ifayile ine-password ayithethi ukuba ikhuselekile ngokupheleleyo okanye ikhuselwe. Kungoko kufuneka ulumke xa uhambisa iifayile ngolwazi olubalulekileyo kubantu besithathu okanye abantu abangabaziyo.
- Akukhuthazwa ukuba ugcine iinkcukacha zakho ezifana neenombolo zekhadi letyala, ukhuseleko loluntu okanye ukuchongwa kwabasebenzi kwincwadi ye-Excel. Khumbula ukuba into yokuba ivaliwe ayithethi ukuba ikhuselekile ngokupheleleyo.
- Ukhuseleko olunxulumene nenqanaba lephepha ayisiyondlela yokhuseleko ethathelwa ingqalelo, kuba inciphisa kuphela iiseli ozithinteleyo ukuba zingalungiswa.
Kubaluleke kakhulu ukuba uzithathele ingqalelo ezi zilumkiso, ngakumbi ukuba uphatha ulwazi oluhlelwe kumbutho wakho okanye kwinkampani oyisebenzelayo.