Chizindikiro cha Chizindikiro pa Excel. Momwe mungapangire chingwe chosinthira mu selo la Excel - njira zonse

Nthawi zambiri, anthu omwe amagwira ntchito ku Excesheam Tabl tabu amakumana ndi zomwezi ndi zomwe mungafune kusintha mzere. Khazikitsani njira yosavuta imeneyi ikhoza kukhala yosiyanasiyana. Munkhaniyi, tikambirana njira zonse mwatsatanetsatane zomwe zimakupatsani mwayi woti musinthe mzere womwe uli pamalo ogwirira ntchito ya tebulo.

Momwe mungachotse mizere yochokera ku maselo a 2013, 2010 ndi 2007

Pali njira zitatu zomwe zimakupatsani mwayi kuti muchotse chonyamulira kuchokera m'minda. Ena mwa iwo amakhazikitsa zizindikiro zamitundu. Zosankha zomwe takambirana pansipa zikugwiranso ntchito mosiyanasiyana m'magulu ambiri okoma.

chimodzi

Kusamutsa mzere womwe uli patsamba la mameseji pazifukwa zosiyanasiyana. Kutengera pafupipafupi monga kugwiritsa ntchito "Alt + olowera" kuphatikiza kwakukulu, komanso kusamutsa mawu kuchokera patsamba la intaneti kupita kuntchito yamalonda. Tiyenera kuchotsa chonyamulira chobwerera, chifukwa popanda njirayi ndizosatheka kukhazikitsa kufunafuna kosayenera kwa mawu olondola.

Chotsani malo onyamula pamanja pamanja

Tidzakambirana mwatsatanetsatane njira yoyamba.

• Ubwino: Kuphedwa mwachangu.
• Zovuta: Palibe mawonekedwe owonjezera.

Malangizo atsatanetsatane amawoneka motere:

1. Timatulutsa maselo onse omwe muyenera kukwaniritsa izi kapena m'malo mwa zizindikiro.

2.

1. Kugwiritsa ntchito kiyibodi, kanikizani mabatani a "CTRL + H" h ". Windo lidawonekera pazenera kukhala ndi dzinalo "kupeza ndi kusintha".
2. Yesani mzere wa "Pezani". Kugwiritsa ntchito kiyibodi, kanikizani kuphatikiza kwa "Ctrl + J". Mfundo yaying'ono idawonekera mu mzere.
3. Mu "m'malo mwa" mzere, timayika mtengo wake womwe umayika m'malo monyamula. Nthawi zambiri malo amagwiritsidwa ntchito, monga amakupatsani mwayi wothetsa vuto la mawu oyandikana nawo. Kuti akwaniritse kuchotsedwa kwa mizere, ndikofunikira kusintha "kulowa" kuti "musinthe" chidziwitso chilichonse.

3.

1. Mothandizidwa ndi LKM, dinani "m'malo mwazonse". Takonzeka! Takhazikitsa kuchotsedwa kwa chonyamula.

4 Chotsani zingwe zosintha pogwiritsa ntchito njira zapamwamba

• Ubwino: Kuthekera kogwiritsa ntchito njira zingapo zomwe zimayesedwa zovuta za chidziwitso cha mameseji pamunda wosankhidwa. Mwachitsanzo, mutha kuzindikira kuti kunyamula katunduyo kumabwerera, kenako kupeza mipata yosafunikira.
• Zovuta: Ndikofunikira kupanga mzere wowonjezera, komanso kuphedwa kwa kuchuluka kwazapula.

Malangizo atsatanetsatane amawoneka motere:

