Excel: Mawonekedwe ambiri osiyanasiyana

Chimodzi mwazinthu zomwe ogwiritsa ntchito amakumana mukamagwira ntchito ndi matebulo ku Microsoft Excorl, ndiye cholakwika "mitundu yambiri ya cell. Zimakhala zofala kwambiri mukamagwira ntchito ndi matebulo owonjezera. Tiyeni tiwone poyera vutoli ndikupeza njira zomwe zingathetsedwe.

Tsopano chikalatacho chidzapulumutsidwa ndi kuchuluka kwa xlsx, komwe kumakulolani kuti mugwire ntchito ndi kuchuluka kwa maola 16 nthawi imodzi. Pamilandu yambiri, njirayi imalola kuti muchepetse cholakwika chomwe tidaphunzira.

Njira 2: Kuyeretsa Mizere Yopanda Yopanda

Komabe pali zochitika ngati wogwiritsa ntchitoyo amagwira ndendende ndi kukula kwa xlsx, koma imachitikabe cholakwika ichi. Izi zimachitika chifukwa chakuti pogwira ntchito ndi chikalatacho, kutsiritsika kwa mafomu 64,000 kunapitilira. Kuphatikiza apo, pazifukwa zina, zinthu zina ndizotheka mukafuna kupulumutsa fayiloyo ndi kukula kwa xls, osati xlk, kuyambira poyambirira, kuyambira koyamba, kumagwira ntchito yoyamba ya gulu. Muzochitika izi, muyenera kuyang'ana njira ina ya zomwe zikuchitika.

Nthawi zambiri, ogwiritsa ntchito ambiri amapanga malo omwe ali pansi pa tebulo ndi malire kotero kuti mtsogolomo sataya nthawi panjirayi. Koma izi ndi njira yolakwika kwambiri. Chifukwa cha izi, kukula kwa fayilo kumachulukirachulukira, kugwira ntchito ndi kumayamba kuchepa, kuwonjezera apo, zochita ngati izi zimatha kubweretsa cholakwika chomwe tikukambirana pamutuwu. Chifukwa chake, kwa oterowo akayenera kuchotsedwa.

1. Choyamba, tiyenera kuwonetsa kudera lonse pansi pa tebulo, kuyambira gawo loyamba lomwe palibe deta. Kuti muchite izi, dinani batani la Mouse kumanzere pa dzina la manambala a chingwe cholumikiza. Adapereka mzere wonse. Ikani kukakamiza kuphatikiza kwa CTRL + Shift + pansi pansi. Adapereka gawo lonse la chikalatacho pansipa.



2. Kenako timasamukira ku "kunyumba" ndikudina chithunzi cha tepi la "chowonekera", chomwe chili mu chipangizo cha chida chosinthira. Mndandanda umatsegulidwa pomwe mumasankha "mitundu yowoneka bwino".



3. Pambuyo pa izi, mizere yodzipereka idzatsukidwa.

Mofananamo, ndizotheka kuyeretsa m'maselo kumanja kwa tebulo.

1. Dongo la dzina la woyamba osadzazidwa ndi mzati m'magulu ogwirizana. Ili ndi Niza. Kenako timatulutsa ctrl + kusuntha + mpaka kumanja. Izi zikuwunikira zingapo za chikalatacho, chomwe chili kumanja kwa tebulo.



2. Ndiye, monga momwe zapita kale, timadina chithunzi cha "chomveka", ndipo mu menyu yotsika, sankhani njira "yodziwikiratu".



3. Pambuyo pake, kuyeretsa kudzatsukidwa m'maselo onse kumanja kwa tebulo.

Njira yofananayo ikamachitika ngati vuto ili la phunziroli, sizingakhale zotsogola ngakhale poyamba zikuwoneka kuti mabungwe omwe ali pansi ndi ufuluwo samasinthidwa konse. Chowonadi ndi chakuti atha kukhala ndi "" zobisika ". Mwachitsanzo, zolemba kapena manambala mu cell sizingakhalepo, koma zimakhala ndi mtundu wolimba, etc. Chifukwa chake, musakhale aulesi, pakakhala cholakwika, kuti muchite njirayi pamphepete mwa kunja. Simuyeneranso kuiwala za mizere ndi mizere yobisika.

Njira 3: Kuchotsa mafomu mkati mwa tebulo

