Momwe mungachotsere ma cell opanda kanthu mu Excel. Njira 3 Zochotsera Maselo Akhungu mu Excel

Mukasamutsa tebulo kuchokera kugwero lakunja kupita ku Excel, zinthu nthawi zambiri zimayamba ndikusintha kwa ma cell ndi chidziwitso ndikupanga voids. Mukamagwiritsa ntchito ma formula, ntchito zina sizingatheke. Pachifukwa ichi, funso likubwera: momwe mungachotsere mwamsanga maselo opanda kanthu?

Milandu imene n'zotheka kuchotsa akusowekapo maselo

Panthawi yogwira ntchito, kusintha kwa deta kungachitike, zomwe sizili zofunika. Kuchotsa kumangochitika nthawi zina, mwachitsanzo:

• Palibe zambiri pamzere wonse kapena gawo.
• Palibe kulumikizana komveka pakati pa ma cell.

Njira yapamwamba yochotsera voids ndi chinthu chimodzi panthawi. Njirayi ndi yotheka ngati mutagwira ntchito ndi madera omwe amafunikira kusintha pang'ono. Kukhalapo kwa maselo ambiri opanda kanthu kumabweretsa kufunikira kogwiritsa ntchito njira yochotsa mtanda.

Yankho 1: chotsani posankha gulu la maselo

Njira yosavuta ndiyo kugwiritsa ntchito chida chapadera posankha magulu a maselo. Kachitidwe:

1. Sankhani malo ovuta omwe ma cell opanda kanthu adawunjikana, kenako dinani batani F5.

2. Chophimba chiyenera kutsegula zenera lotsatira. Dinani pa interactive Sankhani batani.
3. Pulogalamuyo idzatsegula zenera lina. Sankhani "Empty Cells". Chongani bokosi ndikudina Chabwino.
4. Pali malo osankhidwa okha osadzazidwa. Kudina pomwe pagawo lililonse lopanda chidziwitso kumatsegula zenera pomwe muyenera dinani "Chotsani".
5. Kenako, "Chotsani Maselo" adzatsegula. Ikani chizindikiro pafupi ndi "Ma cell omwe ali ndi shift up." Timavomereza ndikukanikiza batani "Chabwino".

6. Zotsatira zake, pulogalamuyi idzachotsa zokha malo omwe akuyenera kukonzedwa.
7. Kuti muchotse zomwe zasankhidwa, dinani LMB paliponse patebulo.

Zindikirani! Njira yochotsera ndi kusintha imasankhidwa pokhapokha ngati palibe mizere pambuyo pa malo osankhidwa omwe amanyamula chidziwitso chilichonse.

Yankho 2: Ikani Zosefera ndi Mapangidwe Okhazikika

Njirayi ndi yovuta kwambiri, choncho, musanayambe kukhazikitsidwa, ndi bwino kuti muyambe kudziwiratu ndi ndondomeko yatsatanetsatane yokonzekera ntchito iliyonse.

Chenjerani! Choyipa chachikulu cha njirayi ndikuti chimagwiritsidwa ntchito ndi gawo limodzi lomwe lilibe ma formula.

Ganizirani zofotokozera motsatizana za kusefa kwa data:

1. Sankhani gawo la gawo limodzi. Pezani chinthu "Editing" pa toolbar. Mwa kuwonekera pa izo, zenera ndi mndandanda wa zoikamo adzaoneka. Pitani ku tabu "Sort and Selter".

2. Sankhani fyuluta ndikuyambitsa LMB.

3. Zotsatira zake, selo lapamwamba limatsegulidwa. Chithunzi chooneka ngati sikweya chokhala ndi muvi wapansi chidzawonekera pambali. Izi zikuwonetsa kuthekera kotsegula zenera ndi ntchito zina.
4. Dinani pa batani ndi tabu yomwe imatsegulidwa, sankhani bokosi pafupi ndi "(Empty)", dinani "Chabwino".

5. Pambuyo pakusintha kochitidwa, ma cell odzazidwa okha ndi omwe amatsalira pamndandanda.

Malangizo a akatswiri! Kuchotsa voids pogwiritsa ntchito kusefa kuli koyenera kokha ngati palibe maselo odzazidwa mozungulira, apo ayi, pochita njirayi, deta yonse idzatayika.

