Microsoft Excel Erution Solution "Mitundu Yosiyanasiyana Ya Maselo"

Limodzi mwamavuto omwe ogwiritsa ntchito amakumana nawo akamagwiritsa ntchito matebulo ku Microsoft Excel ndi cholakwika "Mawonekedwe ambiri amitundu." Ndizofala makamaka pogwira ntchito ndi matebulo okhala ndi kuwonjezera kwa .xls. Tiyeni timvetse tanthauzo la vutoli ndikupeza njira zomwe lingathetsere.

Onaninso: Momwe mungachepetse kukula kwa fayilo ku Excel

Kukonza zovuta

Kuti mumvetsetse zolakwika, muyenera kudziwa tanthauzo lake. Chowonadi ndi chakuti mafayilo a Excel omwe amakhala ndi .xlsx supplement ntchito munthawi yomweyo ali ndi mitundu 64,000 zolembedwa, ndipo ndikuwonjezera kwa .xls - 4,000 okha. Malire awa akapitirira, vuto ili limachitika. Fomu ndi kuphatikiza kwa mitundu yosiyanasiyana:

• Malire;
• Dzazani;
• Font
• Mbiri, etc.

Chifukwa chake, mu selo limodzi mumatha kukhala mitundu ingapo nthawi imodzi. Ngati chikalatacho chimagwiritsa ntchito mitundu yambiri, ndiye kuti zitha kungoyambitsa vuto. Tiyeni tsopano tiwone njira yothetsera vutoli.

Njira 1: sungani fayilo ndi kuwonjezera kwa .xlsx

Monga tafotokozera pamwambapa, zikalata zokhala ndi .xls zimathandizira kugwira ntchito imodzi yamayunitsi okwanira 4,000 okha. Izi zikufotokozera kuti nthawi zambiri cholakwika ichi chimachitika mwa iwo. Kutembenuza buku kukhala buku lamakono la XLSX, lomwe limathandizira kugwira ntchito ndi mitundu yokwana 64,000 nthawi imodzi, lidzakuthandizani kuti mugwiritse ntchito zinthuzi maulendo 16 koposa zolakwika pamwambapa zisanachitike.

1. Pitani ku tabu Fayilo.



2. Kenako, mndandanda wazolowera kumanzere, dinani chinthucho Sungani Monga.



3. Zenera lopulumutsa limayamba. Ngati chikufunidwa, chitha kusungidwa kumalo ena, osati kumalo komwe chikalata chochokera chikupezeka ku doko lina la hard drive. Komanso m'munda "Fayilo dzina" mutha kusintha dzina lakelo. Koma izi sizofunikira poyamba. Zokonda izi zitha kusiidwa ngati zosakwanira. Ntchito yayikulu ndi m'munda Mtundu wa Fayilo kusintha mtengo "Excel Book 97-2003" pa Buku lantchito. Pazifukwa izi, dinani patsamba ili ndikusankha dzina loyenerera kuchokera pamndandanda womwe umatseguka. Pambuyo pochita ndondomeko yomwe mwatchulayo, dinani batani Sungani.

Tsopano chikalatacho chidzapulumutsidwa ndikuwonjezeredwa kwa XLSX, zomwe zingatheke kuti zigwiritse ntchito mpaka nthawi 16 kuchuluka kwa mafomu nthawi imodzi monga momwe zimagwirira ntchito ndi fayilo yowonjezera XLS. Muzochitika zambiri, njira iyi imachotsa cholakwika chomwe tikuphunzira.

Njira 2: mawonekedwe omveka m'mizere yopanda tanthauzo

Komabe, pali nthawi zina pomwe wogwiritsa ntchito akuwonjezera XLSX, komabe amapeza cholakwika ichi. Izi ndichifukwa choti pogwira ntchito ndi chikalatachi, mapilogalamu oyendetsera mafomu 64,000 adapitilira. Kuphatikiza apo, pazifukwa zina, zinthu zimatha kuchitika mukasowa kupulumutsa fayilo ndi XLS kuwonjezera osati XLSX, popeza choyambirira, mwachitsanzo, chitha kugwira ntchito ndi mapulogalamu akulu kwambiri. Muzochitika izi, muyenera kuyang'ana njira ina kuchokera pamenepa.