Ngati mtundu wakale sunathandizire kuthetsa vutoli, ndiye kuti ndikofunikira kutengera kusamalira kwambiri patebulo. Ogwiritsa ntchito ena amapanga mawonekedwe patebulo ngakhale kuti silingamvekenso zina. Amaganiza kuti amapanga tebulo lokongola kwambiri, koma kwenikweni, nthawi zambiri, kapangidwe kotere kumawoneka kokongola koyipa. Choyipa chachikulu ngati zinthu zomwe zanenedwa zimatsogolera ku braket pulogalamuyo kapena cholakwika chomwe timafotokoza. Pankhaniyi, ziyenera kusiyidwa patebulo lokha mawonekedwe ofunikira.

1. M'magulu omwe amapanga mawonekedwe amatha kuchotsedwa kwathunthu, ndipo izi sizingakhudze chidziwikire pa tebulo, timachita njira yolingana ndi algorithm yemweyo, yemwe adafotokozedwayo njira yapitayo. Choyamba, tikutsindika za mtundu womwe ukuyeretsedwa uyenera kutsukidwa. Ngati tebulo ili lalikulu kwambiri, ndiye njirayi ndi yabwino kwambiri kuchitika, pogwiritsa ntchito ctrl + yosasunthika + kumanja (kumanzere, pansi, pansi). Ngati mungasankhe khungu mkati mwa tebulo, kenako pogwiritsa ntchito makiyi awa, kusankhidwa kumangopangidwa mkati mwake, osati mpaka kumapeto kwa pepalalo, ngati njira yapitayo.

   Tadina batani lanu mwachidule "chojambula" m'nyumba ya tabu yakunyumba. M'ndandanda womwe watsika, sankhani njira "yodziwika".



2. Mitundu yapamwamba ya tebulo idzayeretsedwa kwathunthu.



3. Chokhacho chomwe chikufunika kuchitika ndikukhazikitsa malire mu chidutswa choyeretsa ngati alipo m'zofali zina zonse.

Koma pazigawo zina za tebulo, kusankha kumeneku sikoyenera. Mwachitsanzo, munthawi inayake mutha kuchotsa zodzaza, koma mtundu wa tsiku uyenera kusiyidwa, apo ayi deta idzawonetsedwa molakwika, malire ndi zinthu zina. Mtundu womwewo wa zomwe tidakambirana pamwambapa, amachotsa mawonekedwe.

Koma pali njira yopulumukira ndipo pankhaniyi, komabe, ndikovuta kwambiri. Zikatero, wogwiritsa ntchitoyo ayenera kugawa chopindika chilichonse ndikuchotsa mawonekedwe popanda zomwe mungachite.

Zachidziwikire, ndi phunziro lalitali komanso lopanduka, ngati tebulo ili lalikulu kwambiri. Chifukwa chake, kuli bwino mukakonza chikalata chosagwiritsa ntchito "zokongola" kuti zikhale ndi mavuto omwe angakhale nawo nthawi yayitali.

Njira 4: Kuchotsa mawonekedwe

Kupanga kwatsatanetsatane ndi chida chosavuta kwambiri cha data, koma kugwiritsa ntchito kwake kwambiri kungapangitsenso cholakwika chomwe tidaphunzira. Chifukwa chake, muyenera kuwona mndandanda wa malamulo omwe amagwiritsidwa ntchito pa pepala ili, ndikuchotsa udindowo, popanda zomwe mungachite.

1. Ili mu "Home", dongo pa batani la "Maphunziro a" Mumenyu zomwe zitsegulidwa pambuyo pake, sankhani "malamulo oyang'anira".



2. Kutsatira izi, zenera loyang'anira malamulo limayambitsidwa, lomwe lili ndi mndandanda wazopanga zogwirizana.



3. Mwachisawawa, zinthu zokhazokha zomwe zasankhidwa zimapezeka pamndandanda. Pofuna kuwonetsa malamulo onse papepala, sinthaninso kusinthaku mu "kuwonetsa malamulo owonetsa" the "pepala ili". Pambuyo pake, malamulo onse a pepala lapano adzawonetsedwa.



4. Kenako timagawa malamulowa osachita zomwe mungachite, ndikudina pa batani "Delete Blate".



5. Mwanjira imeneyi, timachotsa malamulo omwe satenga gawo lofunikira m'malingaliro owoneka bwino. Pambuyo njirayi yatsirizidwa, kanikizani batani la "OK" pansi pa intaneti.

