Yadda ake goge komai a cikin Excel. Hanyoyi 3 don Cire Kwayoyin Blank a cikin Excel

Lokacin canja wurin tebur daga tushen waje zuwa Excel, sau da yawa yanayi yana tasowa tare da motsi na sel tare da bayanai da samuwar ɓoyayyen. Lokacin amfani da dabaru, ƙarin aiki ba zai yiwu ba. Game da wannan, tambayar ta taso: ta yaya za ku iya cire sel marasa komai da sauri?

Abubuwan da zai yiwu a share sel marasa tushe

Lokacin aiki, canjin bayanai na iya faruwa, wanda ba kyawawa bane. Ana yin cirewa ne kawai a wasu lokuta, misali:

• Babu bayani a cikin duka jere ko ginshiƙi.
• Babu alaka ta hankali tsakanin sel.

Hanyar da aka saba don cire ɓoyayyen abu abu ɗaya ne a lokaci guda. Wannan hanya yana yiwuwa idan kun yi aiki tare da yankunan da ke buƙatar ƙananan gyare-gyare. Kasancewar babban adadin sel mara komai yana haifar da buƙatar amfani da hanyar share tsari.

Magani 1: share ta zaɓin ƙungiyar sel

Hanya mafi sauƙi ita ce amfani da kayan aiki na musamman don zaɓar ƙungiyoyin sel. Tsarin aiwatarwa:

1. Zaɓi wurin matsalar inda sel mara komai suka taru, sannan danna maɓallin F5.

2. Allon ya kamata ya buɗe taga umarni mai zuwa. Danna maballin Zaɓi mai hulɗa.
3. Shirin zai bude wani taga. Zaɓi "Cibiyoyin da Ba komai". Duba akwatin kuma danna Ok.
4. Akwai zaɓi na atomatik na wuraren da ba a cika ba. Danna-dama akan kowane yanki mara bayani yana kunna buɗe taga inda kake buƙatar danna "Share".
5. Na gaba, "Share Sel" zai buɗe. Sanya alama kusa da "Cells tare da motsi sama." Mun yarda ta danna maɓallin "Ok".

6. A sakamakon haka, shirin zai cire ta atomatik wuraren da ake buƙatar gyara.
7. Don cire zaɓin, danna LMB a ko'ina cikin tebur.

Lura! Hanyar sharewa tare da motsi ana zaɓar kawai a lokuta inda babu layukan bayan yankin zaɓi waɗanda ke ɗauke da kowane bayani.

Magani 2: Aiwatar da Tacewa da Tsarin Sharadi

Wannan hanyar ta fi rikitarwa, saboda haka, kafin a ci gaba da aiwatarwa, ana ba da shawarar ku fara sanin kanku da cikakken shirin aiwatar da kowane aiki.

Hankali! Babban rashin lahani na wannan hanya shine ana amfani da ita don aiki tare da ginshiƙi guda ɗaya wanda ba ya ƙunshi ƙididdiga.

Yi la'akari da bayanin jeri na tace bayanai:

1. Zaɓi yanki na shafi ɗaya. Nemo abu "Editing" a kan kayan aiki. Ta danna shi, taga mai jerin saitunan zai bayyana. Je zuwa shafin "Sir da Tace".

2. Zaɓi tacewa kuma kunna LMB.

3. A sakamakon haka, babban tantanin halitta yana kunna. Alamar mai siffar murabba'i mai kibiya ƙasa zai bayyana a gefe. Wannan yana nuna yiwuwar buɗe taga tare da ƙarin ayyuka.
4. Danna maɓallin kuma a cikin shafin da ke buɗewa, cire alamar akwatin kusa da matsayi "(Ba komai)", danna "Ok".

5. Bayan gyare-gyaren da aka yi, cikakkun sel kawai za su kasance a cikin ginshiƙi.

Nasihar masana! Cire kurakurai ta amfani da tacewa ya dace kawai idan babu cikakkun sel a kusa, in ba haka ba, lokacin yin wannan hanyar, duk bayanai zasu ɓace.