Nthawi zambiri, ogwiritsa ntchito ambiri amapanga malo patebulo wokhala ndi malire, kuti m'tsogolo asataye nthawi pochita izi ngati pakukula kwa tebulo. Koma iyi ndi njira yolakwika mwamtheradi. Chifukwa cha izi, kukula kwa fayilo kumawonjezeka kwambiri, kugwira nawo ntchito kumachepera, ndipo pambali pake, machitidwe oterewa angayambitse zolakwika zomwe timakambirana pamutuwu. Chifukwa chake, zochuluka motere ziyenera kutayidwa.

1. Choyamba, tiyenera kusankha dera lonse pansi pa tebulo, kuyambira mzere woyamba, momwe mulibe deta. Kuti muchite izi, dinani kumanzere pa dzina la manambala la mzerewu m'ndendende. Mzere wonse wasankhidwa. Ikani kuphatikiza kwa mabatani Ctrl + Shift + Down Arrow. Gawo lonse la chikalatacho likuwonetsedwa pansipa.



2. Kenako timasunthira ku tabu "Pofikira" ndikudina chizindikiro cha riboni "Chotsani"ili mu chipangizo "Kusintha". Mndandanda umatseguka momwe timasankhira malo "Fafanizani Mafomu".



3. Pambuyo pa izi, mtundu womwe wasankhidwa udzayeretsedwa.

Momwemonso, mutha kuyeretsa kumeselo kupita kumanja kwa tebulo.

1. Dinani pa dzina la mzere woyamba wosadzaza ndi data mu yolumikizira gulu. Imakwezedwa pansi. Kenako timapanga mabatani ophatikizika Ctrl + Shift + Arrow Right. Poterepa, gawo lonse la chikalata chomwe chili kumanja kwa tebulo limawunikidwa.



2. Kenako, monga momwe zinalili kale, dinani chizindikiro "Chotsani", ndikusankha njira mumenyu yotsitsa "Fafanizani Mafomu".



3. Pambuyo pake, kuyeretsa kudzachitidwa mu maselo onse kumanja kwa tebulo.

Njira yofananayo pakachitika cholakwika, chomwe tikukambirana mu phunziroli, sichingakhale malo pomwe chingawonekere koyamba kuti magulu omwe ali pansipa ndi kumanja kwa tebulo sanapangidwe konse. Chowonadi ndi chakuti akhoza kukhala ndi mafomu "obisika". Mwachitsanzo, sipakhoza kukhala zolemba kapena manambala mu foni, koma amayikidwa kuti azilimba, etc. Chifukwa chake musakhale aulesi, mukalakwitsa, chitani izi ngakhale pazinthu zopanda kanthu. Komanso musaiwale za mzati wobisika komanso mizere.

Njira 3: chotsani mawonekedwe mkati mwa tebulo

Ngati njira yapita sikunathandize kuthetsa vutoli, ndiye kuti muyenera kuyang'anira kusanja kwambiri mkati mwa tebulo lokha. Ogwiritsa ntchito ena amapanga kujambulidwa patebulopo ngakhale pomwe sipakhala zowonjezera zina. Amaganiza kuti zimapangitsa kuti gome likhale lokongola kwambiri, koma makamaka nthawi zambiri kuchokera kunja, mawonekedwe otere amawoneka opanda pake. Choyipa chachikulu, ngati izi zimatsogolera pulogalamu kapena zoletsa zomwe timafotokozera. Poterepa, mitundu yokhayo yoyenera ingasiyidwe patebulopo.

