Momwe mungathere mavidiyo kuchokera pa malo ochezera a pa Intaneti Odnoklassniki pa Android-smartphone ndi iPhone

Imodzi mwa mavuto omwe abasebenzisi amakumana nawo pakugwira ntchito ndi matebulo mu Microsoft Excel ndizolakwika "Zambiri zosiyana maselo". Ndizofala makamaka pamene mukugwira ntchito ndi matebulo ndikulumikizidwa kwa .xls. Tiyeni timvetse tanthauzo la vutoli ndikupeza momwe lingathetsere.

Onaninso: Kodi mungachepetse bwanji kukula kwa fayilo ku Excel

Kusintha maganizo

Kuti mumvetsetse momwe mungakonzere zolakwikazo, muyenera kudziwa zomwe zilipo. Chowonadi ndi chakuti maofesi a Excel ndi XLSX kufandizira kufandizira panthawi yomweyo ntchito ndi mafomu 64000 mu chikalata, ndipo ndi XLS kulongosola - 4000 okha. Ngati malire awa atapitirira, vuto ili likupezeka. Maonekedwe ndi kuphatikiza zinthu zosiyanasiyana zojambula:

• Malire;
• Lembani;
• Foni;
• Histograms, ndi zina zotero.

Choncho, pangakhale zida zingapo mu selo limodzi panthawi imodzi. Ngati kupangidwira kwakukulu kumagwiritsidwa ntchito muzitsamba, izi zingayambitse zolakwika. Tiyeni tsopano tiwone momwe tingakonzere vuto ili.

Njira 1: Sungani fayilo ndizowonjezera XLSX

Monga tafotokozera pamwambapa, zolemba ndi XLS zowonjezera zothandizira panthawi imodzi zimagwira ntchito ndi 4,000 zokhazokha magawo. Izi zikufotokozera kuti nthawi zambiri vuto ili limapezeka mwa iwo. Kutembenuzira bukhu ku xLSX yatsopano yamakono, yomwe imathandizira ntchito imodzi palimodzi ndi zinthu 64000 zojambula, zidzakulolani kugwiritsa ntchito zinthu izi kasanu ndi katatu zisanachitike.

1. Pitani ku tabu "Foni".



2. Kuwonjezera pa menyu yoyang'ana kumanzere, timasankha pa chinthucho "Sungani Monga".



3. Fayilo yosungira mafayilo likuyamba. Ngati mukufuna, zikhoza kupulumutsidwa kwina kulikonse, ndipo sikuti kumene buku loyambira likupezeka popita kudiresi yosiyana ya disk. Komanso kumunda "Firimu" Mutha kusankha kusintha dzina lake. Koma izi siziri zovomerezeka zikhalidwe. Zokonzera izi zingasiyidwe ngati zosasintha. Ntchito yaikulu ili m'munda "Fayilo Fayilo" kusintha mtengo "Buku la ntchito la Excel 97-2003" on "Buku labwino". Pachifukwa ichi, dinani pa malo awa ndipo sankhani dzina loyenera kuchokera pandandanda yomwe imatsegulidwa. Mutatha kuchita izi, dinani pa batani. Sungani ".

Tsopano chikalatacho chidzapulumutsidwa ndi kufalikira kwa XLSX, komwe kudzakulolani kugwira ntchito ndi chiwerengero chachikulu cha mawonekedwe nthawi 16, kusiyana ndi momwe zinalili ndi fayilo ya XLS. Nthawi zambiri, njirayi imachotsa zolakwika zomwe tikuphunzirazo.

Njira 2: yesani mawonekedwe mu mizere yopanda kanthu

Koma palinso nthawi pamene wogwiritsa ntchito ndi extension XLSX, koma akadali ndi vuto ili. Ichi ndi chifukwa chakuti pamene mukugwira ntchito ndi chikalata, mzere mu mafomu 64000 udapitilizidwa. Kuwonjezerapo, pazifukwa zina, ndizotheka kuti muzisunga fayilo ndi kutambasula kwa XLS, osati kuwonjezera kwa XLSX, chifukwa, mwachitsanzo, mapulogalamu ena achitatu angagwire ntchito yoyamba. Pazochitikazi, muyenera kuyang'ana njira ina kunja kwa izi.