Yanzu bari mu kalli yadda ake yin tsarin tsari tare da tacewa:

1. Don yin wannan, zaɓi yankin matsalar kuma, bayan samo kayan aikin "Styles", kunna maɓallin "Tsarin Yanayi".

2. A cikin taga da ke buɗewa, nemo layin "Ƙari" kuma bi wannan hanyar haɗin.
3. Na gaba, a cikin taga da ke bayyana a filin hagu, shigar da darajar "0". A cikin filin da ya dace, zaɓi zaɓin cike launi da kuke so ko barin tsoffin ƙima. Mun danna "Ok". Sakamakon haka, duk sel da ke da bayanai za a fentin su cikin launi da ka zaɓa.
4. Idan shirin ya cire zaɓin da aka yi a baya, za mu sake yin shi kuma mu kunna kayan aikin "Filter". Tsaya akan ƙimar "Tace ta launi ta tantanin halitta" ko ta font kuma kunna ɗayan matsayi.
5. A sakamakon haka, kawai sel waɗanda ke da launi da launi, sabili da haka cike da bayanai, za su kasance.

6. Sake zabar yankin mai launi da launi kuma nemo maɓallin "Kwafi" a saman kayan aiki, danna shi. Ana wakilta shi da zanen gado guda biyu da aka ɗorawa juna.
7. Ta zaɓar wani yanki akan wannan takardar, muna yin wani zaɓi.
8. Danna-dama don buɗe menu, inda muka sami "Dabi'u". An gabatar da gunkin a cikin nau'i na kwamfutar hannu tare da ƙididdigar dijital 123, danna.

Lura! Lokacin zabar yanki, ya zama dole cewa ɓangaren sama yana ƙarƙashin layin ƙasa na jerin da aka haskaka.

9. Sakamakon haka, ana canja wurin bayanan da aka kwafi ba tare da amfani da tace launi ba.

Ana iya yin ƙarin aiki tare da bayanai a gida ko ta hanyar canja wurin zuwa wani yanki na takardar.

Magani 3: Yi amfani da dabarar

Cire ƙwayoyin tebur marasa komai ta wannan hanya yana da wasu matsaloli don haka ba shi da farin jini sosai. Wahalar ta ta'allaka ne a cikin amfani da dabarar, wanda dole ne a adana shi a cikin wani fayil daban. Bari mu shiga cikin tsari don:

1. Zaɓi kewayon sel waɗanda ke buƙatar gyara.
2. Sa'an nan kuma mu danna-dama kuma mu sami umurnin "Assign a name." Sanya suna zuwa shafi da aka zaɓa, danna Ok.

4. A kowane wuri a kan takardar, zaɓi yankin kyauta, wanda ya dace da girman yankin da aka yi gyare-gyare. Danna-dama kuma shigar da wani suna daban.

5. Bayan kana buƙatar kunna mafi girman tantanin halitta na yankin kyauta kuma shigar da dabara a ciki: = IF (ROW () -ROW (daidaitawa) + 1> NOTROWS (Last Names) - COUNTBLANK (LastNames); + ROWS(Sunayen Suna))); ROW()-ROW(Gidayawa)+1); COLUMN(Sunayen Suna);4))).

Lura! Ana zaɓar sunayen yankunan ba bisa ka'ida ba. A cikin misalinmu, waɗannan su ne "Sunayen Sunaye" da "gyara".

6. Da zarar an shigar da waɗannan dabarun, danna haɗin maɓalli "Ctrl + Shift + Shigar". Wannan ya zama dole saboda akwai tsararraki a cikin dabara.

Mikewa saman tantanin halitta zuwa iyakokin yankin da aka ayyana a baya. Ya kamata a nuna ginshiƙi tare da bayanan da aka canjawa wuri, amma ba tare da komai ba.

Kammalawa

Cire sel mara komai yana yiwuwa ta hanyoyi da yawa, kowannensu ya bambanta a cikin matakin rikitarwa, ta yadda mai amfani da ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararrun ƙwararru za su iya zaɓar zaɓi mafi dacewa da kansu.