Yadda zaka cire sel babu komai a Fim

Lokacin aiwatar da ayyuka a cikin fice, kuna iya buƙatar cire sel babu komai. Su ne sau da yawa ba dole ba ne kawai ƙara yawan bayanan da yawa fiye da mai amfani ya rikice. Mun ayyana hanyoyi kamar yadda zaku iya cire abubuwa marasa amfani.

Share Algorithms

Da farko dai, kana buƙatar gano, kuma yana yiwuwa a cire sel wofi a cikin wani tsararru ko tebur? Wannan hanya tana haifar da gudun hijira na bayanai, kuma wannan ba ya halatta a koyaushe. Ainihin, abubuwa za a iya share su cikin lokuta biyu:

• Idan zaren (shafi) cikakke ne babu komai (a cikin tebur);
• Idan sel a cikin kirtani da shafi ba a haɗa shi da juna (a cikin labulen).

Idan akwai 'yan sel wood, ana iya cire su gaba ɗaya ta amfani da hanyar cire jagora na al'ada. Amma, idan akwai yawan abubuwa masu yawa, to a wannan yanayin, wannan hanyar dole ne a sarrafa kansa.

Hanyar 1: Zabi rukuni na sel

Hanya mafi sauki don cire abubuwa marasa amfani ita ce amfani da kayan aiki don rabuwa da rukuni na sel.

1. Muna haskaka kewayon a kan takardar wanda za mu gudanar da aikin binciken da cire abubuwa marasa amfani. Latsa maɓallin aikin a kan keyboard F5.



2. An ƙaddamar da karamin taga, wanda ake kira "sauyawa". Muna danna a ciki the "Haskaka ..." button.



3. Tagar da ke gaba da ke buɗe - "Kungiyoyin ƙungiyoyi na sel". Sanya canjin zuwa "sel komai" matsayi a ciki. Yi danna maballin "Ok".



4. Kamar yadda kake gani, duk abubuwan da ba komai na kewayon da aka ƙayyade an bayyana su. Latsa kowane ɗayansu dama maɓallin linzamin kwamfuta. A cikin menu na mahallin da ke gudana maɓallin mahallin, danna maɓallin "Share ..." abu.



5. Smallaramin taga yana buɗewa wanda kuke buƙatar zaɓar abin da ya kamata ka share. Bar saitunan tsoho - "sel, tare da canzawa." Latsa maɓallin "Ok".

Bayan waɗannan magidano, duk abubuwan da ba komai a cikin kewayon da aka ƙayyade za a share.

Hanyar 2: Tsarin sharadi da tacewa

Hakanan za'a iya amfani da sel babu komai ta hanyar amfani da tsarin sharadi kuma bayanan tace. Wannan hanyar ta fi rikitarwa ta daya baya, amma duk da haka, wasu masu amfani sun fi son sa. Bugu da kari, ya zama dole don yin ajiyar nan da nan wannan hanyar ta dace kawai idan dabi'u suna cikin wannan shafi kuma basu da tsari.

1. Muna haskaka kewayon da zai aiwatar. Kasancewa a cikin gidan gida, danna kan "Tsarin tsari" gunkin "gunkin, wanda, bi da shi, yana cikin kayan aikin" salon ". Je zuwa abun da ya bude jerin "ka'idodi don kasaftawa sel". A cikin jerin ayyukan da ya bayyana, zaɓi matsayin "ƙarin ...".



2. Gyara tsarin taga yana buɗewa. A cikin hagu filin shigar da lambar "0". A cikin Dama filin, zaɓi kowane launi, amma zaka iya barin saitunan tsoho. Latsa maɓallin "Ok".



3. Kamar yadda muke gani, dukkanin sel kewayon wanda aka fifita dabi'un da aka fifita a cikin zaba, kuma babu wofi ya kasance fari. Sake zagaye kewayon mu. A cikin wannan shafin, "Home" danna maɓallin "Sort da tace" wanda ke cikin ƙungiyar gyarawa. A cikin menu wanda ke buɗe, danna maɓallin "tace".



4. Bayan waɗannan ayyukan, kamar yadda muke gani, toka alama ta bayyana a cikin ɓangaren ɓangaren ɓangaren shafi. Danna shi. A cikin jerin da ke buɗe, je zuwa "Sassan launuka". Bayan haka, a cikin rukunin "Shin da launi mai launi", zaɓi launi wanda aka zaɓa saboda tsarin sharadi.

   

   Hakanan zaka iya yin kadan daban. Latsa alamar toka. A cikin menu wanda ya bayyana, cire akwati daga matsayin "komai". Bayan haka, danna maɓallin "Ok".