1. Timakhazikitsa ndikuwonjezera gawo lina kumapeto kwa chidziwitso. Mwachitsanzo ichi, lipeza dzinalo "mzere woyamba"
2. Mu gawo limodzi la nambala yowonjezera (C2), timayendetsa formula yomwe imazindikira kuchotsedwa kapena kulowetsedwa kwa mizere. Mitundu ingapo imagwiritsidwa ntchito kukhazikitsa ntchitoyi. Formula, oyenera kugwiritsa ntchito zophatikizana ndi kubwezeretsa kwa chonyamula ndikuwoneka ngati izi: = choloweza (choloweza (13); "").
3. Njira, yoyenera kusintha kusamutsa ndi chizindikiro chilichonse, chikuwoneka ngati ichi: = szhenbel (chogwirizira (13); "). Ndikofunika. Pachifukwa ichi sadzayanja mizere.
4. Njira yomwe imakupatsani mwayi kuti muchotse zikwangwani zonse zosasindikizidwa kuchokera ku deta yolemba, zikuwoneka kuti: = grisimpa (b2).

zisanu

1. Timapanga kiyi yokopera, kenako timayika mu khungu lililonse la gawo lina.
2. Kuphatikiza apo, mutha kusintha mzere woyamba wa yatsopanoyo, pomwe mizere imachotsedwa.
3. Timatulutsa zida zonse zomwe zili mu S. C. akanikizire "ctrl + c" pa kiyibodi kuti mukwaniritse zambiri.
4. Timapanga kusankha kwa gawo la B2. Kanikizani kuphatikiza kwa mabatani a "Shift + F10" F10. Mu mndandanda waung'ono wa LKM, chinthu chokhala ndi dzina "kuyika".
5. Tikhazikitsa kuchotsera kwa chimbalangondo.

Chotsani zingwe zomwe zimagwiritsidwa ntchito pogwiritsa ntchito VBRO

• Ubwino: Zolengedwa zimangochitika. M'tsogolomu, macro awa amathanso kugwiritsa ntchito zikalata zina zolembedwa.
• Zovuta: ndikofunikira kumvetsetsa ntchito ya chilankhulo cha VBA.

Kuti mukwaniritse njirayi, muyenera kulowa pazenera lolowera macros ndikulowetsa nambala iyi:

6.

Kusamutsa mawu

Mnzanu wa Exel wampatuko umakupatsani mwayi wosamutsa nkhani m'munda. Izi zachitika kuti zolemba zalembedwazo zikuwonetsedwa pamizere ingapo. Mutha kupanga njira zokhazikitsira gawo lililonse kuti kusamutsa kwa deta kumapangidwa zokha. Kuphatikiza apo, ndizotheka kukhazikitsa mizere ya mzere ndi njira yamatumbo.Kusamutsa kwaulere

Tidzakambirana mwatsatanetsatane momwe mungagwiritsire ntchito njira yosinthira zolemba. Gawo ndi sitepe a algorithm imawoneka motere:

1. Timapanga kusankha kwa selo yoyenera.
2. Mu "kunyumba" yathu, timapeza malamulo okhala ndi dzinalo "kugwirizanitsa".
3. Mothandizidwa ndi LCM, sankhani "zolemba".

Kukhazikitsa kutalika kwa chingwe kuti muwonetse zolemba zonse

Tidzakambirana mwatsatanetsatane momwe mungagwiritsire ntchito njira yowonjezera pazomwe zalembedwa. Malangizo atsatanetsatane amawoneka motere:

1. Timapanga kusankha kwa maselo omwe mukufuna.
2. Mu "kunyumba", timapeza malamulo okhala ndi dzina "maselo".
3. Kugwiritsa ntchito LCM, Sankhani "mtundu" chinthu.
4. Mu "Kukula kwa Maselo" Muyenera kuwononga imodzi mwazosankhazi. Njira yoyamba ndikugwirizanitsa kutalika kwa ma khzipinda tomwe timakhala ndi mzere wa mizere. Njira yachiwiri - kukhazikitsa kutalika kwa mizere, muyenera dinani gawo la "chingwe kutalika", kenako ndikuyendetsa chizindikiro chofuna kukhala chopanda kanthu.

Lowani Chingwe

Tidzakambirana mwatsatanetsatane momwe tingagwiritsire ntchito njira yolowera mizere yopuma. Malangizo atsatanetsatane amawoneka motere:

1. Mwa kukanikiza pawiri lkm, timasankha gawo lomwe tikufuna kuyendetsa mizere. Ndikofunika kudziwa kuti mutha kusankha gawo lofunikira, kenako dinani F2.
2. Kudina LKM, timasankha malo omwe mizere yopumira idzawonjezedwa. Dinani kuphatikiza kwa "Alt + kulowa". Takonzeka!

Momwe mungasinthire kupatula mu cell ya Excel

Nthawi zambiri ogwiritsa ntchito tebulo, ogwiritsa ntchito matebulo amawonjezera zojambula zosiyanasiyana ndi zojambula ku malo ogwirira ntchito. Nthawi zambiri njirayi imafunikira kusamutsa mizere mu chidziwitso cham'munda. Tidzamvetsetsa mwatsatanetsatane momwe mungadziwire nthawi iyi.

Formula Yosamutsa Zingwe Zowonjezera mu maselo a Excel

Mwachitsanzo, tili ndi roboogram yomwe idachitika mu pulogalamu ya tabular. Pa axis X pali mayina a ogwira ntchito, komanso chidziwitso chokhudza malonda awo. Mtundu wamtunduwu ndi wosavuta, monga momwe zimasonyezeratu kukula kwa ntchito yomwe imachitidwa ndi antchito.

7.

Kukhazikitsa njirayi ndikosavuta. Muyenera kuwonjezera wothandizira ku mtundu wa formula. Zimakupatsani mwayi wotsatira m'badwo wa zisonyezo m'minda ya kusaina chidziwitso mu tchati.

zisanu ndi zitatu

Zachidziwikire, mutha kugwiritsa ntchito njira yosinthira kwina kulikonse, chifukwa cha kuphatikiza kwa "Alt +. Komabe, njirayi siyosavuta pazomwe zili zochulukirapo.

Momwe ntchito ikugwirira ntchito mukamasamutsa mizere mu khungu

Pulogalamuyi imagwiritsa ntchito ma code kuchokera ku zizindikiro za Ascii. Muli manambala osayina omwe adawonetsedwa pawonetsero mu OS. Pulate ili ndi zilembo mazana awiri mphambu makumi asanu ndi asanu.

Wogwiritsa ntchito mkonzi wa tebulo, yemwe amadziwa ma code awa, amatha kuzigwiritsa ntchito pazithunzi zonena kuti mukwaniritse chizindikiro chilichonse. Mwa zitsanzo zomwe tafotokozazi, chizindikiro cha kusamutsa mzere, womwe umalumikiza kuchokera mbali zonse za "&" pakati pa zisonyezo za C2 ndi A2. Ngati mundawo sunayendetsedwe ndi "kutumiza mawu" m'munda, ndiye kuti kupezeka kwa wogwiritsa ntchito kwa moyo sikuzindikira. Izi zikuwoneka pa chithunzi pansipa:

zisanu ndi zinai

Gawani pazingwe za chingwe

Ngati wogwiritsa ntchito "deta" asankha "zolemba pazambiri" chinthu ", chitha kukhazikitsa mizere ndikulekanitsa zidziwitso za mayeso m'maselo angapo. Njirayi imachitika pogwiritsa ntchito "Alt + yolowera". Mu "Kugawa Wiza Ward" Wizard, muyenera kuyika pafupi ndi mawu a "ena" ndikuyambitsa "CTRL + J".

10

Ngati mungayike cholembedwa cholembedwa "kuti muganizire olekana mochenjera kwa m'modzi", ndiye kuti mutha kuwonongeka "kuwonongeka" kwa madongosolo angapo a mizereyo motsatana. Pa gawo lomalizidwa, dinani pa "Kenako". Zotsatira zake, tidzapeza:

khumi chimodzi

Gawani mizere ndi Alt + Enter kudzera kufunsa kwamphamvu

Pali zochitika zomwe wosuta amafunikira kugawa zidziwitso za zolemba zingapo sizili pa mzati, koma pamzere.

12

Kuti akwaniritse njirayi, "kufunsa mafunso amphamvu" amachitidwa, omwe amapezeka pa tebulo la tebulo kuyambira 2016. Malangizo atsatanetsatane amawoneka motere:

1. Kugwiritsa ntchito "Ctrl + t" t ", timatembenuza deta ya" wanzeru ". Njira zina - kusuntha "kunyumba" ndikudina LKM kuti "mtundu ngati tebulo" chinthu.
2. Kusuntha mu "deta" ndikudina pa "kuchokera pagome / mtundu". Opaleshoniyo imakupatsani mwayi kulowetsa chikwangwani chofunsidwa.

13

1. Timapanga chisankho cha nambala ndi chidziwitso cholembedwa. Kusuntha "kunyumba". Vumbulani mndandanda wa chizindikiro cha "sprit yogawanika" ndikudina LKM pa element ".

khumi ndi mphabu zinayi

1. Dinani pa "Chabwino" kuti mutsimikizire zosintha zomwe zachitika. Takonzeka!

fifitini

Macro kuti agawe zingwe pa Alt + Enter

Ganizirani njirayi pogwiritsa ntchito macro apadera. Timapanga kutseguka kwa VBA pogwiritsa ntchito kiyibodi ya kiyibodi ya F11 F11. Pooneka ngati zenera, dinani "Inni" kenako "gawo". Apa tikuwonjezera nambala yotereyi:

khumi ndi zisanu ndi chimodzi

Timabwereranso kuntchito ndikusankha minda yomwe zambiri za mzere wambiri zili. Dinani kuphatikiza kwa "Alt + F8" pa kiyibodi kuti muyambitse zomwe zidapangidwa.

chidule

Kutengera ndi nkhani ya nkhaniyi, zitha kudziwika kuti pali njira zambiri zomwe zimagwiritsira ntchito kusamutsa mzere mu chikalatacho. Mutha kupanga njirayi pogwiritsa ntchito njira, ogwiritsa ntchito, zida zapadera ndi macros. Wogwiritsa aliyense angathe kusankha njira yabwino kwambiri yokha.

Chizindikiro chenicheni. Momwe Mungapangire Kusamutsira mu Sextl Cell - njira zonse zidawonekera koyamba ukadaulo.