Ngati mukufuna kuchotsa zolembedwa kuchokera pamlingo wina, ndiye kuti ndizosavuta kuchita.

1. Tikuwonetsa maselo osiyanasiyana omwe timakonzekera kuchotsa.



2. Dinani pa batani la "Malingaliro" mu "masitayilo" block ya tabu yakunyumba. Pa mndandanda womwe umawonekera, sankhani "Delete malamulo". Kenako, mndandanda wina umayamba. Mmenemo, sankhani "Fufutani malamulo kuchokera ku maselo osankhidwa".



3. Pambuyo pake, malamulo onse m'magawo odzipereka adzachotsedwa.

Ngati mukufuna kuchotsa mapangidwe am'malo, ndiye kuti mu mndandanda wotsiriza wankhani muyenera kusankha njirayi "Chotsani malamulo kuchokera pa pepalalo".

Njira 5: Kuchotsa masitaelo

Kuphatikiza apo, vutoli lingabuke chifukwa chogwiritsa ntchito masitayilo ambiri. Kuphatikiza apo, zitha kuwoneka ngati zotsatira zoloweza kapena kukopera kuchokera m'mabuku ena.

1. Vutoli limachotsedwa motere. Pitani ku "kunyumba". Pa tepi mu "masitayilo" zida block Dinani pagululo "ma cell a maselo".



2. Amatsegula mndandanda wazochitika. Pali mitundu ingapo ya maselo a maselo, ndiye kuti, kuphatikiza mitundu ingapo. Pamwamba kwambiri pamndandanda kuti pali "chizolowezi". Masitayilo awa sanapangidwe poyamba, koma ndi malonda ogulitsa. Ngati cholakwika chikuchitika, kuchotsedwa kwa zomwe timaphunzira tikulimbikitsidwa kuti tichotse.



3. Vuto ndilakuti palibe chida chomangidwa ndi kuchotsa masitayilo, kuti aliyense athetse padera. Timabweretsa cholozera kwa kalembedwe kake kuchokera ku gulu la "chizolowezi". Ndimadina pa iyo ndi batani la mbewa lamanja komanso pazakudya zomwe zili, sankhani ... ".



4. Timachotsa mwanjira iliyonse yochokera ku "chizolowezi" chochokera pansi chokhacho chomangidwa ndi zopangidwa zokha.

Njira 6: Kuchotsa mafomu

Njira yofananira yochotsa masitayles ndikuchotsa mafomu azochitika. Ndiye kuti, tidzakuta zinthu zomwe sizimakhazikitsidwa - zopitilira mu Excel, koma zimakhazikitsidwa ndi wogwiritsa ntchito, kapena adamangidwa mu chikalatacho mwanjira ina.

1. Choyamba, tidzafunikira kutsegula zenera. Njira yodziwika bwino yochitira ndikudina kumanja kulikonse komwe aliwonse mu chikalatacho ndikuchokera ku menyu kuti asankhe njira ya "Fomu ...".

   

   Muthanso, tili mu "kunyumba" tabu, dinani pa "mtundu" batani mu "Cell" pa tepi. Mu menyu yoyendetsa, sankhani chinthu "cell a mtundu ...".

   

   Njira ina yoimbira foni yomwe mukufuna kuti muwoneke la ctrl + 1 makiyi pa kiyibodi.

2. Pambuyo pochita chilichonse chomwe chafotokozedwa pamwambapa, zenera lokonzanso lidzayamba. Pitani ku "nambala". Mu "mitundu ya manambala", timakhazikitsa kusinthaku "(mamitundu onse)". Kumbali yakumanja kwa zenera ili, mundawo umapezeka momwe pali mndandanda wamitundu yonse yazinthu zomwe zimagwiritsidwa ntchito mu chikalatachi.

   Tikutsikiratu mawuwo aliyense. Pitani ku dzina lotsatira kukhala labwino kwambiri ndi kiyi ya "pansi" pa kiyibodi mu chipinda cha navigation. Ngati chinthucho chimamangidwa, kenako "Chotsani" sichikhala chosagwira.



3. Mukangomaliza kumene ogwiritsa ntchito amawunikira, batani la "Chotsani" lidzakhala lachangu. Dinani pa Iwo. Momwemonso, fufutani mayina onse a mawonekedwe omwe ali pamndandanda.



4. Tikamaliza njirayi, tiyenera kukanikiza batani la "OK" pansi pazenera.

