Momwe mungasinthire khungu

Excel ndi matebulo amphamvu, mukamagwira ntchito zomwe zimasinthidwa, ma adilesi amasintha, etc. Koma nthawi zina muyenera kukonza chinthu china kapena, monga momwe amanenera, kuti musunge kuti sizisintha komwe si. Tiyeni tiwone zosankha ziti zomwe zimaloleza kuchita.

Mitundu Yakusintha

Nthawi yomweyo amafunikira kunena kuti mitundu yokhazikika yomwe ili ku ukapolo imatha kukhala yosiyana kwambiri. Mwambiri, amatha kugawidwa m'magulu atatu akulu:

1. Ma adilesi ozizira;
2. Maselo omangika;
3. Kuteteza zinthu zosintha.

Mukamazizira adilesi, cholumikizira cha cell sichisintha ikamawakopera, ndiye kuti, imaleka kukhala achibale. Kutumiza maselo kumakupatsani mwayi kuti muwaone nthawi zonse pazenera, ngakhale atakhala kuti sungani pansi pa pepalalo kapena kumanja. Kuteteza zinthu kuti zisinthe ma break amasintha chilichonse chomwe chatchulidwa. Tiyeni tilingalire mwatsatanetsatane zilizonse zosankha izi.

Njira 1: Breezeze

Choyamba, tikambirana za kukonza ma adilesi. Kuti muumbitse, kuchokera pa mbiri yophunzitsira, yomwe ili pa Excel pabwino, muyenera kuphatikizira mgwirizano womwe susintha magwiridwe antchito pokopera. Pofuna kuchita izi, muyenera kukhazikitsa adilesi ya chizindikiro cha dollar ($) kuchokera pandunji pa nduna iliyonse.

Kukhazikitsa chikwangwani cha dola kumapangidwa ndikukakamizika chizindikiro choyenera pa kiyibodi. Ili pachifuwa chimodzi ndi nambala ya "4", koma kuti muchotse mawonekedwe omwe muyenera kukanikiza fungulo la English Asks (ndi "Shift" kiyi). Pali njira yosavuta komanso yofulumira. Muyenera kusankha adilesi ya chinthu china kapena mzere wa ntchito ndikudina batani la F4. Mukadina kaye, chizindikiro cha dollar chidzawonekera pa adilesi ndi mzere wachiwiri, nthawi yachiwiri pa kiyi ingokhala pa adilesi yachitatu, kunyumba yachitatu. Chachinayi kukanikiza kiyi ya F4 kumachotsa chizindikiro cha madola kwathunthu, ndipo chotsatira chimayamba njirayi ndi bwalo latsopano.

Tiyeni tiwone adilesi yozizira mwachitsanzo.

1. Poyamba, lembani njira yowerengera ku zinthu zina za mzati. Kuti muchite izi, gwiritsani ntchito cholembera. Ikani chotemberero ku ngodya yakumanja kwa cell, data yomwe mukufuna kukopera. Nthawi yomweyo, imasinthidwa kukhala mtanda, womwe umanyamula dzina la cholembera. Kanikizani batani lakumanzere ndikukoka kudutsa kumapeto kwa tebulo.



2. Pambuyo pake, timagawa chinthu chotsika kwambiri patebulo ndikuyang'ana pamzerewo mzere, pomwe mawonekedwe asintha pakukopera. Monga mukuwonera, magwiridwe onse omwe anali mu gawo loyamba la mzati, pomwe kukopera kunasinthidwa. Zotsatira zake, mawonekedwe amafotokoza molakwika. Izi ndichifukwa choti adilesi yachiwiriyi, mosiyana ndi woyamba, sayenera kusinthidwa kuti awerengere, ndiye kuti, imafunikira kuti ipangidwe Mtheradi kapena kukhazikika.



3. Tibwerera ku gawo loyamba la mzati ndikuyika chikwangwani cha dollar pafupi ndi mgwirizano wachiwiri mu njira imodzi yomwe tidakambirana pamwambapa. Tsopano ulalo uku ndi wowundana.



4. Pambuyo pake, pogwiritsa ntchito cholembera chodzaza, koperani ku malo opezeka pansipa.



5. Kenako timagawa chinthu chomaliza cha mzati. Monga momwe tingayang'anire chingwe cha ma formula, malo ogwirizira a chinthu choyamba adasinthidwa akamakopera, koma adilesi muzochulukitsa kwachiwiri, zomwe tidasintha.



6. Ngati mungayike chikwangwani cholumikizirana cholumikizira, ndiye kuti pankhaniyi adilesi ya ulalo udzakonzedwa, ndipo magwiridwe antchito a zingwe amasunthidwa pokopera pokopera.



