Ƙarin sarari a cikin rubutu ba sa launi kowane takardun. Musamman ma ba su buƙatar a yarda su a cikin tebur da aka ba su don gudanarwa ko jama'a. Amma ko da idan kuna amfani da bayanan don dalilai na sirri, ƙananan wurare suna taimakawa wajen ƙara yawan girman takardun, wanda shine maɓallin ma'ana. Bugu da ƙari, kasancewar waɗannan abubuwa marasa mahimmanci ya sa ya wuya a bincika fayil ɗin, yin amfani da filtura, amfani da samfuri da wasu kayan aikin. Bari mu gano yadda za ka iya samun sauri ka cire su.
Darasi: Cire manyan wurare a cikin Microsoft Word
Gap cire fasaha
Nan da nan dole in faɗi cewa wurare a Excel na iya zama daban-daban. Wadannan zasu iya zama wuri tsakanin kalmomi, sarari a farkon darajar kuma a karshen, rabuwa tsakanin lambobi na lambobi, da dai sauransu. Saboda haka, algorithm don kawar da su a cikin wadannan sharuɗɗan daban-daban.
Hanyar 1: Yi amfani da Sauya kayan aiki
Kayan aiki yayi babban aiki na maye gurbin sau biyu a tsakanin kalmomi tare da ɗaya a Excel "Sauya".
- Da yake cikin shafin "Gida", danna kan maɓallin "Nemi kuma haskaka"wanda aka samo a cikin kayan aiki Ana gyara a kan tef. A cikin jerin layi, zaɓi abu "Sauya". Hakanan zaka iya maimakon maimakon abubuwan da ke sama da su kawai rubuta hanyar gajeren hanya Ctrl + H.
- A cikin kowane zaɓuɓɓuka, window na "Nemo da Sauya" ya buɗe a shafin "Sauya". A cikin filin "Nemi" saita siginan kwamfuta kuma danna danna sau biyu Spacebar a kan keyboard. A cikin filin "Sauya da" saka wuri guda. Sa'an nan kuma danna maballin "Sauya Duk".
- Shirin ya sauya sarari biyu tare da guda. Bayan haka, taga yana bayyana tare da rahoto akan aikin da aka yi. Muna danna maɓallin "Ok".
- Sa'an nan taga ya sake bayyana. "Nemi kuma maye gurbin". Mun yi daidai wannan aikin kamar yadda aka bayyana a sakin layi na biyu na wannan umarni har sai sakon yana bayyana cewa ba a samo bayanin da aka so ba.
Ta haka ne, mun kawar da karin wurare biyu tsakanin kalmomi a cikin takardun.
Darasi: Sake Ayyukan Yanayin Excel
Hanyar 2: cire sarari tsakanin lambobi
A wasu lokuta, an saita sarari tsakanin lambobi a lambobi. Wannan ba kuskure bane, kawai don fahimtar ra'ayi na manyan lambobi kawai irin wannan rubutun ya fi dacewa. Amma har yanzu, wannan yana da nisa daga kullum karɓa. Alal misali, idan ba a tsara kwayar halitta ba a matsayin tsari na lambobi, ƙari na mai raba shi zai iya tasiri tasiri na ƙididdiga cikin ƙididdiga. Sabili da haka, batun batun cire waɗannan sassan ya zama gaggawa. Wannan aikin za a iya cika ta amfani da kayan aiki ɗaya. "Nemi kuma maye gurbin".
- Zaɓi shafi ko layin da kake so ka cire masu rarraba tsakanin lambobi. Wannan lokacin yana da mahimmanci, domin idan ba a zaba kewayon ba, kayan aiki zai cire dukkan wurare daga takardun, ciki har da tsakanin kalmomi, wato, inda ake bukata. Bugu da ari, kamar yadda a baya, danna maballin "Nemi kuma haskaka" a cikin asalin kayan aiki Ana gyara a kan rubutun a cikin shafin "Gida". A cikin ƙarin menu, zaɓi abu "Sauya".
- Gila yana farawa. "Nemi kuma maye gurbin" a cikin shafin "Sauya". Amma a wannan lokacin zamu ƙara nau'ikan dabi'u daban-daban zuwa filayen. A cikin filin "Nemi" saita wuri daya da filin "Sauya da" mun bar kowa komai. Don tabbatar cewa babu wurare a cikin wannan filin, saita siginan kwamfuta a gare shi kuma ka riƙe ƙasa madauki (a cikin hanyar kibiya) a kan keyboard. Riƙe maɓallin har sai siginan kwamfuta ya shiga gefen hagu na filin. Bayan haka, danna maballin "Sauya Duk".
- Shirin zai aiwatar da aikin cire sararin samaniya tsakanin lambobi. Kamar yadda aka rigaya, don tabbatar da cewa an kammala aikin, muna yin bincike har ma sai sakon ya bayyana cewa ba'a samo darajar da aka so ba.
Za a cire raguwa tsakanin lambobi, kuma za a fara kirga tsarin da daidai.
Hanyar 3: share rabuwar tsakanin lambobi ta hanyar tsarawa
Amma akwai yanayi lokacin da ka ga cewa a kan takardun takarda suna rabu a lambobi ta wurin sararin samaniya, kuma binciken baya bada sakamako. Wannan yana nuna cewa a wannan yanayin an yi rabuwa ta hanyar tsarawa. Wannan zaɓi na sararin samaniya bai shafi tasirin nuni ba, amma a lokaci guda, wasu masu amfani sunyi imani cewa ba tare da shi ba, tebur zai fi kyau. Bari mu dubi yadda za mu cire irin wannan zaɓi na rabuwa.
Tun da an yi sararin samaniya ta hanyar yin amfani da kayan aiki, kawai tare da irin kayan aikin zasu iya cire su.
- Zaži kewayon lambobi tare da rabawa. Danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. A cikin menu da ya bayyana, zaɓi abu "Tsarin tsarin ...".
- Tsarin tsarin ya fara. Jeka shafin "Lambar", idan an bude wannan wuri a wasu wurare. Idan an saita rabuwa ta hanyar tsarawa, to, a cikin sakon layi "Formats Matsala" dole ne a shigar da dole "Numeric". A gefen dama na taga akwai ainihin saitunan wannan tsari. Kusa kusa "Yanki mai raɗaɗɗun kungiya ()" Kuna buƙatar cire shi kawai. Sa'an nan kuma, domin canje-canje don ɗaukar tasiri, danna maballin "Ok".
- Tsarin tsarawa ya rufe, kuma rabuwa tsakanin lambobi na lambobi a cikin zaɓin da aka zaɓa za a cire.
Darasi: Tsarin layi na Excel
Hanyar 4: Cire wuri tare da aikin
Kayan aiki "Nemi kuma maye gurbin" Mai girma don cire karin sarari tsakanin haruffa. Amma idan akwai bukatar a cire su a farkon ko a ƙarshen magana? A wannan yanayin, aikin yana fitowa daga ƙungiyar masu aiki. CUTS.
Wannan aikin yana kawar da duk wurare daga rubutu na zaɓin da aka zaɓa, sai dai don wuri ɗaya tsakanin kalmomi. Wato, yana iya magance matsala tare da wurare a farkon kalma a cikin tantanin halitta, a ƙarshen kalma, kuma don cire sau biyu wurare.
Haɗin aikin wannan afaretan yana da sauki kuma yana da hujja daya kawai:
= TRIMS (rubutu)
A matsayin hujja "Rubutu" zai iya aiki a matsayin magana ta kansa, ko a matsayin ma'anar tantanin halitta wanda yake dauke da ita. Don shari'armu, kawai zaɓin zaɓin karshe za a yi la'akari.
- Zaɓi tantanin halitta wanda yake daidaita da shafi ko jere inda za a cire sarari. Danna maballin "Saka aiki"located a hagu na dabarun bar.
- Wizard na Ɗawainiya ya fara. A cikin rukunin "Jerin jerin jerin sunayen" ko "Rubutu" neman abu "SZHPROBELY". Zaɓi shi kuma danna maballin. "Ok".
- Ƙungiyar shawara ta buɗewa ta buɗe. Abin takaici, wannan aikin ba ya samar da amfani da dukan jigon da muke bukata a matsayin hujja. Sabili da haka, mun sanya siginan kwamfuta a filin jayayyar, sa'an nan kuma zaɓar maɓallin farko na ɗakin da muke aiki. Bayan da adireshin salula ya nuna a fagen, danna kan maballin "Ok".
- Kamar yadda kake gani, an nuna abinda ke cikin tantanin halitta a yankin da aikin yake, amma ba tare da karin wurare ba. Mun cire sararin samaniya don nau'i daya kawai. Don cire su a wasu kwayoyin, kana buƙatar aiwatar da irin waɗannan ayyuka tare da sauran kwayoyin. Hakika, yana yiwuwa a gudanar da wani aiki na dabam tare da kowane tantanin halitta, amma wannan na iya ɗaukar lokaci mai yawa, musamman ma idan kewayon yana da girma. Akwai hanyar da za ta hanzarta sauke tsarin. Saita siginan kwamfuta a cikin kusurwar dama na tantanin halitta, wanda ya riga ya ƙunshi wannan tsari. Mai siginan kwamfuta ya canza zuwa ƙananan giciye. An kira shi alamar cika. Riƙe maɓallin linzamin hagu kuma ja jawo mai cikawa a layi wanda kake son cire wuraren.
- Kamar yadda kake gani, bayan wadannan ayyuka an kafa sabon filin da ke cikin, wanda dukkanin ƙunshiyar maɓallin wuri ke samuwa, amma ba tare da wani karin wuri ba. Yanzu muna fuskantar nauyin maye gurbin dabi'un lambobin asali tare da bayanan da aka canza. Idan muka yi kwafi mai sauƙi, to, za a kofe wannan tsari, wanda ke nufin cewa sakawa zai faru daidai ba. Sabili da haka, muna buƙatar yin kwafi na dabi'u.
Zaži kewayon tare da dabi'u masu juyo. Muna danna maɓallin "Kwafi"located a kan rubutun a cikin shafin "Gida" a cikin ƙungiyar kayan aiki "Rubutun allo". A matsayin madadin, zaka iya rubuta gajeren hanya bayan an zaɓi Ctrl + C.
- Zaɓi maɓallin bayanan asali. Danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. A cikin mahallin menu a cikin toshe "Zaɓuɓɓukan Zaɓuka" zabi abu "Darajar". An nuna shi a matsayin zane-zane na hoto tare da lambobi a ciki.
- Kamar yadda kake gani, bayan ayyukan da aka sama, ana maye gurbin dabi'u tare da karin wurare tare da bayanan data ba tare da su ba. Wato, an gama aiki. Yanzu zaka iya share yankin da ake amfani dasu don canji. Zaži kewayon Kwayoyin dake dauke da wannan tsari CUTS. Mun danna kan shi tare da maɓallin linzamin linzamin dama. A cikin menu da aka kunna, zaɓi abu "Sunny Content".
- Bayan haka, za a cire karin bayanai daga takardar. Idan akwai wasu jeri a cikin tebur wanda ya ƙunshi karin wurare, to, kana bukatar ka ci gaba da su ta hanyar amfani daidai da algorithm kamar yadda aka bayyana a sama.
Darasi: Wizard Function Wizard
Darasi: Yadda za a yi ba da kyauta a Excel
Kamar yadda kake gani, akwai hanyoyi da dama don cire sauri a cikin Excel. Amma dukkan waɗannan zaɓuɓɓuka suna aiwatarwa da kawai kayan aiki guda biyu - windows "Nemi kuma maye gurbin" da kuma afareta CUTS. A cikin akwati dabam, zaka iya amfani da tsarin. Babu wata hanya ta duniya wanda zai fi dacewa don amfani a duk yanayi. A wani hali, zai zama mafi kyau don amfani da wani zaɓi, kuma a na biyu - wani, da dai sauransu. Alal misali, cire kayan sarari tsakanin kalmomi yana iya yiwuwa ta hanyar kayan aiki. "Nemi kuma maye gurbin", amma aikin kawai zai iya cire wuri a fili da farko kuma a ƙarshen tantanin halitta CUTS. Sabili da haka, mai amfani dole ne ya yanke shawara game da aikace-aikacen wani hanya ta musamman, la'akari da halin da ake ciki.
