Tsare fayil ɗin Excel

Sanya kariya a kan fayilolin Excel hanya ce mai kyau don kare kanka, duka daga masu kutse da kuma daga kuskuren ayyukanku. Matsalar ita ce ba duk masu amfani ba ne suke sanin yadda zasu buɗe, idan ya cancanta, don samun damar shirya littafin ko ma kawai duba abubuwan da ke ciki. Tambayar ita ce mafi dacewa idan mai amfani da kalmar sirri ba saita kansa ba, amma ta wani mutumin da ya fassara kalmar lambar, amma mai amfani da ƙwarewa bai san yadda ake amfani da shi ba. Bugu da kari, akwai maganganun asarar kalmar sirri. Bari mu bincika yadda zaku iya cire kariyar daga takaddar Excel idan ya cancanta.

Darasi: Yadda za a cire kariya daga takaddar Microsoft Word

Hanyar buɗewa

Akwai nau'ikan kulle fayil guda biyu na Excel: Kariyar littafin da kariyar takardar. Dangane da haka, algorithm mai buɗewa ya dogara da wacce aka zaɓi hanyar kariyar.

Hanyar 1: buɗe littafin

Da farko dai, nemo yadda ake cire kariya daga littafin.

1. Lokacin da kake ƙoƙarin gudanar da fayil mai kariya mai kariya, ƙaramin taga yana buɗe don shigar da kalmar lamba. Ba za mu iya buɗe littafin ba har sai mun nuna shi. Don haka, shigar da kalmar wucewa a cikin filin da ya dace. Latsa maɓallin "Ok".



2. Bayan wannan, littafin ya buɗe. Idan kana son cire kariya gaba daya, to kaje ga shafin Fayiloli.



3. Mun matsa zuwa sashin "Cikakkun bayanai". A tsakiyar ɓangaren taga, danna maballin Kare Littattafai. A cikin jerin zaɓi, zaɓi "A rufa tare da kalmar sirri".



4. Kuma sake taga yana buɗe tare da kalmar lamba. Kawai share kalmar sirri daga filin shigar da danna kan "Ok" button



5. Ajiye canje-canje fayil ta zuwa shafin "Gida" ta danna maballin Ajiye a cikin hanyar diskette a saman kusurwar hagu na taga.

Yanzu idan ka buɗe littafin, ba za ka buƙaci shigar da kalmar wucewa ba kuma ba za a sami kariya ba.

Darasi: Yadda za a sanya kalmar sirri a fayil ɗin Excel

Hanyar 2: Buɗe Sheet

Bugu da kari, zaku iya saita kalmar sirri a takarda daban. A lokaci guda, zaku iya buɗe littafin har ma duba bayani akan takarda da aka kulle, amma ba za ku iya canza sel a ciki ba. Lokacin da kake ƙoƙarin shirya, saƙo ya bayyana a cikin akwatin tattaunawa yana sanar da kai cewa an kare sel daga canje-canje.

Domin samun damar gyarawa da cire kariya gaba daya daga takarda, zaku aiwatar da jerin ayyuka.

1. Je zuwa shafin "Duba". A kan kintinkiri a cikin akwatin kayan aiki "Canza" danna maballin "Cire kariyar takardar".



2. A taga yana buɗewa a cikin filin wanda kake son shigar da kalmar wucewa. Saika danna maballin "Ok".

Bayan haka, za a cire kariyar kuma mai amfani zai iya shirya fayil ɗin. Don kare sake amfani da takardar, za ku sake saita kariya ta sake.

Darasi: Yadda za a kare kwayar halitta daga canje-canje a cikin Excel

Hanyar 3: cire kariya ta canza lambar fayil

Amma, wani lokacin akwai wasu lokuta lokacin da mai amfani ya rufa takarda tare da kalmar sirri, don kada ya yi canje-canje da gangan ba, amma ba zai iya tuna cipher din ba. Babu shakka abin takaici ne cewa, a matsayinka na mai mulki, ana shigar da fayiloli tare da bayanai masu mahimmanci kuma asarar kalmar sirri a gare su na iya cin kuɗi mai yawa ga mai amfani. Amma, akwai wata hanyar fita ko da wannan halin. Gaskiya ne, dole ne ku ɗanɗana lambar sirri.

1. Idan fayil dinka yana da tsawo xlsx (Jagoran aikin Excel), sannan ka tafi kai tsaye zuwa sakin layi na uku na umarnin. Idan tsawaita shi xls (Excel Book 97-2003), to ya kamata a sake karanta shi. An yi sa'a, idan kawai takaddar takarda ce, kuma ba littafin gaba ɗaya ba, zaku iya buɗe takaddar ku adana ta kowace hanya mai sauƙi. Don yin wannan, je zuwa shafin Fayiloli kuma danna abun "Ajiye As ...".



2. Wurin ajiyewa yana buɗewa. Da ake bukata a cikin siga Nau'in fayil saita darajar Littafin aikin kwarai maimakon "Kundin littafi mai kyau 97-2003". Latsa maballin "Ok".



3. Littafin xlsx da gaske zikirin zip ne. Muna buƙatar shirya ɗayan fayiloli a cikin wannan adabin. Amma don wannan nan da nan za ku buƙaci canza tsawo daga xlsx zuwa zip. Tafi cikin mai binciken zuwa kundin rumbun kwamfutarka wanda takaddar ke ciki. Idan ba a gan saurin fayil ɗin ba, to sai a danna maballin Tace a cikin ɓangaren sama na taga, zaɓi abu a cikin jerin zaɓi Jaka da Zaɓuɓɓukan Bincike.