7. Komanso, ngati mungayike chizindikiro cha dollar pafupi ndi adilesi, ndiye kuti kukopera sikungasunthire, mosiyana ndi adilesi ya mzati.

Njirayi imatulutsa ma cell ozizira a maselo.

Phunziro: Kuyankhulira kwathunthu

Njira 2: Maselo Okonza

Tsopano tikuphunzira kukonza maselo kuti azingokhala pazenera pomwe wosuta sangapite mkati mwa tsamba. Nthawi yomweyo, ziyenera kudziwika kuti zinthu za munthu sizingathemangitsidwa, koma mutha kukonza malowo.

Ngati khungu lomwe lingafunikire lili pamzere wapamwamba wa pepalalo kapena mzere wakumanzere, ndiye kuti kusintha kwake ndi kokha.

1. Kuti muteteze chingwecho, chita izi. Pitani ku "Onani" tabu ndi dongo pa batani la "Highten Wax", lomwe lili pazenera la "zenera" chida. Mndandanda wazosankha zosiyanasiyana amatsegula. Sankhani dzinalo "chitetezo cham'mwamba".



2. Tsopano ngakhale mutatsikira pansi pa pepalalo, mzere woyamba, zomwe zikutanthauza kuti chinthu chomwe mukufuna, chomwe chili mkati mwake, chidzakhalabe pamwamba pazenera.

Momwemonso, mutha kupulumutsa mbali yopitilira kumanzere.

1. Pitani ku "View" tabu ndikudina batani la "Highteten". Pakadali pano ndimasankha njira "yotetezedwa pamzere woyamba".



2. Monga mukuwonera, mzati wamanzere kwambiri tsopano wakhazikika.

Pafupifupi momwe mungathere kuphatikiza gawo loyambalo ndi chingwe, koma ambiri, malo onse amasiyidwa ndi chinthu chosankhidwa.

1. Algorithm ya ntchitoyi ndi yosiyana pang'ono ndi iwiri yapitayo. Choyamba, ndikofunikira kuwunikira tsamba la masamba, dera lochokera kumwamba ndi lamanzere lomwe lidzakonzedwa. Pambuyo pake, pitani ku "Onani" tabu ndikudina chithunzi chodziwika bwino ". Mumenyu zomwe zimatsegulira, sankhani chinthucho ndi dzina lomweli.



2. Pambuyo pa izi, malo onse omwe ali kumanzere komanso pamwamba pa chinthu chodzipatulira chidzakhazikitsidwa papepala.

Ngati mukufuna, chotsani kuzizira komwe kali, kosavuta. Kuphedwa kwa algorithm kuli chimodzimodzi nthawi zonse kuti zingakhale wogwiritsa ntchito yemwe sangateteze: chingwe, mzati kapena dera. Timasunthira ku "View" tabu, dinani pa malo oti "kukonza" ndi mndandanda womwe umatsegulira, sankhani njira "yochotsa kuphatikizira madera". Pambuyo pake, magulu onse okhazikika a pepalali adzaponyedwa.

Phunziro: Momwe Mungapangire Malowo

Njira 3: Kusintha Chitetezo

Pomaliza, mutha kuteteza khungu kuti musinthe poletsa kutha kusintha kwa ogwiritsa ntchito. Chifukwa chake, zambiri zomwe zili mkati mwake zimaundana.

Ngati tebulo lanu silikhala lamphamvu ndipo silimapereka makonzedwe a kusintha kulikonse mmenemo, mutha kuteteza osati maselo enieni okha, komanso pepala lonse. Ndizosavuta kwambiri.

1. Lowani mu "Fayilo" tabu.



2. Pazenera lomwe limatsegulira menyu yofukiza kumanzere, pitani ku "tsatanetsatane". Mu gawo lalikulu lazenera, dongo pazolembedwa kuti "Tetezani buku la". Pa mndandanda wazotetezedwa zomwe zimatsegulidwa, sankhani "tengani" pepala lapano ".



3. Windo laling'ono layambitsidwa, lomwe limatchedwa "Chitetezo cha Tsoka". Choyamba, mu gawo lapadera lomwe mungafunike kuyika mawu achinsinsi, omwe angafunikire ndi wogwiritsa ntchito ngati akufuna kuletsa chitetezo mtsogolo kuti musinthe chikalatacho. Kuphatikiza apo, potero, mutha kukhazikitsa kapena kuchotsa zoletsa zina zingapo, kukhazikitsa kapena kuchotsa mbendera pafupi ndi zinthu zomwe zili patsamba ili. Koma nthawi zambiri, makonda osinthika amagwirizana ndi ntchitoyi, kuti mungodina batani la "Ok" mutalowa mawu achinsinsi.



