Yadda ake cire tsari daga tantanin halitta a Excel

Excel yana da ayyuka masu yawa waɗanda za a iya amfani da su don aiwatar da ƙididdiga mafi mahimmanci. Ana amfani da su ta hanyar da aka rubuta a cikin sel. Mai amfani koyaushe yana da damar gyara su, maye gurbin wasu ayyuka ko ƙima.

A matsayinka na mai mulki, adana tsari a cikin tantanin halitta ya dace, amma ba koyaushe ba. A wasu yanayi, ya zama dole don ajiye takarda ba tare da dabara ba. Misali, don hana sauran masu amfani fahimtar yadda aka samu wasu lambobi. 

Dole ne in ce wannan aikin yana da sauƙi. Ya isa ya bi wasu matakai masu sauƙi don kawo shi zuwa rayuwa: A lokaci guda, akwai hanyoyi da yawa, kowannensu ya fi dacewa don amfani a cikin wani yanayi. Bari mu duba su dalla-dalla. 

Hanyar 1: Amfani da Zaɓuɓɓukan Manna

Wannan hanya ita ce mafi sauƙi, ko da mafari zai iya amfani da ita. Kuna buƙatar kawai bin waɗannan matakan:

1. Da farko kuna buƙatar danna maɓallin linzamin kwamfuta na hagu kuma ta hanyar ja zazzage sel ɗin da aikin shine share hanyoyin. To, ko daya. Sannan dannawa daya kawai ya isa.
   

   

2. Sa'an nan ya kamata ka bude mahallin menu kuma nemo abin "Kwafi". Amma sau da yawa ana amfani da haɗin Ctrl + C don cimma wannan burin. Wannan ya fi dacewa da sauri fiye da danna-dama na musamman akan kewayon da ake buƙata, sannan danna kan wani abu. Wannan yana da amfani musamman akan kwamfutar tafi-da-gidanka, inda ake amfani da faifan taɓawa maimakon linzamin kwamfuta.
   

   

3. Har ila yau, akwai hanyar kwafi ta uku, wanda, don dacewa, daidai yake tsakanin biyun da ke sama. Don yin wannan, nemo shafin "Gida", sannan danna maballin da aka haskaka a murabba'in ja.
   

   

4. Bayan haka, muna ƙayyade tantanin halitta inda za a fara bayanan da za a kwafi daga teburin tushe (za su kasance a cikin ɓangaren hagu na sama na kewayon gaba). Bayan haka, muna danna-dama kuma danna kan zaɓin da filin ja ya nuna (maɓallin yana kama da gunki mai lambobi).
   

   

5. A sakamakon haka, irin wannan tebur zai bayyana a cikin sabon wuri, kawai ba tare da tsari ba.
   

   

Hanyar 2: Aiwatar da Manna na Musamman

Rashin lahani na hanyar da ta gabata ita ce ba ta adana tsarin asali na asali. Don rasa wannan ragi, kuna buƙatar amfani da wani zaɓi mai irin wannan suna - "Manna Musamman". Ana yin shi kamar haka:

1. Hakanan, zaɓi kewayon da muke buƙatar kwafi. Bari mu yi amfani da maɓallin kwafi akan kayan aiki a wannan yanayin. Za a riga an yi amfani da dukkan tebur ɗin azaman kewayo, tun da rubutun kan sa yana ɗauke da hadadden tsari wanda muke buƙatar kwafi.
   

   

2. Matakai na gaba suna kama da juna. Kuna buƙatar zuwa tantanin halitta wanda tebur ba tare da tsari zai kasance ba. Ko kuma, a cikin tantanin halitta na hagu na sama, don haka kuna buƙatar tabbatar da cewa babu ƙarin ƙima a wurin tebur na gaba. Danna-dama akan shi kuma sami zaɓi na "Manna Special". Kusa da shi akwai alamar triangle, wanda aka nufa zuwa dama tare da samansa. Idan ka danna shi, wani panel zai bayyana, inda muke buƙatar nemo rukunin "Insert Values" kuma zaɓi maɓallin da aka yi alama da ja a cikin wannan hoton.
   

   

