Dziviriro yedata muMicrosoft Excel

Microsoft Excel inopa mushandisi ane akati wandei, ane mamiriro ekutaura, mazinga edziviriro - kubva nyore kudzivirira kwega yega maseru kune encryption yefaira rese nema ciphers e crypto-algorithms yemhuri yeRC4. Handei mavari one by one...

Level 0. Dziviriro kubva pakuisa data isiriyo musero

Nzira iri nyore. Inokutendera kuti utarise kuti chii chaizvo chinopinda mushandisi mune mamwe maseru uye hachikubvumire iwe kuisa data risingaite (semuenzaniso, mutengo wakashata kana nhamba yepakati yevanhu kana zuva reGumiguru Revolution pane zuva rekupedzisa kwe kondirakiti, nezvimwewo) Kuti uise cheki yekuisa yakadaro, unofanirwa kusarudza maseru uye wosarudza tab Data (Zuva) bhatani Kugadziriswa kwedata (Data Validation). MuExcel 2003 uye vakuru, izvi zvinogona kuitwa uchishandisa menyu Data – Validation (Data - Validation)… Mu tab Parameters kubva pane yekudonhedza pasi, unogona kusarudza mhando yedata inotenderwa kuisa:

Matebhu ari padyo nehwindo rino anobvumira (kana zvichidikanwa) kuseta mameseji anozoonekwa asati apinda - tab Isa meseji (Mharidzo yekupinda), uye kana ukaisa ruzivo rwakashata - tab Error message (Error Alert):

 Nhamba 1: Kuchengetedza Mashizha Masero kubva kune Shanduko

Tinogona kudzivirira zvachose kana kusarudza kudzivirira mushandisi kubva pakuchinja zviri mukati memasero echero pepa rakapihwa. Kuisa dziviriro yakadaro, tevera algorithm iri nyore:

1. Sarudza maseru ayo hapana chikonzero chekudzivirira (kana iripo), tinya-kurudyi pavari uye sarudza iwo murairo kubva pane zviri mukati menyu Sero format (Mafomati Masero)… Mu tab Protection (Protection) bvisa bhokisi Yakachengetedzwa sero (Yakakiiwa). Masero ese anoramba akasarudzirwa bhokisi rino achadzivirirwa kana mashizha ekudzivirira agoneswa. Masero ese ausingatarise mureza uyu anogadzirika zvisinei nekuchengetedzwa. Kuti uone kuti ndeapi masero achadzivirirwa uye asingazodaro, unogona kushandisa iyi macro.
2. Kugonesa kuchengetedza pepa razvino muExcel 2003 uye vakuru - sarudza kubva kumenyu Sevhisi - Dziviriro - Dzivirira Sheti (Zvishandiso - Dziviriro - Dzivirira pepa rebasa), kana muExcel 2007 uye gare gare, tinya Dzivirira Sheet (Chengetedza Pepa) Tab Kuongorora (Ongororo). Mubhokisi rebhokisi rinovhura, unogona kuseta password (inozodikanwa kuti pasave nemunhu anogona kubvisa dziviriro) uye, uchishandisa rondedzero yemabhokisi, gadzirisa, kana uchida, kunze:

Kureva, kana isu tichida kusiya mushandisi kugona, semuenzaniso, kufomati akachengetedzwa uye asina kudzivirirwa maseru, matatu ekutanga mabhokisi ekutarisa anofanirwa kutariswa. Iwe unogona zvakare kubvumira vashandisi kushandisa kuronga, autofilter, uye zvimwe zviri nyore tafura maturusi.

Level 2. Kusarudzwa kwekudzivirira kwezvikamu zvevashandisi vakasiyana

Kana zvichifungidzirwa kuti vashandisi vakati wandei vachashanda nefaira, uye mumwe nemumwe wavo anofanirwa kuwana nzvimbo yavo yepepa, saka unogona kuseta kuchengetedzwa kwepepa nemapassword akasiyana emhando dzakasiyana dzemasero.

Kuti uite izvi, sarudza pane tab Kuongorora (ongorora) bhatani Bvumira kuchinja mitsara (Bvumira vashandisi kugadzirisa masanji). MuExcel 2003 uye gare gare, kune menyu yekuraira kweizvi Sevhisi - Dziviriro - Bvumira kushandura masanji (Zvishandiso - Dziviriro - Bvumira vashandisi kuti vachinje marara):

Pahwindo rinoonekwa, tinya bhatani sika (nyowani) uye isa zita reiyo renji, kero dzemasero anosanganisirwa mune ino renji uye password yekuwana iyi chiyero:

Dzokorora nhanho idzi kune imwe neimwe yakasiyana-siyana yevashandisi renji kusvika ese anyorwa. Iye zvino unogona kudzvanya bhatani Dzivirira Sheet (ona ndima yapfuura) uye gonesa kuchengetedza bepa rese.

Zvino, iwe paunoyedza kuwana chero emhando dzakachengetedzwa kubva pane iyo rondedzero, Excel inoda password yeiyi siyana, kureva kuti mushandisi wega wega achashanda "mubindu rake".

Level 3. Kuchengetedza mapepa ebhuku

Kana iwe uchida kuzvidzivirira kubva kune:

• kudzima, kutumidza zita, kufambisa mapepa mubhuku rebasa
• shanduko kunzvimbo dzakapinirwa ("misoro", nezvimwewo)
• shanduko isingadikanwi yechimiro (kudonha mitsara/makoramu uchishandisa mabhatani ekuwedzera/kubvisa)
• kugona kudzikisa / kufambisa / chinja hwindo rebhuku rebasa mukati meExcel hwindo

ipapo unofanira kuchengetedza mapepa ose ebhuku, uchishandisa bhatani Dzivirira bhuku (Chengetedza Bhuku Rebasa) Tab Kuongorora (Ongororo) kana - muzvinyorwa zvekare zveExcel - kuburikidza nemenyu Sevhisi - Dziviriro - Dzivirira bhuku (Zvishandiso - Dziviriro - Dzivirira bhuku rebasa):

Level 4. Faira encryption

Kana zvichidikanwa, Excel inopa kugona kuvharidzira faira rese rebhuku rekushandisa uchishandisa akati wandei akasiyana eRC4 mhuri encryption algorithms. Kudzivirirwa uku kuri nyore kuseta kana uchichengeta bhuku rebasa, kureva sarudza zvikwata Faira - Save As (Faira - Sevha Se), uyezve pahwindo rekuchengetedza, tsvaga uye wedzera rondedzero yekudonha Basa - General Options (Zvishandiso - General Options). Muhwindo rinoonekwa, tinogona kuisa mapassword maviri akasiyana - kuvhura faira (kuverenga chete) uye kuchinja:

• Maitiro ekuseta / kusadzivirira ese mapepa ebhuku kamwechete (PLEX yekuwedzera)
• Simbisa maseru asina kudzivirirwa ane ruvara
• Kudzivirirwa kwakaringana kwemashizha nema macro