Yadda za a ware lambobi a Faith

Hanyar 1: Mai saurin halaye

Areo Excel, akwai maballin biyu na duniya waɗanda ke ba ku damar warware haruffa, hawa ko saukowa, idan muna magana ne game da lambobi. Suna amfani da hanya mafi sauƙi idan akwai tebur da aka shirya don abin da ake yin rarrabewa. Yi la'akari da cewa lokacin da ke ƙara sabon ƙimar, an rushe rarraba nau'in, kuma don hana irin wannan yanayin, ya zama dole don sake farawa ko amfani da hanyar 3 na wannan labarin.

1. Da farko, riƙe maɓallin linzamin kwamfuta na hagu kuma zaɓi duk dabi'un da kake son rarrabe cikin tsari.



2. A shafin gida, fadada sashe na gyara kuma zaɓi kayan aiki ".



3. A ciki, zaku ga nau'ikan rarrabuwa iri biyu - Dangane da haka, a cikin lamarin da ke cikin la'akari da shi zai ɗauka don zaɓar "rarrabuwar hankali".



4. Idan teburin ya ƙunshi wasu bayanai a waje da kewayon da aka ƙayyade, sanarwa zai bayyana tare da tsari don faɗaɗa dangi da aka zaɓa a cikin sel da aka zaɓa.



5. Idan ka zaɓi faɗadar kewayo, za ku ga cewa duk bayanan da aka tsara don nuna dangi don tsara dabi'u. Zaka iya soke canje-canje ta latsa maɓallin mai zafi + Z.



6. Nau'in nau'ikan yanayi, wanda ya shafi kawai iyakokin zaɓi da aka ƙayyade, ya shafi kawai ga layin da aka zaɓa kuma baya tasiri ga maƙwabta.

Hanyar 2: Gyara rarrabuwa

Gudanar da tsari ya dace yayin aiki tare da dabi'u da yawa a cikin tebur, lokacin da ya zama dole ba wai kawai don tsara jere ɗaya ba ko wasu nau'ikan da aka gabatar a Excel. Babban aiwatar da tsari lokacin amfani da wannan kayan aikin yana daɗaɗawa.

1. A cikin wannan sashin "Gwaji", danna maɓallin "Comment Sulle".



2. A da, mun riga mun yi magana game da bayyanar sanarwar lokacin da aka gano bayanai a waje da kafuwar bangarori. Duba bayanin da aka karɓa da yanke shawara wane zaɓi don murnar mai alamar.



3. A cikin menu na farko na digo biyu, zaɓi shafin nau'in da ƙayyadaddun ƙayyadaddun.



4. Don "oda" siga, saita darajar "hawa".



5. Idan kana son irin wasu ginshiƙai, da hannu ƙara sabon matakin kuma bi wannan ayyuka.



6. Koma kan tebur ka tabbatar cewa aikin yayi nasara.

Hanyar 3: Tsarin rarrabewa

A ƙarshe, zamu bincika mafi yawan hadadden, amma hanya mai sassauci wanda zai kwatanta dabi'un a cikin tebur da fitarwa akan sabbin ƙwayoyin ke hawa. Amfanin wannan hanyar kafin sauran ya ta'allaka ne cewa dabara tana fadada ta atomatik lokacin da kara sabon dabi'u zuwa teburin, wanda ke nufin cewa rarrabuwar kawunansu na faruwa.

1. Kunna kwayar farko don dabara kuma shigar = ƙarami. Wannan shine babban aikin da ke lissafta ta atomatik ƙimar ƙimar.



2. A cikin brackets, shigar da furcin (a: A; Row (A1), inda aka maye gurbin da lambar farko a matsayin A1.



3. Duk da haka wannan tsari zuwa ƙarshen tebur don ƙarshen lambar da aka nuna a cikin kowane sel.



4. Idan ka zaɓi kowane sel daga jerin sunayen da aka kirkira, za ka ga cewa abinda ke cikin tsari ta hanyar canjewa ta atomatik. Wannan shine babban fasalin irin wannan shimfiɗa mai gamsuwa.