Njira ziwiri zosinthira mtundu wodzaza ma cell mu Excel kutengera zomwe amakonda

M'nkhaniyi, mupeza njira ziwiri zofulumira zosinthira mtundu wa selo kutengera mtengo wake mu Excel 2013, 2010, ndi 2007. Komanso, muphunzira momwe mungagwiritsire ntchito mafomu mu Excel kuti musinthe mtundu wa maselo opanda kanthu. kapena ma cell omwe ali ndi zolakwika za fomula.

Aliyense amadziwa kuti kusintha mtundu wodzaza wa selo limodzi kapena gulu lonse mu Excel, ingodinani batani Lembani mtundu (Dzazani mtundu). Koma bwanji ngati mukufuna kusintha mtundu wodzaza wa maselo onse okhala ndi mtengo wake? Komanso, bwanji ngati mukufuna kuti mtundu wa selo lililonse usinthe zokha zimene zili mu selolo zikusintha? Kupitilira munkhaniyi mupeza mayankho a mafunsowa ndikupeza malangizo angapo othandiza omwe angakuthandizeni kusankha njira yoyenera yothetsera vuto lililonse.

• Sinthani mtundu wodzaza wa ma cell kutengera zomwe amafunikira (mwamphamvu) - Mtundu wodzaza umasintha zokha mtengo wa cell ukasintha.
• Sinthani mtundu wa selo kutengera mtengo wake wapano (statically) - Mukangokhazikitsidwa, mtundu wodzaza susintha, ziribe kanthu momwe mtengo wa selo usinthira.
• Sinthani mtundu wa maselo ena (opanda kanthu, ndi zolakwika, ndi ma formula)

Momwe mungasinthire mtundu wa cell mu Excel kutengera mtengo wake

Mtundu wodzaza udzasintha malinga ndi mtengo wa selo.

vuto: Muli ndi tebulo kapena kuchuluka kwa data ndipo mukufuna kusintha mtundu wodzaza wa ma cell potengera zomwe amafunikira. Kuphatikiza apo, ndikofunikira kuti mtundu uwu usinthe mwachangu, kuwonetsa kusintha kwa data m'maselo.

Kusankha: Gwiritsani ntchito masanjidwe okhazikika mu Excel kuti muwunikire zinthu zazikulu kuposa X, zosakwana Y, kapena pakati pa X ndi Y.

Tiyerekeze kuti muli ndi mndandanda wamitengo yamafuta m'maiko osiyanasiyana, ndipo mukufuna mitengo yomwe ili yokwera kuposa $ 3.7, zinasonyezedwa mofiira, ndi zazing'ono kapena zofanana $ 3.45 - green.

Zindikirani: Zithunzi zachitsanzozi zidatengedwa ku Excel 2010, komabe, mu Excel 2007 ndi 2013, mabatani, ma dialog, ndi zoikamo zidzakhala chimodzimodzi kapena zosiyana pang'ono.

Kotero, izi ndi zomwe muyenera kuchita sitepe ndi sitepe:

1. Sankhani tebulo kapena mtundu womwe mukufuna kusintha mtundu wodzaza ma cell. M'chitsanzo ichi, tikutsindika $B$2:$H$10 (mitu yandalama ndi gawo loyamba lomwe lili ndi mayina a mayiko sanasankhidwe).
2. Dinani Kunyumba (Kunyumba), mu gawo masitaelo (Masitayelo) dinani Njira Zakukonzerani (Mapangidwe Okhazikika) > Malamulo Atsopano (Pangani lamulo).
3. Pamwamba pa bokosi la zokambirana Lamulo Latsopano Lopanga (Pangani Formatting Rule) m'munda Sankhani Mtundu Walamulo (Sankhani mtundu wa malamulo) sankhani Pangani ma cell omwe ali ndi (Sungani ma cell okhawo omwe ali).
4. Pansi pa bokosi la zokambirana m'bokosi Sinthani Maselo Okha ndi (Sungani ma cell okhawo omwe amakwaniritsa zotsatirazi) Khazikitsani malamulowo. Timasankha kupanga ma cell okha okhala ndi izi: Mtengo wa Ma cell (mtengo wa cell) - wamkulu kuposa (Zambiri) - 3.7monga momwe tawonera m'chithunzichi.Kenako dinani batani kukula (Format) kusankha mtundu wodzaza womwe uyenera kugwiritsidwa ntchito ngati zomwe zafotokozedwazo zakwaniritsidwa.
5. Mu bokosi la zokambirana lomwe likuwoneka Sakani Maselo (Maselo a Format) tabu Lembani (Dzazani) ndikusankha mtundu (tinasankha zofiira) ndikudina OK.
6. Pambuyo pake mudzabwerera pawindo Lamulo Latsopano Lopanga (Kupanga lamulo lokonzekera) komwe kuli m'munda chithunzithunzi (Zitsanzo) ziwonetsa chitsanzo cha masanjidwe anu. Ngati mwakhutitsidwa, dinani OK.

