Cire kariya daga fayil ɗin Excel

Shigar da kariya a fayiloli Excel shine hanya mai kyau don kare kanku daga masu ɓoyewa biyu da kuma ayyukanku mara kyau. Matsalar ita ce ba duka masu amfani sun san yadda za a cire kulle ba, don haka idan ya cancanta, iya gyara littafin ko ko da kawai duba abinda yake ciki. Tambayar ita ce mafi mahimmanci idan kalmar sirri ba ta mai amfani da kansa ba, amma ta wani mutumin da ya aika kalmar kalmar, amma mai amfani ba shi da sanin yadda za a yi amfani da shi. Bugu da ƙari, akwai lokuta na asarar kalmar sirri. Bari mu gano yadda, idan ya cancanta, cire kariya daga takardun Excel.

Darasi: Yadda za a kare wani asusun Microsoft Word

Hanyoyi don buɗewa

Akwai nau'i nau'i na nau'i na Excel guda biyu: kariya ga littafi da kariya ga takardar. Sabili da haka, algorithm na cirewa ya dogara ne akan yadda aka zaɓi kariya.

Hanyar 1: buše littafin

Da farko, gano yadda za'a cire kariya daga littafin.

1. Lokacin da kake ƙoƙarin gudu fayil ɗin Excel kare, ƙananan taga yana buɗewa don shigar da kalmar kalma. Ba za mu iya bude littafin ba sai mun saka shi. Don haka, shigar da kalmar sirri a filin da ya dace. Danna maballin "OK".



2. Bayan haka littafin ya buɗe. Idan kana so ka cire kariya gaba daya, je shafin "Fayil".



3. Matsar zuwa sashe "Bayanai". A tsakiyar ɓangaren taga danna maballin. "Kare littafin". A cikin menu mai saukarwa, zaɓi abu "Ƙaddamar da kalmar sirri".



4. Bugu da sake taga yana buɗewa tare da kalmar kalma. Kawai cire kalmar sirri daga filin shigar kuma danna maballin "Ok"



5. Ajiye canje-canjen fayilolin ta hanyar zuwa shafin "Gida" danna maɓallin "Ajiye" a cikin nau'i na floppy disk a kusurwar hagu na taga.

Yanzu, lokacin bude littafin, bazai buƙatar shigar da kalmar sirri ba kuma zai daina kiyaye shi.

Darasi: Yadda za a sanya kalmar sirri a kan wani takardar Excel

Hanyar 2: buše takarda

Bugu da ƙari, za ka iya saita kalmar sirri a kan takardar raba. A wannan yanayin, za ka iya bude littafi kuma koda duba bayani game da takarda rufe, amma canzawa cikin jikin ba zai sake aiki ba. Lokacin da kake kokarin shirya, sakon yana bayyana a cikin akwatin maganganun da ke sanar da kai cewa ana kiyaye kodin daga canje-canje.

Domin samun damar gyara kuma cire gaba ɗaya daga kariya, za kuyi jerin ayyukan.

1. Jeka shafin "Binciken". A tef a cikin asalin kayan aiki "Canje-canje" danna maballin "Shafin takarda".



2. Fila yana buɗewa a filin da kake buƙatar shigar da kalmar sirrin saiti. Sa'an nan kuma danna maballin "Ok".

Bayan haka, za'a kare kariya kuma mai amfani zai iya shirya fayil din. Don kare takardar, za ku sake shigar da kariya ta sake.

Darasi: Yadda za a kare cell daga canje-canje a Excel

Hanyar 3: Dakatar da sauya lambar fayil ɗin

Amma, wani lokacin lokuta akwai lokuta idan mai amfani ya ɓoye takarda tare da kalmar sirri, don haka kada ya yi canji a kansa, amma ba zai iya tunawa da cipher ba. Abin takaici ne ƙwarai, cewa, a matsayin mai mulkin, fayiloli da bayanai mai mahimmanci suna ƙulla da kuma rasa kalmar sirri zuwa gare su zai iya zama mai tsada ga mai amfani. Amma akwai hanya ta fita daga wannan matsayi. Tabbatacce, lallai ya zama dole don tinker tare da lambar rubutu.

1. Idan fayil din yana da tsawo xlsx (Littafin littafin Excel), sa'an nan kuma kai tsaye zuwa sakin layi na uku na umarnin. Idan tsawo xls (Excel 97-2003 littafi), to, ya kamata a sake mayar da shi. Abin farin ciki, idan kawai takardar da aka ɓoye, ba littafin duka ba, za ka iya buɗe takardun kuma ajiye shi a kowane tsarin da ake samuwa. Don yin wannan, je shafin "Fayil" kuma danna abu "Ajiye Kamar yadda ...".



2. A ajiye taga yana buɗewa. Da ake nema a saiti "Nau'in fayil" saita darajar "Littafin littafin Excel" maimakon "Ayyukan 97-2003". Muna danna maɓallin "Ok".



3. Littafin xlsx shine ainihin tashar zip. Muna buƙatar gyara ɗaya daga cikin fayiloli a wannan tarihin. Amma saboda wannan zaka buƙatar sau da sauri canza tsawo daga xlsx zuwa zip. Muna wucewa ta hanyar mai bincike a kan jagorancin rumbun da aka ajiye takardun. Idan kariyar fayiloli ba a bayyane ba, sannan danna maballin. "A ware" A saman taga, a menu mai sauke, zaɓi abu "Zabuka da zaɓin bincike".



