Ana cire kyawawan dabi'u a Microsoft Excel

Lokacin amfani da dabarbayoyi a cikin Excel, idan ƙwayoyin da aka ambata ta hanyar sabis ɗin babu komai, zeros zai bayyana a cikin lissafin yanki ta asali. Aesthetically, wannan baiyi kyau sosai ba, musamman idan teburin yana da madaidaitan jeri iri ɗaya tare da ƙimar sifili. Kuma zai fi wahala ga mai amfani ya yi amfani da bayanai idan aka kwatanta da halin da ake ciki idan irin wadannan wuraren zasu zama fanko. Bari mu gano cikin waɗanne hanyoyi zaka iya cire nuni na ƙarar bayanai a cikin Excel.

Zero Cire Algorithms

Excel yana ba da ikon cire zeros a sel a hanyoyi da yawa. Ana iya yin wannan duka ta amfani da ayyuka na musamman da kuma tsara tsari. Hakanan yana yiwuwa a kashe bayyanar irin waɗannan bayanan gaba ɗaya akan takardar.

Hanyar 1: Saitunan Excel

A duniya, ana iya warware wannan batun ta hanyar sauya saitunan Excel don takaddun na yanzu. Wannan yana ba ku damar yin cikakken ƙwayoyin sel dauke da zeros fanko.

1. Kasancewa a cikin shafin Fayilolije zuwa sashen "Zaɓuɓɓuka".



2. A cikin taga wanda zai fara, matsa zuwa sashin "Ci gaba". A ɓangaren dama na taga muna neman katangar saiti "Nuna zaɓuɓɓuka don takardar gaba". Cire akwatin a kusa da "Nuna zeros a sel wadanda suke da dabi'u mara kyau". Don kawo canjin saiti a cikin aiki kar a manta danna maballin "Ok" a kasan taga.

Bayan waɗannan ayyuka, duk sel na yanzu takardar da ke ɗauke da dabi'un ba za a nuna su fanko ba.

Hanyar 2: tsara tsari

Kuna iya ɓoye dabi'un sel marasa komai ta hanyar sauya yadda suke.

1. Zaɓi kewayon da kake so ka ɓoye sel tare da dabi'un ƙira. Mun danna kan guntun da aka zaɓa tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu, zaɓi "Tsarin kwayar halitta ...".



2. Ana ƙaddamar da taga tsarawa. Matsa zuwa shafin "Lambar". Dole a saita sauya mai lamba zuwa "Duk fayiloli". A hannun dama na taga a filin "Nau'in" shigar da wannan magana:

   0;-0;;@

   Don adana canje canje, danna maɓallin "Ok".

Yanzu duk wuraren da suke ɗauke da dabi'u marasa amfani zasu zama fanko.

Darasi: Tsarin tebur a cikin Excel

Hanyar 3: Tsarin sharadi

Hakanan zaka iya amfani da wannan kayan aiki mai ƙarfi azaman tsari mai mahimmanci don cire ƙarin zeros.

1. Zaɓi kewayon da za'a iya amfani da ƙimar sifili. Kasancewa a cikin shafin "Gida"danna maballin akan kintinkiri Tsarin Yanayiwanda yake a cikin shinge na saiti Salo. A cikin menu wanda yake buɗe, shiga cikin abubuwan Dokokin Zabi na Cell da "Daidaita".



2. Tsarin tsarawa yana buɗe. A fagen "Tsarin sel waɗanda suke daidai" shigar da darajar "0". A cikin madaidaicin filin a cikin jerin abubuwan da aka saukar, danna kan abun "Tsarin al'ada ...".



3. Wani taga ya bude. Je zuwa shafin a ciki Harafi. Danna jerin jerin abubuwan da aka saukar "Launi"wanda muke zaɓi launin fari da danna maballin "Ok".



4. Komawa window ɗin da aka tsara, kuma danna maɓallin "Ok".

Yanzu, idan har darajar ta kwayar halitta ba komai bane, to ba zai zama mai ganuwa ga mai amfani ba, tunda launin font ɗin zai haɗu da launi na bango.

Darasi: Tsarin yanayi a cikin Excel

Hanyar 4: amfani da aikin IF

Wani zabin don ɓoye zeros ya ƙunshi amfani da ma'aikaci IF.

