Unofanira kuchengetedza mamwe masero mupepa rako rebasa reExcel here? Kana kuti pamwe unoda kukiya masero ese kunze kweashoma aunogona kugadzirisa. Chero zvazvingava, kukiya masero muExcel kuri nyore kuita, asi unofanirwa kuziva matanho akakodzera. Chinyorwa chino chine mapikicha akawanda, pamwe nemirairo nhanho nhanho uye zvinobuda kuti uratidze pfungwa imwe neimwe. Ramba uchiverenga gwara rekutanga rekukiya masero muExcel.
Maitiro Ekudzivirira Mhando dzeMasero muExcel Kuti Dzisagadziriswe
Rimwe remabasa akajairika auchaita paunenge uchishanda nedata muExcel nderekuti kiya mamwe masero Izvi zvinogona kubatsira kana uchida kudzivirira mamwe mashoko kuti asagadziriswe kana kubviswa. Heino maitiro ekuzviita:
Danho rekutanga. Kutanga, vhura pepa rekushanda reExcel raunoda kushanda naro.
Danho rechipiri. Kana pepa rako rebasa rakachengetedzwa kare kuti risagadziriswe, unofanira kutanga wabvisa kuchengetedzwa kwaro kuitira kuti rigone kuchinjwa zviri pamutemo.
Kuti usachengetedze pepa rako rekushandira muExcel, ingoenda ku "Ongororo" tab wobva wasarudza "Unprotect Sheet". Inogona kukumbira kuti upe password.
Danho rechitatu. Dzvanya chiratidzo chetriangle chiri pakona yepamusoro kuruboshwe kuti usarudze masero ese epepa rako.
Danho rechitatu kusvika rechishanu rakagadzirirwa kuva nechokwadi chekuti hapana kana masero akakiyiwa kana wangochengetedza bhuku rebasa. Izvi zvakakosha pakuona kuti ndeapi masero anofanira kukiyiwa gare gare.
Danho rechina. Dzvanya popup launcher ye "Alignment" kana "Font" pasi pe "Home" tab.
Izvi zvichaunza hwindo rekuti “Format Cells” rine tab inonzi “Protection”.
Danho rechishanu. Bvisa chiratidzo mubhokisi riri pedyo ne "Yakakiyiwa", wobva wadzvanya "Zvakanaka" kuti uchengetedze shanduko dzako.
Danho rechitanhatu. Yasvika nguva yekusarudza masero aunoda kuvharira kana dziviriro yavepo.
Kana uchida kukiya koramu yese kana mutsetse, ingodzvanya pachikamu ichocho chespreadsheet. Kana uchida kusarudza range yakati, unogona kuita izvi nekudzvanya nekukwevera cursor yako pamusoro pemasero, kana nekushandisa nzira pfupi dzekhibhodi Ctrl+Click kune mamwe masero kana Shift+Click kuti usarudze range yemasero.
Mumuenzaniso uyu, tichavhara masero A1 kusvika B2.
Danho rechinomwe. Kana masero asarudzwa, tinya popup launcher ye "Alignment" (kana "Font") zvakare kuti uratidze hwindo.
Danho rekare, takabvisa chiratidzo pairi kuti pepa rese rebasa rivhurike. Zvino tinofanira kushandura mamiriro kubva pakusabvisa chiratidzo kuenda pakutarisa nekutarisa bhokisi rakanyorwa kuti "Yakakiyiwa", kuti tigadzire A1 kusvika B2 lock.
Danho rechisere. Dzvanya pa "Ongororo" tab wobva wasarudza murairo wekuti "Protect Sheet" kubva pamenyu. Isa password kana uchida kuchengetedza masero nepassword. Mushure meizvozvo, tinya "OK".
Tinokurudzira kuti ugadzire password, sezvo vamwe vanongoda kudzvanya bhatani rekuti “Unprotect Sheet” kuti vaigadzirise zvakanaka kana iwe usingadaro.
Danho rechipfumbamwe. Chengetedza bhuku rebasa. Kana mashandiro ako akafanana neari pamusoro apa, hauzokwanisi kuchinja chero sero kubva paA1 kuenda kuB2, uye masero ari kunze kwerudzi urwu anogona kuchinjwa panguva pfupi.
Maitiro Ekuona Kuti Masero Mashoma Chete Anoramba Achigadziriswa
Pawakanga uchida kiya zvese kunze kwezvishoma , heino maitiro ekuita.
Danho rekutanga. Vhura bhuku rako rebasa reExcel wobva wadzvanya pane pepa raunoda kukiya.
Danho rechipiri. Kana pepa racho rakachengetedzwa kuti risagadziriswe, unofanira kudzvanya pakanzi “Unprotect Sheet” pane tab ye “Review” kuti utange warega kuridzivirira.
Danho rechitatu. Negonzo rako, sarudza masero aunoda kuti agadziriswe, wobva wadzvanya pa "Bvumira maereji ekugadzirisa" kuitira kuti hwindo rekuti "Bvumira Vashandisi Kugadzirisa Maereji" rionekwe.
Mumuenzaniso uyu, masero A1 kusvika kuB1 achasarudzwa.
Danho rechina. Dzvanya bhatani rekuti “Itsva” kuti uwedzere mutsetse. Pasi pechikamu che“Musoro”, unogona kupa mutsetse uyu zita raunogona kunzwisisa zviri nyore. Pasi pechikamu che“Refers to cells” uchaona kuti unoratidzwa masero awakasarudza.
Unogonawo kugadzira password yerange inobvumira kugadziriswa chete mushure mekuiisa. Password yerange yakasiyana nepassword isingadziviriri. Vamwe vane "password yerange" asi vasina "password yekudzivirira" vanogona kungochinja masero aunobvumira, uye havangadziviriri pepa rese rebasa kunze kwekunge uchishandisa mapassword maviri akafanana.
Danho rechishanu. Dzvanya pa "Zvakanaka" kuti uchengetedze shanduko uye uvhare hwindo re "New Range", wobva wadzvanya pa "Zvakanaka" zvakare kuti uvhare hwindo rekuti "Bvumira Vashandisi Kugadzirisa MaRange".
Danho rechitanhatu. Enda ku "Ongororo", wobva wasarudza bhatani rekuti "Dzivirira Sheet" riri pa "toolbar" yespredishiti yako kuti uvhare sheet yacho.
Danho rechinomwe. Chengetedza gwaro reExcel. Uchaona kuti kiyi yakaiswa pamasero ese kunze kweA1 kusvika B1, zvinoreva kuti A1 neB1 zvinotenderwa kugadziriswa, asi mamwe masero ese akakiyiwa kuti achinje.
Zvino zvawava kuziva nzira yekukiya kana kuvhura masero muExcel, unogona kuchengetedza zviri nani data rako kubva pakuchinja kana kudzimwa netsaona.
Kana Ndakakanganwa Password Yekugadzirisa, Ndingabvisa Sei Kudzivirira Pepa Rangu?
Mapassword anowedzera kuchengetedzeka, asi anogona kusashanda zvakanaka kana ukaakanganwa. Nerombo rakanaka, kubvisa password yekudzivirira edit kuri nyore pane kupinda mugedhi. dziviriro yakavhurika !
Zvisinei, kana nekuda kwechikonzero chipi zvacho, ukazvivharira kunze nekukanganwa password yako yekugadzirisa, mhinduro iri nyore ndeyekukopa data racho kune rimwe pepa rebasa.
Neimwe nzira, kune maExcel Restrictions Removers, akadai se Pasipoti yeExcel , kuti ikubatsire kubvisa zvirambidzo nekudzvanya kamwe chete. Nguva inotora kubvisa zvirambidzo zvekugadzirisa maspredishiti haina chekuita nekuoma kwepassword. Pasinei nekuti password yakaoma sei, chirongwa ichi chinogona kubvisa zvirambidzo zvese zvebhuku rebasa musekondi imwe chete.
Mashoko emupepeti
Kukiya masero muExcel chishandiso chinobatsira chinogona kushandiswa kuchengetedza mavalues kubva pakuchinja kusingatarisirwi, asi hazvisi pachena nguva dzose kuti ungazviita sei. Tinovimba matanho aya achakubatsira kuvhara mavalues esero riri paspreadsheet yako uye kuve nechokwadi chekuti anoramba aripo kusvika iwe (kana munhu ane mvumo) wachinja iwe pachako. Kana paine chimwe chinhu nezvekuvhara masero chichiita sechisina kujeka kana kana uine mimwe mibvunzo, inzwa wakasununguka kutisiya mhinduro pazasi.
