01 na 03
Tsara ta Sashin Launi Tsuntsu a Excel
Tsara ta Launi a Excel
Bugu da ƙari ga warwarewa ta hanyar dabi'u - kamar rubutu ko lambobi - Excel na da samfuran nau'i na al'ada waɗanda zasu yarda izin ta ta launi.
Tsara ta launi zai iya zama da amfani a yayin yin amfani da tsarin kwakwalwa , wanda za'a iya amfani da shi don canza launin launi ko launin launi na bayanan da ya dace da wasu yanayi.
Kamar yadda aka nuna a cikin hoton da ke sama, za a iya amfani da launi ta hanyar launi da wannan bayanan don sauƙaƙe da bincike.
Wannan samfurori na ƙididdigar hanyoyi daban-daban na rarraba bayanai a Excel ta yin amfani da launi. Bayanai na musamman ga nau'in daban ta hanyar zaɓin launi za a iya samuwa a shafuka masu zuwa:
- Tsara ta Sashin Launi na Launi (wannan shafi a ƙasa)
- Tsara ta Font Color
- Hada ta Kayan Kwance na Yanayi
Zaɓin Bayanan da za a ƙayyade
Kafin bayanai za a iya warewa, Excel yana bukatar sanin ainihin iyakar da za'a tsara, kuma yawanci, Excel yana da kyau a zaɓar yankunan da aka haɗa - kamar dai lokacin da aka shigar,
- Ba a bar wasu layuka ko ginshiƙai a cikin wani yanki na bayanai ba;
- kuma an bar layukan layi da ginshiƙai tsakanin yankunan da suka shafi bayanai.
Excel za ta ƙayyade, daidai sosai, idan yankin bayanai yana da sunayen filin kuma cire wannan jere daga bayanan da za a tsara.
Bada izinin Excel don zaɓin kewayon da za a yi jeri yana da kyau ga ƙananan bayanai waɗanda za a iya duba su don su tabbatar da:
- cewa an saita madaidaicin madaidaicin;
- cewa babu alamun a cikin kewayon;
- cewa bayan wannan, bayanan bayanan sun kasance cikakke kuma daidai.
Don manyan wuraren bayanai, hanyar da ta fi dacewa don tabbatar da cewa zaɓin daidai ya zaɓa shi ne ya haskaka shi kafin fara irin wannan.
Idan har yanzu ana iya rarraba irin wannan layi, to mafi kusantar shi ne a ba shi suna .
Idan an ƙayyade sunan don zaɓin da za'a tsara, rubuta sunan a cikin Akwatin Akwati , ko kuma zaɓi shi daga jerin abubuwan da aka haɗu tare da shi kuma Excel zai nuna haskakaccen madaidaicin bayanai a cikin takardun aiki.
Kaddamarwa ta Launi da Zabuka
Tsarin yana buƙatar yin amfani da tsari irin .
Lokacin da zazzage ta dabi'u, akwai yiwuwar umarni biyu - hawa ko sauka. A yayin da yake fitowa da launuka, duk da haka, babu irin wannan tsari ya kasance mai amfani da ya fassara tsarin launi a cikin akwatin maganganu .
Tsara ta hanyar Salon Alal misali
A cikin hoton da ke sama, an yi amfani da jigilar sel H2 zuwa L12 don canza canjin layin salula na rubuce-rubucen bisa ga shekarun dalibai.
Maimakon canja launin tantanin halitta na duk takardun dalibai, kawai wadanda shekarun 20 ko yarinya sun rinjaye ta tsarin tsarawa tare da sauran da ba a taɓa samun su ba.
Wadannan bayanan an tsara su ta hanyar launi na sel don haɗu da littattafai na sha'awa a saman ɗakunan don sauƙaƙewa da bincike.
Matakan da suka biyo baya sun biyo don warware bayanai ta hanyar launi na bayanan sirri.
- Ganyama kewayon Kwayoyin da za a ƙayyade - H2 zuwa L12
- Danna kan shafin shafin shafin rubutun
- Danna maɓallin Fit & Filter a kan rubutun don buɗe jerin saukewa
- Danna Custom Custom a cikin jerin saukewa don kawo sama da akwatin maganganu
- A ƙarƙashin Rubutattun Hoto a cikin akwatin maganganu, zaɓi Ƙwallon Launi daga jerin jeri
- Lokacin da Excel ya sami launuka daban-daban daban-daban a cikin bayanan da aka zaɓa ya ƙara waɗannan launi zuwa ga zaɓuɓɓukan da aka jera a ƙarƙashin Dokar Sake a cikin akwatin maganganu
- A ƙarƙashin Dokar Tsarin, zaɓi launin ja daga lissafin sauke
- Idan ya cancanta, zaɓa A saman a ƙarƙashin tsari don haka bayanan masu launin jan za su kasance a saman jerin
- Danna Ya yi don warware bayanai da rufe akwatin maganganu
- Rubutun guda hudu tare da launi na jan launi ya kamata a haɗu tare a saman tarin bayanai
02 na 03
Tsara Bayanai ta Font Color a Excel
Tsara ta Font Color
Sakamakon kama da launi ta launi, za a iya amfani da launi ta launin launi don warware bayanai tare da rubutu mai launi daban-daban.
Canje-canje a launi na launi za a iya yi ta yin amfani da tsari na kwakwalwa ko sakamakon sakamakon tsara lambobi - kamar su lokacin nuna lambobin mummunan a cikin ja don sa su sauƙi don samo.
Tsara ta Font Color Misali
A cikin hoton da ke sama, an yi amfani da jigilar sel H2 zuwa L12 don canza launin launi na rubuce-rubuce na dalibai bisa ga shirin binciken su:
- Takardun Red - dalibai sun shiga cikin shirin kulawa
- Alamar Blue - daliban da suka shiga cikin kimiyya
An rubuta waɗannan bayanan ta hanyar launin launi don haɗu da littattafai na sha'awa a saman kan iyakar don sauƙaƙewa da bincike.
Tsarin tsari don launin launi yana ja biye da blue. Bayanai da tsoffin launin launin launi ba an ware ba.
Matakan da suka biyo baya sun biyo don tantance bayanai ta launin launi.
- Ganyama kewayon Kwayoyin da za a ƙayyade - H2 zuwa L12
- Danna kan shafin shafin shafin rubutun .
- Danna maɓallin Fit & Filter a kan rubutun don buɗe jerin saukewa.
- Danna Custom Custom a cikin jerin saukewa don kawo sama da akwatin maganganu
- A karkashin Rubutattun Hoto a cikin akwatin maganganu, zaɓi Font Color daga jerin sunayen da aka sauke
- Lokacin da Excel ya sami launuka daban-daban a cikin bayanai da aka zaɓa ya ƙara waɗannan launi zuwa ga zaɓuɓɓukan da aka jera a ƙarƙashin Dokar Saya a cikin akwatin maganganu
- A ƙarƙashin Dokar Tsarin, zaɓi launin ja daga lissafin sauke
- Idan ya cancanta, zaɓa A saman a ƙarƙashin tsari don haka bayanan masu launin jan za su kasance a saman jerin
- A saman akwatin maganganu, danna kan Ƙara Matsayin Ƙara don ƙara nau'in nau'i na biyu
- Domin matakin na biyu, ƙarƙashin Dokar Sayi, zaɓi launin launi daga layin da aka sauke
- Zaɓin Zaɓuɓɓuka a ƙarƙashin tsari na musamman don haka bayanai masu launin shuɗi zasu kasance a sama da waɗannan bayanan tare da tsoffin baki
- Danna Ya yi don warware bayanai da rufe akwatin maganganu
- Dole ne a haɗa rukuni guda biyu tare da launin launi ja a cikin saman bayanan bayanan da suka biyo bayan rubutun launuka masu launi guda biyu
03 na 03
Tsara Bayanan ta Hanya Tsarin Yanayi a Excel
Hada ta Kayan Kwance na Yanayi
Wani zaɓi don rarraba ta launi shi ne yin amfani da zane-zane na tsara yanayin yanayin tsari .
Wadannan madogara suna bada wata madadin hanyoyin zaɓuɓɓukan tsari na yau da kullum wanda ke mayar da hankali kan sauyawa da tsarin tsarawa.
Kamar yadda tayi ta launi ta launi, a yayin da ke nunawa ta wurin launi ya kunshi mai amfani ya tsara tsari irin a cikin akwatin maganganu.
Tsara ta misali launi mai launi
A cikin hoton da ke sama, yawancin kwayoyin da ke dauke da bayanan zafin jiki na Paris, Faransa an tsara ta da yanayin da aka saita da hasken wutar lantarki da aka ƙaddara dangane da yawan zafin rana na yau da kullum ga Yuli 2014.
An yi amfani da waɗannan gumakan don rarraba bayanai tare da rubutun nuna gumakan gilashin da aka haɗe na farko da gumakan amber suka bi, sa'an nan kuma ja.
Matakan da suka biyo baya sun biyo don warware bayanai ta hanyar launi ta launi.
- Bada hankalin jinsunan da za a yi jeri - I3 zuwa J27
- Danna kan shafin shafin shafin rubutun .
- Danna maɓallin Fit & Filter a kan rubutun don buɗe jerin saukewa.
- Danna Custom Custom a cikin jerin saukewa don kawo sama da akwatin maganganu
- A karkashin Rubutattun Hoto a cikin akwatin maganganu, zaɓi Icon Siffar daga jerin saukewa
- Lokacin da Excel ya samo gumakun tantanin halitta a cikin bayanan da aka zaɓa ya ƙara waɗannan gumaka zuwa zaɓuɓɓukan da aka jera a ƙarƙashin Dokar Tsarin a cikin akwatin maganganu
- A karkashin Dokar Tsarin, zaɓi gunkin kore daga jerin jerin saukewa
- Idan ya cancanta, zaba A saman a ƙarƙashin tsari don haka bayanan tare da gumakan kore zai kasance a saman jerin
- A saman akwatin maganganu, danna kan Ƙara Matsayin Ƙara don ƙara nau'in nau'i na biyu
- Domin mataki na biyu, a ƙarƙashin Dokar Sayi, zaɓi amber ko gunkin jajan daga lissafin drop down
- Bugu da ƙari, zaɓi Top a ƙarƙashin tsari idan ya cancanta - wannan zai sanya rukuni na biyu na bayanan da ke ƙasa da wadanda ke da gumakan kore, amma a sama da duk sauran bayanan da ake rarrabawa
- Tunda akwai kawai zaɓi uku a cikin wannan saiti, babu buƙatar ƙara ƙarami na uku don tsara rubutun tare da gumakan ja, tun da sune rubutun da aka bari kawai kuma zasu kasance a kasa na kewayon
- Danna Ya yi don warware bayanai da rufe akwatin maganganu
- Dole ne a haɗa rukunin tare da gunkin kore a saman jerin bayanan da suka biyo baya tare da rubutun tare da amber icon, sannan waɗanda suke da gunkin ja