Njira 7: Kuchotsa ma sheet osafunikira

Tidafotokozeranso zomwe zachitika kuti zithetse vutoli mkati mwa pepala limodzi. Koma musaiwale kuti ndewu zomwezo muyenera kuchitika ndi buku lina lonse lodzazidwa ndi ma sheet.

Kuphatikiza apo, ma sheet osafunikira kapena mapepala, pomwe chidziwitso chimalembedwa, ndibwino kuchotsa konse. Amachitika mosavuta.

1. Mwa kuwonekera batani la mbewa lamanja panjira yachidule, yomwe iyenera kuchotsedwa pamwamba pa bar. Kenako, mumenyu zomwe zikuwoneka, sankhani "chotsani ...".



2. Pambuyo pake, bokosi la zokambirana limatseguka zomwe zimafuna kutsimikizira kwa kuchotsedwa kwakanthawi. Dinani pa batani la "Chotsani".



3. Kutsatira izi, zilembo zosankhidwa zidzachotsedwa pachikalatacho, chifukwa chake, zonse zomwe zimapangika.

Ngati mukufuna kuchotsa njira zingapo zokhazikika, kenako dinani woyamba wa iwo ndi batani lakumanzere, kenako dinani chomaliza, koma nthawi yomweyo ndikugwira kiyi yosinthira. Zolemba zonse zomwe zili pakati pa zinthuzi zidzafotokozedwa. Kenako, njira zochotserapo zimachitika pa algorithm yemweyo yemwe adafotokozedwa pamwambapa.

Koma palinso mapepala obisika, ndipo itha kukhala zinthu zambiri zosiyanasiyana. Kuchotsa kwambiri mapangidwe awa kapena kuzichotsa konse, muyenera kuwonetsa nthawi yomweyo.

1. Dinani pa zilembo zilizonse komanso muzosankha zomwe zili munkhaniyi, sankhani "SHAT".



2. Mndandanda wa zobisika zobisika. Sankhani dzina la pepala lobisika ndikudina batani la "OK". Pambuyo pake, idzawonetsedwa pandege.

Ntchito yotereyi imachitika ndi mapepala onse obisika. Kenako tikuwona chochita nawo: Kuchotsa kwathunthu kapena kuyeretsa kusinthidwa ngati chidziwitsocho ndichofunikira pa iwo.

Koma kupatula izi, palinso ma sheet otchedwa apamwamba kwambiri, omwe mu mndandanda wamalo obisika omwe simupeza. Amatha kuwoneka ndikuwonetsedwa pamagulu okha kudzera mu mkonzi wa VBA.

1. Kuyambitsa VBA mkonzi (Mkonzi wa Macro), dinani kuphatikiza kwa Keys Gys + F11. Mu "ntchito", timagawa dzina la pepalalo. Apa akuwonetsedwa ngati ma shidi wamba, obisika kwambiri. Pamalo otsika "katundu" tikuyang'ana mtengo wa "wowoneka". Ngati zakhazikitsidwa "2-xrsheetphyhi zobisika", ndiye pepala lapamwamba kwambiri.



2. Dinani pa gawo ili komanso mndandanda womwe umatsegulira, sankhani dzina "-1-xrsheetvisble". Kenako dinani malinga ndi batani lotseka.

Pambuyo pa izi, pepala losankhidwa lidzasiya kukhala ndi nkhawa ndipo zilembozi ziwonetsedwa pandege. Kenako, zidzatheka kuchititsa chilichonse njira yotsuka kapena kuchotsedwa.

Phunziro: Zoyenera kuchita ngati ma sheet akusowa kwambiri

Monga mukuwonera, njira yabwino kwambiri komanso yabwino imachotsa cholakwika chophunzirira mu phunziroli - ndikusunga fayilo kachiwiri ndi kukula kwa Xlx. Koma ngati njira iyi siyigwira ntchito kapena pazifukwa zina sioyenera, njira zotsalazo zothetsera vutoli lizifuna nthawi yambiri ndi khama kuchokera kwa wogwiritsa ntchito. Kuphatikiza apo, zonsezi zidzayenera kugwiritsidwa ntchito movuta. Chifukwa chake, ndibwino kuti mupange chikalata chosagwiritsa ntchito molakwika mapangidwe kuti ndiye kuti sayenera kugwiritsa ntchito mphamvuzo kuti athetse cholakwikacho.