4. Pambuyo pake, zenera lina limayamba, pomwe mawu achinsinsi adalowa kale ayenera kubwerezedwa. Izi zimachitika kuonetsetsa kuti wogwiritsa ntchitoyo watsimikiza kuti amayambitsa mawu achinsinsi omwe ndidakumbukira ndikulemba mu kiyibodi yoyenera ya kiyibodiyo ndi nthawi yomwe iyo imatha kutaya kusintha kwa chikalatacho. Pambuyo polowera mawu achinsinsi, dinani batani la "OK".



5. Tsopano poyesera kusintha chinthu chilichonse cholembera, izi zitsekedwa. Windo la chidziwitso lidzatseguka, kufotokozera za kuthekera kosintha deta pa pepala lotetezedwa.

Pali njira ina yoletsa kusintha kulikonse pamapepala.

1. Pitani ku "Unikani" pawindo la "Tulutsani tsamba la masamba" lomwe lili pa tepi mu "kusintha" chida.



2. Adatsegulidwa kale kwa inu zenera loteteza pawindo. Zochita zonse zimachita chimodzimodzi monga tafotokozera m'mbuyomu.

Koma choti muchite ngati mungafunike kumasuka maselo amodzi kapena angapo, ndipo mwa ena kumaganiziridwa, monganso, kuti mupange data? Pali njira yothetsera udindowu, koma yankho lake ndilovuta kwambiri kuposa ntchito yapitayo.

M'maselo onse a chikalata chokhazikika mu katundu, chitetezo chikuwonetsedwa, pomwe pepala limayambitsidwa mwa onse, zosankha zotchulidwa pamwambapa. Tiyenera kuchotsa gawo loteteza mu zinthu zonse m'mapepala onse, kenako ndikuyikanso mu zinthu zomwe tikufuna kuti zisinthe.

1. Dinani pa rectangle, yomwe ili pachiwonetsero cha mapanelo opingasa ndi ofukula. Komanso, ngati cholozera chili m'dera lililonse la pepalalo kunja kwa tebulo, kanikizani kuphatikiza makiyi otentha pa ctrl + kiyibodi. Zotsatira zake zidzakhala chimodzimodzi - zinthu zonse pa pepalalo zikuwonetsedwa.



2. Kenako timakhala ndi malo owoneka bwino ndi oyenera. Mumenyu Yoyambitsa, sankhani "Fomu Yachisoni ...". Komanso, m'malo mwake, mutha kugwiritsa ntchito ctrl + 1 kuphatikiza.



3. "Mawonekedwe a" Foll 'zenera limayambitsidwa. Kusintha nthawi yomweyo ku "chitetezo". Iyenera kuchotsedwa bokosi lomwe lili pafupi ndi "cell yotetezedwa". Dinani pa batani la "OK".



4. Kenako, timabwereranso ku pepalalo ndikugawa chinthu kapena gulu lomwe tidzaumbitsirani. Timadina kumanja ku dikatiro lodzipereka komanso mndandanda wazomwe zalembedwa, pitani ku dzina la "Fomu la Maselo ...".



5. Mukatsegula zenera, mukapitanso ku "chitetezo" cha "chitetezo" chojambulidwa. Tsopano mutha kudina batani la "OK".



6. Pambuyo pake, timakhazikitsa chitetezerocho mwa njira ziwiri izi zomwe zidafotokozedwapo kale.

Pambuyo popanga njira zonse zomwe zafotokozedwa pamwambapa, ma cell okha omwe timayikonzanso omwe timakonzedwanso kudzera mu zinthu zomwe zimatsekedwa kusintha. Mu zinthu zina zonse za pepalalo, monga kale, mutha kupereka ndalama zonse.

Phunziro: Momwe mungatetezere khungu kuti zisinthe kuti zisinthe

Monga mukuwonera, pali njira zitatu zozinulira maselo. Koma ndikofunikira kuzindikira kuti zimasiyana mwa iwo aliyense wa iwo osati ukadaulo zokha zopanga njirayi, komanso chiyambi cha chisanu chokha. Chifukwa chake, nthawi imodzi, adilesi ya tsamba lokha ndi yolembedwa, lachiwiri - malowa ndi okhazikika pazenera, ndipo chachitatu - chitetezo cha kusintha kwa deta m'maselo. Chifukwa chake, ndikofunikira kuti mumvetse bwino asanachite njirayi, muyenera kutchinjiriza ndi chifukwa chiyani mumachita.