Yadda ake tace bayanai a cikin Excel ta launi

A cikin Microsoft Office Excel, farawa daga sigar 2007, ya zama mai yiwuwa a ware da tace sel na tsararrun tebur ta launi. Wannan fasalin yana ba ku damar kewaya teburin da sauri, yana ƙara haɓakawa da ƙayatarwa. Wannan labarin zai rufe manyan hanyoyin da za a tace bayanai a cikin Excel ta launi.

Siffofin tacewa ta launi

Kafin ci gaba da yin la'akari da hanyoyin da za a tace bayanai ta launi, ya zama dole a yi nazarin fa'idodin da irin wannan hanya ta samar:

• Tsarin tsari da oda bayanai, wanda ke ba ka damar zaɓar guntun da ake so na farantin kuma da sauri sami shi a cikin babban kewayon sel.
• Ƙwayoyin da aka haska tare da mahimman bayanai za a iya ƙara nazarin su.
• Tace ta launi yana haskaka bayanan da suka dace da ƙayyadaddun ka'idojin.

Yadda ake tace bayanai ta launi ta amfani da ginanniyar zaɓi na Excel

Algorithm don tace bayanai ta launi a cikin tsararrun tebur na Excel an raba shi zuwa matakai masu zuwa:

1. Zaɓi kewayon sel da ake buƙata tare da maɓallin linzamin kwamfuta na hagu kuma matsa zuwa shafin "Gida" da ke cikin saman kayan aiki na shirin.
2. A cikin yankin da ya bayyana a cikin sashin gyarawa, kuna buƙatar nemo maɓallin "Tsarin da Tace" kuma fadada shi ta danna kibiya da ke ƙasa.

3. A cikin menu da ya bayyana, danna kan layin "Filter".

4. Lokacin da aka ƙara tacewa, ƙananan kibau zasu bayyana a cikin sunayen ginshiƙan tebur. A wannan mataki, mai amfani yana buƙatar danna LMB akan kowane kibau.

5. Bayan danna kan kibiya a cikin sunan shafi, za a nuna irin wannan menu, wanda a ciki kuna buƙatar danna kan Tace ta layin launi. Wani ƙarin shafin zai buɗe tare da ayyuka guda biyu da ake da su: "Tace ta launin tantanin halitta" da "Tace ta launin rubutu".

6. A cikin sashin "Tace ta launi", zaɓi inuwar da kake son tace teburin tushen ta danna shi tare da LMB.
7. Duba sakamakon. Bayan yin magudin da ke sama, sel kawai masu launi da aka ƙayyade a baya zasu kasance a cikin tebur. Abubuwan da suka rage za su ɓace, kuma za a rage farantin.

Kuna iya tace bayanai da hannu a cikin tsararrun Excel ta hanyar cire layuka da ginshiƙai masu launuka marasa so. Koyaya, mai amfani zai ƙara ƙarin lokaci don kammala wannan aikin.

Idan ka zaɓi inuwar da ake so a cikin sashin "Tace ta launi", to kawai layin da aka rubuta rubutun font a cikin launi da aka zaɓa za su kasance a cikin tebur.

Kula! A cikin Microsoft Office Excel, tacewa ta aikin launi yana da babban koma baya. Mai amfani zai iya zaɓar inuwa ɗaya kawai, wanda za a tace jeri na tebur. Ba zai yiwu a ƙayyade launuka masu yawa lokaci ɗaya ba.

Yadda ake warware bayanai ta launuka masu yawa a cikin Excel

Yawancin lokaci babu matsaloli tare da rarraba ta launi a cikin Excel. Ana yin ta kamar haka:

1. Ta kwatanci tare da sakin layi na baya, ƙara tacewa zuwa jeri na tebur.
2. Danna kan kibiya da ke bayyana a cikin sunan shafi, kuma zaɓi "Rarraba ta launi" a cikin menu mai saukewa.

3. Ƙayyade nau'in rarrabuwa da ake buƙata, alal misali, zaɓi inuwar da ake so a cikin ginshiƙin "Rarraba ta launi ta salula".
4. Bayan yin magudi na baya, layuka na tebur tare da inuwar da aka zaɓa a baya za su kasance a wuri na farko a cikin tsararru don tsari. Hakanan zaka iya tsara wasu launuka.

Ƙarin Bayani! Hakanan zaka iya tsara bayanan da ke cikin tebur ta amfani da aikin "Custom sorting", ƙara matakan da yawa ta launi.

Yadda ake tace bayanai a cikin tebur ta launi ta amfani da aikin al'ada

Domin Microsoft Office Excel ya zaɓi tace don nuna launuka masu yawa a cikin tebur lokaci ɗaya, kuna buƙatar ƙirƙirar ƙarin saiti tare da cika tint. Dangane da inuwar da aka kirkira, za a tace bayanan nan gaba. An ƙirƙiri aikin al'ada a cikin Excel bisa ga umarni masu zuwa:

1. Je zuwa sashin "Developer", wanda ke saman babban menu na shirin.
2. A cikin shafin da ya buɗe, danna maɓallin "Visual Basic".
3. Editan da aka gina a cikin shirin zai buɗe, wanda a ciki zaku buƙaci ƙirƙirar sabon tsari kuma ku rubuta lambar.

Don amfani da aikin da aka ƙirƙira, dole ne ku:

1. Koma zuwa takaddar aikin Excel kuma ƙirƙirar sabbin ginshiƙai biyu kusa da tebur na asali. Ana iya kiran su "Launi na Kwayoyin" da "Launi na Rubutu" bi da bi.

2. Rubuta dabarar a shafi na farko "= Cika Launi()». An haɗa hujjar a cikin baƙaƙe. Kuna buƙatar danna kan tantanin halitta tare da kowane launi a cikin farantin.

3. A cikin shafi na biyu, nuna hujja iri ɗaya, amma tare da aikin kawai "=Launi Font()».

4. Miƙa da sakamakon da aka samu zuwa ƙarshen tebur, ƙaddamar da dabara zuwa duka kewayo. Bayanan da aka karɓa suna da alhakin launi na kowane tantanin halitta a cikin tebur.

5. Ƙara tacewa zuwa jeri na tebur bisa ga makircin da ke sama. Za a jera bayanan ta launi.

Muhimmin! Rarraba a cikin Excel ta amfani da aikin da aka ayyana mai amfani ana yin su ta hanya iri ɗaya.

Kammalawa

Don haka, a cikin MS Excel, zaku iya hanzarta tace ainihin tsarin tebur ta launi na sel ta amfani da hanyoyi daban-daban. Babban hanyoyin tacewa da rarrabawa, waɗanda aka ba da shawarar yin amfani da su yayin aiwatar da aikin, an tattauna su a sama.