Mtundu wa maselo kutengera mtengo wake

Anonim

Kudzaza maselo amtundu mu Microsoft Excel

Mukamagwira ntchito ndi matebulo, mtengo wofunikira umakhala ndi zomwe zimawonetsedwa mkati mwake. Koma chinthu chofunikira kwambiri ndi kapangidwe kake. Ogwiritsa ntchito ena amaona kuti ndi chinthu chachiwiri ndipo sichimawasamalira mwapadera. Ndipo pachabe, chifukwa tebulo lokongoletsera bwino ndilofunika kuti muzindikire bwino komanso kumvetsetsa kwa ogwiritsa ntchito. Kuwona kwa deta kumaseweredwa makamaka mu izi. Mwachitsanzo, pogwiritsa ntchito zida zopenya, mutha kujambula ma cell ma cell kutengera zomwe zilimo. Tiyeni tiwone momwe zitha kuchitikira mu pulogalamu ya Excel.

Njira yosintha mtundu wa maselo kutengera zomwe zili

Zachidziwikire, zimakhala bwino kukhala ndi tebulo lopangidwa bwino, lomwe maselo otengera zomwe zili m'mitundu yosiyanasiyana. Koma izi ndizofunikira makamaka pamagome akulu okhala ndi gawo lalikulu la data. Pankhaniyi, kudzaza ndi mtundu wa maselo kumathandizira kwambiri ogwiritsa ntchito mu chidziwitso chambiri, monga momwe chinganenere chidzalembedwedwa kale.

Zinthu za tsamba zimatha kuyesera kupaka utoto wamakono, koma kachiwiri, ngati tebulo ndi lalikulu, limatenga nthawi yambiri. Kuphatikiza apo, mu mtundu wa deta, chinthu chamunthu chingasewere gawo ndipo zolakwa zidzaloledwa. Osanena kuti tebulo likhoza kukhala lamphamvu ndipo zomwe zimasinthidwa nthawi ndi nthawi, komanso. Pankhaniyi, sinthani utoto nthawi zonse kumakhala wopanda pake.

Koma zotulutsa zimakhalapo. Kwa maselo omwe ali ndi Mphamvu (Kusintha) Kugwiritsa ntchito mawonekedwe am'madzi

Njira 1: Mawonekedwe

Pogwiritsa ntchito mawonekedwe azolinga, mutha kufotokozera malire omwe malembedwe omwe maselo adzapakidwa utoto umodzi. Kukhazikika kudzachitika zokha. Ngati mtengo wake, chifukwa cha kusintha, kutuluka m'malire, kumangosinthanitsa ndi tsamba.