Kawirikawiri, ambiri ogwiritsa ntchito amajambula danga la tebulo lokhala ndi malire kuti asawononge nthawi pazochitikazi pokhapokha pakhale chingwe chowonjezera. Koma izi ndi njira yolakwika. Chifukwa chaichi, kukula kwa fayilo kumawonjezeka kwambiri, kugwira nawo ntchito kumachepetsanso, kupatulapo, zochita zoterezi zingayambitse zolakwika, zomwe tikukambirana m'nkhaniyi. Choncho, kupitirira koteroko kuyenera kuthetsedwa.

1. Choyamba, tifunika kusankha malo onse pansi pa tebulo, kuyambira ndi mzere woyamba, umene mulibe deta. Kuti muchite izi, dinani botani lamanzere lamanzere pa dzina lachindunji la mzerewu pamphindi wowonongeka. Sankhani mzere wonse. Yesani kukanikiza mabatani osakaniza Ctrl + Shift + Pansi Mzere. Chigawo chonsecho chili pansi pa tebulo chikuwonetsedwa.



2. Kenaka pita ku tabu "Kunyumba" ndipo dinani pa chithunzi pa leboni "Chotsani"yomwe ili mu zida za zipangizo Kusintha. Mndandanda umatsegulidwa pamene timasankha malo. "Chotsani Zomangamanga".



3. Pambuyo pachithunzi ichi, mtundu wosankhidwa udzathetsedwa.

Mofananamo, mukhoza kupanga kuyeretsa m'maselo kupita kumanja.

1. Dinani pa dzina la ndime yoyamba yosadzazidwa ndi deta muzowunikira. Pali kusankha kwa pansi. Kenako timapanga makina osakaniza. Ctrl + Shift + Kwanja lamanja. Panthawi imodzimodziyo, chikalata chonsecho chimakhala kumanja kwa gome chikusonyezedwa.



2. Ndiye, monga momwe zinalili kale, dinani pazithunzi "Chotsani", ndi m'ndandanda pansi, sankhani kusankha "Chotsani Zomangamanga".



3. Zitatha izi, zidzakonzedwa m'maselo onse kumanja.

Mchitidwe wofananamo ngati cholakwikacho chikuchitika, zomwe tikukamba mu phunziro lino, sizongoganizira ngakhale poyamba poyang'ana zikuoneka kuti mndandanda womwe uli pansipa ndikupangidwe pa tebulo sungapangidwe konse. Chowonadi ndi chakuti akhoza kukhala ndi maonekedwe "obisika". Mwachitsanzo, pangakhale palibe malemba kapena manambala mu selo, koma liri ndi mawonekedwe ofanana, ndi zina zotero. Choncho, musakhale aulesi, ngati mukulakwitsa, kuti muzitsatira njirayi, ngakhale pazinthu zooneka ngati zopanda kanthu. Komanso, musaiwale zazomwe zingakhale zobisika ndi mizere.

Njira 3: Chotsani Mafomu M'mawonekedwe

Ngati bukhu lapitalo silinathetsere vutoli, ndiye kuti muyenera kumvetsera mwakuya kwambiri mkati mwa tebulo lokha. Ogwiritsa ntchito ena amapanga ma tebulo patebulo ngakhale pamene sali ndi zina zowonjezera. Iwo amaganiza kuti apanga tebulo kukhala lokongola kwambiri, koma makamaka nthawi zambiri kuchokera kumbali, mapangidwe amenewa amawoneka osakhala abwino. Choipa kwambiri, ngati zinthu izi zimayambitsa kulepheretsa pulogalamuyo kapena zolakwika zomwe tikufotokoza. Pankhaniyi, muzisiya zokhazokha zokhazikika patebulo.

