Yadda za a ƙayyade Adadin Layuka a cikin Teburin Excel - Hanyoyi 3

Ba sabon abu ba ne ga mai amfani da Excel ya yi ma'amala da tantance yawan layuka na tebur. Don yin wannan, zaka iya amfani da wasu hanyoyi. Akwai su da yawa, don haka zaɓi na takamaiman ya dogara gaba ɗaya akan burin da mai amfani yake son cimmawa. A yau za mu yi bayanin wasu daga cikinsu. Ana iya amfani da su don labarai masu digiri na abun ciki daban-daban, da kuma a wasu yanayi.

Me yasa ake tantance adadin layuka a cikin Excel

Da farko, me yasa ake tantance adadin layuka a cikin Excel kwata-kwata? Wataƙila akwai zaɓuɓɓuka da yawa. Alal misali, wajibi ne a ƙididdige yawan adadin kayayyaki, kowannensu yana cikin layi daban kuma a lokaci guda takamaiman lambar ba ta dace da lambar layin da ke cikin takardar kanta ba. Ko kuma kuna buƙatar ƙayyade adadin layuka waɗanda suka dace da wani ma'auni. Bari mu ci gaba kai tsaye zuwa la’akari da hanyoyin kan yadda ake fahimtar layuka nawa ne tebur na Excel ya ƙunshi.

Ƙayyade adadin layuka a cikin tebur na Excel

Don haka, akwai hanyoyi na asali da yawa don ƙayyade adadin layuka:

1. Duba bayanin da ke ƙunshe a mashigin matsayi.
2. Yin amfani da aiki na musamman wanda zai iya tantance adadin layuka da kansa ko kuma a yi amfani da shi don wasu ƙididdiga.
3. Amfani da kayan aikin tsara yanayin yanayi da masu tacewa.

Ya kamata a yi la'akari da waɗannan hanyoyin dalla-dalla.

Tsarin Yanayi da Tace

A wane yanayi ne wannan hanya ta dace? Da farko, idan muna buƙatar ƙayyade adadin layuka a cikin wani kewayon, wanda kuma yayi daidai da wani sifa. Wato, a wannan yanayin, kawai waɗancan layukan da suka faɗi ƙarƙashin ƙayyadaddun ƙayyadaddun ma'auni za a yi la'akari da su. Ta yaya yake aiki a aikace?

1. Muna zaɓar kewayon bayanan da za a yi amfani da su don lissafin.
2. Bayan haka mun sami a kan "Home" shafin "Styles" rukuni. Akwai kayan aiki mai suna Conditional Formatting.
3. Bayan mun danna maɓallin da ya dace, menu na buɗewa zai bayyana tare da rubutun "Dokokin Zaɓin Tantanin halitta".
4. Bayan haka, wani sabon taga ya bayyana wanda a ciki muna buƙatar zaɓar abin "Text ya ƙunshi" abu. Amma wannan ya keɓanta da misalinmu, domin saitin sel ɗin da aka yi amfani da su a cikin yanayinmu ya ƙunshi ƙimar rubutu kawai. Hakanan kuna buƙatar zaɓar abin da ya dace da yanayin ku. Muna bayyana makanikai ne kawai.
5. Bayan haka, taga zai bayyana wanda kai tsaye muka saita ka'idojin tsara tsarin. Da farko, muna bukatar mu saka dabi'u a abin da Kwayoyin za a fentin da wani launi. A filin hagu, alal misali, za mu rubuta harafin A, kuma a cikin filin dama za mu zaɓi tsarin da aka saita ta tsohuwa. Hakanan, zaku iya canza waɗannan saitunan zuwa abubuwan da kuke so. Misali, zaɓi tsarin launi daban-daban. Muna buƙatar zaɓar duk sel waɗanda ke ɗauke da harafin A kuma mu sanya su ja. Bayan mun shigar da waɗannan saitunan, danna maɓallin OK.
6. Na gaba, muna yin cak. Idan duk kwayoyin da suka hadu da wannan ma'auni suna da launin ja, to wannan yana nuna cewa mun yi duk abin da ya dace.
7. Bayan haka, muna buƙatar amfani da kayan aikin Filter, wanda zai taimaka wajen ƙayyade adadin layin da suke ja. Don yin wannan, sake zaɓi kewayon da muke buƙata. Sa'an nan je zuwa "Gida" tab kuma bude "Filter" icon a can. Kuna iya ganin yadda yake kama a wannan hoton. Mu danna shi.
8. Alama zata bayyana a saman ginshiƙin da aka zaɓa, yana nuna matatar da ba ta aiki ba. Yana kama da kibiya ƙasa. Mu danna shi.
9. Bayan haka, muna neman abu "Tace ta launi" kuma danna kan launi da muka yi amfani da shi a baya.
10. Bayan an shafa matattarar a kan tebur, sai kawai waɗanda ke ɗauke da sel masu ja za a iya gani a ciki. Bayan haka, ya isa ya zaɓi su don fahimtar lambar ƙarshe. Yadda za a yi? Ana yin wannan ta hanyar ma'aunin matsayi. Zai nuna jimlar adadin layuka waɗanda dole ne mu lissafta a cikin matsalar da muka saita a farkon wannan sashe.

Yin amfani da aikin LINE

Wannan fasalin yana da babbar fa'ida ɗaya. Yana ba da damar ba kawai don fahimtar yawan layukan da aka cika ba, har ma don nuna wannan darajar a cikin tantanin halitta. Koyaya, zaku iya sarrafa waɗanne layuka don haɗawa cikin ƙirga ta amfani da wasu ayyuka. Duk waɗanda ke ɗauke da ƙima da waɗanda ba su ƙunshi bayanai ba za a yi la’akari da su.

Babban ma'anar wannan aikin shine kamar haka: = STRING(tsari). Yanzu bari muyi tunanin yadda ake amfani da wannan aikin a aikace. Don yin wannan, muna buƙatar buɗe kayan aiki mai suna Wizard Aiki.

1. Zaɓi kowane tantanin halitta wanda bai ƙunshi ƙima ba. Ana ba da shawarar cewa ka fara tabbatar da cewa baya ƙunshe da haruffan da ba za a iya bugawa ba ko wasu dabaru waɗanda ke ba da ƙima mara kyau. Wannan tantanin halitta zai nuna sakamakon aikin.
2. Bayan haka, muna danna maballin "Saka Aiki", wanda yake dan kadan zuwa hagu na mashaya dabara.
3. Yanzu muna da akwatin maganganu inda za mu iya zaɓar nau'in aikin da aikin kansa. Don sauƙaƙe bincike, muna buƙatar zaɓar nau'in "Cikakken lissafin haruffa". A can za mu zaɓi aikin CHSTROK, saita tsararrun bayanai kuma tabbatar da ayyukanmu tare da maɓallin Ok.

Ta hanyar tsoho, ana la'akari da duk layukan duka waɗanda ke ɗauke da bayanai da waɗanda ba su da shi. Amma idan an haɗa shi da sauran masu aiki, to, zaku iya daidaitawa da sauƙi.

Bayani a cikin ma'aunin matsayi

Kuma a ƙarshe, hanya mafi sauƙi don ganin adadin layukan da aka zaɓa a nan da yanzu shine amfani da ma'aunin matsayi. Don yin wannan, kuna buƙatar zaɓar kewayon da ake so ko sel guda ɗaya, sannan ku ga adadin a ma'aunin matsayi (wanda aka haskaka tare da jan rectangular a cikin hoton hoton).

Don haka, babu wani abu mai wahala wajen ganin adadin layukan.