Tiyeni tiwone momwe njirayi imagwirira ntchito mwachitsanzo. Tili ndi tebulo la ndalama za bizinesi, pomwe izi zikuwopa. Tiyenera kuwunikirana ndi mitundu yosiyanasiyana yomwe kuchuluka kwa ndalama zomwe zimapezeka ndizochepera 400,000, kuyambira ma ruble 400,000 mpaka 500,000 mpaka ma rubles 500,000.

  1. Tikutsindika za mzere momwe chidziwitso chambiri chabizinesi chimapezeka. Kenako timasamukira ku tabu "kunyumba". Dinani pa batani la "Makina", omwe ali pa tepi mu "masitayilo". Pa mndandanda womwe umatsegulira, sankhani zowongolera malamulo.
  2. Kusintha Kunja Malamulo Oyang'anira ku Microsoft Excel

  3. Malamulo wamba amayambitsidwa. "Kupanga kukonza kwa" mundawo kuyenera kukhazikitsidwa kwa "chiwonetsero chapano". Mwachidule, ndi ndendende kuti isalembedwe pamenepo, koma ngati, onani momwe mungasinthire, sinthani zikhazikitso malinga ndi malingaliro omwe ali pamwambawa. Pambuyo pake, dinani pa "Pangani lamulo ..." batani.
  4. Kusintha Kukupanga Lamulo la Microsoft Excel

  5. NJIRA YA DZIKO LAPANSI LOPHUNZITSIRA. Pamndandanda wa malamulo, sankhani malo oti "mawonekedwe okhawo omwe ali ndi". M'mafotokozedwe, malamulo omwe ali m'munda woyamba, kusinthaku kuyenera kuyimilira. Mu gawo lachiwiri, timasinthiratu ku "zochepa". Mu gawo lachitatu, fotokozerani mtengo, zinthu za pepalali lomwe lili ndi kuchuluka kwake komwe kumapakidwa utoto. Kwa ife, mtengo uwu udzakhala 400,000. Pambuyo pake, timadina pa "mtundu ..." batani.
  6. Kulenga zenera lazolonera ku Microsoft Excel

  7. Zenera la Folale limatsegulidwa. Kusunthira "kudzaza" tabu. Sankhani mtundu wa zodzaza zomwe tikufuna, kuti tiime ma cell omwe ali ndi mtengo wosakwana 400,000. Pambuyo pake, timadina batani la "Ok" pansi pazenera.
  8. Sankhani mtundu wa khungu mu Microsoft Excel

  9. Tibwerera ku zenera lolenga zinthu ndipo pamenepo, dinani batani la "Ok".
  10. Kupanga njira yopanga mawonekedwe mu Microsoft Excel

  11. Pambuyo pa izi, tidzatumizidwanso kumalo oyang'anira malamulo. Monga mukuwonera, lamulo limodzi lawonjezedwa kale, koma tiyenera kuwonjezera zina ziwiri. Chifukwa chake, timakanikiza "pangani lamulo ..." batani kachiwiri.
  12. Kusintha Kukupanga Lamulo Lotsatira ku Microsoft Excel

  13. Ndiponso timalowa zenera. Pitani mu gawo la "Mtundu wokhawo womwe uli ndi". Mu gawo loyamba la gawoli, timasiya "mtengo wamtengo wapatali", ndipo mchiwiri adasinthiratu kupita "pakati". Mu gawo lachitatu, muyenera kutchulanso mtengo woyamba womwe zinthu za pepalalo zidzakonzedwa. Kwa ife, iyi ndi nambala 400000. M'chinayi, fotokozerani kufunika komaliza kwa izi. Idzakhala ma 500,000. Pambuyo pake, dinani pa "mtundu ..." batani.
  14. Sinthani ku zenera lopanga mu Microsoft Excel

  15. Muzenera, timabwereranso ku Tab "Dzazani", nthawi ino Sankhani mtundu wina, kenako dinani batani la "OK".
  16. Kupanga zenera ku Microsoft Excel

  17. Pambuyo pobwerera zenera lolenga, ndimadinanso pa batani la "Ok".
  18. Anamaliza kulengedwa kwa ulamuliro ku Microsoft Excel

  19. Monga tikuwona, malamulo awiri adapangidwa kale mu malamulo. Chifukwa chake, imangokhala yachitatu. Dinani pa batani la "Pangani Lamulo".
  20. Kusintha Kuti Kupanga Lamulo Lomaliza ku Microsoft Excel

  21. Polenga malamulowa zenera, ndikusamukiranso ku gawo la "mawonekedwe okha maselo omwe ali". Mu gawo loyamba, timasiya njira yosankha "mtengo wa maselo". M'gawo lachiwiri, ikani switch kupita ku apolisi "owonjezera". Mu gawo lachitatu, yendetsani nambala 500000. Kenako, monga momwe zidalili, timadina pa "mtundu ..." batani.
  22. Zenera zenera ku Microsoft Excel

  23. Mu "mtundu wa maselo", amasamukiranso ku "kudzaza" tabu. Pakadali pano timasankha utoto womwe umasiyana ndi milandu iwiri yapitayi. Chitani batani pa batani la "Ok".
  24. Zenera la Folane pa Microsoft Excel

  25. Pawindo la malamulo a malamulo, bwerezani batani la "OK".
  26. Lamulo lomaliza lopangidwa mu Microsoft Excel

  27. Malamulo atsegulidwa. Monga mukuwonera, malamulo onse atatuwa amapangidwa, kotero timakanikiza batani la "OK".
  28. Kumalizidwa pantchito mu manejala mu Microsoft Excel

  29. Tsopano zinthu zatheli zimapakidwa utoto molingana ndi mikhalidwe ndi malire omwe adafotokozedwa m'makonzedwe.
  30. Maselo amapaka utoto molingana ndi mikhalidwe yomwe yatchulidwa mu Microsoft Excel

  31. Ngati tisintha zomwe zili mu cellone imodzi, kusiya malire a imodzi mwa malamulo omwe adafotokozedwa, ndiye kuti gawo ili la pepalalo lisintha mtundu.

Kusintha kwa mtundu mu bar mu Microsoft Excel

