Maitiro ekubvisa dziviriro neExcel faira: 4 proven nzira

Kuisirwa kuchengetedzwa kwekunyorera mafaera inzira huru yekuzvidzivirira iwe, zvese kubva kune vanopinda uye kubva pane zvako zvisirizvo. Kune marudzi maviri efaira anovhara Excel: dziviriro pane bhuku uye dziviriro pane pepa. Saizvozvo, kusunungura algorithm kunoenderana nenzira iyo nzira yekudzivirira yakasarudzwa.

Chidzidzo: Maitiro Ekubvisa Kudzivirirwa kubva kuMicrosoft Izwi

Vhidhiyo Dzidziso

Nzira 1: Vhura Mabhuku

Chekutanga pane zvese, tsvaga nzira yekubvisa kudzivirira nebhuku racho.

1. Paunoyedza kutanga faira yakachengeteka, Excel inovhura hwindo diki yekupinda iyo kodhi izwi. Hatizokwanise kuvhura bhuku racho kudzamara tirondedzere. Saka, isa password kune iyo inoenderana munda. Dzvanya pane "OK" bhatani.



2. Mushure meizvozvo, bhuku iri rinovhura. Kana iwe uchida kubvisa zvachose kuchengetedzwa, wobva waenda ku "Faira" tab.



3. Isu tinoenda kune "ruzivo" chikamu. Muchikamu chepakati chehwindo isu tinodzvanya pane "chengetedza bhuku" bhatani. Mukudonha-pasi menyu, sarudza iyo "encrypt password" chinhu.



4. Iyo hwindo rinovhura neiyo kodhi izwi. Ingodzima password kubva kune iyo Input shamba uye tinya pane "OK" bhatani



5. Sevha iyo faira inoshanduka nekudzvanya pane iyo "Imba" Tab nekudzvanya pane "Sevha" bhatani sekona yeFloppy mukona yekuruboshwe yepahwindo.

Zvino, kana uchivhura bhuku, hauzofaniri kupinda mupassword uye ichapera kudzivirirwa.

Chidzidzo: Maitiro ekuisa password kune iyo Excel faira

Nzira 2: Vhura Sheet

Mukuwedzera, iwe unogona kuseta password kune yakaparadzana pepa. Panguva imwecheteyo, iwe unogona kuvhura bhuku uye ukaona ruzivo pane rakavharidzirwa pepa, asi hazviiti kuchinja masero mariri. Paunoyedza kurongedza, meseji inoonekwa mune dialog bhokisi iyo inozivisa kuti sero rinodzivirirwa kubva mukuchinja.

Kuti uwane sarudzo yekugadzirisa uye kubvisa zvizere dziviriro kubva papepa, iwe uchafanirwa kuita zviito zvinoverengeka.

1. Enda kune "ongororo" tab. Pane ribbon mune "shanduko" chishandiso block, tinodzvanya pane "Bvisa pepa dziviriro" bhatani.



2. Iyo hwindo rinovhura, mumunda waunoda kuisa iyo seti password. Wobva wadzvanya pane "OK" bhatani.

Mushure meizvozvo, kuchengetedzwa kuchabviswa uye mushandisi achakwanisa kugadzirisa iyo faira. Kuti udzivirire pepa zvakare, iwe uchafanirwa kuiisa zvakare.

Chidzidzo: Maitiro ekuchengetedza iyo sero kubva pakushanduka kuExcel

Nzira 3: Kubvisa Dziviriro Kupfuura Kuchinja Iyo Faira Code

Asi, dzimwe nguva pane zviitiko apo mushandisi akanyorwazve papepa password kuti urege kuita shanduko kwazviri, asi haugone kurangarira cipher. Izvo zvinokatyamadza mafaera ayo mafaera ane ruzivo rwakakosha uye kurasikirwa password kunogona kudhura kuti uite mushandisi. Asi, pane nzira yekubuda nayo kubva pachinzvimbo ichi. Chokwadi, iwe unofanirwa kusekerera nekodhi yegwaro.

1. Kana faira rako riine XLSX (BHUKU RINOGONA), wobva wangoenda kukamba yechitatu yemirayiridzo. Kana yayo xls yekuwedzera (Bhuku reKexcelbook 97-2003), zvinofanirwa kudzokororwa. Neraki, kana chete pepa rakanyorwa, kwete bhuku rese, unogona kuvhura gwaro uye chengetedza mune chero chimiro chinowanikwa. Kuti uite izvi, enda ku "Faira" tab uye tinya pa "Chengetedza se ...".



2. Iyo windows inovhura. Zvinosungirwa mu "faira rerudzi" paramende seta kukosha "Excel bhuku rinoti" panzvimbo pe "Bhuku Excel 97-2003". Dzvanya pane "OK" bhatani.



3. Iyo XLLSX BHUKU Icho chinonyanya kugovera zip? Isu tichazoda kurongedza imwe yemafaira ekuchengetedza uku. Asi nekuda kwekudaro pakarepo vanoda kuchinja kuwedzera ne xLLX pa zip. Enda kuburikidza ne conductor kune iyo dhairekitori yeiyo hard disk mune iyo gwaro racho iri. Kana iyo faira yekuwedzera isingaonekwe, wobva wadzvanya pane "Sort" bhatani kumusoro kwewindo, sarudza iyo "folda uye yekutsvaga paramende" chinhu mune yakavhurika menyu.



