Momwe mungachotsere ma cell mu Excel. Chotsani maselo amwazikana komanso opanda kanthu, njira zitatu zochotsera selo mu Excel

Pogwira ntchito ndi zikalata za Excel, ogwiritsa ntchito nthawi zonse amafunikira osati kungoyika ma cell, komanso kuwachotsa. Njira yokhayo ndiyosavuta, koma pali njira zina zoyendetsera njirayi zomwe zimatha kufulumizitsa ndikuzichepetsa. M'nkhaniyi, tiwona mwatsatanetsatane njira zonse zochotsera ma cell mu chikalata.

Njira yochotsera ma cell

Zomwe zimaganiziridwa patebulo zitha kukhala zamitundu iwiri: zomwe zili ndi chidziwitso komanso zopanda kanthu. Poganizira izi, njira yowachotsera idzakhala yosiyana, popeza pulogalamuyo imapereka mwayi wosankha njira yosankha ndikuchotsanso ma cell osafunika.

Ziyeneranso kunenedwa pano kuti pochotsa chinthu chimodzi kapena zingapo patebulo, chidziwitso chomwe chili mkati mwake chingasinthe mawonekedwe ake, chifukwa chifukwa cha njira zomwe zatengedwa, mbali zina za tebulo zikhoza kuchotsedwa. Pachifukwa ichi, musanayambe kuchotsa maselo osafunika, m'pofunika kuganizira zotsatira zake ndipo, kuti mukhale otetezeka, pangani kopi yosunga chikalatachi.

Zofunika! Pochotsa maselo kapena zinthu zingapo, osati mizere yonse ndi mizati, zomwe zili mkati mwa tebulo la Excel zimasinthidwa. Choncho, kukhazikitsidwa kwa ndondomekoyi kuyenera kuganiziridwa bwino.

Njira 1: menyu yankhani

Choyamba, muyenera kuganizira za kukhazikitsidwa kwa njira yomwe ikufunsidwa kudzera pa menyu yankhaniyo. Njirayi ndi imodzi mwazofala kwambiri. Itha kugwiritsidwa ntchito ngati ma cell odzazidwa ndi zinthu zopanda kanthu patebulo.

1. M'pofunika kusankha 1 selo kapena zinthu zingapo kuti zichotsedwa. Kusindikiza pa kusankha ndi kumanja mbewa batani. Pambuyo pake, muyenera kuyambitsa menyu yachidule. M'menemo, muyenera kusankha "Chotsani ...".
   

   

2. A zenera ndi 4 ntchito adzakhala anasonyeza pa polojekiti. Popeza tifunika kuchotsa maselo mwachindunji, osati mizere yonse kapena mizati, ndiye kuti 1 mwa zochita za 2 zimasankhidwa - kuchotsa zinthu zomwe zili ndi mbali ya kumanzere kapena kuchotseratu. Kusankha zochita kuyenera kutengera ntchito zomwe wogwiritsa ntchito akukumana nazo. Ndiye, pamene njira ina yasankhidwa, zochitazo zimatsimikiziridwa ndi kukanikiza "Chabwino".
   

   

3. Monga momwe zakonzedwera, zinthu zonse zolembedwa zimachotsedwa pachikalatacho. Njira yachiwiri (kusintha mmwamba) idasankhidwa, chifukwa gulu la ma cell omwe ali pansi pa malo ojambulidwa adasunthidwa ndi mizere yambiri momwe analiri pampata wosankhidwa.
   

   

4. Ngati mungasankhe 1st njira (kusintha kumanzere), selo lililonse lomwe lili kumanja kwa omwe achotsedwa lidzasinthidwa kumanzere. Izi zitha kukhala zabwino kwambiri munthawi yathu, popeza kumanja kwa mzere womwe watchulidwa kunalibe zinthu zopanda kanthu. Poganizira izi, kunja kumawoneka kuti chidziwitso cha nthawi yodziwika bwino chinachotsedwa pamene chikusunga kukhulupirika kwa chikalatacho. Ngakhale, kwenikweni, zotsatira zofanana zimatheka mwachindunji chifukwa chakuti zinthu za tebulo zomwe zinalowa m'malo mwa zoyambazo zilibe deta mwa iwo.
   

   