Zotsatira za zokonda zanu zidzawoneka motere:

Popeza tifunika kukhazikitsa chikhalidwe china chomwe chimatilola kusintha mtundu wodzaza kukhala wobiriwira kwa ma cell okhala ndi zocheperako kapena zofanana 3.45, kenako dinani batani kachiwiri Malamulo Atsopano (Pangani Lamulo) ndikubwereza masitepe 3 mpaka 6, ndikukhazikitsa lamulo lomwe mukufuna. M'munsimu muli chitsanzo cha lamulo lachiwiri lokhazikitsa malamulo lomwe tidapanga:

Zonse zikakonzeka - dinani OK. Tsopano muli ndi tebulo losanjidwa bwino lomwe limakupatsani mwayi wowona mitengo yamafuta apamwamba komanso ocheperako m'maiko osiyanasiyana pang'onopang'ono. Zabwino kwa iwo kumeneko, ku Texas! 🙂

Tip: Momwemonso, mutha kusintha mtundu wa font kutengera mtengo wa cell. Kuti muchite izi, ingotsegulani tabu Zilembo (Font) mu bokosi la zokambirana Sakani Maselo (Ma cell Format) monga tinachitira mu gawo 5 ndikusankha mtundu womwe mukufuna.

Momwe mungakhazikitsire mtundu wa cell wokhazikika kutengera mtengo wake wapano

Akangokhazikitsidwa, mtundu wodzaza sudzasintha, ngakhale zomwe zili mu selo zidzasintha mtsogolo.

vuto: Mukufuna kusintha mtundu wa selo kutengera mtengo wake wapano, ndipo mukufuna kuti mtundu wodzaza ukhalebe womwewo ngakhale mtengo wa cell utasintha.

Kusankha: Pezani ma cell onse okhala ndi mtengo wake (kapena ma values) pogwiritsa ntchito chida Pezani Zonse (Pezani Zonse) ndiyeno sinthani mawonekedwe a maselo opezeka pogwiritsa ntchito bokosi la zokambirana Sakani Maselo (mtundu wa cell).

Ichi ndi chimodzi mwazosowa zomwe zilibe kufotokozera m'mafayilo othandizira a Excel, mabwalo kapena mabulogu, ndipo palibe yankho lachindunji. Ndipo izi ndizomveka, chifukwa ntchitoyi siinali yofanana. Ndipo komabe, ngati mukufuna kusintha mtundu wodzaza selo kwamuyaya, ndiye kuti, kamodzi kokha (kapena mpaka mutasintha pamanja), tsatirani izi.

Pezani ndikusankha ma cell onse omwe amakwaniritsa zofunikira

Zochitika zingapo ndizotheka pano, kutengera mtundu wamtengo womwe mukuyang'ana.

Ngati mukufuna kukongoletsa ma cell ndi mtengo wake, mwachitsanzo, 50, 100 or 3.4 - ndiye pa tabu Kunyumba (Kunyumba) mu gawo Kusintha (Kusintha) dinani Pezani Sankhani (Pezani ndi kuwunikira) > Pezani (Pezani).

Lowetsani mtengo womwe mukufuna ndikudina Pezani Zonse (Pezani zonse).