4. Iyo folda parameter hwindo rinovhura. Enda kune "maonero" tab. Tiri kutsvaga chinhu "kuviga extensions yemhando dzakanyoreswa faira". Bvisa bhokisi rekutarisa kubva pairi uye tinya pane "OK" bhatani.



5. Sezvauri kuona, mushure meizvi zviito, kana iyo yekuwedzera isina kuratidzwa, yaonekwa. Dzvanya pane iyo faira kurudyi-tinya uye mune yakaonekwa mamiriro menyu, sarudza iyo "rezita" chinhu "chinhu.



6. Chinja kuwedzera ne xlsx pane zip.



7. Mushure mekumisikidzwa kugadzirwa, windows inoona gwaro iri sechigadziriso uye rinogona kungova rakavhurika uchishandisa mutungamiriri mumwechete. Gadzira mbeva mbiri tinya pane ino faira.



8. Enda kukero:

   Faira Izita / XL / Worksheets /

   Mafaira ane XML extension mune ino dhairekitori ine ruzivo nezve mashitsi. Isu tinovhura yekutanga ine chero mavara ezvinyorwa. Unogona kushandisa iyo yakavakwa-muWindows Notepad yezvinangwa izvi, uye iwe unogona kushandisa chirongwa chakapfuura chakapfuura, chakadai se notepad ++.



9. Mushure mekunge chirongwa ichi chazarura, Type Ctrl + F Keys pane yekhibhodi pane kudana chikumbiro chemukati chekutsvaga kwemukati. Isu tinotyaira mubhokisi rekutsvaga. Kutaura:

   Sheetpretection.

   Tiri kutsvaga murugwaro. Ukasawana, tinovhura iyo yechipiri faira, nezvimwewo Isu tinodaro chero bedzi chinhu chinowanikwa. Kana akati wandei mashizha exets akachengetedzwa, chinhu chacho chichava mune akati wandei mafaera.



10. Mushure mekunge chinhu ichi chikaonekwa, chibuditsa pamwe chete neruzivo rwese kubva kune iyo yekuvhura iyo yekuvhara. Sevha iyo faira uye uvhara chirongwa.



11. Isu tinodzokera kune yakachengetwa nzvimbo dhairekitori uye shandura kuwedzera kwayo ne zip pane xlsx zvakare.

Zvino, kugadzirisa pepa rekunyorera, hauzofaniri kuziva password yakakanganikwa nemushandisi.

Nzira 4: Kushandisa yechitatu-bato application

Mukuwedzera, kana iwe wakanganwa iyo kodhi yedhedha, iyo inovhara inogona kubviswa uchishandisa nyanzvi yechitatu-bato application. Iwe unogona kudzima iyo password kubva kune yakachengetedzwa pepa uye kubva kune yakazara faira. Chimwe chezvakakurumbira zvekushandisa izvi kuenda kune accent hofisi password kupora. Funga nezve reseter reset nzira pane iyo muenzaniso yekushandiswa uku.

Dhawunirodha Accent Hofisi password Kudzoreredza kubva kunzvimbo yepamutemo

1. Mhanyisa application. Dzvanya pane iyo menyu chinhu "faira". Mukudonha-pasi rondedzero, sarudza iyo "yakavhurika" chinzvimbo. Panzvimbo peizvi zviito, iwe unogona zvakare kufona ctrl + o makiyi pane kabhodhi.



2. Bhokisi rekutsvaga faira rinovhura. Nekubatsira kwairi, enda kune dhairekitori uko bhuku reExcel bhuku raunoda rinowanikwa, iro password yakarasika. Isu tinoratidzira uye tinya pane "Vhura" bhatani.



3. Iyo password yekudzoreredza wizard inovhura, iyo inoshuma kuti faira iri password yakachengetedzwa. Dzvanya bhatani re "rinotevera".



4. Ipapo menyu inovhura menyu kuti isarudze kuti ndeapi mamiriro achabviswa. Muzhinji, sarudzo yakanyanya kunaka ndeyekubva kuZvirongwa Zvekuita uye chete kana Kutadza, edza kuzvichinja kusvika pakuedza kwechipiri. Dzvanya pane "Pedzisa" bhatani.



5. Maitiro ekusarudza mapassword anotanga. Zvinogona kutora nguva yakareba, zvichienderana nekuoma kweiyo kodhi izwi. Maitiro ekuita masimba anogona kucherechedzwa pazasi pehwindo.



6. Mushure mekunge data raputika, hwindo rinenge riratidzwe umo iyo password chaiyo ichanyorwa. Iwe unongogara uchimhanya iyo Excel faira mune yakajairika modhi uye isa kodhi mumunda unoenderana. Pakarepo mushure meizvi, tafura yekunyanyisa ichavhurwa.

Sezvauri kuona, pane nzira dzinoverengeka dzekubvisa dziviriro kubva kugwaro reExEL. Mashandisiro aunoita mushandisi anofanira kusarudza zvichienderana nerudzi rwekuvharidzira, pamwe nekumwe kweanogona kugona uye nekukurumidza kuwana mhedzisiro inogutsa. Nzira yekubvisa dziviriro uchishandisa mupepeti ane nekukurumidza, asi inoda imwe ruzivo uye kushanda nesimba. Iko kushandiswa kwezvirongwa zvinonyatsotarisirwa zvinogona kuda huwandu hwakakosha hwenguva, asi kushandiswa kwacho kunoita kuti zvese zvive zvese pachako.