Mukati
Mamwe maspredishiti eMicrosoft Excel anofanirwa kuchengetedzwa kubva pakuona maziso, semuenzaniso, izvi zvinobatsira kune zvinyorwa zvine data rebhajeti. Pane njodzi yekurasikirwa kwedata netsaona mumatafura anotungamirwa nevanhu vakati wandei, uye kudzivirira izvi kuti zvisaitike, unogona kushandisa yakavakirwa-mukati kudzivirira. Ngationgororei zvese zvingaita zvekuvharisa kuwana magwaro.
Kuisa password yemashizha nemabhuku
Pane nzira dzakawanda dzekuchengetedza gwaro rose kana zvikamu zvaro - mapepa. Ngatikurukurei mumwe nomumwe wavo nhanho nhanho. Kana iwe uchida kuzviita kuitira kuti password yekukurumidza ioneke paunovhura gwaro, iwe unofanirwa kuseta iyo kodhi kana iwe uchinge wachengeta faira.
- Vhura iyo "Faira" menyu tebhu uye tsvaga "Save As" chikamu. Iyo ine "Bhurawuza" sarudzo, uye ichadikanwa kuseta password. Mune shanduro dzechinyakare, kudzvanya pakanzi "Save As" kunobva kwavhura hwindo rekutarisa.
- Kana hwindo rekuchengetedza richionekwa pachiratidziri, unofanirwa kuwana chikamu che "Tools" pazasi. Vhura iyo uye sarudza iyo "General Options" sarudzo.
- The General Options hwindo rinokutendera kuti udzivise kupinda kune gwaro. Unogona kuseta mapassword maviri - kuona faira uye kushandura zvirimo. Kuwana Kuverenga Chete kunosetwa senzira inodiwa kupinda nepahwindo rimwe chete. Zadza minda yekupinda password uye tinya bhatani rekuti "OK" kuchengetedza shanduko.
- Tevere, iwe uchafanirwa kusimbisa mapassword - zvakare pinda iwo muchimiro chakakodzera. Mushure mekudzvanya bhatani rekuti "Zvakanaka" muhwindo rekupedzisira, gwaro richadzivirirwa.
- Inosara chete kuchengetedza faira, mushure mekuisa mapassword chirongwa chinodzosera mushandisi kuhwindo rekuchengetedza.
Nguva inotevera paunovhura bhuku rebasa reExcel, hwindo rekupinda password richaonekwa. Kana macode maviri akaiswa - kuona uye kuchinja - musuwo unoitika mumatanho maviri. Hazvifanirwe kuisa yechipiri password kana iwe uchingoda kuverenga gwaro.
Imwe nzira yekudzivirira gwaro rako kushandisa maficha ari muInfo chikamu.
- Vhura iyo "Faira" tebhu uye uwane iyo "Details" chikamu mairi. Imwe yezvisarudzo zvechikamu ndeye "Mvumo".
- Menyu yemvumo inovhurwa nekudzvanya pakanzi "Protect Book". Chinhu chechipiri pane chinyorwa chinodiwa - "Encrypt nepassword". Sarudza iyo kuseta kodhi yekuwana.
- Isa password nyowani mu encryption box. Tevere, iwe uchafanirwa kuisimbisa muhwindo rimwechete. Pakupedzisira, tinya bhatani "OK".
Teerera! Iwe unogona kunzwisisa kuti sarudzo inogoneswa neorenji furemu inotenderedza chikamu che "Mvumo".
Kuisa password yemasero ega
Kana iwe uchida kuchengetedza mamwe maseru kubva pakuchinja kana kudzima ruzivo, password encryption ichabatsira. Seta dziviriro uchishandisa "Protect Sheet" basa. Inoshanda pane pepa rose nekukasira, asi mushure mekuchinja kudiki muzvigadziriso inongotarisa chete pane inodiwa masero.
- Sarudza pepa uye tinya-kurudyi pairi. Menyu ichaonekwa iyo yaunoda kuwana iyo "Format Cells" basa uye sarudza iyo. Hwindo rezvirongwa richavhurika.
- Sarudza iyo "Kudzivirirwa" tebhu pahwindo rinovhurwa, pane mabhokisi maviri ekutarisa. Izvo zvinodiwa kuti usarudze hwindo repamusoro - "Sero rakadzivirirwa". Sero parizvino harina kuchengetedzwa, asi harina kuchinjwa kana password yaiswa. Zvadaro, tinya "OK".
- Isu tinosarudza maseru anoda kuchengetedzwa, uye kuita reverse chiito. Iwe unofanirwa kuvhura iyo "Format masero" zvakare uye tarisa bhokisi "Yakachengetedzwa cell".
- Mu "Ongorora" tab pane bhatani "Chengetedza pepa" - tinya pairi. Hwindo rinovhurika netambo yepassword uye runyoro rwemvumo. Isu tinosarudza mvumo yakakodzera - unofanirwa kutarisa mabhokisi ari padyo navo. Tevere, iwe unofanirwa kuuya nepassword yekudzima kudzivirira. Kana zvese zvaitwa, tinya "OK".
Paunenge uchiedza kushandura zviri mukati mesero, mushandisi achaona yambiro yekudzivirira uye mirairo yekubvisa dziviriro. Avo vasina password havazokwanisi kuita shanduko.
Chenjerera! Iwe unogona zvakare kuwana iyo "Chengetedza Sheet" basa mu "Faira" tab. Iwe unofanirwa kuenda kune chikamu cheruzivo uye tsvaga "Mvumo" bhatani nekiyi uye kukiya.
Kuisa password pane bhuku rekugadzirisa
Kana kuchengetedzwa kwechimiro kwakaiswa, pane akati wandei zvirambidzo pakushanda negwaro. Iwe haugone kuita zvinotevera nebhuku:
- kopi, shandura zita, bvisa mapepa mukati mebhuku;
- kugadzira mapepa;
- vhura mashizha akavanzika;
- kukopa kana kutamisa mapepa kune mamwe mabhuku ebasa.
Ngatitorei matanho mashoma ekuvharisa shanduko yemaitiro.
- Vhura iyo "Ongorora" tebhu uye tsvaga iyo "Chengetedza bhuku" sarudzo. Iyi sarudzo inogonawo kuwanikwa mu "Faira" tab - iyo "Details" chikamu, iyo "Mvumo" basa.
- Iwindo rinovhurika nesarudzo yekudzivirira uye munda wekuisa password. Isa tiki padivi peshoko rekuti "Chimiro" uye uuye nepassword. Pashure paizvozvo, unofanira tinya "OK" bhatani.
- Isu tinosimbisa password, uye chimiro chebhuku chinochengetedzwa.
Maitiro ekubvisa password muExcel document
Unogona kukanzura kuchengetedzwa kwegwaro, maseru kana bhuku rebasa panzvimbo imwechete payakaiswa. Semuenzaniso, kubvisa password kubva mugwaro uye kudzima kurambidzwa kwekuchinja, vhura iyo yekuchengetedza kana encryption hwindo uye bvisa mitsara nemapassword akatsanangurwa. Kuti ubvise mapassword kubva pamashiti nemabhuku, unofanirwa kuvhura iyo "Ongorora" tab uye tinya pane mabhatani akakodzera. Hwindo rakanzi "Bvisa dziviriro" richaonekwa, richida kuti iwe uise password. Kana iyo kodhi yakarurama, kuchengetedzwa kunodonha uye zviito nemasero uye mapepa zvichazaruka.
Zvinokosha! Kana password yarasika, haigone kudzoserwa. Iyo purogiramu inogara ichinyevera pamusoro peizvi paunenge uchiisa makodhi. Muchiitiko ichi, masevhisi echitatu achabatsira, asi kushandiswa kwavo hakusi kwakachengeteka nguva dzose.
mhedziso
Kudzivirirwa kwakavakirwa-mukati kwegwaro reExcel kubva pakugadzirisa kwakavimbika - hazvigoneke kudzoreredza password, inoendeswa kune vanhu vanovimbwa kana inoramba iine mugadziri wetafura. Izvo zviri nyore zvekudzivirira mabasa ndezvekuti mushandisi anogona kudzora kupinda kwete chete patafura yese, asiwo kune ega maseru kana kugadzirisa chimiro chebhuku.