Wataƙila, masu amfani da dama ba su da kwarewa sun yi ƙoƙari su kwafe wasu bayanai a Excel, amma saboda sakamakon su, fitarwa ta samar da wata maɓamata ta daban ko kuskure. Wannan shi ne saboda gaskiyar cewa wannan tsari ya kasance a cikin kundin firamare na farko, kuma wannan ƙira ce da aka saka, kuma ba ta da darajar ba. Irin wannan matsalolin ana iya kaucewa idan waɗannan masu amfani sun saba da wannan ma'anar "Manna Musamman". Tare da shi, zaku iya yin wasu ayyuka masu yawa, ciki har da lissafi. Bari mu ga abin da wannan kayan aiki yake da yadda zamuyi aiki tare da shi.
Yi aiki tare da saitin musamman
Ana ƙaddamar da Musamman ɗin Musamman ne don saka wani bayani a kan takardar Excel kamar yadda mai amfani yake bukata. Yin amfani da wannan kayan aiki, zaka iya sanya ba duk kwafin bayanai a cikin tantanin halitta ba, amma dukiya kawai (dabi'u, tsari, tsari, da dai sauransu). Bugu da ƙari, ta yin amfani da kayan aiki, zaka iya yin aiki na asali (ƙari, haɓakawa, raguwa da rabuwa), kazalika da shimfiɗa teburin, wato, swap layuka da ginshiƙai a ciki.
Don zuwa jerin saiti na musamman, da farko, kana buƙatar yin wani aiki akan kwashe.
- Zaɓi tantanin halitta ko kewayon da kake so ka kwafi. Zaɓi shi tare da siginan kwamfuta yayin riƙe da maballin hagu na hagu. Danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. An kunna menu na mahallin, wanda kake buƙatar zaɓar abu "Kwafi".
Har ila yau, a maimakon hanyar da aka sama, za ka iya, zama a cikin shafin "Gida", danna kan gunkin "Kwafi"wanda aka sanya a kan tef a cikin rukuni "Rubutun allo".
Zaka iya kwafi wata magana ta zabi da shi kuma rubuta haɗin maɓallan zafi Ctrl + C.
- Don tafiya kai tsaye zuwa hanyar, zaɓi yankin a kan takardar inda muke shirya shirya manne abubuwan da aka kwashe. Danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. A cikin shirin da aka kaddamar menu, zaɓi matsayi "Musamman saka ...". Bayan wannan, ƙarin lissafi zai buɗe inda zaka iya zaɓar nau'ukan daban-daban, zuwa kashi uku:
- Saka (Manna, Juyawa, Formulas, Formulas da Formats Formats, Borderless, Save Original ginshiƙai Width, kuma Ajiye Original Tsarin);
- Saka bayanai ("Darajan darajar da asali", "Ƙimar" da kuma "Ƙimar da kuma samfuran lambobi");
- Sauran zabin zaɓuɓɓuka ("Tsarin", "Hoto", "Saka Hanya" da "Hoton da aka Haɗa").
Kamar yadda kake gani, kayan aiki na rukuni na farko kofe da maganganun da ke cikin tantanin halitta ko kewayon. Ƙungiyar na biyu an yi nufi, da farko, don kwafin dabi'u, ba ƙari ba. Ƙungiyar ta uku ta sa tsarin canja wuri da bayyanar.
- Bugu da ƙari, a cikin ƙarin ƙarin menu akwai wani abu wanda yake da sunan ɗaya - "Musamman saka ...".
- Idan kayi tafiya ta hanyarsa, madaurar rami yana buɗe tare da kayan aikin da suka kasu kashi biyu: Manna kuma "Aikin". Hakanan, godiya ga kayan aiki na rukuni na ƙarshe, yana yiwuwa a aiwatar da ayyukan lissafi, waɗanda aka tattauna a sama. Bugu da ƙari, a cikin wannan taga akwai abubuwa biyu waɗanda ba'a haɗa su cikin kungiyoyi dabam dabam ba: "Tsaya kullun jaka" kuma "Juyawa".
- Za a iya samun nauyin musamman ba kawai ta hanyar mahallin mahallin ba, amma kuma ta hanyar kayan aiki a kan kintinkiri. Don yin wannan, zama a cikin shafin "Gida", danna kan gunkin a cikin nau'i mai maƙalli mai nuna ƙasa, wadda take ƙarƙashin maɓallin Manna a cikin rukuni "Rubutun allo". Sa'an nan kuma an buɗe jerin abubuwan da za a iya aiki, ciki har da sauyawa zuwa wata taga dabam.
Hanyar 1: Ayyuka tare da Darajoji
Idan kana buƙatar canja wurin dabi'u na sel, wanda aka samo sakamakonsa ta amfani da tsari na lissafi, to, an sanya saitin musamman don kawai irin wannan hali. Idan ka yi amfani da kwaskwarima ta al'ada, za a kwafi wannan maƙala, kuma adadin da aka nuna a ciki bazai zama abin da kake buƙata ba.
- Domin yin kwafin dabi'un, zaɓi fili wanda ya ƙunshi sakamakon sakamakon lissafi. Rubuta shi a kowane irin hanyoyin da muka yi magana game da sama: menu na mahallin, maballin kan rubutun kalmomi, haɗuwa da maɓallin hotuna.
- Zaɓi yankin a kan takardar inda muka shirya saka bayanai. Je zuwa menu a cikin ɗayan hanyoyi, waɗanda aka tattauna a sama. A cikin toshe "Saka bayanai" zabi matsayi "Darajoji da kuma Nau'in Lambobi". Wannan abu yafi dacewa a wannan halin.
Haka hanya za a iya yi ta hanyar taga da muka bayyana a baya. A wannan yanayin, a cikin toshe Manna canza zuwa matsayi "Darajoji da kuma Nau'in Lambobi" kuma danna maballin "Ok".
- Kowace zaɓin da ka zaɓa, za a sauke bayanan zuwa zaɓin da aka zaba. Za a nuna shi daidai sakamakon ba tare da canja wuri ba.
Darasi: Yadda za a cire wannan tsari a Excel
Hanyar 2: Kwafi Formulas
Amma akwai kuma halin da ke faruwa a lokacin da ya wajaba don kwafin dabarar.
- A wannan yanayin, muna aiwatar da tsarin yin kwafi a kowace hanyar da ta dace.
- Bayan wannan, zaɓi yankin a kan takardar inda kake son sanya tebur ko wasu bayanai. Kunna menu mahallin kuma zaɓi abu "Formulas". A wannan yanayin, za a saka nau'o'i da dabi'un kawai (a cikin waɗannan sassan inda babu takaddama), amma tsarawa da daidaitawa na samfurin lissafi zasu rasa. Saboda haka, alal misali, idan kwanan wata ya kasance a wuri mai tushe, to, bayan kwashe shi za a nuna kuskure. Kwayoyin dacewa za su buƙaci a kara tsara su.
A cikin taga, wannan aikin ya dace da motsi canjin zuwa matsayin "Formulas".
Amma yana yiwuwa a sauya takardu tare da adana tsarin lambobi ko ma tare da cikakken adana tsarin tsarawa.
- A cikin akwati na farko, cikin menu, zaɓi matsayi Formulas da Formats Formats.
Idan an yi aiki ta hanyar taga, to, a wannan yanayin kana buƙatar motsa canjin zuwa Formulas da Formats Formats sannan danna maballin "Ok".
- A cikin akwati na biyu, lokacin da kake buƙatar ajiyewa ba kawai tsari da lambobi ba, amma kuma cikakken tsari, zaɓi abu a cikin menu "Ajiye Asali Tsarin".
Idan mai amfani ya yanke shawarar yin wannan aiki ta hanyar zuwa zuwa taga, to, a wannan yanayin kana buƙatar motsa canjin zuwa matsayi "Tare da ainihin taken" kuma danna maballin "Ok".
Hanyar 3: Canjin wuri
Idan mai amfani ba ya buƙatar canja wurin bayanai, kuma yana so ya kwafi tebur domin ya cika shi da cikakken bayani, sa'an nan kuma a wannan yanayin zaka iya amfani da wani abu na musamman saka.
- Kwafi maɓallin tushe.
- A takardar, zaɓi wuri inda muke so mu saka layout na tebur. Kira menu na mahallin. A ciki a cikin sashe "Sauran Saka Zaɓuka" zabi abu "Tsarin".
Idan anyi hanya ta hanyar taga, to, a wannan yanayin, motsa canjin zuwa matsayi "Formats" kuma danna maballin "Ok".
- Kamar yadda kake gani, bayan wadannan ayyukan akwai canja wurin shimfida maɓallin tashar tare da tsaraccen tsari, amma bai cika da bayanai ba.
Hanyar 4: Kwafi tebur yayin rike da girman ginshiƙan
Ba wani asiri ba ne idan idan muka yi sauƙi a kan teburin, ba gaskiya ba cewa dukkanin sel na sabon launi zasu iya ɗaukar dukkanin bayanan a cikin asusun. Don gyara wannan yanayin yayin yin kwafi, zaka iya amfani da saiti na musamman.
- Na farko, ta hanyar kowane hanyoyin da aka sama, kwafe maɓallin tushe.
- Bayan ƙaddamar da menu wanda ya saba da mu, za mu zabi darajar "Ajiye nisa daga ginshiƙan asali".
Za'a iya yin irin wannan hanya ta hanyar daɗa ta musamman. Don yin wannan, sake sake canzawa zuwa matsayin "Gurbin ginshiƙin". Bayan haka, kamar yadda kullum, danna maballin. "Ok".
- An saka tebur tare da nuni na asali.
Hanyar 5: Saka Hoton
Mun gode wa iyawa na musamman, za ka iya kwafa duk bayanan da aka nuna akan takardar, ciki har da tebur, azaman hoto.
- Kwafi abu ta amfani da kayan aiki na kwarai.
- Zaɓi wuri a kan takardar inda aka sanya zane. Kira menu. Zaɓi abu a ciki "Zane" ko "Shafin zane". A cikin akwati na farko, ba a haɗa hoto da aka sanya ba tare da maɓallin tushe. A cikin akwati na biyu, idan kun canza dabi'u a cikin tebur, zane zane za'a sabunta ta atomatik.
A cikin musamman saka taga, irin wannan aiki baza a iya yi ba.
Hanyar 6: Kwafi Bayanan kula
Ta hanyar saiti na musamman, zaka iya sauke bayanan rubutu.
- Zaɓi sel wanda ya ƙunshi bayanin kula. Muna yin kwafin su ta hanyar mahallin mahallin, ta amfani da maballin kan rubutun ko ta latsa haɗin haɗin Ctrl + C.
- Zaɓi sassan da za'a saka rubutu. Je zuwa na musamman saka taga.
- A cikin taga wanda ya buɗe, sake shirya canzawa zuwa matsayin "Bayanan kula". Muna danna maɓallin "Ok".
- Bayan haka, za a kwashe bayanan da aka zaɓa a cikin sassan da aka zaɓa, kuma sauran bayanan za su kasance ba su canza ba.
Hanyar 7: Sauka tebur
Amfani da saitin na musamman, zaka iya canza Tables, matrices, da sauran abubuwa waɗanda kake son swap ginshiƙai da layuka.
- Zaɓi teburin da kake son gyarawa, da kwafe shi ta amfani da ɗaya daga cikin hanyoyin da muka riga muka sani.
- Zaɓi a kan takardar kewayon inda kake tsara don sanya saitin inverted na tebur. Kunna menu mahallin kuma zaɓi abu a ciki. "Juyawa".
Wannan aikin kuma za a iya yi ta amfani da taga mai mahimmanci. A wannan yanayin, akwai buƙatar ka laka akwatin "Juyawa" kuma danna maballin "Ok".
- Kuma a gaskiya, kuma a wani hali, kayan aiki zai zama teburin da ba a taɓa shi ba, wato, teburin wanda ginshiƙai da layuka suna swapped.
Darasi: Yadda za a sauya tebur a Excel
Hanyar 8: Amfani da lissafi
Yin amfani da kayan aikin da aka bayyana ta mu a cikin Excel, zaku iya aiwatar da ayyukan hadewa na yau da kullum:
- Ƙari;
- Girma;
- Ragu;
- Division
Bari mu ga irin yadda ake amfani da wannan kayan aiki akan misalin yawancin.
- Da farko, zamu shiga cikin wayar maras kyau wanda aka tsara ta hanyar da muke tsara don ninka yawan bayanai tare da saitin musamman. Na gaba, mun kwafe shi. Ana iya yin wannan ta latsa maɓallin haɗin Ctrl + C, ta hanyar kiran mahallin mahallin ko amfani da damar kayan aiki don yin kwafi akan tef.
- Zaži kewayon kan takardar, wanda dole mu ninka. Danna maɓallin zaɓi tare da maɓallin linzamin linzamin dama. A cikin menu mahallin bude, danna sau biyu a kan abubuwa. "Musamman saka ...".
- An kunna taga. A cikin rukuni na sigogi "Aikin" saita canzawa zuwa matsayi "Karu". Kusa, danna maballin "Ok".
- Kamar yadda ka gani, bayan wannan aikin dukkanin dabi'u na zaɓin da aka zaɓa ya karu ta lambar da aka kwafi. A cikin yanayinmu, wannan lambar 10.
Hakanan za'a iya amfani da wannan ka'idar don rabuwa, karawa da ragu. Sai kawai don wannan, window zai buƙaci sake shirya fasalin, daidai da, a matsayi Raba, "Fold" ko "Rage". In ba haka ba, duk ayyukan suna kama da manipulations da aka bayyana.
Kamar yadda kake gani, zabin na musamman shine kayan amfani mai amfani don mai amfani. Tare da shi, ba za ka iya kwafin ƙwaƙwalwar bayanan ba kawai a cikin tantanin halitta ko a cikin kewayon, amma ta rarraba su cikin layi daban-daban (dabi'u, tsari, tsarawa, da dai sauransu). Bugu da ƙari, yana yiwuwa a haɗa waɗannan yadudduka da juna. Bugu da ƙari, za a iya yin aiki na lissafi ta amfani da kayan aiki ɗaya. Tabbas, sayen kwarewa don aiki tare da wannan fasaha zai taimaka masu amfani a hanya don sarrafa Excel gaba ɗaya.