4. Zaɓuɓɓukan babban fayil ɗin buɗe. Je zuwa shafin "Duba". Muna neman abu "Ideoye kari don nau'in fayil ɗin rijista". Cire shi kuma danna maballin "Ok".



5. Kamar yadda kake gani, bayan waɗannan ayyuka, idan ba a nuna tsawaita ba, to ya bayyana. Danna-dama kan fayil ɗin kuma zaɓi abu a cikin mahallin mahallin da ke bayyana Sake suna.



6. Canja tsawo tare da xlsx a kunne zip.



7. Bayan an gama sake sunan, Windows ya hango wannan takaddar a matsayin wani kayan tarihi kuma zaka iya bude shi ta amfani da mai binciken daya. Mun danna sau biyu akan wannan fayil din.



8. Je zuwa adireshin:

   file_name / xl / worksheets /

   Fayiloli tare da tsawo xml Wannan jagorar ta ƙunshi bayani game da zanen gado. Mun buɗe farkon su tare da taimakon kowane editan rubutu. Kuna iya amfani da ginanniyar Windows Notepad don waɗannan dalilai, ko zaka iya amfani da ingantaccen shiri, misali, Notepad ++.



9. Bayan shirin ya buɗe, sai mu buga a kan gajeriyar hanyar keyboard Ctrl + Ffiye da kiran binciken aikace-aikacen ciki. Muna tuka cikin magana akwatin nema:

   takwarastI

   Muna nemansa a cikin rubutun. Idan ba mu same shi ba, to, buɗe fayil na biyu, da sauransu. Muna yin wannan har sai an samo kashi. Idan ana kiyaye ayyukan aikin Excel da yawa, to, abin da ke cikin zai kasance cikin fayiloli da yawa.



10. Bayan an gano wannan abun, share shi tare da dukkan bayanan daga alamar budewa zuwa rufewa. Adana fayil ɗin kuma rufe shirin.



11. Mun koma ga inda aka ajiye kayan tarihin sannan kuma a sake canza shi daga zip zuwa xlsx.

Yanzu, don shirya takaddar Excel, ba kwa buƙatar sanin kalmar wucewa ta mai amfani.

Hanyar 4: yi amfani da aikace-aikace na ɓangare na uku

Bugu da kari, idan kun manta kalmar lambar, to za a iya cire kulle ta amfani da aikace-aikacen ɓangare na musamman. A lokaci guda, zaka iya share kalmar wucewa gaba ɗaya daga takaddarar da ta kare da duka fayil. Daya daga cikin shahararrun aikace-aikace a wannan yankin shine Yarda da izinin KUDI kalmar sirri. Yi la'akari da tsarin don sake saita kariya ta amfani da misalin wannan mai amfani.

Zazzage Sifin Kashe Sakon kalmar sirri daga wurin aikin

1. Mun ƙaddamar da aikace-aikacen. Danna kan abun menu Fayiloli. A cikin jerin zaɓi, zaɓi matsayi "Bude". Madadin waɗannan ayyuka, za ku iya kawai buga gajeran hanya a kan keyboard Ctrl + O.



2. Ana buɗe taga bincika fayil ɗin. Tare da shi, za mu je kan jagora inda littafin aikin Excel da muke buƙata ya kasance, wanda kalmar ɓace kalmar sirri ta ɓace. Zaɓi shi kuma danna maballin. "Bude".



3. Maganganar dawo da kalmar sirri ta buɗe, wanda ke bayar da rahoton cewa an kiyaye fayil ɗin kalmar sirri. Latsa maɓallin "Gaba".



4. Sannan menu ya buɗe acikin abin da dole ku zaɓi bisa ga wanne yanayin za'a cire kariyar. A mafi yawan lokuta, mafi kyawun zaɓi shine barin saitunan tsoho kuma kawai idan akwai kasawa kayi ƙoƙarin canza su akan ƙoƙari na biyu. Latsa maballin Anyi.



5. Tsarin kalmar wucewa yana farawa. Zai iya ɗaukar tsawan lokaci mai tsawo, dangane da hadadden kalmar lambar. Za'a iya lura da kuzari na tsari a ƙasan taga.



6. Bayan an gama lissafin bayanai, za a nuna wani taga wanda za'a rubuta kalmar sirri mai inganci. Dole ne kawai ku kunna fayil ɗin Excel a yanayin al'ada kuma shigar da lambar a filin da ya dace. Nan da nan bayan wannan, za a buɗe kariyar maƙunsar ta Excel.

Kamar yadda kake gani, akwai hanyoyi da yawa don cire kariya daga takaddar Excel. Dole ne mai amfani ya zabi wanda zai yi amfani da shi dangane da nau'in toshewa, daidai gwargwadon ikonsa da yadda yake hanzarin samun sakamako mai gamsarwa. Hanya don cire kariya ta amfani da editan rubutu yana da sauri, amma yana buƙatar ɗan sani da ƙoƙari. Yin amfani da shirye-shirye na musamman na iya buƙatar lokaci mai mahimmanci, amma aikace-aikacen yana yin kusan komai da kansa.