Tetezani fayilo ya Excel

Kukhazikitsa chitetezo pamafayilo a Excel ndi njira yabwino kwambiri yodzitetezerera, kuchokera kwa osagwirizana nawo komanso pazinthu zanu zolakwika. Vuto ndikuti ogwiritsa ntchito onse sangavule, ngati kuli kotheka, kuti athe kusintha bukuli kapena kungoona zomwe zili mkati mwake. Funso ndiloyenera kwambiri ngati mawu achinsinsi sanakhazikitsidwe ndi wosuta yekha, koma ndi munthu wina yemwe adapereka mawu akuti, koma wosazindikira sakudziwa momwe angagwiritsire ntchito. Kuphatikiza apo, pali zochitika za kuchepa kwachinsinsi. Tiyeni tiwone momwe mungachotsere chitetezo kuchokera ku chikalata cha Excel ngati kuli kofunikira.

Phunziro: Momwe mungachotsere chitetezo kuchokera ku chikalata cha Microsoft Mawu

Tsegulani Njira

Pali mitundu iwiri yotseka ya fayilo ya Excel: chitetezo cha buku ndi chitetezo cha pepala. Momwemo, algorithm yotsegulira imatengera njira yotetezedwa yomwe yasankhidwa.

Njira 1: tsegulani buku

Choyamba, pezani njira yochotsera chitetezo m'buku.

1. Mukamayesa kuyendetsa fayilo yotetezedwa ya Excel, zenera laling'ono limatseguka lolowetsa mawu. Sitingatsegule bukulo mpaka titamuuza. Chifukwa chake, ikani mawu achinsinsi mumunda woyenera. Dinani pa "Chabwino" batani.



2. Pambuyo pake, bukulo limatsegulidwa. Ngati mukufuna kuchotsa chitetezo chonse, ndiye pitani Fayilo.



3. Timasunthira ku gawo "Zambiri". Pakati pazenera, dinani batani Tetezani Buku. Pazosankha zotsitsa, sankhani "Sungitsa ndi password".



4. Apanso zenera limayamba ndi mawu. Ingotsani achinsinsi patsamba loyika ndikuyika ndikudina batani "Chabwino"



5. Sungani kusintha kwa fayilo popita ku tabu "Pofikira" pomadina batani Sungani mawonekedwe a diskette pakona yakumanzere ya zenera.

Tsopano mutatsegula bukuli, simudzafunika kulowa mawu achinsinsi ndipo silidzatetezekanso.

Phunziro: Momwe mungasungire achinsinsi pa fayilo ya Excel

Njira 2: Tsegulani Mapepala

Kuphatikiza apo, mutha kukhazikitsa chinsinsi patsamba lina. Nthawi yomweyo, mutha kutsegula bukulo ngakhale kuwona chidziwitso papepala loksekedwa, koma simungathe kusintha maselo. Mukayesa kusintha, meseji imawoneka m'bokosi la zokambirana kukudziwitsani kuti khungu limatetezedwa pakusintha.

Kuti muthe kusintha ndikusintha kwathunthu kutetezedwa, muyenera kuchita zinthu zingapo.

1. Pitani ku tabu "Ndemanga". Pa nthiti yomwe ili m'bokosi la chida "Sinthani" dinani batani "Chotsani pepala kuteteza".



2. Iwindo limatsegulidwa m'munda womwe mukufuna kuti mulowetse mawu achinsinsi. Kenako dinani batani "Zabwino".

Pambuyo pake, chitetezo chimachotsedwa ndipo wogwiritsa ntchito amatha kusintha fayilo. Kuteteza pepalalo, muyenera kukhazikitsanso chitetezo chake.

Phunziro: Momwe mungatetezere khungu kuti lisasinthe ku Excel

Njira 3: chotsani chitetezo posintha fayilo

Koma, nthawi zina pamakhala kuti wosuta walembera pepalalo achinsinsi, kuti tisasinthe mwangozi, koma osakumbukira cipher. Ndikukhumudwitsa kopitilira kuti, monga lamulo, mafayilo okhala ndi chidziwitso chofunikira amalembedwa ndipo kutayika kwa chinsinsi kwa iwo kumatha kulipira ndalama zambiri kwa wogwiritsa ntchito. Koma, pali njira yotengera ngakhale izi. Zowona, muyenera kusamala ndi chikalatacho.

1. Ngati fayilo yanu ili ndi kuwonjezera xxx (Buku lothandizira), kenako pitani molunjika pa gawo lachitatu la malangizowo. Ngati kukulitsa xx (Excel Book 97-2003), ndiye kuti iyenera kukonzedwanso. Mwamwayi, ngati pepala lokhalo lili lozunguliridwa, ndipo osati buku lonse, mutha kutsegula chikalatacho ndikuchisunga mwanjira iliyonse. Kuti muchite izi, pitani ku tabu Fayilo ndipo dinani pachinthucho "Sungani Monga ...".



2. Zenera lopulumutsa limatseguka. Zofunikira pachimake Mtundu wa Fayilo mtengo wokhazikitsidwa Buku lantchito m'malo "Excel Book 97-2003". Dinani batani "Zabwino".



3. Buku la xlsx kwenikweni ndi nkhokwe yach zip. Tidzafunika kusintha fayilo imodzi yosungidwa pano. Koma chifukwa cha izi muyenera kusintha pomwepo kuchokera pa xlsx kupita ku zip. Pitani pa wofufuzayo kupita kumalo osungira zikwatu zomwe zikupezeka zolembedwa. Ngati kuwonjezera kwa fayilo sikuwoneka, dinani batani Sanjani kumtunda kwa zenera, sankhani chinthucho menyu Foda ndi Zosankha.