3. Sakamakon shine tebur guda ɗaya wanda ke cikin guntun da aka kwafi, kawai maimakon dabarar, ƙimar uXNUMXbuXNUMXbare an riga an jera su a can.
   

   

Hanyar 3: Share Formula a cikin Tantanin halitta

Rashin lahani na duka hanyoyin da ke sama shine cewa basu samar da ikon kawar da dabarar kai tsaye a cikin tantanin halitta ba. Kuma idan kuna buƙatar yin ƙaramin gyara, dole ne ku kwafi, liƙa tare da wasu sigogi a wani wuri, sannan ku canza wannan tebur ko sel guda ɗaya zuwa matsayinsu na asali. Babu shakka, wannan ba shi da daɗi sosai.

Don haka, bari mu dubi hanyar da za ta ba ka damar goge tsarin kai tsaye a cikin sel. Bi wadannan matakai:

1. Kwafi kewayon da ake buƙata ta amfani da kowane hanyoyin da ke sama. Don bayyanawa, za mu yi maɓallin linzamin kwamfuta na dama kuma zaɓi zaɓin "Copy" a can.
   

   

2. Kama da hanyar da ta gabata, muna buƙatar manna yankin da muka kwafa a baya zuwa sabon wuri. Kuma a lokaci guda bar asalin tsarawa. Na gaba, muna buƙatar manna wannan tebur a ƙasa.
   

   

3. Bayan haka, za mu je saman tantanin halitta na tebur wanda yake asali (ko zaɓi irin wannan kewayon da ke cikin mataki na 1), bayan haka muna kiran menu na mahallin kuma zaɓi saka "Dabi'u".
   

   

4. Bayan ya juya ya zama kwafi kwafin sel ɗin da ake so ba tare da adana tsarin ba, amma tare da ƙimar iri ɗaya, kuna buƙatar share kwafin. Don yin wannan, kuna buƙatar zaɓar kewayon bayanan da kuke son kawar da su, sannan danna-dama akan su kuma danna abun "Share".
   

   

5. Bayan haka, ƙaramin taga zai bayyana wanda yakamata ku zaɓi abu "layi" kuma tabbatar da gogewar ta danna maɓallin "Ok".
   

   

6. Hakanan zaka iya zaɓar wani abu. Misali, ana amfani da “cells, da aka canjawa hagu” don cire wasu adadin sel waɗanda ke gefen hagu, muddin ba a bayyana ƙima a gefen dama ba.

Komai, yanzu muna da tebur iri ɗaya, kawai ba tare da tsari ba. Wannan hanyar tana kama da kwafi da liƙa teburin da aka samu ta hanyar hanya ta biyu zuwa ainihin inda take, amma da ɗan fi dacewa idan aka kwatanta da ita. 

Hanyar 4: Guji yin kwafin zuwa wani wuri kwata-kwata

Wadanne ayyuka ne za ku yi idan babu sha'awar kwafin tebur zuwa wani wuri kwata-kwata? Wannan hanya ce mai wahala. Babban hasaransa shine kurakurai na iya lalata ainihin bayanan. Tabbas, zaku iya dawo da su ta amfani da haɗin Ctrl + Z, amma sake yin su a cikin wannan yanayin zai fi wahala. A gaskiya, hanyar kanta ita ce kamar haka:

1. Muna zaɓar tantanin halitta ko kewayon da muke buƙatar sharewa daga cikin dabarar, sannan mu kwafa su ta amfani da kowane ɗayan hanyoyin da ke sama. Kuna iya zaɓar wanda kuke so mafi kyau. Za mu yi amfani da hanyar da ta ƙunshi amfani da maɓallin da ke kan kayan aiki a cikin Shafin Gida.
   

   

2. Ba mu cire zaɓi daga yankin da aka kwafi ba, kuma a lokaci guda muna danna-dama akansa, sannan zaɓi abu "Dabi'u" a cikin rukunin "Paste Options".
   

   

3. Sakamakon haka, ana shigar da takamaiman ƙima ta atomatik cikin madaidaitan sel.
   

   