1. Mu mndandanda momwe maonekedwe angachotsedwe kwathunthu, ndipo izi sizidzakhudza zomwe zilipo patebulo, timachita ndondomekoyi pogwiritsira ntchito ndondomeko yomweyo monga momwe tafotokozera mu njira yapitayi. Choyamba, sankhani zamtundu uliwonse kuti muyeretsedwe. Ngati tebulo ndi lalikulu kwambiri, ndiye kuti njirayi idzakhala yabwino kwambiri kugwiritsa ntchito mabatani Ctrl + Shift + Kwanja lamanja (kumanzere, mmwamba, pansi). Ngati mutasankha selo mkati mwa gome, ndiye kugwiritsa ntchito makiyiwa, kusankha kumangokhala mkati mwake, osati kumapeto kwa pepala, monga mwa njira yapitayi.

   Timakanikiza pa batani yomwe tidziwa kale. "Chotsani" mu tab "Kunyumba". M'ndandanda wotsika pansi, sankhani kusankha "Chotsani Zomangamanga".



2. Mndandanda wa tebulo wosankhidwa udzasulidwa kwathunthu.



3. Chinthu chokha chimene chiyenera kuchitika pambuyo pake ndikuyika malire mu chidutswa chochotsedwa, ngati alipo mndandanda wa magome onse.

Koma kumadera ena a gome, njira iyi sichitha kugwira ntchito. Mwachitsanzo, pamtunda wina, mutha kuchotsa, koma muyenera kuchoka pa fomu yamtundu, mwinamwake deta sidzawonetsedwa molondola, malire ndi zinthu zina. Zochita zomwezo, zomwe tinakambirana pamwamba, zimachotsa zonsezo.

Koma pali njira yothetsera vutoli, komabe, nthawi yambiri ikudya. Zikatero, wogwiritsa ntchitoyo ayenera kugawa maselo ofanana ndi maselo opangidwa mofananamo ndikuchotsa pamanja mawonekedwe popanda, omwe angaperekedwe nawo.

Zoonadi, izi ndizochita masewera olimbitsa thupi, ngati tebulo ndi lalikulu kwambiri. Choncho, ndibwino kuti musagwiritse ntchito molakwika "pokongola" polemba chikalata, kuti pakapita nthawi pasakhale mavuto, ndipo muyenera kuthera nthawi yochuluka poyithetsa.

Njira 4: Chotsani zojambula Zowonjezera

Kupanga maonekedwe ndizomwe zimagwiritsidwa ntchito bwino, koma kugwiritsa ntchito molakwika kungapangitsenso zolakwika zomwe tikuphunzirazo. Choncho, m'pofunika kubwereza mndandanda wa malamulo omangika omwe akugwiritsidwa ntchito pa pepala ili ndi kuchotsa malo omwe angaperekedwe nawo.

1. Ili pa tabu "Kunyumba"dinani batani "Mafomu Okhazikika"zomwe ziri mu block "Masitala". Mu menyu yomwe imatsegulira pambuyo pachithunzichi, sankhani chinthucho "Ulamuliro wa Malamulo".



2. Pambuyo pake, malamulo oyendetsa zenera akuyambira, momwe mndandandanda wa zigawo zovomerezeka zovomerezeka zilipo.



3. Mwachikhazikitso, zigawo zokha za chidutswa chosankhidwa chalembedwa. Kuti muwonetsere malamulo onse pa pepala, titsani kusinthana kumunda "Onetsani malamulo omasulira" mu malo "Tsamba ili". Pambuyo pake malamulo onse a pepala laposachedwapa adzawonetsedwa.



4. Kenaka sankhani lamulolo, popanda zomwe mungachite, ndipo dinani batani "Chotsani malamulo".



5. Mwa njira iyi, timachotsa malamulo omwe samasewera mbali yofunikira pamaganizo a deta. Ndondomekoyo itatha, dinani pa batani. "Chabwino" pansi pazenera Mtsogoleri Woyang'anira.

Ngati mukufuna kuchotsa mwatsatanetsatane maonekedwe osiyana siyana, ndiye kuti n'zosavuta kuchita.

1. Sankhani maselo osiyanasiyana omwe tikukonzekera kuchotsa.



2. Dinani pa batani "Mafomu Okhazikika" mu block "Masitala" mu tab "Kunyumba". Mundandanda womwe ukuwonekera, sankhani kusankha "Chotsani Malamulo". Zina zowonjezera zina zimatsegulidwa. M'menemo, sankhani chinthucho "Chotsani malamulo ku maselo osankhidwa".



3. Pambuyo pake, malamulo onse mudongosolo losankhidwa adzachotsedwa.

