Yadda ake Amfani da Salo a cikin Microsoft Excel - Part 2

A kashi na biyu na labarin, za ku koyi ƙarin dabarun aiki tare da salo a cikin Microsoft Excel.

A cikin wannan ɓangaren, zaku ga yadda ake canza tsoffin salon Excel kuma raba su tsakanin littattafan aiki. Anan zaku sami wasu ra'ayoyi don taimaka muku samun mafi kyawun amfani da salo a cikin Microsoft Excel.

Yadda ake canza salon saiti?

Kuna iya canza kowane salon saiti, duk da haka, ba za ku iya canza sunansa ba!

Don canza wani yanki na ɗaya daga cikin halayen salon:

1. A cikin Excel Ribbon je zuwa: Gida (Gida) > styles (Style) > Salon salula (salon salula).
2. Dama danna kan salon da kake son canza kuma danna Gyara (canji).
3. Cire alamar akwatunan kusa da halayen da aka kunna, ko danna maɓallin size (Format) kuma canza halayen a cikin akwatin maganganu na tsara tantanin halitta.
4. Zaɓi tsarin da ake so kuma danna OK.
5. latsa OK a cikin akwatin maganganu style (Salo) don gama gyarawa.

Yadda ake ƙirƙirar sabon salon ku?

Da kaina, na fi son ƙirƙirar sabbin salo maimakon gyara tsoffin salon Microsoft, saboda sauƙi mai sauƙi wanda zaku iya ba salon da aka ƙirƙira suna mai ma'ana. Amma wannan gaba ɗaya batu ne na zaɓi na sirri!

Akwai hanyoyi guda biyu don ƙirƙirar sabon salo:

Hanyar 1: Kwafi salon daga tantanin halitta

Don kwafi tsarin salula don sabon salo:

1. Tsara tantanin halitta yadda kuke son sabon salo ya dubi.
2. latsa Gida (Gida) > styles (Style) > Salon salula (Salon Cell) akan Ribbon Microsoft Excel.
3. Zaɓi abu Sabon Salon Sel (Ƙirƙiri Salon Waya), akwatin maganganu na tsarawa zai bayyana. Ka lura cewa abubuwan da aka tsara a cikin wannan taga suna cike da saitunan da aka saita a mataki na 1.
4. Ba wa salon suna mai dacewa.
5. latsa OK. Lura cewa yanzu sabon salon ku yana samuwa a cikin taga zaɓin salon da ke ƙarƙashin Custom (Al'ada).

Hanyar 2: Ƙirƙiri Sabon Salo a cikin Akwatin Magana Mai Tsara

A madadin, zaku iya ƙirƙirar sabon salo a cikin maganganun tsarawa. Don wannan:

1. latsa Gida (Gida) > styles (Style) > Salon salula (Salon Cell) akan Ribbon Microsoft Excel
2. Zaɓi abu Sabon Salon Sel (Ƙirƙiri Salon Waya) don buɗe akwatin maganganu na tsarawa.
3. latsa size (Format) don buɗe akwatin maganganu tsarin tsarin salula.
4. Ƙayyade zaɓuɓɓukan tsara tantanin halitta da ake so kuma danna OK.
5. latsa OK a cikin taga style (Salo) don ƙirƙirar sabon salo.

Duk waɗannan hanyoyin za su haifar da salo na al'ada a cikin littafin aikin ku.

Shawara mai amfani: Kar a sake ɓata lokaci da hannu saitin tsarin tantanin halitta, aiwatar da salo a wurin aiki, sarrafa saitunan tsarawa cikin sauri da inganci tare da menu na saitunan salo.

Kar a taɓa ƙirƙirar salo iri ɗaya sau biyu! Kodayake an adana salon kawai a cikin littafin aiki inda aka ƙirƙira shi, har yanzu yana yiwuwa a fitar da sifofin (haɗe) zuwa sabon littafin aiki ta amfani da aikin haɗin gwiwa.

Yadda za a haɗa salon littattafan aiki guda biyu?

Don matsar da salo tsakanin littattafan aiki:

1. Buɗe littafin aiki mai ɗauke da salon da ake so da littafin aikin da salon za a fitar dashi zuwa waje.
2. A cikin littafin da kake son liƙa salon, danna Gida (Gida) > styles (Style) > Salon salula (Salon Cell) akan Ribbon Microsoft Excel
3. Zaɓi abu Ci Styles (Haɗa Salon) don buɗe akwatin maganganu kamar yadda aka nuna a ƙasa.
4. Zaɓi littafin da ya ƙunshi salon da ake so (a wurina shine littafin samfurin salo.xlsx, Littafin aikin bude kawai banda mai aiki).
5. latsa OK. Lura cewa an haɗa nau'ikan al'ada kuma yanzu suna samuwa don amfani a cikin littafin aikin da ake so.

Shawara mai amfani: Kuna iya ajiye salon salular da kuke so a cikin wani littafin aiki na daban don sauƙaƙa haɗawa tare da littattafan aiki, maimakon neman fayiloli marasa ƙarewa a warwatse cikin manyan manyan fayiloli a kan kwamfutarka.

Yadda ake cire salon al'ada?

Cire salo yana da sauƙi kamar ƙirƙirar shi. Don cire salon al'ada:

1. Gudun: Gida (Gida) > styles (Style) > Salon salula (Salon Cell) akan Ribbon Microsoft Excel.
2. Dama danna kan salon da kake son gogewa.
3. Zaɓi umarni daga menu share (Share).

Komai na farko ne! Babu wanda zai musun sauƙin wannan kayan aiki!

Babu shakka, kowane mutum ɗaya zai ƙayyade hanyoyin da za a iya amfani da kayan aikin da aka bayar don inganta inganci. Don ba ku abinci don tunani, zan ba ku wasu ra'ayoyin kaina don amfani da salo a cikin Microsoft Excel.

Yadda zaka iya amfani da Salon a cikin Microsoft Excel

• Ƙirƙirar cikakkiyar daidaito a cikin takaddunku ko takaddun ƙungiyar ku / kamfanin ku.
• Mahimman raguwa a cikin ƙoƙari yayin tallafawa tsarin tantanin halitta a nan gaba.
• Ikon raba salon al'ada tare da wanda ba zai iya ƙirƙirar salon kansa ba saboda ƙarancin fasaha ko lokaci.
• Saita salo wanda ya ƙunshi tsarin lambar al'ada wanda kuke amfani da shi akai-akai. Na yi farin ciki da a ƙarshe da aka tsara tsarin tsarawa na al'ada: # ##0;[Ja] -# ##0kamar salo.
• Ƙara alamun gani waɗanda ke nuna aiki da manufar tantanin halitta. Kwayoyin shigarwa - a cikin wani salon, sel tare da tsari - a cikin wani, ƙwayoyin fitarwa - a cikin salo na uku, haɗin kai - a cikin na huɗu.

Shin kun yanke shawarar amfani da salo a cikin Microsoft Excel? Ina da yakinin cewa wannan kayan aikin zai iya kuma zai inganta aikin ku. Me yasa ya kasance maras so? – wannan tambayar ta rude ni sosai!!!

Kuna da wasu ra'ayoyi kan yadda ake amfani da salo a cikin maƙunsar rubutu na Excel? Me yasa kuke tunanin muna raina amfanin wannan kayan aiki? Shin kun sami wannan labarin yana da taimako?

Da fatan za a bar maganganun ku a ƙasa! Ra'ayoyi da ra'ayoyin suna maraba!