Share ƙa'ida a Microsoft Excel

Yin aiki tare da dabaru a cikin Excel yana ba ku damar sauƙaƙewa da sarrafa kansa ƙididdiga masu yawa. Koyaya, ya zama koyaushe wajibi ne cewa sakamakon ya kasance dangane da magana. Misali, lokacin da aka canza dabi'u a sel masu hade, sakamakon data shima zai canza, kuma a wasu halayen wannan ba lallai bane. Bugu da ƙari, lokacin da kake canja wurin teburin da aka kwafa tare da dabarun zuwa wani yanki, ƙimar na iya zama "batattu". Wani dalili don ɓoye su na iya zama yanayi inda ba ku son sauran mutane su ga yadda ake aiwatar da lissafi a cikin tebur. Bari mu gano ta waɗanne hanyoyi zaka iya cire foda a cikin ƙwayoyin, barin kawai sakamakon lissafin.

Tsarin cirewa

Abun takaici, Excel bashi da kayan aiki wanda zai cire kwastomomi ta hanzari daga sel, kuma ya bar kawai dabi'u a wurin. Sabili da haka, dole ne mu nemi wasu hanyoyi masu rikitarwa don magance matsalar.

Hanyar 1: kwafe dabi'u ta hanyar zaɓin liƙa

Kuna iya kwafin bayanai ba tare da dabara zuwa wani yanki ta amfani da zaɓin man ɗin ba.

1. Zaɓi tebur ko kewayon, wanda muke kewaye shi da siginan kwamfuta yayin riƙe maɓallin linzamin kwamfuta na hagu. Tsayawa a cikin shafin "Gida"danna alamar Kwafa, wanda aka sanya a kan tef a cikin toshe Clipboard.



2. Zaɓi tantanin da zai zama babba hagu na tebur da aka saka. Danna shi tare da maɓallin linzamin kwamfuta na dama. Za a kunna menu na mahallin. A toshe Saka Zabi dakatar da zaɓi a "Dabi'u". An gabatar dashi azaman mai hoto tare da lambobi "123".

Bayan kammala wannan hanya, za a shigar da kewayon, amma azaman dabi'u ba tare da tsari ba. Gaskiya ne, Tsarin asali shima za'a rasa. Saboda haka, dole ne sai an shirya tebur da hannu.

Hanyar 2: kwafa tare da manna na musamman

Idan kuna buƙatar adana tsari na ainihi, amma ba ku son ɓata lokaci da sarrafa teburin, to, akwai damar amfani da su "Saka ta musamman".

1. Kwafa su a cikin layi ɗaya kamar na ƙarshe lokacin abinda ke cikin tebur ko kewayo.
2. Zaɓi duk wurin shigarwa ko sashin hagunsa na sama. Mun danna-dama, ta haka muke kiran menu. Cikin jeri dake buɗe, zaɓi "Saka ta musamman". Na gaba, a cikin ƙarin menu, danna maballin "Dabi'u da kuma tsarin tsarawa"wanda aka sanya a cikin rukuni Sanya dabi'u kuma alama ce ta murabba'i mai lamba tare da lambobi da goga.

Bayan wannan aikin, za a kwafa bayanan ba tare da tsari ba, amma za a adana tsari na ainihi.

Hanyar 3: share dabara daga teburin tushen

Kafin wannan, mun yi magana game da yadda za a cire dabara lokacin kwafa, kuma yanzu bari mu nemo yadda za a cire shi daga ragin asali.

1. Muna kwafin teburin ta kowane ɗayan hanyoyin da aka tattauna a sama zuwa yankin mara lahani. Zaɓin wani takamaiman hanya a cikin lamarinmu ba zai rasa matsala ba.
2. Zaɓi kewayon da aka kwafa. Latsa maballin Kwafa a kan tef.



3. Zaɓi kewayon farko. Mun danna shi tare da maɓallin linzamin kwamfuta na dama. A cikin jerin mahallin a cikin rukuni Saka Zabi zaɓi abu "Dabi'u".



4. Bayan an shigar da bayanai, zaku iya share kewayon juyawa. Zaba shi. Muna kiran menu na mahallin ta danna maɓallin linzamin kwamfuta na dama. Zaɓi abu a ciki "Share ...".