Tsopano tiyeni tiwone momwe tingapangire masanjidwe azikhalidwe limodzi ndi kusefa:

1. Kuti muchite izi, sankhani malo ovuta ndipo, mutapeza chida cha "Styles", yambitsani batani la "Conditional Formatting".

2. Pazenera lomwe limatsegulidwa, pezani mzere "Zambiri" ndikutsata ulalo uwu.
3. Kenako, pawindo lomwe likuwoneka kumanzere, lowetsani mtengo "0". M'munda woyenera, sankhani njira yodzaza mitundu yomwe mumakonda kapena siyani zomwe mwasankha. Timadina "Chabwino". Zotsatira zake, maselo onse okhala ndi chidziwitso adzapakidwa utoto womwe mwasankha.
4. Ngati pulogalamuyo ichotsa zomwe zidasankhidwa kale, timapanganso ndikuyatsa chida cha "Zosefera". Yendani pamwamba pa mtengo "Zosefera ndi mtundu wa cell" kapena ndi font ndikuyambitsa imodzi mwamaudindowo.
5. Chotsatira chake, maselo okhawo omwe ali amitundu ndi mtundu, choncho odzazidwa ndi deta, adzakhalapo.

6. Sankhaninso zone yamitundu yamitundu ndikupeza batani la "Copy" pamwamba pazida, dinani. Imayimiridwa ndi mapepala awiri omwe ali pamwamba pa wina ndi mzake.
7. Posankha malo ena papepalali, timasankhanso zina.
8. Dinani kumanja kuti mutsegule menyu, pomwe timapeza "Makhalidwe". Chizindikirocho chimaperekedwa ngati piritsi lokhala ndi digito 123, dinani.

Zindikirani! Posankha zone, m'pofunika kuti gawo lapamwamba likhale pansi pa mzere wa mndandanda womwe wasonyezedwa.

9. Zotsatira zake, zomwe zakopedwa zimasamutsidwa popanda kugwiritsa ntchito fyuluta yamtundu.

Ntchito yowonjezereka ndi deta ikhoza kuchitidwa kwanuko kapena posamutsa kudera lina la pepala.

Yankho 3: gwiritsani ntchito chilinganizo

Kuchotsa ma cell opanda kanthu patebulo motere kuli ndi zovuta zina ndipo chifukwa chake sikudziwika bwino. Chovuta chagona pakugwiritsa ntchito chilinganizo, chomwe chiyenera kusungidwa mu fayilo ina. Tiyeni tidutse ndondomekoyi motere:

1. Sankhani kuchuluka kwa maselo omwe akuyenera kusinthidwa.
2. Kenako timadina kumanja ndikupeza lamulo "Pakani dzina." Perekani dzina pagawo losankhidwa, dinani Chabwino.

4. Pamalo aliwonse pa pepala, sankhani malo omasuka, omwe amafanana ndi kukula kwa malo omwe kusinthako kumapangidwira. Dinani kumanja ndikuyika dzina lina.

5. Mukafunika kuyambitsa selo lapamwamba kwambiri la malo aulere ndikulowetsamo fomula: =IF(ROW() -ROW(Adjustment)+1>NOTROWS(LastNames)-COUNTBLLANK(LastNames);””;INDIRECT(ADDRESS(LOW(IF(LastNames<>“”),ROW(LastNames);ROW() + MALO(Ma Surname)));ROW()-ROW(Kusintha)+1); COLUMN(Surnames);4))).

Zindikirani! Mayina a madera amasankhidwa mwachisawawa. Mu chitsanzo chathu, awa ndi "Surnames" ndi "Adjustment".

6. Mafomuwa akangolowa, dinani makiyi ophatikizira "Ctrl + Shift + Enter". Izi ndi zofunika chifukwa pali masanjidwe mu formula.

Tambasulani selo lapamwamba mpaka kumalire a malo omwe atchulidwa kale. Mzere wokhala ndi zomwe zasamutsidwa uyenera kuwonetsedwa, koma opanda ma cell opanda kanthu.

Kutsiliza

Kuchotsa maselo opanda kanthu ndi kotheka m'njira zingapo, aliyense wa iwo amasiyana mu msinkhu wa zovuta, kotero kuti onse osadziwa komanso wogwiritsa ntchito spreadsheet akhoza kusankha njira yoyenera kwambiri kwa iwo okha.