Ngati mukufuna kuchotsa mwatsatanetsatane zolembazo, ndiye kuti mumndandanda wamasewera omaliza, sankhani kusankha "Chotsani malamulo kuchokera mndandanda wonse".

Njira 5: Chotsani Mafilimu Ogwiritsa Ntchito

Kuwonjezera pamenepo, vutoli likhoza kuchitika chifukwa chogwiritsa ntchito miyambo yambiri yamakhalidwe. Ndipo zingawoneke ngati zotsatira za kutumiza kapena kukopera kuchokera ku mabuku ena.

1. Vutoli lasinthidwa motere. Pitani ku tabu "Kunyumba". Pa tepiyi mu chida cha zipangizo "Masitala" dinani pagulu Maselo Achilili.



2. Mndandanda wa masewera umatsegulidwa. Limapereka mitundu yosiyanasiyana ya zokongoletsera maselo, ndiko kuti, kuyika kosakanikirana kwa maonekedwe angapo. Pamwamba pa mndandanda muli chipika "Mwambo". Mitambo iyi yokha siinamangidwe koyambirira mu Excel, koma ndizogwiritsidwa ntchito pamagwiritsidwe ntchito. Pomwe pali vuto, kuchotseratu kumene tikuphunzira, ndibwino kuchotsa.



3. Vuto ndiloti palibe chida chogwiritsidwa ntchito pochotsa mafilimu, kotero muyenera kuchotsa aliyense payekha. Sungani chithunzithunzi pa ndondomeko inayake kuchokera pagulu. "Mwambo". Dinani pa ilo ndi botani lamanja la mouse ndipo sankhani zomwe mungachite m'mawotchi "Chotsani ...".



4. Mwanjira imeneyi timachotsa kalembedwe kalikonse kuchokera ku chipika. "Mwambo"mpaka pali Excel machitidwe omwe ali mkati mwake.

Njira 6: Chotsani Mafomu Athunzi

Ndondomeko yofanana yochotsera mafashoni ndiyo kuchotsa machitidwe ozoloŵera. Izi ndizo, tidzachotsa zinthu zomwe sizinapangidwe mwachisawawa ku Excel, koma zimagwiritsidwa ntchito ndi wogwiritsa ntchito, kapena zakhala zolembedwera muzitsulo m'njira ina.

1. Choyamba, tifunika kutsegula zenera. Njira yowonjezereka yochitira izi ndikulumikiza molondola pa malo alionse m'kalembedwe ndikusankha njira kuchokera mndandanda wa mauthenga. "Sungani maselo ...".

   

   Mukhozanso, pokhala pa tabu "Kunyumba", dinani pa batani "Format" mu block "Maselo" pa tepi. Mu menyu yoyamba, sankhani chinthucho "Sungani maselo ...".

   

   Njira ina yowonjezera mawindo omwe tikusowa ndiyiyi yazitsulo zosintha Ctrl + 1 pabokosi.

2. Pambuyo pochita zochitika zilizonse zomwe zafotokozedwa pamwambapa, zenera zikuyambira. Pitani ku tabu "Nambala". Muzitsulo zamkati "Maofomu Owerengeka" ikani kasinthasintha kuti muyime "(mafomu onse)". Kumanja kwazenera pazenera ili ndi munda umene uli ndi mndandanda wa mitundu yonse ya zinthu zomwe zimagwiritsidwa ntchito muzitsamba.

   Sankhani aliyense wa iwo ndi ndondomeko. Ndibwino kwambiri kusamukira ku dzina lotsatira ndi fungulo "Kutsika" pa khibhodi yoyendetsa. Ngati chinthucho chili mkati, batani "Chotsani" m'munsimu mndandanda sudzatha.



3. Mwamsanga pamene chinthu chowonjezeka chowonjezeka chikuwonekera, batani "Chotsani" adzakhala achangu. Dinani pa izo. Mofananamo, timachotsa maina onse ojambula pamndandanda.



4. Pambuyo pokwaniritsa ndondomekoyi, onetsetsani kuti dinani pa batani. "Chabwino" pansi pazenera.

Njira 7: Chotsani Masamba Osayenera