1. M'magawo momwe makonzedwe amatha kuchotsedwa kwathunthu, ndipo izi sizingakhudze zambiri zomwe zili patebulopo, timachita njirayi molingana ndi algorithm yomweyo yomwe inafotokozedwera njira yapita. Choyamba, sankhani mitundu yonse patebulopo momwe mungayeretsere. Ngati tebulo ndi lalikulu kwambiri, ndiye kuti njirayi idzakhala yosavuta kugwiritsa ntchito kuphatikiza batani Ctrl + Shift + Arrow Right (kumanzere, m'mwamba, pansi) Ngati nthawi yomweyo mumasankha khungu mkati mwa tebulo, pogwiritsa ntchito mafungulo awa, kusankha kumapangidwa mkati mwake momwemo, osati kumapeto kwa pepalalo, monga momwe munachitira kale.

   Dinani batani lomwe tikudziwa kale "Chotsani" pa tabu "Pofikira". Pamndandanda wotsitsa, sankhani njira "Fafanizani Mafomu".



2. Mitundu yosankhidwa ya tebulo idzayeretsedwa kwathunthu.



3. Chokhacho chomwe chidzafunikire kutero ndikuyika malire mu gawo lochotsedwa, ngati likupezeka m'ndondomeko yonse.

Koma m'malo ena a tebulo, njirayi singagwire ntchito. Mwachitsanzo, mumtundu wina, mutha kuchotsa zojambulazo, koma muyenera kusiya mtundu wa tsikulo, apo ayi sizowonetsedwa bwino, malire ndi zinthu zina. Kutengera komweko zomwe tidakambirana pamwambapa kumachotsa mawonekedwe.

Koma pali njira yopitira ndipo pankhaniyi, komabe, imawononga nthawi yambiri. Zikatero, wosuta ayenera kusankha mtundu uliwonse wa maselo osakanikirana ndikuchotsa pamanja mawonekedwe omwe angagawiridwe nawo.

Zachidziwikire, iyi ndi ntchito yayitali komanso yopweteka ngati tebulo ndilokulirapo. Chifukwa chake, ndibwino kusagwiritsa ntchito "kukongola" nthawi yomweyo pokonzekera chikalata, kuti pambuyo pake pasakhale zovuta, yankho lake lomwe limatenga nthawi yambiri.

Njira 4: chotsani mawonekedwe anu

Kusintha kwamagetsi ndi chida chothandiza kwambiri pakuwona zithunzi, koma kugwiritsa ntchito kwambiri kungayambitsenso cholakwika chomwe tikuphunzira. Chifukwa chake, muyenera kuyang'ana pa mndandanda wa malamulo ogwiritsira ntchito polemba izi ndikuchotsa maudindo omwe mutha kuchita popanda.

1. Ali pa tabu "Pofikira"dinani batani Njira Zakukonzeranizomwe zili pabowo Masitaelo. Pazosankha zomwe zimayamba pambuyo pa izi, sankhani Malamulo Oyang'anira.



2. Kutsatira izi, iwindo lolamulira lawongolera limayambitsidwa, lomwe lili ndi mndandanda wazinthu zosintha mawonekedwe.



3. Mwachidziwikire, mndandandawo umangokhala ndi zinthu zomwe zidasankhidwa. Kuti tiwonetse malamulo onse papepala, timakonzanso kusintha m'munda "Onetsani malamulo osintha a" m'malo "Tsamba ili". Pambuyo pake, malamulo onse a pepala lapano awonetsedwa.



4. Kenako sankhani lamulo lomwe mutha kuchita popanda kudina, ndikudina batani Chotsani lamulo.



5. Mwanjira imeneyi, timachotsa malamulowo omwe samachita mbali yofunika pakuwona kwa chidziwitso. Ndondomekoyo ikamaliza, dinani batani "Zabwino" pansi pazenera Woyang'anira.

Ngati mukufunikira kuchotsa mawonekedwe onse pamitundu ina, ndiye kuti kupangitsa kukhala kosavuta.

1. Sankhani maselo osiyanasiyana omwe tikufuna kuchotsa.



2. Dinani batani Njira Zakukonzerani mu block Masitaelo pa tabu "Pofikira". Pamndandanda womwe umawonekera, sankhani njira Chotsani malamulo. Kenako, mndandanda wina umatsegulidwa. Mmenemo, sankhani chinthucho "Chotsani malamulo ku maselo osankhidwa".



3. Pambuyo pake, malamulo onse mumtundu wosankhidwa adzachotsedwa.

