01 ya 01
Excel Shading Rows / Columns Formula
Nthawi zambiri, mawonekedwe ovomerezeka amagwiritsidwa ntchito kusintha selo kapena maonekedwe a mndandanda pogwiritsa ntchito deta yomwe imalowa mu selo monga tsiku lachilendo kapena ndalama zomwe zimagwiritsidwa ntchito kwambiri, ndipo nthawi zambiri izi zimagwiritsidwa ntchito pogwiritsa ntchito ma Excel.
Kuwonjezera pa zosankha zisanachitike, komatu n'zotheka kukhazikitsa malamulo opanga maofesi osiyanasiyana pogwiritsa ntchito Excel mayesero kuti ayese pazolowera zizindikiro.
Njira imodzi yomwe imaphatikizapo MOD ndi ROW ntchito, ingagwiritsidwe ntchito kuti ikhale mthunzi umodzi wa deta yomwe ingathe kupanga deta yowerengera m'mabuku akuluakulu, mosavuta.
Kupanga Mphamvu
Ubwino wina pogwiritsa ntchito njirayi kuti uwonjezere mzere wa mzere ndiko kuti kumeta ndikutanthauzira kumasintha ngati nambala ya mizere isintha.
Ngati mizere imalowetsedwa kapena kuchotsedweratu mzere wa mzere kuti ukhale ndi chitsanzo.
Zindikirani: Mizera ina siyi yokhayo yokha yomwe ili ndi njirayi. Powasintha pang'ono, monga momwe tafotokozera m'munsiyi, njirayi ikhoza kumthunzi mzere uliwonse wa mizera. Ikhoza kugwiritsidwa ntchito pamitu ya mthunzi mmalo mwa mizere ngati mutasankha.
Chitsanzo: Kuyika Mizere Yowonjezera
Njira yoyamba ndiyo kuwonetsera maselo omwe amawombedwa chifukwa mawonekedwewa amakhudza maselo osankhidwawo.
- Tsegulani tsamba la Excel-pepala losalemba lopanda ntchito lidzagwira ntchito pa phunziro ili
- Sungani maselo angapo m'masamba
- Dinani pa tabu la Home la riboni
- Dinani pazithunzi zojambula Zowonongeka pazomwe mungatsegule menyu
- Sankhani Zolemba Zatsopano kuti mutsegule Chigawo Chatsopano Choyika Mafomu
- Dinani pa Gwiritsani Ntchito Fomu kuti mudziwe maselo omwe angapangidwe kusankha kuchokera mndandanda pamwamba pa dialog box
- Lowani ndondomeko zotsatirazi mu bokosi ili m'munsimu mawonedwe owonetsetsa pomwe chofunikira ichi chiri pansi pa theka la dialog box = MOD (ROW (), 2) = 0
- Dinani Pulogalamuyi kuti muyatse bokosi la mauthenga a mawonekedwe
- Dinani Lembani tabu kuti muwone zosankha zamkati
- Sankhani mtundu umene ungagwiritse ntchito poboola mizere ina yosankhidwa
- Dinani KULI kawiri kuti mutseke bokosilo ndikubweranso kuntchito
- Mzere wina mumasankhidwe akuyenera tsopano ukhale wojambulidwa ndi mtundu wosankhidwa kumbuyo
Kutanthauzira Mpangidwe
Momwe chiwerengerochi chikuwerengedwa ndi Excel ndi:
- chiwerengero chachiwiri chimawonetsera kuti mthunzi wa mthunzi umabwereza mzere uliwonse wamphindi muzithunzi zosankhidwa
- chikhalidwe cha = 0 mu chiganizochi chimatsimikizira kuti mzere woyamba mumtunduwu sungagwedezeke - zomwe zimachitika chifukwa mzerewu nthawi zambiri uli ndi mitu yomwe ili ndi maonekedwe awo.
Kodi MOD NDI MWACHITO ZIYANI?
Chitsanzo chimadalira ntchito ya MOD mu njirayi. Chomwe MOD imachita chimasiyanitsa nambala ya mzere (yotsimikiziridwa ndi ROW ntchito) ndi nambala yachiwiri mkati mwa mabakitayo ndi kubwezera otsala kapena modulus monga momwe nthawi zina imatchulidwira.
Panthawiyi, maonekedwe ovomerezeka amatenga ndikuyerekezera modulus ndi nambala pambuyo pa chizindikiro chofanana. Ngati pali machesi (kapena molondola ngati chikhalidwe chiri CHOONA), mzerewu ndi wobisika, ngati manambala ali mbali imodzi ya chizindikiro chofanana sagwirizana, chikhalidwe chiri FALSE ndipo palibe mthunzi umachitika pamzere umenewo.
Mwachitsanzo, mu chithunzi pamwambapa, pamene mzere womaliza mu 18 osiyanasiyana wasankhidwa ndi 2 ndi ntchito ya MOD, yotsala ndi 0, choncho chikhalidwe cha 0 = 0 ndi CHOONA, ndipo mzerewo uli wochepa.
Mzere 17, komano, pamene ugawidwa ndi 2 asiya 1, osagwirizana 0, kotero mzere wachoka wosasunthika.
Kuyika Mizati M'malo mwa Mizere
Monga tafotokozera, mayendedwe omwe amapezeka mumthunzi akhoza kusintha kuti asamalire nsanamira za shading. Kusintha kuli kofunika kugwiritsa ntchito ntchito COLUMN mmalo mwa ROW ntchito mu njirayi. Pochita izi, njirayi idzawoneka ngati iyi:
= MOD (COLUMN (), 2) = 0Zindikirani: Kusintha kwa mizere ya shading yosintha kapangidwe ka shading yomwe ili pansipa ikugwiranso ntchito pazithunzi za shading.
Sintha Mchitidwe, Sinthani Chithunzi cha Shading
Kusintha kapangidwe ka shading kumachitika mosavuta posintha kaya mwa nambala ziwirizo.
- Kuti mzere wa mzere uyambe ndi mzere woyamba m'malo mwachiwiri, pamapeto pake, kusintha = 0 to = 1 ;
- Kuti mukhale ndi mzere uliwonse wachitatu kapena wachinayi m'malo mwazitsulo zina, sintha 2 mu njirayi kwa 3 kapena 4.
Kugawanika sikungakhale Zero kapena Mmodzi
Chiwerengero chomwe chili mkati mwa mabakia chimatchedwa " divisor" chifukwa ndi chiwerengero chomwe chimagawidwa mu ntchito ya MOD. Ngati mukukumbukira mmbuyo mu masamu okhala ndi zero sanaloledwe ndipo saloledwa ku Excel mwina. Ngati muyesa kugwiritsa ntchito zero mkati mwa mabakia m'malo mwa 2, monga:
= MOD (ROW (), 0) = 2simudzapeza mthunzi konse pamtundu uliwonse.
Mwinanso, ngati mutayesa kugwiritsa ntchito nambala imodzi kwa wotsogolera kotero kuti machitidwe akuwoneka ngati:
= MOD (ROW (), 1) = 0Mzere uliwonse mumtunduwu udzakhala wobisika. Izi zimachitika chifukwa chiwerengero chilichonse chogawidwa ndi chimodzi chimachoka pa zero, ndipo kumbukirani, pamene chikhalidwe cha 0 = 0 chiri CHOONA, mzerewu umakhala wochepa.
Sinthani Operator, Sinthani Chithunzi cha Shading
Kusintha ndondomekoyi, kusintha ndondomeko yowonjezera kapena yofananitsa (chizindikiro chofanana) chomwe chimagwiritsidwa ntchito muzitsulo zochepa (<).
Mwa kusintha = 0 mpaka <2 (pansi pa 2) mwachitsanzo, mizere iwiri palimodzi ikhoza kukhala shaded. Pangani izo <3, ndipo kumeta kumapangidwa m'magulu a mizere itatu.
Chombo chokha chogwiritsa ntchito osachepera ndi kutsimikiza kuti nambala mkati mwa mabakiteriya ndi yayikulu kuposa nambala kumapeto kwa njirayi. Ngati sichoncho, mzere uli wonsewo udzakhala wofiira.