Nzira Yokuvhara Masiri uye Kudzivirira Mafashiti Epa Excel

Kuchengetedza kushanduka kwechiitiko kana kuchinja nemaune kune zvimwe zvinhu mune pepa rekushanda kana bhuku rebhuku , Excel ine zvigadziro zvekudzivirira zvimwe zvikamu zvebasa rinogona kushandiswa kana risina password.

Kuchengetedza dhamusi kubva kune shanduko ye Excel worksheet iri danho redziviri.

1. Kuvhara / kuzarura masero chaiwo kana zvinhu, zvakadai sematare kana maikirwo, mune pepa rekushanda.
2. Kushandisa Purogiramu Yokudzivirira - kusvikira danho rechipiri rapera, zvese zvemashizha ebasa uye data zviri nyore kuchinja.

Cherechedza : Kuchengetedza zvinyorwa zvebasa hazvifaniri kuvhiringidzwa nebhuku rebasa-level password kuchengeteka, iro rinopa hupamhi hwekuchengeteka uye rinogona kushandiswa kudzivirira vashandi pakusvhura faira zvachose.

Danho 1: Chengetedza / Svinura Masekeri mu Excel

Nokusingaperi, masero ose eExpcel worksheet akavharwa. Izvi zvinoita kuti zvive nyore kwazvo kuchengetedza dhese rose nekufambisa mune imwe pepaji pekushanda nekushandisa kushandisa chekudzivirira pepa.

Kuti dzichengetedze dheti mumashizha ose mubhuku rebhuku, chekuchengetedza pepa pekudzivirira inofanira kushandiswa pane rimwe peji rimwe nerimwe.

Kusunungura majekiseni mamwe masvomho anoshandurwa kuti apiwe aya masero mushure mekuchengetedzwa kwepaiti / bhuku rebasa rakashandiswa.

Mitsara inogona kuzarurirwa kushandiswa kweChin Cell Cell. Iyi sarudzo inoshanda sechinoshandura chekugadzirisa-inongova nematunhu maviri kana nzvimbo - ON or OFF. Sezvo masero ose akangovharwa mukati mebasa rekushanda, achinyanya kusarudza kusunungura masero ose akasarudzwa.

Mamwe masero ari mune pepa rekushandisa angasara asina kusunurwa kuitira kuti data itsva iwedzere kana kuti iripo data yakashandurwa.

Maseji ane zvigadzirwa kana zvimwe zvakakosha zvakachengetedzwa zvinochengetwa kuitira kuti kana kese yekuchengetedza pepa / bhuku rebasa rave rakashandiswa, aya masero haagoni kuchinjwa.

Muenzaniso: Svinura maCells mu Excel

Mumufananidzo uri pamusoro, kuchengetedzwa kwakashandiswa kumasero. Matanho ari pasi apa anowirirana nomuenzaniso webasa riri mumufananidzo uri pamusoro.

Mumuenzaniso uyu:

• Masero I6 kusvika J10 ave asina kuzarurirwa kubvumira deta kuwedzerwa kana kuchinjwa sezvinodiwa.
• Mitsara I10 neJ10, ine mavara ekuverenga zvikamu zvacho, yakasara yakakiyiwa.
• Nzvimbo yekuchengetedza pepa yakagadzirirwa kushandiswa kwepaji rino.

Matanho ekuvhara / kuzarura masero:

1. Simbisai masero I6 kusvika J10 kuti musarudze.
2. Dzvanya paIndaneti tab.
3. Sarudza iyo Fomati yekodhi pane ribhoni kuti uzarure rondedzero.
4. Dzvanya paKvhavha yeSiraini sarudzo pasi pezasi.
5. Iyo yakasimbiswa masero I6 kusvika J10 iko zvino yakasunungurwa.

Svinura Charts, Textboxes, uye Graphics

Nekusavapo, zvinyorwa zvose, mabhokisi mabhokisi, uye maikirwo zvinhu - zvakadai semifananidzo, mavhidhiyo emifananidzo, maumbirwo, uye Smart Art - zviripo mune pepa rekushanda zvakavharwa uye, naizvozvo, zvinodzivirirwa apo Chekudzivirira Shee t inoshandiswa.