Ngati mukufuna kuchotsera mitundu yonse, ndiye kuti mndandanda wotsiriza muyenera kusankha "Chotsani malamulo pachidutswa chonse".

Njira 5: chotsani masitaelo

Kuphatikiza apo, vutoli limatha kuchitika chifukwa chogwiritsa ntchito masitayilo ambiri. Kuphatikiza apo, zitha kuwoneka ngati zotengera kapena kutsitsa kuchokera ku mabuku ena.

1. Nkhaniyi yathetsedwa motere. Pitani ku tabu "Pofikira". Pa nthiti yomwe ili m'bokosi la chida Masitaelo dinani pagulu Masitayelo Am'manja.



2. Zosintha zamawonekedwe zimatseguka. Mitundu yosiyanasiyana yamapangidwe am'masamba aperekedwa pano, ndiye kuti, ndizophatikiza zosakanikira zamitundu ingapo. Pamwambapa kwambiri ndi mndandanda Mwambo. Zotengera izi zokha sizomwe zidapangidwira mu Excel, koma ndizochita zamagulu ogwiritsa. Ngati cholakwika chachitika kuti tikufufuza, tikulimbikitsidwa kuti muzifafaniza.



3. Vutoli ndikuti palibe chida chokhazikitsidwa chomachotsa masitayilo, motero muyenera kufufuta chilichonse payokha. Yendani pamtundu winawake kuchokera pagulu Mwambo. Timadina ndi batani loyenera la mbewa ndikusankha njira muzosankha Chotsani ... ".



4. Timachotsa kalembedwe kalikonse pa chipika motere. Mwambompaka mawonekedwe okhawo a Excel atsalira.

Njira 6: chotsani mawonekedwe

Njira yofananira yochotsa masitaelo ndikuchotsa mawonekedwe. Ndiye kuti, tidzachotsa zinthu zomwe sizinapangidwe mwaosakhazikika ku Excel, koma ndizophatikizidwa ndi wogwiritsa ntchito, kapena zomwe zinamizidwa mu chikalatacho mwanjira ina.

1. Choyamba, tifunika kutsegula zenera lolowera. Njira yodziwika kwambiri yochitira izi ndikudina kumanja kulikonse mu chikalatacho ndikusankha njira kuchokera pazosankha "Mtundu wamtundu ...".

   

   Mukhozanso, kukhala tabu "Pofikira"dinani batani "Fomu" mu block "Maselo" pa tepi. Pazosankha zomwe zimatsegulira, sankhani "Mtundu wamtundu ...".

   

   Njira ina yoyitanitsa zenera lomwe tikufuna ndi makina amtundu wa keyboard Ctrl + 1 pa kiyibodi.

2. Pambuyo pochita chilichonse mwazomwe tafotokozazi, chiwonetserochi chikuyamba. Pitani ku tabu "Chiwerengero". Pakadutsa magawo "Mawerengero Amanambala" khazikitsani kusintha "(mitundu yonse)". Mbali yoyenera ya zenera ili ndi gawo lomwe lili ndi mndandanda wazinthu zonse zomwe zimagwiritsidwa ntchito polemba izi.

   Sankhani chilichonse chaiwo ndi chowunikira. Pitani ku chinthu chotsatira ndichabwino kwambiri ndi kiyi "Pansi" pa kiyibodi mu msewu wopita panyanja. Ngati chinthucho chili pakati, batani Chotsani pansi pa mndandanda adzakhala wopanda ntchito.



3. Chomwe chawonjezedwa chosankha chikawonetsedwa, batani Chotsani azikhala achangu. Dinani pa izo. Momwemonso, timachotsa mayina onse ofotokozedwa ndi ogwiritsa ntchito mndandanda.



4. Mukamaliza ndondomekoyi, onetsetsani kuti dinani batani "Zabwino" pansi pazenera.

Njira 7: chotsani ma sheet osafunikira

Tinafotokoza zochita kuthana ndi vutoli mkati mwa pepala limodzi. Koma musaiwale kuti chimodzimodzi kuti ziwonetsero zomwezo ziyenera kuchitika ndi ma sheet ena onse a bukhu lodzazidwa ndi izi.