Tip: Kumanja kwa bokosi la zokambirana Pezani ndikutsogola (Pezani ndi Kusintha) pali batani Zosintha (Zosankha), mwa kukanikiza komwe mudzakhala ndi mwayi wopeza makonda angapo apamwamba, monga match kesi (zomvera mlandu) ndi Fananizani zonse zama cell (Selo yonse). Mukhoza kugwiritsa ntchito zilembo zakutchire monga asterisk (*) kuti mufanane ndi mndandanda wa zilembo, kapena funso (?) kuti mufanane ndi chilembo chilichonse.

Ponena za chitsanzo chapitachi, ngati tifunika kupeza mitengo yonse ya petulo kuchokera 3.7 ku 3.799, kenako tidzakhazikitsa zotsatirazi:

Tsopano dinani chilichonse mwa zinthu zomwe zapezeka pansi pa bokosi la zokambirana Pezani ndikutsogola (Pezani ndi Kusintha) ndikudina Ctrl + Akuwonetsa zonse zomwe zapezeka. Pambuyo pake dinani batani pafupi (Tsekani).

Umu ndi momwe mungasankhire ma cell onse okhala ndi mtengo wopatsidwa (makhalidwe) pogwiritsa ntchito njirayo Pezani Zonse (Pezani Zonse) mu Excel.

Komabe, zenizeni, tifunika kupeza mitengo yonse ya petulo yomwe imaposa $ 3.7. Mwatsoka chida Pezani ndikutsogola (Pezani ndi Kusintha) sikungatithandize pa izi.

Sinthani Mitundu Yodzaza Maselo Osankhidwa Pogwiritsa Ntchito Bokosi la Maselo a Format

Tsopano muli ndi maselo onse omwe ali ndi mtengo wopatsidwa (kapena zikhalidwe) zosankhidwa, tangochita izi ndi chida Pezani ndikutsogola (Pezani ndikusintha). Zomwe muyenera kuchita ndikuyika mtundu wodzaza pamaselo osankhidwa.

Tsegulani bokosi la zokambirana Sakani Maselo (Mawonekedwe a Ma cell) mwanjira iliyonse ya 3:

• kukanikiza Ctrl + 1.
• podina pa selo iliyonse yosankhidwa ndi batani lakumanja la mbewa ndikusankha chinthucho kuchokera pamenyu yankhani Sakani Maselo (mtundu wa cell).
• tsamba Kunyumba (Kunyumba) > Maselo. Maselo. (maselo) > kukula (Fomati) > Sakani Maselo (mtundu wa cell).

Kenako, sinthani masanjidwe momwe mukufunira. Nthawi ino tiyika mtundu wodzaza kukhala lalanje, kuti tisinthe 🙂

Ngati mukufuna kusintha mtundu wodzaza okha popanda kukhudza zina zonse zomwe mungasankhe, mutha kungodina batani Lembani mtundu (Dzazani mtundu) ndikusankha mtundu womwe mumakonda.

Izi ndi zotsatira za kusintha kwathu kwa masanjidwe mu Excel:

Mosiyana ndi njira yapitayi (yokhala ndi zovomerezeka), mtundu wodzaza womwe umayikidwa motere sudzasintha wokha popanda kudziwa kwanu, ngakhale zisintha bwanji.

Sinthani mtundu wodzaza m'maselo apadera (opanda kanthu, ndi zolakwika mu fomula)

Monga m'chitsanzo cham'mbuyomo, mutha kusintha mtundu wodzaza wa maselo enaake m'njira ziwiri: dynamically ndi statically.

Gwiritsani ntchito fomula kuti musinthe mtundu wodzaza wa maselo apadera mu Excel

Mtundu wa selo udzasintha zokha malinga ndi mtengo wa selo.

Mudzagwiritsa ntchito njira iyi yothetsera vutoli mu 99% ya milandu, ndiye kuti, kudzazidwa kwa maselo kudzasintha malinga ndi momwe mudafotokozera.

Mwachitsanzo, tiyeni titengenso tebulo la mtengo wa petulo, koma nthawi ino tiwonjezeranso zigawo zingapo, ndikupanga ma cell opanda kanthu. Tsopano onani momwe mungapezere ma cell opanda kanthuwa ndikusintha mtundu wawo wodzaza.

