Share sel marasa aiki a Microsoft Excel

Lokacin aiwatar da ayyuka a cikin Excel, zaku buƙaci share ƙwayoyin komai. Yawancin lokaci abubuwa ne marasa mahimmanci kuma kawai suna ƙaruwa jimlar bayanai, wanda ke rikitar da mai amfani. Zamu ayyana hanyoyin da za'a cire abubuwa marasa hanzari.

Share Algorithms

Da farko dai, kuna buƙatar ganowa, shin zai yiwu a share ƙwayoyin wofi cikin takamaiman tsararren tebur ko tebur? Wannan hanyar tana haifar da nuna bambancin bayanai, kuma wannan ya dagula halatta koyaushe. A zahiri, abubuwa kawai za'a iya goge su a lokuta biyu:

• Idan jere (shafi) gaba daya fanko ne (a cikin allunan);
• Idan ƙwayoyin da ke cikin layin da shafi ba su da alaƙa da juna (cikin tsare-tsare).

Idan akwai emptyan tsirarun sel, to za a iya cire su gaba ɗaya ta amfani da hanyar cirewar da aka saba. Amma, idan akwai adadin adadin waɗannan abubuwan da ba a cika su ba, to a wannan yanayin, wannan hanya tana buƙatar sarrafa kansa.

Hanyar 1: zaɓi ƙungiyoyin tantanin halitta

Hanya mafi sauƙi don cire abubuwan wofi shine amfani da kayan aikin zaɓi na tantanin halitta.

1. Mun zabi kewayon akan takaddun wanda zamuyi aikin bincike da share abubuwa marasa amfani. Latsa maɓallin aiki akan keyboard F5.



2. Wani karamin taga aka kira Canji. Latsa maɓallin a ciki "Zaɓi ...".



3. Wannan taga mai zuwa yana buɗe - "Zabi kungiyoyin salula". Saita canjin zuwa matsayi a ciki Kwayoyin marasa komai. Latsa maballin. "Ok".



4. Kamar yadda kake gani, duk abubuwan babu komai na ƙayyadadden kewayon an zaɓa. Mun danna kowane ɗayansu tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da zai fara, danna kan abu "Share ...".



5. Windowaramin window yana buɗewa wanda kuke buƙatar zaɓi abin da ya kamata a cire. Bar tsoffin saitunan - "Kwayoyin tare da juyawa sama". Latsa maballin "Ok".

Bayan waɗannan manipulation, duk abubuwan da babu komai a cikin yankin da aka ƙayyade za'a share su.

Hanyar 2: Tsararren tsari da tacewa

Hakanan zaka iya share ƙwayoyin mara komai ta amfani da tsararren tsari da tace bayanai masu zuwa. Wannan hanyar ta fi rikitarwa fiye da wacce ta gabata, amma, duk da haka, wasu masu amfani sun fi sonta. Bugu da kari, dole ne a hanzarta yin ajiyar cewa wannan hanyar ta dace ne kawai idan dabi'un suna cikin layi ɗaya kuma basu da dabara.

1. Zabi kewayon da za mu aiwatar. Kasancewa a cikin shafin "Gida"danna alamar Tsarin Yanayi, wanda, bi da bi, yana cikin shinge na kayan aiki Salo. Je zuwa abu a cikin jerin da yake buɗe. Dokokin Zabi na Cell. A jerin ayyukan da ke bayyana, zaɓi matsayi "...Ari ...".



2. Tsarin tsara yanayin yana buɗe. Shigar da lambar a filin hagu "0". A filin dama, zaɓi kowane launi, amma zaka iya barin saitunan tsoho. Latsa maballin "Ok".



3. Kamar yadda kake gani, dukkanin sel a cikin takamaiman kewayon abin da aka sanya mahimmancinsu waɗanda aka haskaka su da launi da aka zaɓa, kuma fanko sunyi fari fat. Sake kuma, nuna adadinmu. A cikin wannan shafin "Gida" danna maballin Dadi da kuma Matatarwadake cikin rukunin "Gyara". A cikin menu wanda yake buɗe, danna maballin "Tace".



4. Bayan waɗannan ayyuka, kamar yadda muke gani, gunki mai nuna alamar yana bayyana a saman ɓangaren shafi. Danna shi. Cikin jerin masu buɗewa, jeka A ware ta launi. Karin bayani a cikin kungiyar A ware ta hanyar launi na sel " zabi launi wanda zabin ya faru sakamakon tsararren tsari.

   

   Hakanan zaka iya yi kadan daban. Latsa alamar tacewa. A cikin menu wanda ya bayyana, ɓoye gurbin "Babu komai". Bayan haka, danna maɓallin "Ok".



