Ta yaya zan iya share duk layuka marasa komai a cikin Excel ta atomatik

Kwarewar yin aiki tare da shirin Excel tabbas yana da amfani ga wakilan sana'o'i da yawa. A cikin wannan labarin, za mu yi la'akari da batutuwa da dama - musamman, me yasa cire layuka a cikin Excel ta amfani da tsarin "zaɓi sel mara komai -> share jere" ba shine mafi kyawun ra'ayi ba. Za mu kuma yi nazari Hanyoyi 3 masu sauri kuma masu dogaro don Cire Layukan da ba komai haka, don kada ya lalata bayanan da ke cikin wasu sel ta kowace hanya. Duk mafita sun shafi Excel 2019, 2016, 2013 da baya.

Hanyoyi 3 masu sauri kuma masu dogaro don Cire Layukan da ba komai 

Tun da a halin yanzu kuna kallon wannan labarin, yana da ma'ana a ɗauka cewa ku, kamar sauran mutane, dole ne ku yi mu'amala akai-akai Excel maƙunsar bayanai na babban girman girma. Yiwuwar kun ci karo da yanayi inda layukan banza, yana hana mafi yawan kayan aikin da aka gina a ciki daga fahimtar kewayon bayanai daidai. Don haka, kowane lokaci, dole ne ku ƙayyade iyakokin da hannu - in ba haka ba za ku sami sakamako mara kyau, kuma zai ɗauki fiye da sa'a ɗaya na lokaci don ganowa da gyara irin waɗannan kurakurai. 

Akwai dalilai daban-daban da ya sa layin da ba su da tushe ya bayyana - alal misali, kun sami fayil ɗin Excel daga wani, ko an fitar da fayil ɗin daga wasu bayanan bayanai, ko kuma kun goge bayanan da gangan a cikin layin da ba a so. A kowane yanayi, idan kuna buƙata cire m Lines kuma a sakamakon haka don samun tebur mai tsabta da kyau, kuna buƙatar aiwatarwa jerin matakai masu sauƙi. Bari mu kalli wasu takamaiman yanayi kan batutuwa masu zuwa:

• Me yasa bai kamata ku cire layuka marasa komai ba ta zaɓin sel mara komai.
• Yadda ake kawar da duk layuka marasa komai lokacin da akwai ginshiƙin maɓalli.
• Yadda ake kawar da duk layuka marasa komai lokacin da babu ginshiƙin maɓalli.
• Yadda ake amfani da kayan aikin Share Layin Layi, kuma me yasa ya fi dacewa, kuma mafi mahimmanci, hanya mafi sauri.

Kar a cire layuka marasa komai ta zabar sel mara komai  

A Intanet, galibi ana iya samun shawara mai zuwa:

• Zaɓi duk ƙwayoyin da ke ɗauke da bayanai, daga na 1 zuwa karshe.
• Latsa madannin F5 - A sakamakon haka, akwatin maganganu "Sauyin yanayi".
• A cikin taga da ya buɗe, danna "haskaka".
• A cikin tagar"Zaɓin ƙungiyar sel» zaɓi zaɓi «Kwayoyin komai", sannan"OK".
• Danna-dama akan kowane tantanin halitta, sannan zaɓi "Share…".
• Ciki taga wanda ya budeShare sel» danna kan zabin «kirtani". 

Abin baƙin ciki, wannan ba hanya ce mafi kyau ba - Yi amfani da shi kawai don ƙananan teburi inda aka nuna layuka a cikin allon, ko ma mafi kyau - kar a yi amfani da shi kwata-kwata.

Wannan shi ne saboda gaskiyar cewa idan babu tantanin halitta guda ɗaya kawai a cikin layin da ke ɗauke da mahimman bayanai, an share duk layin. 

Bari mu kalli misali. A gabanmu akwai tebur na abokan ciniki, a ciki kawai 6 lokaci. Muna so share layi na uku da na biyar, tunda babu komai.

Yi amfani da hanyar da ke sama kuma za ku sami masu zuwa:

Layin 4 (Rojer) shima ya ɓace, saboda a cikin ginshiƙin "Traffic Source".  cell D4 fanko ne.

Tun da kuna da ƙaramin tebur, za ku iya samun rashin bayanai, amma a cikin manyan allunan da ke ɗauke da dubban layuka, za ku iya share layuka masu yawa da suka dace ba tare da sanin su ba. Idan kun yi sa'a za ku lura ya ɓace cikin 'yan sa'o'i kaɗan, mayar da fayil ɗinku daga madadinsannan a sake yi. Amma idan kun kasance daga cikin sa'a ko ba ku da madadin? 

Bari mu duba Hanyoyi 3 masu sauri kuma masu dogaro don Cire Layukan da ba komai daga maƙunsar bayanan ku na Excel. Kuma idan kuna son adana lokacinku - tafi kai tsaye zuwa Hanya ta 3.

Cire duk layuka marasa komai lokacin da akwai ginshiƙin maɓalli

The hanyar ayyukansu muddin kuna da shafi don taimaka muku gano idan igiyar ba ta da komai ko a'a (abin da ake kira ginshiƙin maɓalli). Misali, wannan na iya zama lambar oda, ko ID na abokin ciniki, ko wani abu makamancin haka.

