Dzimwe nguva haudi kuti mamwe masero ari muexcel sheets ako agadziriswe. Unogona kuzviita nekudzidza kukiya kana kuvhura maseru muexcel.
Microsoft Excel inotipa yakanakisa nzira yekuchengetedza data redu mune rakanyorwa uye rakarongeka fomu. Asi iyi data inogona kuchinjwa kana yakagovaniswa pakati pevamwe vanhu. Kana iwe uchida kuchengetedza data rako kubva pakushandurwa nemaune, saka unogona kuchengetedza maExcel mapepa ako nekuakiya. Asi, iri idanho rakanyanyisa ringave risingafarirwe. Pane kudaro, unogona kukiya mamwe maseru, mitsetse, uye makoramu zvakare. Semuenzaniso, unogona kubvumira vashandisi kuisa chaiyo data asi kukiya maseru neruzivo rwakakosha. Muchikamu chino, tichaona nzira dzakasiyana dzekuita kukiya kana kuvhura maseru muExcel.
Zviri mukati[ hide ]
- Maitiro ekukiya kana kuvhura maseru muExcel?
- Maitiro ekukiya ese maseru muExcel?
- Nzira yeKukiya uye Kudzivirira Masero Ega ega muExcel?
- Maitiro ekuvhura uye kusadzivirira Masero muExcel Sheet?
- Makiinura sei Masero muPepa Rakachengetedzwa?
Maitiro ekukiya kana kuvhura maseru muExcel?
Unogona kukiya shiti rese kana kungosarudza maseru ega zvichienderana nesarudzo dzako.
Maitiro ekukiya ese maseru muExcel?
Kuchengetedza maseru ese ari mukati Microsoft Excel , iwe unongofanirwa kuchengetedza pepa rose. Maseru ese ari mushizha anozodzivirirwa kubva kune chero akawandisa-kunyora kana kugadzirisa nekusarudzika.
1. Sarudza ' Dzivirira Sheet ' kubva pasi pechidzitiro mu' Worksheet Tab ' kana zvakananga kubva ku' Ongorora Tab ' mu Anochinja boka .
2. The ‘ Dzivirira Sheet ' dialogue box inooneka. Iwe unogona kusarudza kuchengetedza yako excel sheet nepassword kana kusiya iyo ' password chengetedza yako Excel sheet ’ munda usina chinhu.
3. Sarudza zviito kubva pane rondedzero yaunoda kubvumidza mubepa rako rakachengetedzwa uye tinya pakanzi 'Zvakanaka.'
4. Kana ukasarudza kuisa password, a ‘ tsigira pasiwedhi ' dialogue box ichaonekwa. Nyora password yako zvakare kuti upedze kuita.
Verenga zvakare: Maitiro ekubvisa password kubva kuExcel File
Nzira yeKukiya uye Kudzivirira Masero Ega ega muExcel?
Unogona kukiya maseru ega kana huwandu hwemasero nekutevera matanho ari pasi apa:
1. Sarudza maseru kana mitsara yaunoda kuchengetedza. Iwe unogona kuzviita negonzo kana nekushandisa shanduko uye museve makiyi pane ako makiyi. Shandisa iyo Ctrl kiyi uye mbeva kusarudza masero asina pedyo uye mitsara .
2. Kana iwe uchida kukiya koramu(ma) yese nemitsara(mitsetse), unogona kuzvisarudza nekudzvanya pambiru yavo kana mutsara mavara. Iwe unogona zvakare kusarudza akawanda ari padyo makoramu nekudzvanya-kurudyi pane mbeva kana kushandisa kiyi yekuchinja uye mbeva.
3. Unogonawo kusarudza chete masero ane mafomula. MuKumba tab, tinya pa Kugadzirisa boka ndokuzo ' Tsvaga uye Sarudza '. Dzvanya pa Enda kune Special .
4. Muhurukurobhokisi, sarudza iyo Formulas sarudzo uye tinya OK .
5. Kana wangosarudza maseru aunoda kuvharwa, dzvanya Ctrl + 1 pamwe chete. ‘ Format Masero ' dialogue box ichaonekwa. Iwe unogona zvakare kudzvanya-kurudyi pane akasarudzwa maseru uye sarudza iyo Format masero sarudzo kuvhura bhokisi renhaurirano.
6. Enda kune ' Dziviriro ' tab uye tarisa iyo' rakakiyiwa ' option. Dzvanya pa OK , uye basa renyu rapera.
Cherechedza: Kana iwe uri kuyedza kukiya maseru pane yakambodzivirirwa Excel sheet, iwe unofanirwa kuvhura shiti kutanga wozoita maitiro ari pamusoro. Iwe inogona kukiya kana kuvhura maseru muExcel muna 2007, 2010, 2013, uye 2016 shanduro.
Maitiro ekuvhura uye kusadzivirira Masero muExcel Sheet?
Iwe unogona kuvhura zvakananga pepa rese kuti uvhure maseru ese muExcel.
1. Dzvanya pa' Unprotect Sheet ' pa ' Ongorora tab ' mu shanduko boka kana kudzvanya pane iyo sarudzo nekudzvanya-kurudyi pane Sheet tab.
2. Iwe zvino unogona kuita chero shanduko kune data mumasero.
3. Unogona zvakare kuvhura pepa uchishandisa iyo ' Format Cells' dialogue box.
4. Sarudza maseru ese ari mupepa ne Ctrl + A . Wobva wadzvanya Ctrl + 1 kana kuti tinya kurudyi uye sarudza Format Masero . Mu ' Dziviriro ' tab yeFormat Cells dialogue box, bvisa iyo ' Yakakiyiwa ' sarudzo uye tinya OK .
Zvakare Verenga: Gadzirisa Excel yakamirira imwe application kuti ipedze OLE chiito
Makiinura sei Masero muPepa Rakachengetedzwa?
Dzimwe nguva ungangoda kugadzirisa chaiwo maseru mune yako Yakachengetedzwa Excel sheet. Nekushandisa nzira iyi, unogona kuvhura maseru pabepa rako uchishandisa password:
1. Sarudza maseru kana mitsara yaunoda kuvhura mupepa rakachengetedzwa nepassword.
2. Mune ' Ongorora ' tab, tinya pa' Bvumira vashandisi kugadzirisa Range ' option. Iwe unofanirwa kuvhura pepa rako kutanga kuti uwane iyo sarudzo.
3. The 'Bvumira vanoshandisa Edit Ranges' nhaurirano bhokisi rinooneka. Dzvanya pa' New ' option.
4. A ‘ New Range ' dialogue box inoonekwa ne Title, Rinoreva maseru, uye Range password munda.
5. Mundima yeChinyorwa, ipa zita kurudzi rwako . Mu ' Zvinoreva sero ' munda, nyora huwandu hwemasero. Inotova nemaseru akasarudzwa siyana nekukasira.
6. Nyora iyo pasiwedhi muPasiwedhi munda uye tinya pa OK .
7. Nyora password zvakare mu ' tsigira pasiwedhi ' dialogue box uye tinya OK .
8. Rutsva rutsva ruchawedzerwa . Iwe unogona kutevera matanho zvakare kuti ugadzire mamwe mitsara.
9. Dzvanya pa' Dzivirira Sheet ' bhatani.
10. Nyora password mu 'Chengetedza Sheet' hwindo rebepa rese uye sarudza zviito unoda kubvumira. Dzvanya OK .
gumi neimwe. Nyora password zvakare muhwindo rekusimbisa, uye basa rako raitwa.
Ikozvino, kunyangwe bepa rako rakachengetedzwa, mamwe maseru akadzivirirwa achange aine imwe nhanho yekudzivirira uye anozovhurwa chete nepassword. Iwe unogona zvakare kupa mukana kune marenji pasina kuisa password nguva dzese:
Poshi.Paunenge wagadzira iro renji, tinya pane ' Mvumo ' sarudzo yekutanga.
2. Dzvanya pa Wedzera bhatani pahwindo. Isa zita revashandisi mu ' Isa mazita ezviro kuti usarudze 'bhokisi. Iwe unogona kunyora zita remushandisi remunhu sezvakachengetwa mudura rako . Dzvanya pa OK .
3. Zvino tsanangura mvumo yemushandisi wega wega pasi pe ' Mazita eboka kana evashandisi ' uye tarisa iyo Rega sarudzo. Dzvanya pa OK , uye basa renyu rapera.
Zvinokurudzirwa:
- Maitiro eKuchinjanisa Makoramu kana Mitsetse muExcel
- Ungashandura sei faira reExcel (.xls) kuita vCard (.vcf) faira?
- Kurumidza Chinja Pakati Pemashiti Ekushanda muExcel
- Maitiro ekugadzirisa maWhatsapp mapikicha asiri kuratidzwa muGarari
Idzi dzese dzaive nzira dzakasiyana dzaungagone nadzo kukiya kana kuvhura maseru muExcel. Kuziva kuchengetedza pepa rako kwakakosha kuti udzivirire kubva kune netsaona shanduko. Iwe unogona kuchengetedza kana kusadzivirira maseru muExcel sheet kamwechete kana kusarudza imwe mhando. Iwe unogona zvakare kupa vamwe vashandisi kuwana ne kana pasina password. Tevera nhanho dziri pamusoro zvakanyatsonaka, uye haufanirwe kunge uine dambudziko.
Pete Mitchell Pete munyori wevashandi vepamusoro paCyber S. Pete anoda zvinhu zvese tekinoroji uye zvakare anodisa DIYer pamoyo. Ane makore gumi eruzivo rwekunyora sei-tos, maficha, uye tekinoroji madhairekitori painternet.