Kuphatikiza apo, ma shiti kapena ma shiti osafunikira pomwe zidziwitso zimakonzedwanso, ndibwino kuzimitsa. Izi zimachitika mosavuta.

1. Timadina pomwe pamndandanda wa pepala lomwe liyenera kuchotsedwa, lomwe lili pamwamba pa mipiringidzo yaudindo. Kenako, menyu omwe akuwoneka, sankhani Chotsani ... ".



2. Izi zimatsegula bokosi la zokambirana zomwe zimafuna chitsimikiziro kuti zichotse njira yachidule. Dinani batani mmenemo. Chotsani.



3. Kutsatira izi, zilembo zomwe zasankhidwa zidzachotsedwa mu chikalatacho,, mwakutero, zinthu zonse zosintha pa icho.

Ngati mukufuna kuchotsa njira zazifupi zingapo, ndiye dinani koyamba ndi batani lakumanzere, kenako dinani komaliza, koma ingotsitsani kiyi Shift. Njira zazifupi zonse pakati pa zinthuzi zidzawonetsedwa. Chotsatira, njira yochotsera imachitika molingana ndi algorithm yomweyo monga tafotokozera pamwambapa.

Koma palinso masamba obisika, ndipo pa iwo pomwepo pamatha kukhala ndi chiwerengero chachikulu cha zinthu zosiyanasiyana zosanjidwa. Kuti muchepetse mawonekedwe pama sheet awa kapena kuwachotsa onse, muyenera kuwonetsa zazifupi.

1. Timadina tatifupi iliyonse ndikusankha chinthucho menyu Onetsani.



2. Mndandanda wamasamba obisika amatsegulidwa. Sankhani dzina la chinsinsi chobisika ndikudina batani "Zabwino". Pambuyo pake, ziwonetsedwa pagawo.

Timagwira ntchito yotere ndi ma sheet onse obisika. Kenako tiona zoyenera kuchita ndi iwo: kuchotsa kwathunthu kapena kuyeretsa pakupanga mitundu yambiri, ngati chidziwitso ndichofunika.

Koma kupatula izi, palinso ma sheet otchedwa obisika kwambiri, omwe simupeza pamndandanda wamashiti wamba obisika. Amatha kuwonetsedwa ndikuwonetsedwa pagawo kokha kudzera mkonzi wa VBA.

1. Kuyambitsa mkonzi wa VBA (mkonzi wamkulu), akanikizire kuphatikiza kwa hotkey Alt + F11. Mu block "Ntchito" sankhani dzina la pepalalo. Imawoneka ngati ma shiti wamba owoneka, obisika komanso obisika kwambiri. M'dera lakumunsi "Katundu" yang'anani phindu la chizindikiro "Zowoneka". Ngati mungakhale pamenepo "2-xlSheetVeryH siri", ndiye ichi ndi chinsinsi chobisika kwambiri.



2. Timadina pagululi ndipo pamndandanda womwe umatsegulira, sankhani dzinalo "-1-xlSheetChowonekera". Kenako dinani batani loyenera kutseka zenera.

Pambuyo pa izi, pepala losankhidwa silidzabisikanso ndipo cholembedwa chake chiziwonetsedwa pagawo. Komanso, ndizotheka kuchita njira yoyeretsera kapena yochotsa.

Phunziro: Zoyenera kuchita ngati ma sheet akusowa ku Excel

Monga mukuwonera, njira yachangu kwambiri komanso yothandiza kwambiri yochotsera zolakwika zomwe zaphunzirazi ndi kupulumutsanso fayilo ndikuwonjezera .xlsx. Koma ngati njirayi imagwira ntchito kapena pazifukwa zina sizigwira ntchito, ndiye njira zina zothetsera vutoli zimafuna nthawi yochulukirapo komanso khama kuchokera kwa wogwiritsa ntchito. Kuphatikiza apo, onse ayenera kugwiritsidwa ntchito palimodzi. Chifukwa chake, ndibwino kuti musagwiritse ntchito zolemba molakwika pakapangidwe ka chikalatacho, kuti pambuyo pake musayese mphamvu mukukonza cholakwacho.