Muna bukatar mu tafi jerin kirtani ba canzawa, don haka, kawai rarraba ta wannan ginshiƙi da matsar da duk layuka marasa komai zuwa ƙarshen tebur ba zai yi aiki ba. To me bukatar yi.

1. Zaɓi teburin gaba ɗaya, daga jere na 1 zuwa na ƙarshe (don yin wannan, zaku iya riƙe ƙasa lokaci guda. Ctrl + Gida, Gaba - Ctrl + Shift + Ƙarshe).

2. kafa Mai tacewa: jeka tab"data"kuma danna kan button"Tace".

3. Na gaba, kuna buƙatar amfani da tacewa zuwa "Custo #" ("Abu Abokin Ciniki.") shafi: danna kan kibiya mai saukewa "Autofilter" a cikin sunan shafi, cire (zaɓi duka), gungura ƙasa zuwa ƙarshe (a zahiri lissafin yana da tsayi sosai), sannan duba akwatin "Ba komai"… Danna OK.

4. Haɗa duk layukan da aka tace: don wannan zaka iya riƙe ƙasa a lokaci guda Ctrl + Gida, sannan maɓallin kibiya na ƙasa don sake komawa layin farko, sannan ka riƙe Ctrl + Shift + Ƙarshe.

5. Danna dama akan kowane tantanin halitta da aka zaɓa kuma danna kan "Share line» ko kawai danna Ctrl + - (alamar cirewa).

6. Latsa maballin OK lokacin amsa tambayarShare dukan wa'adin wasiƙar?»

7. Sannan kuna buƙatar share matatar da aka yi amfani da ita: don yin wannan, je zuwa "data"kuma danna kan button"Clean".

8. Good aiki! Dukkan layukan da babu komai sun tafi, kuma layi na uku (Rojer) yana nan (don kwatanta, za ka iya koma zuwa baya version).

Cire duk layuka marasa komai lokacin da babu ginshiƙin maɓalli    

Yi amfani da wannan hanyaridan kuna da tebur a cikin aikinku tare da ɗimbin sel mara komai da aka sanya a cikin ginshiƙai daban-daban, kuma kuna son share ainihin waɗannan layuka waɗanda cikakken fanko.

ginshiƙin maɓalli, wanda za a iya amfani da shi don gano ko igiyar ba ta da komai ko a'a, ya ɓace a cikin misalinmu. Me za a yi? Mu kanmu ƙirƙirar ƙarin shafi:

1. Create shafi "Blanks" ("Bakwai Kwayoyin") a ƙarshen teburin ku, sannan ku rubuta a cikin tantanin halitta ta 1 na wannan shafi. dabarar: = KYAUTA (A2: C2).

wannan tsari yana ƙidaya sel mara komai a cikin waɗanda aka tsara iyaka, inda A2 shine tantanin halitta na farko, C1 shine tantanin halitta na ƙarshe.

2. Copy dabarar ga duk sel a cikin ginshiƙi.

3. Yanzu muna da ginshiƙin maɓalli. Sannan amfani tace a cikin ginshiƙin "Blanks" (cikakkiyar umarnin da ke sama) don nuna layuka tare da matsakaicin ƙimar (3). "3" yana nufin mai zuwa: duk sel a jere babu kowa.

4. Sannan zabi duk tace layuka kuma cire gaba daya komaita amfani da umarnin da aka bayyana a baya.

Don haka layin fanko (layi na 5) cire, da kuma layi tare da bayanan da suka dace zauna a wurin.

5. Na gaba, share ƙarin shafi. Ba za a ƙara buƙatarsa ​​ba. Ko zaka iya saka wani tace da nuna layuka inda akwai sel guda ɗaya ko fiye.

Don yin wannan, cire alamar0"sannan danna"OK".

Amfani da kayan aikin Cire Layi mara kyau shine hanya mafi dacewa kuma mafi sauri  

Hanya mafi sauri kuma mafi ƙarancin aibi don cire layukan da ba komai kayan aiki neCire layi mara kyau”, an haɗa a cikin kit Ultimate Suite don Excel.

Daga cikin sauran masu amfani ayyuka ya ƙunshi da yawa amfani, wanda ke ba da damar dannawa ɗaya don motsa ginshiƙai ta hanyar ja; share duk sel marasa komai, layuka da ginshiƙai, haka kuma tace ta ƙimar da aka zaɓa, ƙididdige kashi, yi amfani da duk wani aikin lissafi na asali zuwa kewayo, kwafi adiresoshin tantanin halitta zuwa allon allo da ƙari mai yawa.

Yadda ake cire layin da ba komai a cikin matakai 4 masu sauki

Yin amfani da Ultimate Suite, Bugu da žari shigar da shirin Excel, shine abin da kuke buƙata do:

1. Danna kowane cell a cikin tebur.
2. Danna shafin Kayayyakin aiki, Ability > Ƙungiyar Canji.
3. latsa Cire layi mara kyau > Layukan banza.

4. latsa OKdon tabbatar da cewa da gaske kuke so cire layin komai.

Shi ke nan! Kawai dannawa kaɗan kuma zaku samu tebur mai tsabta, duk layukan da babu komai a ciki sun tafi, kuma tsarin layin bai karkata ba!