4. Zaɓin zaɓi na babban fayil ya buɗe. Jeka shafin "Duba". Neman abu "Ɓoye kari don nau'in fayil ɗin rijista". Bude shi kuma danna maballin. "Ok".



5. Kamar yadda kake gani, bayan waɗannan ayyukan, idan ba a nuna tsawo ba, ya bayyana. Mun danna kan fayil ɗin tare da maɓallin linzamin linzamin dama kuma a cikin yanayin mahallin da aka bayyana mun zaɓi abu Sake suna.



6. Canja tsawo tare da xlsx a kan zip.



7. Bayan da aka sake yin suna, Windows ta lura da wannan takarda a matsayin littafi kuma ana iya buɗewa ta hanyar amfani da wannan mai bincike. Danna wannan fayil ɗin sau biyu.



8. Je zuwa adireshin:

   filename / xl / worksheets /

   Fayiloli da tsawo xml a cikin wannan shugabanci yana dauke da bayani game da zanen gado. Bude na farko da kowane editan rubutu. Zaka iya amfani da Windows Notepad da aka gina a cikin waɗannan dalilai, ko zaka iya amfani da shirin ci gaba, misali, Notepad ++.



9. Bayan da shirin ya buɗe, muna buga maɓallin haɗin haɗin kan keyboard Ctrl + FAbin da ke sa bincike na ciki don aikace-aikacen. Muna fitarwa a cikin sashin binciken bincike:

   sheetProtection

   Muna neman shi a cikin rubutun. Idan ba a samu ba, to bude bude fayil na biyu, da dai sauransu. Yi haka har sai an samo abu. Idan ana adana nau'in fom na Excel, abu zai kasance cikin fayiloli masu yawa.



10. Bayan an samo wannan kashi, share shi tare da duk bayanan daga alamar budewa zuwa alama ta ƙarshe. Ajiye fayil kuma rufe shirin.



11. Komawa zuwa wurin wurin ginin ajiyar kuma sake canza tsawo daga zip zuwa xlsx.

Yanzu, don shirya takardar Excel, ba ka buƙatar sanin kalmar sirri wanda mai amfani ya manta ba.

Hanyar 4: Yi amfani da Aikace-aikace na Ƙungiyoyin Uku

Bugu da ƙari, idan kun manta da kalmar kalmar, to sai a cire kulle ta amfani da aikace-aikace na ɓangare na uku. A wannan yanayin, zaka iya share kalmar sirri daga duka takardun kare da duk fayil. Ɗaya daga cikin shahararren aikace-aikace a wannan yanki shine Ƙara Sabuntawar Kuskuren OFFICE. Yi la'akari da hanya don sake saita kariya akan misalin wannan mai amfani.

Sauke Karin Takaddun Kalmar Ɗabiyar Kasuwancin OFFICE daga shafin yanar gizon.

1. Gudun aikace-aikacen. Danna maɓallin menu "Fayil". A cikin jerin layi, zaɓi matsayi "Bude". Maimakon waɗannan ayyuka, zaka iya kawai rubuta hanyar gajeren hanya Ctrl + O.



2. Maɓallin bincika fayil ya buɗe. Tare da taimakonsa, je zuwa shugabanci inda ake buƙatar littafin littafin Excel na buƙata, wanda kalmar kalmar sirri ta ɓace. Zaɓi shi kuma danna maballin. "Bude".



3. Wizard na Farfadowa na Sabunta ya buɗe, wanda ya nuna cewa fayil yana kare kalmar sirri. Muna danna maɓallin "Gaba".



4. Sa'an nan kuma zaɓin menu ya buɗe inda za ka zabi abin da yanayin kariya za a buɗe. A mafi yawancin lokuta, mafi kyawun zaɓi shine barin barin saitunan tsoho kuma kawai idan akwai rashin cin nasara kokarin canza su a ƙoƙari na biyu. Muna danna maɓallin "Anyi".



5. Hanyar zaɓin kalmomin shiga farawa. Zai iya ɗaukar lokaci mai tsawo, dangane da ƙwarewar kalmar kalmar. Za'a iya lura da yanayin da ake gudanarwa a kasa na taga.



6. Bayan binciken bincike ya ƙare, za a nuna wani taga wanda za'a yi rikodin kalmar sirri mai amfani. Kuna buƙatar tafiyar da fayil na Excel a yanayin al'ada kuma shigar da lambar a filin da ya dace. Nan da nan bayan haka, za a buɗe maƙunsar Bayar da Excel.

Kamar yadda kake gani, akwai hanyoyi da yawa don cire kariya daga Excel. Wanne daga cikinsu mai amfani ya kamata ya yi amfani da shi, dangane da nau'in katangewa, da kuma matakin da ya iya kwarewa da yadda sauri ya so ya sami sakamako mai kyau. Hanya don karewa ta amfani da editan rubutu yana da sauri, amma yana buƙatar wasu sani da ƙoƙari. Yin amfani da shirye-shirye na musamman na iya buƙatar lokaci mai mahimmanci, amma aikace-aikacen ya kusan kusan komai.