Njira 2: Zida za Riboni

Mutha kufufutanso ma cell pamatebulo a Excel pogwiritsa ntchito zida zomwe zaperekedwa pa riboni.

1. Poyamba, muyenera kuyika chizindikiro m'njira inayake yomwe mukufuna kuchotsa. Kenako muyenera kusinthana ndi tabu yayikulu ndikudina "Chotsani" (yomwe ili mu "Maselo" menyu).
   

   

2. Tsopano mutha kuwona kuti selo loyang'aniridwa lachotsedwa patebulo, ndipo zinthu zomwe zili pansipa zasuntha. Kuonjezera apo, ziyenera kutsindika kuti njirayi sidzakulolani kuti mudziwe komwe zinthu zidzasunthidwe pambuyo pochotsa.
   

   

Pakafunika kuchotsa gulu lopingasa la maselo pogwiritsa ntchito njirayi, ndi bwino kukumbukira zotsatirazi:

• Maselo angapo opingasa amasankhidwa. Dinani "Chotsani" pa "Home" tabu.
  

  

• Monga momwe zinalili m'mbuyomu, zinthu zomwe zatchulidwazi zimachotsedwa ndi kukweza pamwamba.
  

  

Gulu loyima la maselo likachotsedwa, kusinthaku kumachitika mbali ina:

• Gulu la zinthu zoyima likuwunikira. Dinani "Chotsani" pa riboni.
  

  

• Mutha kuwona kuti kumapeto kwa njirayi, zinthu zolembedwa zimachotsedwa ndikusinthira kumanzere.
  

  

Tsopano popeza ntchito zoyambira zaphimbidwa, ndizotheka kugwiritsa ntchito njira yosinthika pochotsa zinthu. Zimaphatikizapo kugwira ntchito ndi matebulo ndi magulu a maselo opingasa ndi oima:

• Nthawi yofunikira ya data imawonetsedwa ndipo batani lochotsa lomwe lili pa riboni limakanidwa.
• Gulu losankhidwa limachotsedwa ndipo ma cell oyandikana nawo amasunthidwa kumanzere.

Zofunika! Kugwiritsa ntchito kiyi ya Delete yomwe ikupezeka pa riboni ya chida sikukhala yogwira ntchito kwambiri kuposa kufufuta kudzera pazosankha, chifukwa sizimalola wogwiritsa ntchito kusintha ma cell.

Pogwiritsa ntchito zida zomwe zili pa riboni, ndizotheka kuchotsa zinthu posankha njira yosinthira. Muyenera kuphunzira momwe izi zimagwiritsidwira ntchito:

• Chigawo chomwe chiyenera kuchotsedwa chikuwonetsedwa. Komabe, tsopano mu "Maselo" tabu, si "Chotsani" batani kuti adina, koma makona atatu, amene ili kumanja kwa kiyi. Pazosankha zowonekera, dinani "Chotsani Maselo ...".
  

  

• Tsopano mutha kuzindikira zenera likuwonekera kale ndi zosankha zochotsa ndikusintha. Yemwe ingagwirizane ndi zolinga zapadera imasankhidwa, ndipo fungulo la "Chabwino" limakanizidwa kuti mupeze zotsatira zomaliza. Mwachitsanzo, kudzakhala kusintha kwapamwamba.
  

  

• Njira yochotsera idapambana, ndipo kusintha kunachitika mwachindunji mmwamba.
  

  

Njira 3: kugwiritsa ntchito hotkeys

Ndikothekanso kuchita zomwe zikufunsidwa pogwiritsa ntchito kuphatikiza kwa ma hotkey:

1. Sankhani osiyanasiyana mu tebulo kuti mukufuna kuchotsa. Kenako muyenera kukanikiza kuphatikiza mabatani "Ctrl" + "-" pa kiyibodi.
   

   

2. Ndiye muyenera kutsegula zenera kale bwino kwa deleting maselo mu tebulo. Njira yomwe mukufuna kuchotsa imasankhidwa ndikudina batani la OK.
   

   