4. Tsamba la zosankha chikwatu limatsegulidwa. Pitani ku tabu "Onani". Tikuyang'ana chinthu "Bisani zowonjezera zamtundu wamafayilo olembedwa". Unambule ndikudina batani "Zabwino".



5. Monga mukuwonera, izi zitatha, ngati kuwonjezera sikunawonetsedwa, ndiye kuti kuwonekera. Dinani kumanja pa fayilo ndikusankha chinthucho menyu omwe awonekera Tchulani.



6. Sinthani kuwonjezera ndi xxx pa zip.



7. Ukasinthanso dzina ukatha, Windows imazindikira kuti nkhaniyi ndi nkhokwe yosungirako ndipo ukhoza kungoyitsegula ndikugwiritsa ntchito yowerenga yomweyo. Timadina kawiri pa fayilo iyi.



8. Pitani ku adilesi:

   file_name / xl / worksheets /

   Mafayilo okhala ndi kuwonjezera xml Fayilo iyi ili ndi zambiri pamashiti. Timatsegula yoyamba yawo mothandizidwa ndi mkonzi walemba zilizonse. Mutha kugwiritsa ntchito Windows Notepad yomanga pazinthu izi, kapena mutha kugwiritsa ntchito pulogalamu yapamwamba kwambiri, mwachitsanzo, Notepad ++.



9. Pulogalamu itatsegulidwa, timalemba pa njira yachidule Ctrl + Fkuposa kuyitanitsa kusaka kwamkati. Timayendetsa mawu akuti:

   ChapaLatina

   Tikulifuna mu malembawo. Ngati sitinachipeze, ndiye kuti mutsegule fayilo yachiwiri, etc. Timachita izi mpaka chinthucho chikapezeka. Ngati ma worksheets angapo a Excel atetezedwa, ndiye kuti chinthucho chizikhala m'mafayilo angapo.



10. Katunduyu wapezeka, fufutani pamodzi ndi chidziwitso chonse kuyambira pa tag yoyambira mpaka kutseka. Sungani fayilo ndikutseka pulogalamuyo.



11. Timabwereranso kuchikhazikitso cha malo osungirako zakale ndikusinthanso kuwonjezera kwake kuchokera ku zip kupita ku xlsx.

Tsopano, kuti musinthe pepala la Excel, simuyenera kudziwa mawu achinsinsi oiwalidwa ndi wogwiritsa ntchito.

Njira 4: gwiritsani ntchito pulogalamu yachitatu

Kuphatikiza apo, ngati mukuyiwala mawu a khodi, ndiye kuti loko imatha kuchotsedwa pogwiritsa ntchito mapulogalamu apamwamba. Nthawi yomweyo, mutha kufufuta achinsinsi pa pepala lotetezedwa komanso mufayilo yonse. Imodzi mwa mapulogalamu omwe adadziwika kwambiri m'derali Accent OFISI Yachinsinsi Kuyambiranso. Ganizirani momwe mungakhazikitsire chitetezo pogwiritsa ntchito fanizoli.

Tsitsani Kuulula kwa Akaunti Yapadera ya Accent OFFICE kuchokera ku tsamba lovomerezeka

1. Tikuyambitsa ntchitoyo. Dinani pazosankha Fayilo. Pamndandanda wotsitsa, sankhani malo "Tsegulani". M'malo mwazinthu izi, mutha kungolemba mtundu wamtundu wa kiyibodi Ctrl + O.



2. Tsamba losaka fayilo limatsegulidwa. Ndi iyo, timapita ku dawunilodi komwe buku la ntchito la Excel lomwe timafunikira lili, komwe achinsinsi adatayika. Sankhani ndikudina batani. "Tsegulani".



3. Wizard Yachinsinsi Kwambiri imatsegulidwa, yomwe imanena kuti fayiloyo imatetezedwa achinsinsi. Kanikizani batani "Kenako".



4. Kenako mndandanda umatsegulidwa pomwe muyenera kusankha malinga ndi momwe chitetezero chizichotsedwera. Nthawi zambiri, njira yabwino ndikusiya makonda ndipo pokhapokha ngati mulephera kuyesa kuzisintha kachiwiri. Dinani batani Zachitika.



5. Njira yosankha mawu achinsinsi imayamba. Zimatha kutenga nthawi yayitali, kutengera zovuta za mawu. Mphamvu ya njirayi imawonedwa pansi pazenera.



6. Pambuyo pakuwonetsedwa kwa deta ikatsirizidwa, zenera lidzawonetsedwa momwe achinsinsi adzajambulidwa. Muyenera kungoyendetsa fayilo ya Excel mumalowedwe oyenera ndikulowetsa kachidindo koyenera. Zitangochitika izi, tsamba lokhala ndi Excel lidzatsegulidwa.

Monga mukuwonera, pali njira zingapo zochotsera chitetezo kuchokera ku chikalata cha Excel. Wogwiritsa ntchito ayenera kusankha yomwe angagwiritse ntchito kutengera mtundu woletsa, komanso kuchuluka kwa luso lake komanso momwe angafunire mwachangu zotsatira zabwino. Njira yochotsera chitetezo pogwiritsa ntchito cholembera mawu ndichangu, koma pamafunika chidziwitso ndi khama. Kugwiritsa ntchito mapulogalamu apadera kungafune nthawi yayitali, koma kugwiritsa ntchito kumachita pafupifupi chilichonse chokha.