Ungayibeka njani iphasiwedi kwifayile ye-Excel

Ezokhuseleko kunye nokukhuselwa kwedatha yenye yezona ndlela ziphambili kuphuhliso lwetekhnoloji yolwazi yangoku. Ukubaluleka kwale ngxaki akuphunyelwa, kodwa kukhula kuphela. Ngokukodwa kukhuseleko olubalulekileyo lweefayile zetafile apho ulwazi lubalulekileyo luhlala lugcinwe kulwazi lwezorhwebo. Masifumanise ukuba ungayikhusela njani iifayile ze-Excel usebenzisa iphasiwedi.

Ufakelo lwegama eligqithisiweyo

Abaphuhlisi benkqubo bakuqonda ukubaluleka kokufaka iphasiwedi kwiifayile ze-Excel, ke zinokukhetha ukwenza le nkqubo ngaxeshanye. Kwangelo xesha, kunokwenzeka ukuseka isitshixo, ekuvulekeni kwencwadi kunye notshintsho.

Indlela yoku-1: Ukuseta iphasiwedi ngelixa ugcina ifayile

Enye indlela ebandakanya ukuseta iphasiwedi ngokuthe ngqo xa usigcina iNcwadi ye-Excel.

1. Yiya kwi "Ifayili" ithebhu yenkqubo ye-Excel.



2. Cofa kwi "Gcina njengo".



3. Kwifestile evula, sicofa iqhosha "leseshoni", elibekwe ezantsi. Kwimenyu ebonakalayo, khetha "iparameters jikelele ...".



4. Enye iwindow encinci ivulwa. Kuyo nje, unokuchaza iphasiwedi kwifayile. Kwigama elithi "ipassword yokuvula" intsimi, sifaka igama eliphambili eliya kufuna ukucacisa xa uvula incwadi. Kwigama elithi "ipassword yokutshintsha" intsimi, faka isitshixo ukuba ufakelwe ukuba ufuna ukuhlela le fayile.

   Ukuba ufuna ifayile yakho ikwazi ukuhlela abantu abangagunyaziswanga, kodwa ufuna ukushiya ukufikelela kwimbonakalo yasimahla, emva koko, kule meko, faka ipaswedi yokuqala. Ukuba amaqhosha amabini achaziweyo, ke xa uvula ifayile, uya kukhuthaza ukuba ungene kuzo zombini. Ukuba umsebenzisi uyazazi kuphela owokuqala kubo, emva koko iya kufumaneka kuphela ukuba ifundwe, ngaphandle kokukwazi ukuhlela idatha. Endaweni yoko, iya kuba nakho ukuhlela yonke into, kodwa ayizukugcina olu tshintsho. Ingagcinwa kuphela ngohlobo lwekopi ngaphandle kokutshintsha uxwebhu lokuqala.

   Ukongeza, unokubeka uphawu ngokukhawuleza malunga ne "Cebing-kuphela" kuphela "kuphela.

   Kwangelo xesha, nkqu nomsebenzisi owazi i-password, ifayile emiselweyo iya kuvulwa ngaphandle kwebar yesixhobo. Kodwa, ukuba uyafuna, uya kuhlala ekwazi ukuvula le paneli ngokucinezela iqhosha elifanelekileyo.

   Emva kwazo zonke iisetingi kwifestile eqhelekileyo ye-parameter yenziwa, cofa kwiqhosha "Kulungile".



5. Ifestile ivula apho ufuna ukufaka khona isitshixo kwakhona. Oku kwenziwa ukuqinisekisa ukuba umsebenzisi unempazamo ekungeneni okokuqala. Cofa kwiqhosha "Kulungile". Kwimeko yokungaphezulu kwegama eliphambili, le nkqubo iya kubonelela ngemvume kwakhona.



6. Emva koko, sibuyele kwifestile yokugcina ifayile kwakhona. Apha, ukuba unqwenela, utshintshe igama layo kwaye ubone isikhombisi apho iya kuba khona. Xa yonke le nto yenziwe, cofa iqhosha u "Gcina".

Ke siyikhusele ifayile ye-Excel. Ngoku iyakuthatha iiphasiwedi ezifanelekileyo ukuze ivule kwaye ihlele.

Indlela yesi-2: Ukuseta iphasiwedi kwicandelo "Iinkcukacha"