5. Wani karamin taga yana buɗewa wanda kuke buƙatar kafa abin da daidai yake buƙatar cirewa. A cikin halinmu na musamman, kewayon wucewa yana kusa da teburin tushen, saboda haka muna buƙatar share layuka. Amma idan ya kasance a gefen shi, to ya kamata a share ginshiƙan, yana da matukar muhimmanci kada a haɗasu, tunda ana iya lalata babban tebur. Don haka, mun saita saitin cirewa kuma danna maballin "Ok".

Bayan aiwatar da waɗannan matakan, za a share duk abubuwan da ba dole ba, kuma dabarun daga teburin asali za su shuɗe.

Hanyar 4: share dabarun ba tare da ƙirƙirar kewayawa ba

Kuna iya sauƙaƙe shi mafi sauƙi kuma ba ƙirƙirar kewayon jigilar kaya kwata-kwata. Gaskiya ne, a wannan yanayin, kuna buƙatar yin aiki musamman a hankali, saboda duk ayyukan za a yi a cikin teburin, wanda ke nufin cewa duk wani kuskure na iya keta amincin bayanan.

1. Zaɓi hanyar da kake so ka share dabaru. Latsa maballin Kwafasanya a kan kintinkiri ko buga maɓallan ma onallan akan keyboard Ctrl + C. Wadannan ayyuka daidai suke.



2. Bayan haka, ba tare da cire zaɓi ba, danna-dama. An ƙaddamar da menu na mahallin. A toshe Saka Zabi danna alamar "Dabi'u".

Don haka, duk bayanan za a kwafa kuma za a buga su nan da nan azaman ƙimar. Bayan waɗannan ayyukan, dabarun a yankin da aka zaɓa ba zai kasance ba.

Hanyar 5: amfani da macro

Hakanan zaka iya amfani da macros don cire tsari daga sel. Amma saboda wannan kuna buƙatar fara kunna shafin haɓakawa, kuma ku kunna macros kansu idan basu da aiki. Yadda za a yi wannan za a iya samunsa a wani take daban. Zamu yi magana kai tsaye game da ƙara da amfani da Macro don cire tsari.

1. Je zuwa shafin "Mai Haɓakawa". Latsa maballin "Kayayyakin aikin Kayan gani"sanya a kan kintinkiri a cikin akwatin kayan aiki "Lambar".



2. Edita mai macro ya fara. Manna wannan lambar a cikin:

   
Sub Tsarin Gaske Share ()
Zabi.Value = Zabi.Value
Are ƙarshen

   Bayan haka, rufe taga edita a cikin daidaitaccen hanyar ta danna maɓallin a cikin kusurwar dama ta sama.



3. Mun koma kan takarda wanda teburin ban sha'awa yake. Zaɓi guntuƙin inda aka share dabarun da za'a share su. A cikin shafin "Mai Haɓakawa" danna maballin Macrossanya a kan tef a cikin rukuni "Lambar".



4. Taga taga Macro. Muna neman abun da ake kira Rashin Tsarin Gaskiya, zaɓi shi kuma danna maballin Gudu.

Bayan wannan matakin, duk dabarun da aka zaɓa a yankin da aka zaɓa za a share su, kuma sakamakon ƙididdigar zai ragu.

Darasi: Yadda za a kunna ko kashe macros a cikin Excel

Darasi: Yadda ake ƙirƙirar macro a cikin Excel

Hanyar 6: Share dabara tare da sakamako

Koyaya, akwai wasu lokuta waɗanda kuke buƙatar cirewa ba kawai dabara ba, har ma da sakamako. Sanya sauki.

1. Zaɓi kewayon da aka sanya dabarun. Danna dama. A cikin menu na mahallin, dakatar da zaɓi akan abu Share Abun ciki. Idan baku son kiran sama menu, zaku iya danna maɓallin bayan zaɓi Share a kan keyboard.



2. Bayan waɗannan matakan, za a share duk abubuwan da ke cikin sel, gami da tsari da dabi'u.

Kamar yadda kake gani, akwai hanyoyi da yawa waɗanda zaka iya share dabarun tsari, duka lokacin kwafa bayanai, kuma kai tsaye a cikin tebur kanta. Gaskiya ne, kayan aikin Excel na yau da kullun, wanda zai cire magana ta atomatik tare da dannawa ɗaya, da rashin alheri, ba a wanzu ba tukuna. Ta wannan hanyar, zaka iya share dabarun kawai tare da dabi'u. Sabili da haka, dole ne kuyi aiki a cikin maye ta hanyar zaɓin abun ciki ko amfani da macros.