4. Idan akwai wasu tsarawa a cikin tantanin halitta, to kuna buƙatar amfani da zaɓin “Manna Special”.

Hanyar 5: Amfani da Macro

Macro ƙaramin shiri ne wanda ke yin wasu ayyuka a cikin takarda don mai amfani. Ana buƙatar idan sau da yawa dole ne ku yi nau'in ayyuka iri ɗaya. Amma ba za ku iya amfani da macros nan da nan ba, saboda yanayin haɓakawa ba a kunna shi ta tsohuwa ba, wanda dole ne a kunna shi kafin ku iya share hanyoyin kai tsaye.

Don yin wannan, aiwatar da jerin ayyuka masu zuwa:

1. Danna "File".
   

   

2. Wani taga zai bayyana wanda a cikin menu na hagu, muna neman abu "Zaɓuɓɓuka" kuma zaɓi shi.
   

   

3. Za a sami wani abu "Cstomize the Ribbon", kuma a gefen dama na taga kuna buƙatar duba akwatin kusa da abu "Mai Haɓakawa".
   

   

Don rubuta macro, bi waɗannan matakan:

1. Bude shafin "Developer", inda za a je zuwa ga Visual Basic edita ta danna maɓallin sunan iri ɗaya.
   

   

2. Na gaba, muna buƙatar zaɓar takarda daidai, sannan danna maɓallin "Duba Code". Zaɓin mafi sauƙi shine danna sau biyu a jere da sauri tare da maɓallin linzamin kwamfuta na hagu akan takardar da ake so. Wannan zai buɗe editan macro.
   

   

Sannan ana shigar da irin wannan lambar a cikin filin edita.

Sub Share_formulas()

Selection.Value = Selection.Value

karshen Sub

Irin waɗannan ƙananan layukan sun juya sun isa sosai don cire dabarun a cikin kewayon da aka zaɓa. Sannan kuna buƙatar zaɓar yankin da muke buƙata kuma danna maɓallin "Macros". Ana iya samunsa kusa da Editan Kayayyakin Kaya. Wani taga don zaɓar fayilolin da aka adana ya bayyana, wanda a ciki kuna buƙatar nemo rubutun da ake so kuma danna "Run".

Bayan danna wannan maɓallin, kowace dabara za a maye gurbinsu ta atomatik da sakamakon. Da alama yana da wahala. A zahiri, waɗannan matakan suna ɗaukar mintuna kaɗan kawai. Amfanin wannan hanyar ita ce, zaku iya ƙirƙirar tsarin da ya fi rikitarwa wanda, alal misali, zai ƙayyade wa kansa waɗanne sel don cire dabarar bisa wasu sharudda. Amma wannan riga aerobatics.

Hanyar 6: Cire duka dabara da sakamakon

Kusan kowane mutum ba dade ko ba dade dole ne ya share ba kawai dabarar ba, har ma da sakamakon. To, wato, ta yadda babu abin da ya rage a cikin tantanin halitta kwata-kwata. Don yin wannan, zaɓi waɗannan sel waɗanda kuke son tsaftacewa, danna-dama akan su kuma zaɓi "Clear contents".

To, ko kawai amfani da baya ko maɓallin del akan madannai. A cikin kalmomi masu sauƙi, ana yin wannan ta hanya ɗaya da share bayanai a cikin kowane tantanin halitta. 

Bayan haka, za a share duk bayanan.

karshe

Kamar yadda kake gani, yana da sauƙi don cire darussan daga sel. Abu mai kyau shi ne cewa akwai hanyoyi da yawa don cimma wannan manufa. Mutum yana da hakkin ya zaɓi duk wanda ya fi dacewa da shi saboda, alal misali, dacewa. Misali, hanyoyi tare da kwafi suna da amfani idan kuna buƙatar saurin jujjuya canje-canje ko sake yin sakamakon ta yadda ainihin bayanin ya kasance. Wannan na iya zama da amfani sosai, alal misali, idan kuna buƙatar tabbatar da cewa takarda ɗaya ta ƙunshi ƙididdiga, ɗayan kuma ya ƙunshi ƙima kawai ba tare da ikon gyara tsarin ba.