Tinafotokozera zomwe tingachite kuti tithetse vuto pokhapokha mu pepala limodzi. Koma musaiwale kuti ndondomeko zomwezo ziyenera kuchitika ndi bukhu lonse lodzazidwa ndi deta.

Kuphatikizanso, mapepala kapena mapepala osayenera, kumene mauthenga akuphatikizidwa, ndi bwino kuchotsa. Izi zachitika mophweka.

1. Dinani pomwepo pa chizindikiro cha pepala chomwe chiyenera kuchotsedwa, chomwe chili pamwamba pa chikhomo. Kenako, mu menyu imene ikuwonekera, sankhani chinthucho "Chotsani ...".



2. Zitatha izi, bokosi la bokosi liyamba kutsegula lomwe likufuna kutsimikizira kuti kuchotsa njirayo. Dinani pa batani "Chotsani".



3. Pambuyo pake, chizindikiro chosankhidwa chidzachotsedwa pa chikalatacho, ndipo, motero, zigawo zonse zojambula pa izo.

Ngati mukufuna kuchotsa mafupikiti angapo otsatizana, dinani pa yoyamba ndi batani lamanzere, kenako dinani pamapeto pake, koma ingogwiritsani chinsinsi Shift. Malembo onse pakati pa zinthu izi adzawonetsedwa. Komanso, njira yakuchotserako ikuchitika molingana ndi ndondomeko yomweyo yomwe inanenedwa pamwambapa.

Koma palinso mapepala obisika, ndipo pazimenezi zingakhale zigawo zambiri zosiyana siyana. Kuti muchotse zambiri pamasamba awa kapena kuchotsa zonsezi, muyenera kuwonetsa mwamsangamsanga madulewo.

1. Dinani pa njira yotsatila iliyonse ndipo sankhani chinthucho m'ndandanda wamakono "Onetsani".



2. Mndandanda wa mapepala obisika amatsegulidwa. Sankhani dzina la pepala lobisika ndipo dinani pa batani "Chabwino". Pambuyo pake idzawonetsedwa pa gululi.

Timachita opaleshoniyi ndi mapepala onse obisika. Ndiye tikuyang'ana zomwe tingachite ndi iwo: kuchotsani kapena kuchotseratu maonekedwe, ngati mauthengawa ndi ofunika.

Koma kupatula izi, palinso amatchedwa mapepala obisika, omwe simungapeze mndandanda wa mapepala omwe amapezeka nthawi zonse. Amatha kuwonetsedwa ndikuwonetsedwa pa gululo kupyolera mu mkonzi wa VBA.

1. Kuti muyambe mkonzi wa VBA (macro editor), pezani makina otentha Alt + F11. Mu chipika "Project" sankhani dzina la pepala. Nazi pano ngati mapepala omwe amawonekera, omwe amabisika komanso obisika kwambiri. M'munsimu "Zolemba" yang'anani mtengo wa parameter "Chowoneka". Ngati yayikidwira "2-xlSheetVeryHidden"ndiye iyi ndi pepala lobisika kwambiri.



2. Ife timasankha pa parameter iyi ndi mndandanda wotsegulidwa yomwe timasankha dzina. "-1-xlSheetVisible". Kenaka dinani pa batani kuti muzitseka zenera.

Zitatha izi, pepala losankhidwa lidzatha kukhala losabisala ndipo njira yake yotsatila idzawonetsedwa pa gululi. Kenaka, n'zotheka kuchita njira yoyeretsera kapena kuchotsa.

PHUNZIRO: Zomwe mungachite ngati mapepala akusowa mu Excel

Monga mukuonera, njira yofulumira komanso yothandiza kwambiri yochotsera zolakwika zomwe tafufuza mu phunziro ili ndikusunga fayilo kachiwiri ndi extension XLSX. Koma ngati chisankhochi sichigwira ntchito kapena chifukwa china sichigwira ntchito, zotsalazo zothetsa vutoli zidzafuna nthawi yambiri ndi khama kuchokera kwa wogwiritsa ntchito. Kuwonjezera pamenepo, zonsezi ziyenera kugwiritsidwa ntchito movuta. Choncho, ndi bwino kupanga pulogalamu kuti musagwiritse ntchito molakwika kwambiri machitidwe, kotero kuti pamapeto pake simusowa mphamvu kuti muchotse vutoli.