Kubva zvinhu zvakadaro hazvina kuvhurwa kuitira kuti zvigone kuchinjwa kana shande ichidzivirirwa:

1. Sarudza chinhu chakasunungurwa; kuita kudaro kunowedzera iyo Tema tab kune ribhoni.
2. Dzvanya pa Format format .
3. Muchikamu cheMusikirwo kuruoko rworudyi rwebhoni, chengetedza bhokisi rebhokisi rebhokisi rebhokisi (zvishoma zvishoma pasi rinotarisa museve) iri pedyo neshoko Kukura kuti uzarure maitiro ekugadzira basa (Format Picture dialog box in Excel 2010 uye 2007)
4. MuChechi yeZviro zvemafafa ebasa, bvisa check check kubva pakachengetedzwa chebhokisi, uye kana iko kushanda, kubva kuClocker text check box.

Nhanho 2: Kushandisa Purogiramu Yokudzivirira Purogiramu muExcel

Nhanho yechipiri mubasa - kuchengetedza rese pepaji - inoshandiswa kushandisa Protect Sheet dialog box.

Iyo bhokisi iri rine mutsara wezvasarudzo zvinogadzirisa kuti zvikamu zvepashiti rinogona kuchinjwa. Izvi zvinosanganisira:

• Kuwedzera password kuti kudzivirira pepa rekudzivirirwa kusachengetedzwa kubva kuvharwa.
• Kusarudza akavharidzirwa uye asina kusunungura masero.
• Kugadzirisa, kufamba, kana kubvisa deta.
• Kuwedzera / kubvisa mitsara nemirasi .
• Kuvanza kana kusunungura koromo nemirara.
• Kushandura nhamba yekugadzirisa - mari yezviratidzo, zvikamu zvemashoko, nhamba yepamusoro nzvimbo, nezvimwewo.
• Kushandura masero ekufambisa - kuwedzera / kubvisa miganhu , sero kana fonji ruvara rwekuchinja, kuvhara mavara , nezvimwewo.

Cherechedza : Kuwedzera password hakudziviriri vashandisi kuti vatange pepa rekushandira uye vachiona zviri mukati.

Kana iyo miviri miviri iyo inobvumira musikana kuisa pachena yakakiwa uye asina kuvharwa masero akadzimwa, vashandisi havazokwanisi kuita chero shanduko pane pepa rekushanda-kunyange kana iri yakavhara masero.

Zvasara zvingasarudzwa, zvakadai sekugadzirisa masero uye kusarudza data, havasi vose vanoshanda zvakafanana. Semuenzaniso, kana maitiro ekushandiswa kwemasero ari kubviswa apo pepa rinodzivirirwa, masero ose anogona kuenzaniswa.

Izvo zvakasarudzwa, kune rumwe rutivi, zvinobvumira chete pamasero akave asina kuzarurwa pamberi peepa racho rakachengetedzwa kurongwa.

Muenzaniso: Kushandisa Purogiramu Yokudzivirira Purogiramu

1. Svinura kana kuvhara masero aidiwa mune pepa rekushanda riripo.
2. Dzvanya paIndaneti tab.
3. Sarudza iyo Fomati yekodhi pane ribhoni kuti uzarure rondedzero.
4. Dzvanya paKachengetedza Sheet sarudzo pasi pezveru kuti uzarure bhokisi rekudzivirira reSpect Sheet.
5. Chengetedza kana kusanudza zvaunoda.
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye chengetedza pepa rekushanda.

Kuvhara Pasi Pepa Rokuchengetedza

Kuchengetedza pepa rekuti kuitira kuti masero ose aite kugadziriswa:

1. Dzvanya paIndaneti tab.
2. Sarudza iyo Fomati yekodhi pane ribhoni kuti uzarure rondedzero.
3. Dzvanya paKusachengetedza Shanduro Sarudzo pane pasi pezita kuti usadzivirira pepa.

Cherechedza : Kusachengetedza purogiramu yebasa hakuchina mamiriro ekudzivirira kwemaseri akavharwa kana kusvinudzwa.