Kuphatikiza apo, ndizotheka kugwiritsa ntchito mawonekedwe amtundu wina monga mtundu wa zopangira mapepala.

  1. Pachifukwa ichi, woyang'anira malamulowo atatha, timapita pawindo la anthu, timakhala mu "mitundu yonse maselo otengera zomwe amakhulupirira" gawo. Mu gawo la "mtundu wa" utoto, mutha kusankha mtunduwo, mithunzi yake idzathiridwa zinthu za pepalalo. Kenako muyenera kudina batani la "OK".
  2. Mawonekedwe a maselo ozikidwa pamalingaliro awo mu Microsoft Excel

  3. Mu manejala oyang'anira, inunso, kanikizani batani la "OK".
  4. Microsoft Excel Commanes

  5. Monga mukuwonera, maselo awa pambuyo pa utoto umapakidwa utoto ndi mithunzi yosiyanasiyana. Mtengo womwe wa pepala uli ndi wokulirapo, wotsika ndi wopepuka kuposa - wakuda.

Maselo amapangidwa mu Microsoft Excel

Phunziro: Mawonekedwe ogwirizana

Njira 2: Kugwiritsa ntchito "Pezani ndi kugawa chida

Ngati pali zokhazikika patebulo, zomwe sizokonzekera kuti zisinthidwe nthawi, mutha kugwiritsa ntchito chida chake kusintha mtundu wa maselo chifukwa cha zomwe ali nazo zimatchedwa "kugawa ndi kugawa". Chida chodziwikirachi chikulolani kuti mupeze zomwe zafotokozedwazo ndikusintha mtunduwo m'maselo awa kwa wosuta womwe mukufuna. Koma ziyenera kudziwitsidwa kuti pakusintha zomwe zili muzomwe zilimo, mtunduwo sudzasintha zokha, koma ndizofanana. Pofuna kusintha mtunduwo kukhala woyenera, muyenera kubwerezanso njirayi. Chifukwa chake, njirayi siyokwanira matebulo okhala ndi mphamvu.