3. Zotsatira zake, mutha kuwona kuti ma cell osankhidwa amachotsedwa ndi njira yosinthira yomwe yafotokozedwa m'ndime yomaliza.
   

   

Njira 4: Kuchotsa zinthu zosiyanasiyana

Pali nthawi zina pomwe mukufuna kuchotsa magawo angapo omwe samaganiziridwa kuti ndi ofanana, omwe ali m'malo osiyanasiyana muzolemba. Akhoza kuchotsedwa pogwiritsa ntchito imodzi mwa njira zomwe zili pamwambazi, poyendetsa selo lililonse padera. Komabe, izi nthawi zambiri zimatenga nthawi yambiri. Pali mwayi wochotsa zinthu zobalalika patebulo, zomwe zimathandiza kuthana ndi ntchitoyi mwachangu kwambiri. Komabe, chifukwa cha izi, ziyenera kudziwika poyamba.

1. Selo loyamba limasankhidwa ndi njira yokhazikika, kugwirizira batani lakumanzere ndikulizungulira ndi cholozera. Kenako, muyenera kugwira fungulo la "Ctrl" ndikudina pazotsalira zomwe zabalalika kapena kuzungulira mizere pogwiritsa ntchito cholozera ndikusindikiza batani lakumanzere.
2. Kenaka, pamene maselo ofunikira amasankhidwa, ndizotheka kuchita kuchotsa ndi njira iliyonse yomwe ili pamwambayi. Pambuyo pake, maselo onse ofunikira adzachotsedwa.
   

   

Njira 5: Kuchotsa Maselo Opanda kanthu

Wogwiritsa ntchito akafuna kuchotsa ma cell opanda kanthu muzolemba, ndizotheka kusinthiratu njira yomwe ikufunsidwayo osati kusankha chilichonse payekhapayekha. Pali njira zingapo zothetsera vutoli, koma njira yosavuta yochitira izi ndi chida chosankha.

1. Gome kapena mtundu wina papepala limasankhidwa pomwe kufufutidwa kumafunika. Pambuyo pake, kiyi yantchito "F5" imadina pa kiyibodi.
   

   

2. Zenera lakusintha layatsidwa. Mmenemo, muyenera dinani batani la "Sankhani ...", lomwe lili kumanzere kumanzere.
   

   

3. Kenako zenera losankha magulu azinthu lidzatsegulidwa. Pazenera lokha, chosinthiracho chimayikidwa pamalo a "Empty Cells", ndiyeno batani la "Chabwino" limadina pansi kumanja.
   

   

4. Pambuyo pake, mutha kuzindikira kuti mutatha kuchitapo kanthu komaliza, ma cell opanda kanthu omwe ali pamndandanda wolembedwa adzawonetsedwa.
   

   

5. Tsopano wogwiritsa ntchito angoyenera kuchotsa ma cell omwe akufunsidwa ndi njira iliyonse yomwe yasonyezedwa pamwambapa.

Njira 1. Zovuta komanso zofulumira

Kuti muchotse ma cell osafunikira patebulo la Excel chimodzimodzi, tsatirani izi:

1. Sankhani mtundu womwe mukufuna.
2. Kenako batani logwira ntchito "F5" likanikizidwa, pambuyo pa kiyi ya "Select (Special)". Mu menyu omwe akuwoneka, sankhani "Blanks" ndikudina "Chabwino". Ndiye zinthu zonse zopanda kanthu mumtunduwo ziyenera kusankhidwa.
   

   

3. Pambuyo pake, menyu imapereka lamulo loti muchotse zinthu zomwe zafotokozedwa patebulo la RMB - "Chotsani Maselo (Chotsani Maselo) ndikusintha m'mwamba".

Njira 2: Njira Yopangira

Kuti muchepetse njira yochotsera ma cell osafunikira patebulo, muyenera kugawa mayina kumagawo ofunikira ogwirira ntchito pogwiritsa ntchito "Name Manager" pa "Formulas" tabu, kapena - mu Excel 2003 ndi achikulire - "Insert zenera" - "Dzina" - "Pangani".