5. A kowane ɗayan waɗanda aka ƙayyade a cikin zaɓi na baya, za a ɓoye abubuwa wofi. Muna haskaka kewayon sauran sel. A shafin gida, a cikin saitunan Clipboard, yi danna maɓallin "Kwafi".



6. Sannan muna haskaka wani yanki mara komai a kan iri ɗaya ko a kan wani takarda. Yi maɓallin linzamin kwamfuta na dama dama. A cikin jerin mahancin mahaɗan waɗanda ke bayyana a cikin sigogin shigar sa, zaɓi maɓallin "darajar".



7. Kamar yadda kake gani, shigar da bayanai ya faru ba tare da ingantawa ba. Yanzu zaku iya cire farkon kewayon, kuma saka ɗaya a wurinta wanda muka karɓa yayin aikin da aka bayyana a sama, kuma zaku iya ci gaba da aiki tare da bayanan a cikin sabon wuri. Duk ya dogara da takamaiman ayyuka da kuma abubuwan da ke da fifikon mai amfani.

Darasi: Tsarin sharadi a Excel

Darasi: Rarrabe da tace bayanai don fice

Hanyar 3: Aikace-aikace na Computula

Bugu da kari, yana yiwuwa a cire sel babu komai daga cikin tsararre ta amfani da wani hadaddun tsari wanda ya kunshi ayyuka da yawa.

1. Da farko dai, muna buƙatar ba da suna zuwa kewayon da ke ƙarƙashin canji. Muna haskaka yankin, zamu danna dama. A menu na aiki, zaɓi sunan "Sanya sunan ..." abu.



2. Window Sarar da aka buɗe. A cikin "Sunan" filin da muke ba da wani suna da ya dace. Babban yanayin - bai kamata ya zama gibba ba. Misali, mun sanya sunan "C_Pust". Babu sauran canje-canje a wannan taga ba sa buƙata. Latsa maɓallin "Ok".



3. Muna haskaka ko'ina a kan takardar a kan takardar daidai iri ɗaya girman sel iri ɗaya. Hakazalika, ta danna maɓallin linzamin kwamfuta da dama kuma, ta hanyar kiran menu na mahallin, bi ta hanyar "sanannun suna ..." abu.



4. A cikin taga da ke buɗe, kamar yadda a zamanin da ya gabata, sanya kowane sunan wannan yankin. Mun yanke shawarar ba shi sunan "komai".



5. Muna haskaka da farko-danna maɓallin linzamin kwamfuta na hagu, tantanin farko na kewayon yanayin "komai" (za ku iya juyawa daban). Saka wannan dabara zuwa gare ta:

   = Idan (kirtani () - kirtani (email) +1> essay (tare da_posts) -Thetl (cirm) (idan (kirtani) -; Tare da_posts)))); jere () - kirtani (email) +1); shafi

   Tun da yake wannan tsari ne na tsararru, yana da mahimmanci don latsa maɓallin don cire ƙididdigewa a allon, maimakon latsa labarin maɓallin Shigar.



6. Amma, kamar yadda muke gani, sel guda daya ne kawai ya cika. Domin cika da sauran, kuna buƙatar kwafa dabara don ragowar kewayon. Ana iya yin wannan ta amfani da mai alama. Shigar da siginan kwamfuta zuwa ƙananan kusurwar dama na tantanin halitta yana dauke da cikakken aiki. Dole ne siginan kwamfuta ta canza a cikin gicciye. Danna maɓallin linzamin kwamfuta na hagu kuma cire shi har zuwa ƙarshen "imel" band.



7. Kamar yadda kake gani, bayan wannan matakin, muna da kewayon da ciyawar da take a jere. Amma ba za mu iya yin ayyuka da yawa tare da waɗannan bayanan ba, kamar yadda suke da alaƙa da tsarin tsararru. Mun ware duk kewayon "imel". Latsa maɓallin "Kwafi", wanda aka sanya a cikin shafin "Gidan" a cikin "Exchange Buffer".



8. Bayan haka, muna ware tsarin bayanan farko. Danna dama linzamin kwamfuta. A cikin jerin da ke buɗe a cikin Sassan Sadarwa, danna maɓallin "darajar".



9. Bayan waɗannan ayyukan, za a saka bayanan a cikin farkon yankin wurin da mahaɗan mai ƙarfi ba tare da sel ba komai. Idan ana so, da aka tsara wanda ya ƙunshi dabara yanzu.

Darasi: Yadda ake sanya sunan tantancewa zuwa fice

Akwai hanyoyi da yawa don cire abubuwa marasa amfani a Microsoft Excel. Zabi tare da sakin kungiyoyin sel shine mafi sauki da sauri. Amma akwai yanayi daban-daban. Sabili da haka, azaman ƙarin hanyoyin, zaku iya amfani da zaɓuɓɓuka tare da tacewa da amfani da tsari mai rikitarwa.