Tiyeni tiwone momwe zimagwirira ntchito mwachitsanzo, komwe timatenganso ndalama zomwezo za Enterprise.

  1. Timatsindika mzere wokhala ndi deta yomwe iyenera kukhazikitsidwa ndi mtundu. Kenako pitani ku "kunyumba" ndikudina batani la "Pezani ndikusankha", komwe kumapezeka pa tepi pokonza chida. M'ndandanda womwe umatsegula, dinani "Pezani".
  2. Pitani ku Pezani ndikusintha zenera ku Microsoft Excel

  3. "DZIWANI NDIPONSO NDI ZINSINSI" Zeding "limayamba mu" Pezani ". Choyamba, tidzapeza ma ruble ruble 400,000. Popeza tiribe cell, pomwe kudzakhala ma ruble ochepera 300,000, ndiye kuti, tiyenera kufotokoza zinthu zonse zomwe manambala ali osiyana ndi 300,000. Tsokanani mwachindunji. Mapulogalamu a mawonekedwe a zamagetsi, mwanjira imeneyi ndizosatheka.

    Koma pali kuthekera kochita mosiyana ndi izi kuti tidzapereka zotsatiranso zomwezo. Mutha kukhazikitsa template yotsatirayi "3 ??????? Chizindikiro cha mafunso amatanthauza mawonekedwe aliwonse. Chifukwa chake, pulogalamuyi idzayang'ana manambala onse asanu ndi limodzi omwe amayamba ndi manambala "3". Ndiye kuti, kusaka kukafufuza kudzagwera m'mitundu ya 300,000 - 400,000, komwe timafunikira. Ngati tebulo lili ndi manambala osakwana 300,000 kapena ochepera 200,000, ndiye kuti pafupifupi pafupifupi 200,000, kusaka kukayenera kuchitidwa mosiyana.

    Timayambitsa mawu oti "3 ??????" "? Mu "pezani" ndikudina batani "Pezani" zonse ".

  4. Kuyambitsa kusaka mu Microsoft Excel

  5. Pambuyo pake, m'munsi mwa zenera, zotsatira za zotsatira zosaka ndizotseguka. Dinani pa batani lakumanzere pa aliyense wa iwo. Kenako mulembe Ctrl + kuphatikiza kwakukulu. Pambuyo pake, zotsatira zake zonse zakukonzekera zimaperekedwa ndipo zinthu zomwe zili mumphepetezo zimasiyanitsidwa nthawi yomweyo, zomwe zimatanthauzira.
  6. Kusankhidwa kwa zotsatira zakusaka ku Microsoft Excel

  7. Pambuyo pazinthu zomwe zili pachiwopsezo zikuwonetsedwa, musathamangire kutseka "kupeza ndikusintha" zenera. Pokhala m'gulu la "Nyumba" yomwe tasuntha m'mbuyomu, pitani kuchipika kupita ku malo osungirako zinthu. Dinani pa makona atatu kumanja kwa batani la "Dzazani". Pali kusankha mitundu yosiyanasiyana ya kudzaza. Sankhani utoto womwe tikufuna kugwiritsa ntchito zigawo za chitani zomwe zili ndi ma ruble 400,000.
  8. Kusankha mtundu wadzaza mu Microsoft Excel

  9. Monga mukuwonera, maselo onse a mzere womwe muli ma ruble ruble 400,000 omwe amawonetsedwa, owonetsedwa mu mtundu wosankhidwa.
  10. Maselo amawonetsedwa mu Blue mu Microsoft Excel

  11. Tsopano tikufunika kujambula zinthu zomwe kuchuluka komweko kuli kochokera kumayiko 400,000 mpaka 500,000. Izi zimaphatikizapo manambala omwe amafanana ndi "4 ????" template. Timayendetsa mu gawo lofufuza ndikudina batani "Pezani" zonse "mutasankha mzati womwe mukufuna.
  12. Sakani katsatanetsatane wachiwiriyo mu Microsoft Excel

  13. Mofananamo, ndi nthawi yapita kumapeto, timagawa zotsatira zonse zomwe zimapezeka pokakamiza Ctrl + kuphatikiza kwakukulu. Pambuyo pake, timasamukira ku chithunzi chosankha cha utoto. Dinani pa iyo ndikudina chithunzi cha mthunzi chomwe mukufuna, chomwe chidzajambulidwa ndi zinthu za pepalalo, komwe kuli mikhalidwe yochokera ku 400,000 mpaka 500,000.
  14. Dzazani utoto wa utoto wa data yachiwiri mu Microsoft Excel

  15. Monga mukuwonera, zitachitika izi, zinthu zonse za tebulo ndi deta pamtundu wa 400,000 mpaka 500,000 zimawonetsedwa mu mtundu wosankhidwa.
  16. Maselo amawonetsedwa mu zobiriwira mu Microsoft Excel

  17. Tsopano tiyenera kuwunikira miyambo yomaliza - yoposa 500,000. Pano tili ndi mwayi kwambiri, chifukwa manambala onse opitilira 500,000 ali ndi 600,000. Chifukwa chake, mu gawo lofufuzira lomwe timafotokoza mawu akuti "5 ????? " Ndikudina batani la "Pezani" zonse ". Ngati panali zikhulupiriro zoposa 600,000, ndiye kuti tifunika kuwunikiridwa "6 ????????? etc.
  18. Sakani kachitatu kachitatu mu Microsoft Excel

  19. Apanso, gawani zotsatira zosaka pogwiritsa ntchito Ctrl + kuphatikiza. Kenako, pogwiritsa ntchito batani la tepi, sankhani mtundu watsopano kuti mudzaze mpweya wopitilira 500000 womwe unali wofanana nawo.
  20. Dzazani utoto wa utoto wazinthu zachitatu mu Microsoft Excel

  21. Monga mukuwonera, zitachitika izi, zinthu zonse za mzati zidzapakidwa utoto, malingana ndi kuchuluka kwa manambala, komwe kumayikidwa mwa iwo. Tsopano mutha kutseka bokosi losakira ndikukanikiza batani lotseka pakona yakumanja ya zenera, chifukwa ntchito yathu itha kusinthidwa.
  22. Maselo onse amapaka utoto mu Microsoft Excel

  23. Koma ngati tisinthanitsa nambala ya inayi, yomwe imapita kopitilira malire omwe amaikidwa kuti akhale mtundu winawake, utoto susintha, monga momwe zinaliri kale. Izi zikusonyeza kuti njira iyi igwira ntchito modalirika pamasanja omwe data sasintha.

Mtunduwo sunasinthe atasintha mtengo mu cell mu Microsoft Excel

Phunziro: Momwe Mungafufuze

Monga mukuwonera, pali njira ziwiri zojambulira maselo otengera manambala omwe ali nawo: mothandizidwa ndi kapangidwe kake ndikugwiritsa ntchito "Pezani ndi kusintha chida. Njira yoyamba ndiyopita patsogolo kwambiri, chifukwa zimakupatsani mwayi wina kuti mumve bwino zomwe zilembedwe zimasiyanitsidwa. Kuphatikiza apo, pakapangidwe kakhalidwe, mtundu wa chinthu kumasintha zokha, posintha zomwe zili mmenemu, zomwe sizingachitike. Komabe, kudzaza maselo, kutengera mtengo pogwiritsa ntchito "Pezani ndikusintha zida, kumagwiritsidwanso ntchito, koma mu matebulo okhazikika.

Werengani zambiri