1. Mun zaɓi sel na farko daga kewayon inda aka nuna sakamakon lissafin, kuma inda zeros zai yiwu. Danna alamar "Saka aikin".



2. Ya fara Mayan fasalin. Muna bincika jerin ayyukan ayyukan da aka gabatar IF. Bayan an zaɓi shi, danna maballin "Ok".



3. Ana kunna taga mai aiki na mai aiki. A fagen Bayani mai ma'ana shigar da dabara wanda ya lissafa a cikin kwayar manufa. Sakamakon yin lissafin wannan dabara ne wanda a ƙarshe zai iya ba da sifili. Ga kowane takamaiman yanayi, wannan magana zata sha bamban. Nan da nan bayan wannan dabara, a cikin filin guda, ƙara magana "=0" ba tare da ambato ba. A fagen "Ma'ana idan gaskiya ne" saka sarari - " ". A fagen "Ma'ana idan karya" muna maimaita tsarin sake, amma ba tare da nuna magana ba "=0". Bayan an shigar da bayanai, danna maballin "Ok".



4. Amma wannan yanayin ya zuwa yanzu ya shafi sel ɗaya kawai cikin kewayon. Don kwafar dabarar zuwa wasu abubuwan, sanya siginan kwamfuta a cikin kusurwar dama ta sel. Ana kunna alamar cikawa a cikin nau'i na gicciye. Riƙe maɓallin linzamin kwamfuta na hagu ka ja siginar lamba akan duk kewayon da ya kamata a canza.



5. Bayan haka, a cikin waɗancan sel waɗanda sakamakon lissafin zai zama sifili, maimakon lambar "0" za'a sami sarari.

Af, idan a cikin muhawara taga a fagen "Ma'ana idan gaskiya ne" saita datsa, sannan lokacin fitar da sakamako a cikin sel tare da kimar sifili to babu wani sarari, sai dai wani dash.

Darasi: Aikin 'IF' a cikin Excel

Hanyar 5: amfani da aikin NUMBER

Hanyar da ta biyo baya itace nau'in haɗakar ayyuka. IF da NUMBER.

1. Kamar yadda ya gabata a cikin kwatancen baya, buɗe taga alamun muhawara na aikin IF a cikin tantanin farko na kewayon da aka sarrafa. A fagen Bayani mai ma'ana rubuta aiki NUMBER. Wannan aikin yana nuna ko wani kashi yana cike da bayanai ko a'a. Sannan a cikin filin guda muna buɗe kwarjinin kuma shigar da adireshin tantanin, wanda, idan fanko ne, na iya sa ɓoɓin ɓoyayyun sashin sifiri. Muna rufe baka. Wannan shine, a zahiri, mai aiki NUMBER zai bincika idan akwai wasu bayanai a cikin yankin da aka ƙayyade. Idan sun kasance, to aikin zai dawo da darajar "GASKIYA"in ba haka ba, to - KARYA.

   Kuma a nan ne dabi'u na muhawara biyu masu zuwa na mai aiki IF mu sake shirya. Wato, a cikin filin "Ma'ana idan gaskiya ne" nuna ƙididdigar lissafin, da cikin filin "Ma'ana idan karya" saka sarari - " ".

   Bayan an shigar da bayanai, danna maballin "Ok".



2. Kamar yadda yake a hanyar da ta gabata, kwafa dabarar zuwa ragowar kewayon ta amfani da alamar alamar. Bayan haka, ƙimar zirin za ta shuɗe daga yankin da aka ƙayyade.

Darasi: Wizard ɗin Aiki a cikin Excel

Akwai hanyoyi da yawa don cire lambar ta “0” a cikin tantanin idan yana da kimar komai. Hanya mafi sauki ita ce a kashe nuni na zeros a cikin saitunan Excel. Amma to ya kamata a ɗauka a hankali cewa za su ɓace ko'ina cikin takardar. Idan kuna buƙatar amfani da rufewar takamaiman ga takamaiman yanki, to a wannan yanayin tsarin jeri, tsarin yanayi da aikace-aikacen ayyuka zasu zo ga ceto. Wanne daga cikin waɗannan hanyoyin zaɓa ya dogara da takamaiman halin da ake ciki, kazalika da kwarewar mutum da kuma abubuwan da ake so.