1. Pa Advanced tabu Kunyumba (Kunyumba) mu gawo masitaelo (Masitayelo) dinani Njira Zakukonzerani (Mapangidwe Okhazikika) > Malamulo Atsopano (Pangani lamulo). Monga momwe mu gawo lachiwiri la chitsanzo Momwe mungasinthire mtundu wa selo kutengera mtengo wake.
2. Mu dialog box Lamulo Latsopano Lopanga (Pangani lamulo la masanjidwe) sankhani njira Gwiritsani ntchito fomula kuti mudziwe ma cell kupanga (Gwiritsani ntchito fomula kuti mudziwe kuti ndi maselo ati oti muwapange). Kupitilira kumunda Sankhani zomwe fomulayi ili yowona (Mawonekedwe amtundu womwe fomula ili ndi yowona) lowetsani imodzi mwanjirazi:
   • kusintha kudzaza kwa maselo opanda kanthu

     =ISBLANK()

     =ЕПУСТО()

   • kusintha mawonekedwe a ma cell omwe ali ndi ma formula omwe amabweretsa cholakwika

     =ISERROR()

     =ЕОШИБКА()

   Popeza tikufuna kusintha mtundu wa maselo opanda kanthu, timafunikira ntchito yoyamba. Lowetsani, kenako ikani cholozera pakati pa bulaketi ndikudina chizindikiro chosankha chamitundu ili kumanja kwa mzere (kapena lembani pamanja mtundu womwe mukufuna):

   =ISBLANK(B2:H12)

   =ЕПУСТО(B2:H12)

   

3. atolankhani kukula (Format), sankhani mtundu wodzaza womwe mukufuna pa tabu Lembani (Dzazani), ndiyeno dinani OK. Malangizo atsatanetsatane aperekedwa mu gawo 5 lachitsanzo "Momwe mungasinthire mtundu wa selo kutengera mtengo wake." Chitsanzo cha masanjidwe okhazikika omwe mwakhazikitsa chiwoneka motere:
4. Ngati ndinu okondwa ndi mtundu, dinani OK. Mudzawona momwe lamulo lopangidwa lidzagwiritsidwira ntchito nthawi yomweyo patebulo.

Sinthani mtundu wodzaza wa maselo apadera mokhazikika

Mukakonzedwa, kudzaza kudzakhalabe kosasinthika, mosasamala kanthu za mtengo wa selo.

Ngati mukufuna kukhazikitsa mtundu wodzaza osatha wamaselo opanda kanthu kapena ma cell okhala ndi mafomu omwe ali ndi zolakwika, gwiritsani ntchito njirayi:

1. Sankhani tebulo kapena mtunda ndikudina F5kuti mutsegule kukambirana Pitani ku (Lumphani), kenako dinani batani Wapadera (Kuwonetsa).
2. Mu dialog box Pitani ku Special (Sankhani gulu la maselo) fufuzani njira Makumbidwe (Maselo opanda kanthu) kuti musankhe ma cell opanda kanthu.Ngati mukufuna kuwunikira ma cell omwe ali ndi ma fomula okhala ndi zolakwika, yang'anani zomwe mwasankha Mafomu (mafomu) > Zolakwika (Zolakwa). Monga mukuwonera pachithunzi pamwambapa, pali zina zambiri zomwe mungapeze.
3. Pomaliza, sinthani kudzaza kwa maselo osankhidwa kapena ikani zosankha zina zilizonse pogwiritsa ntchito bokosi la zokambirana Sakani Maselo (Maselo a Format), monga tafotokozera mu Kusintha Kudzaza Kwa Maselo Osankhidwa.

Musaiwale kuti masanjidwe opangidwa motere adzasungidwa ngakhale ma cell opanda kanthu atadzazidwa ndi zikhalidwe kapena zolakwika m'ma formula zikonzedwa. Ndizovuta kulingalira kuti wina angafunike kupita motere, kupatula pazolinga zoyeserera 🙂