Indlela yesibini ibonisa ukufakwa kwegama eliyimfihlo kwiCandelo le-Excel "

1. Njengexesha lokugqibela, yiya kwi "Ifayile" yethebhu.
2. Kwicandelo "Iinkcukacha", cofa kwiqhosha "lokukhusela". Uluhlu lokhetho olunokwenzeka lokukhusela iqhosha lefayile livula. Njengoko ubona, ungayikhusela ipassword hayi ifayile kuphela, kodwa nephepha elahlukileyo, kunye nokuseka ukhuseleko kwiinguqu zencwadi.



3. Ukuba simisa into ethi "Iphasiwedi yePalamente ye-Eineplas", iwindow iya kuvulwa apho kufuneka ifakwe khona igama eliphambili. Le password idibana neqhosha lokuvula incwadi esiyisebenzisileyo kwindlela yangaphambili ngelixa sigcina ifayile. Emva kokungena kwidatha, cinezela iqhosha u "Kulungile". Ngoku, ngaphandle kokwazi isitshixo, akukho fayile akukho mntu unokuvula.



4. Xa ukhetha "ukukhusela inqaku langoku", iwindow iya kuvula ngenani elikhulu leseto. Kukho ne-passwomp yokufaka iwindows. Esi sixhobo sikuvumela ukuba ukhusele iphepha elithile kuhlelo. Kwangelo xesha, ngokuchasene nokukhusela kwiinguqu ngogcino, le ndlela ayiboneleli ngokukwazi ukudala ikopi eguqulweyo yephepha. Zonke iintshukumo zivaliwe kuyo, nangona i-jikelele inokuthi igcinwe.

   Useto lomgangatho wokukhusela Umsebenzisi unokuzibeka ngokwakhe, eveza iibhokisi zokutshekisha kwizinto ezithile. Ngokungagqibekanga, kuwo onke amanyathelo omsebenzisi ongenayo i-password, efumaneka kwiphepha kuphela kukhetho lweeseli. Kodwa, umbhali woxwebhu unokuvumela ukufomatha, ukufaka nokususa imigca kunye neekholamu, ukuhlelwa, ukusebenzisa i-Autofilter, utshintsho kwizicatshulwa, njl njl. Ungasusa ukhuseleko malunga naliphi na inyathelo. Emva kokubeka useto, cofa kwiqhosha "Kulungile".



5. Xa ucofa kwi-"Khusela ubume bencwadi" Into, ungazibeka ukhuselo lwesakhiwo soxwebhu. Useto lubonelela ngebhloko yotshintsho kwisakhiwo, zombini ngephasiwedi kwaye ngaphandle kwawo. Kule meko, le yinto ebizwa ngokuba "kukhuseleko lwesinyabi", oko kukuthi, kwizenzo ezingacacanga. Kwicala lesibini, le sele ikhuselwe kuxwebhu olujolisiweyo lutshintsho lwabasebenzisi.

Indlela 3: Ukufakwa kwegama eligqithisiweyo kunye nokususwa kwayo kwi "phononongo" ithebhu

Ukukwazi ukufaka iphasiwedi ikhoyo kwi "phononongo" ithebhu.

1. Yiya kule thebhu ingentla.



2. Sikhangela isixhobo sokutshintsha ibhloko ye-tape. Cofa kwiqhosha "lokukhusela igqabi", okanye "khusela incwadi". La maqhosha ahambelana ngokupheleleyo nezinto "zokukhusela iphepha langoku" kwaye "ukukhusela icandelo lencwadi" kwicandelo "leLwazi esilithethileyo ngaphezulu. Ezinye iintshukumo ziyafana.



3. Ukwenzela ukususa iphasiwedi, kufuneka ucofe iqhosha elithi "Susa ukhuseleko lwe-FAF" kwi-tepi kwaye ufake igama eliphambili elifanelekileyo.

Njengoko ubona, iMicrosoft Excel ibonelela ngeendlela ezininzi zokukhusela ifayile ngegama eligqithisiweyo, ukusuka ekuqubeni ngabom, kunye nezenzo ezingacacanga. Ungadlula ekuvulekeni kwencwadi kunye nokuhlela okanye ukutshintsha izinto zayo zolwakhiwo. Kwangelo xesha, umbhali unokuthi azimisele ngokwakhe, apho ufuna ukukhusela uxwebhu.