5. A kowane ɗayan zaɓuɓɓukan da aka nuna a sakin baya, ɓoyayyun abubuwan za su ɓoye. Zabi kewayon ragowar sel. Tab "Gida" a cikin tsarin toshewa Clipboard danna maballin Kwafa.



6. Sannan zaɓi kowane yanki mara wofi a kan iri ɗaya ko akan takarda. Danna-dama A cikin jerin abubuwan aiwatarwar da suka bayyana, a cikin zabin sa, zabi "Dabi'u".



7. Kamar yadda kake gani, an saka bayanan ba tare da tsara tsari ba. Yanzu zaku iya share kewayon farko, kuma a wurin sa saka wanda muka karɓa yayin aikin da ke sama, ko kuna iya ci gaba da aiki tare da bayanai a cikin sabon wuri. Dukkanta ya dogara ne akan takamaiman ayyuka da mahimmancin mai amfani.

Darasi: Tsarin yanayi a cikin Excel

Darasi: A ware da kuma tace bayanai a cikin Excel

Hanyar 3: amfani da tsari mai rikitarwa

Bugu da kari, zaku iya cire sel marasa komai daga jeri ta hanyar amfani da tsari mai rikitarwa wanda ya kunshi ayyuka da yawa.

1. Da farko, muna buƙatar ba da suna ga kewayon da yake shirin canji. Zaɓi yankin, danna-dama. A cikin menu na kunnawa, zaɓi "Sanya suna ...".



2. Wurin suna yana buɗewa. A fagen "Suna" ba kowane suna da ya dace. Babban yanayin shine cewa kada a sami sarari. Misali, mun sanya suna zuwa ga kewayon. "C_empty". Ba a bukatar ƙarin canje-canje a cikin wannan taga. Latsa maballin "Ok".



3. Zaɓi ko'ina cikin takin daidai girman kewayon ƙwayoyin komai. Hakanan, muna danna-dama kuma, da muke kiran menu na mahallin, je zuwa ga abun "Sanya suna ...".



4. A cikin taga da ke buɗe, kamar lokacin da ya gabata, mun sanya kowane suna zuwa wannan yankin. Mun yanke shawarar ba ta suna "Babu_empty".



5. Danna sau biyu na maɓallin linzamin kwamfuta na hagu a kan sel na farko na keɓaɓɓiyar yanayin "Babu_empty" (yana iya samun wani suna daban). Mun shigar dashi wani tsari na nau'in mai zuwa:

   = IF (LINE () - LINE (Ba tare da_empty) +1> STRING (Tare da_empty) -Credit VOIDs (Tare_empty); ""; (С_empty))); STRING () - STRING (Babu_empty) +1); COLUMN (С_empty); 4))

   Tunda wannan tsari ne na tsari, don nuna ƙididdigar akan allon, kana buƙatar latsa haɗin maɓalli Ctrl + Shift + Shigar, maimakon shigarwar maballin da aka saba Shigar.



6. Amma, kamar yadda muke gani, sel guda ɗaya kawai aka cika. Domin cike ragowar, kuna buƙatar kwafa dabarar zuwa ragowar kewayon. Ana iya yin wannan ta amfani da alamar cikawa. Mun sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta dauke da aiki mai rikitarwa. Maimaitawar siginar ya kamata ya juya zuwa gicciye. Riƙe maɓallin linzamin kwamfuta na hagu ka ja shi zuwa ƙarshen kewayon "Babu_empty".



7. Kamar yadda kake gani, bayan wannan aikin muna da kewayon da aka cika ɗakunan ƙwayoyin sel a jere. Amma ba za mu iya yin ayyuka daban-daban tare da wannan bayanan ba, tunda suna da alaƙa da tsarin tsararru. Zaɓi duka kewayon. "Babu_empty". Latsa maballin Kwafawanda aka sanya a cikin shafin "Gida" a cikin akwatin kayan aiki Clipboard.



8. Bayan haka mun zaɓi bayanan farko. Mun danna maɓallin linzamin kwamfuta na dama. A lissafin da yake buɗe a cikin rukunin Saka Zabi danna alamar "Dabi'u".



9. Bayan waɗannan ayyuka, za a shigar da bayanai a cikin asalin asalin wurin da yake tare da ingantaccen iyaka ba tare da ƙwayoyin komai ba. Idan ana so, za a iya share tsararren tsari wanda ya ƙunshi tsarin.

Darasi: Yadda ake yin suna a cikin Excel

Akwai hanyoyi da yawa don cire abubuwa marasa amfani a Microsoft Excel. Zaɓin zaɓi tare da zaɓar rukuni na sel shine mafi sauƙi kuma mafi sauri. Amma yanayin ya bambanta. Sabili da haka, azaman ƙarin hanyoyin, yana yiwuwa a yi amfani da zaɓuɓɓuka tare da tacewa da kuma amfani da tsari mai santsi.