Mwachitsanzo, mtundu wa B3: B10 udzakhala ndi dzina "IsEmpty", mtundu wa D3: D10 - "NoEmpty". Mipata iyenera kukhala yofanana, ndipo ikhoza kupezeka paliponse.

Pambuyo pa maopaleshoni omwe adachitika, gawo loyamba la gawo lachiwiri (D3) limasankhidwa ndipo njira yotsatirayi imayikidwa: =IF(ROW()-ROW(NoEmpty)+1>NOTROWS(YesEmpty)-COUNTBLLANK(YesEmpty);”«;INDIRECT(ADDRESS(LOWEST((IF(Empty<>“«;ROW(Empty);ROW)) + Mzere (Pali Chopanda))); Mzere () -ROW (Palibe Chopanda) + 1); COLUMN (Pali Chopanda); 4))).

Imalowetsedwa ngati chilinganizo chotsatira, mutatha kuyika, muyenera dinani "Ctrl + Shift + Lowani". Pambuyo pake, chilinganizo chomwe chikufunsidwacho chikhoza kukopera pogwiritsa ntchito kudzaza kokha (chizindikiro chakuda chophatikizana chimatambasulidwa pansi kumanja kwa chinthucho) - pambuyo pake, mndandanda wapachiyambi udzapezedwa, koma popanda zinthu zopanda kanthu.

Njira 3. Mwambo ntchito mu VBA

Pamene wogwiritsa ntchito amayenera kubwereza nthawi zonse ntchito yomwe ikufunsidwa kuti achotse maselo osafunika patebulo, tikulimbikitsidwa kuwonjezera ntchito yotereyi ku seti kamodzi ndikuigwiritsa ntchito pazochitika zilizonse. Pachifukwa ichi, Visual Basic Editor imatsegulidwa, gawo latsopano lopanda kanthu limayikidwa, ndipo malemba a ntchitoyi amakopera.

Ndikofunika kuti musaiwale kusunga fayilo ndikubwerera kuchokera ku Visual Basic Editor kupita ku Excel. Kuti mugwiritse ntchito zomwe zikufunsidwa mu chitsanzo china:

1. Mtundu wofunikira wa zinthu zopanda kanthu umawonetsedwa, mwachitsanzo F3:F10.
2. Tsegulani tabu ya "Ikani", kenako "Function", kapena dinani batani la "Insert Function" pagawo la "Mafomula" mu mtundu watsopano wa mkonzi. M'mawonekedwe Otanthauzira Ogwiritsa, NoBlanks amasankhidwa.
3. Monga mtsutso wa ntchito, tchulani mndandanda woyamba ndi mipata (B3: B10) ndikusindikiza "Ctrl + Shift + Enter", izi zidzakuthandizani kuti mulowetse ntchitoyi ngati ndondomeko yowonjezera.

Kutsiliza

Kutengera ndi nkhaniyi, njira zingapo zimadziwika, pogwiritsa ntchito zomwe zingatheke kuchotsa maselo osafunika m'matebulo a Excel. Tiyenera kuzindikira kuti kukhazikitsidwa kwa ambiri mwa iwo ndi ofanana, ndipo nthawi zina ndondomeko imakhala yofanana. Chifukwa chake, ogwiritsa ntchito amatha kusankha njira yomwe ingawathandize kuthana ndi vuto linalake mwachangu komanso moyenera. Kuphatikiza apo, mkonzi mwachindunji pa ntchito yochotsa zinthu za tebulo amapereka "mabatani otentha" omwe amakulolani kuti musunge nthawi pazomwe mukufunsidwa. Kuphatikiza apo, chikalatacho chikakhala ndi maselo opanda kanthu, palibe chifukwa chosankha chilichonse padera kuti chichotsedwe. Pazifukwa izi, ndizotheka kugwiritsa ntchito chida chamagulu, chomwe chimasankha zinthu zomwe zilibe deta. Pambuyo pake, wosuta amangofunika kuzichotsa mwa njira iliyonse yomwe ili pamwambayi.