Duk wani mai amfani da ke aiki a Excel ko ba dade ko ba jima, ya ci karo da yanayin da abin da ke cikin tantanin halitta bai dace da kan iyakokinta ba. A wannan yanayin, akwai hanyoyi da yawa daga wannan halin: rage girman abun ciki; ku fahimci yanayin da ake ciki; fadada fadin sel; fadada tsayin su. Kawai game da zaɓi na ƙarshe, wato game da daidaita daidaitaccen layin, zamuyi magana gaba.
Zaɓin atomatik
AutoSize shine kayan haɓaka kayan haɓaka Excel wanda ke taimaka muku fadada sel ta hanyar abun ciki. Ya kamata a lura da kyau cewa, duk da suna, ba a amfani da wannan aikin ta atomatik. Domin fadada takamaiman kashi, kuna buƙatar zaɓi kewayon kuma amfani da kayan aikin da aka ƙayyade akan shi.
Bugu da kari, dole ne a faɗi cewa an daidaita daidaitaccen tsayi ta atomatik a cikin Excel kawai don waɗancan ƙwayoyin waɗanda wane salatin magana aka kunna a tsara. Don ba da damar mallakar wannan mallakar, zaɓi tantanin ko zaɓi akan takardar. Danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama. A cikin jerin mahallin da aka ƙaddamar, zaɓi matsayin "Tsarin kwayar halitta ...".
Ana kunna taga tsarawa. Je zuwa shafin Jeri. A cikin toshe saitin "Nuna" duba kwalin kusa da sigogi Kunshin Magana. Don adanawa da aiwatar da canje-canje na saiti a saitunan, danna maballin "Ok"wacce take a kasan wannan taga.
Yanzu an kunna kundin kalma akan zaɓin yanki na takardar, kuma zaku iya amfani da tsayin layin atomatik akansa. Bari muyi la’akari da yadda ake yin hakan ta hanyoyi daban-daban ta amfani da misalin na Excel 2010. Koyaya, yakamata a lura cewa anyi amfani da irin wannan tsari gaba ɗayan nau'ikan shirin kuma ga Excel 2007.
Hanyar 1: Gudanar da Kwamitin
Hanya ta farko ta ƙunshi aiki tare da kwamiti mai daidaituwa a tsaye wanda lambobin layin tebur ke zaune.
- Danna lambar wannan layin akan kwamiti mai haɗin gwiwar wanda kake son amfani da tsayin daka. Bayan wannan matakin, za a fifita layin gaba daya.
- Mun isa zuwa kan iyakar ƙananan layin a cikin ɓangaren kwamitin daidaitawa. Maƙallin ya kamata ya ɗauki siffar kibiya da ke nunawa ta fuskoki biyu. Danna maɓallin linzamin kwamfuta na hagu.
- Bayan waɗannan ayyuka, lokacin da nisa ba a canzawa, tsayin layin zai haɗu ta atomatik gwargwadon buƙata don duk rubutun a cikin ƙwayoyinsa duka suna iya gani akan takardar.
Hanyar 2: kunna dacewa-dace don layuka da yawa
Hanyar da ke sama tana da kyau lokacin da kuke buƙatar kunna daidaitaccen dacewa don layi ɗaya ko biyu, amma menene idan akwai abubuwa da yawa masu kama? Bayan haka, idan kunyi aiki akan algorithm ɗin da aka bayyana a farkon asalin, to hanya zata kasance ku ɓata lokaci mai yawa. A wannan yanayin, akwai hanyar fita.
- A kan kwamiti na hadin kai, zabi dukkan layin da kake son hada aikin da aka ayyana. Don yin wannan, riƙe maɓallin linzamin kwamfuta na hagu kuma motsa siginan kwamfuta a kan sashi mai dacewa na kwamitin daidaitawa.
Idan kewayon suna da girma sosai, to danna-hagu a kan sashin farko, to sai ka riƙe maɓallin Canji a kan maballin keyboard ka danna satin karshe na kwamitin hadin gwiwar yankin da ake so. A wannan yanayin, duk layinsa za a fifita.
- Sanya siginan kwamfuta a kan iyakar ƙasan kowane ɓangarorin da aka zaɓa a kan kwamitin daidaitawa. A wannan yanayin, siginan kwamfuta ya kamata ya ɗauka daidai daidai lokacin karshe. Danna maɓallin linzamin kwamfuta na hagu.
- Bayan aiwatar da aikin da ke sama, duk layuka na zaɓin da aka zaɓa za a ƙara girma a tsayi ta girman bayanan da aka adana a cikin sel.
Darasi: Yadda za a zabi sel a Excel
Hanyar 3: maɓallin kintinkiri na kayan aiki
Bugu da ƙari, don kunna zaɓin auto ta hanyar tsayin sel, zaka iya amfani da kayan aiki na musamman akan tef.
- Zaɓi kewayon a kan takardar da kake so ka zaɓa zaɓi na kansa. Kasancewa a cikin shafin "Gida"danna maballin "Tsarin". Wannan kayan aiki is located in the block block. "Kwayoyin". A jeri wanda ya bayyana a rukunin "Girman kwayar halitta" zaɓi abu "Auto Fit Row Height".
- Bayan wannan, layin yawan zaɓaɓɓen zai ƙara tsayin tsayin su gwargwadon buƙata domin ƙwayoyin su nuna duk abin da ke cikin su.
Hanyar 4: dacewa don haɗaɗɗun sel
A lokaci guda, ya kamata a lura cewa aikin zaɓi na auto baya aiki don haɗakar sel. Amma a wannan yanayin, kuma, akwai mafita ga wannan matsalar. Hanya ta gaba ita ce amfani da algorithm na aiki wanda ainihin haduwar sel bai gudana ba, amma bayyane kawai. Sabili da haka, zamu iya amfani da fasaha na zaɓi na auto.
- Zaɓi ƙwayoyin da suke buƙatar haɗuwa. Danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama. Je zuwa kayan menu "Tsarin kwayar halitta ...".
- A cikin taga tsarawa wanda zai buɗe, je zuwa shafin Jeri. A cikin toshe saitin Jeri a cikin sigar siga "A kwance" zaɓi darajar "Zaɓin cibiyar". Bayan an gama yin wannan aikin, danna maballin "Ok".
- Bayan waɗannan ayyukan, bayanan suna ko'ina cikin yanki na kashin baya, kodayake a haƙiƙa ana ci gaba da adana su a cikin ƙwayar hagu, tunda haɗakar abubuwan, a gaskiya, bai faru ba. Sabili da haka, idan, alal misali, ya zama dole a goge rubutun, to ana iya yin wannan ne kawai a cikin ƙwayoyin hagu. Bayan haka, sake za selectar duk kewayon takarda akan sa rubutu. Ta kowane ɗayan hanyoyi uku da suka gabata waɗanda aka yi bayaninsu a sama, kunna madaidaiciya.
- Kamar yadda kake gani, bayan waɗannan ayyuka, an zaɓi tsayin layi ta atomatik yayin da labari na haɗuwa da abubuwan ya kasance.
Domin kada ku ringa saita tsawo na kowane layi ɗaya daban-daban, kuna ɓata lokaci mai yawa a kanta, musamman idan teburin yana da girma, ya fi kyau a yi amfani da irin wannan kayan aiki mai dacewa kamar auto-fit. Tare da shi, zaka iya daidaita girman layin kowane kewayon gwargwadon abun ciki. Matsalar kawai za ta iya tasowa idan kuna aiki tare da yanki na hanyar da aka haɗa sel ɗin, amma a wannan yanayin ma, kuna iya nemo hanyar fita daga wannan halin ta hanyar daidaita abubuwan da ke ciki tare da zaɓi.
