Ƙirƙiri, Kwafi, da Sauya Ƙa'idodin Yanayin Ƙaƙwalwar a cikin Excel

Yi amfani da Hannun Siffar zuwa Fayilolin Ɗauki da Saukewa

Hanyoyin tantanin halitta a cikin Excel shine haɗuwa da zaɓuɓɓukan tsarawa - irin su launi da launi, siffofin lambobi , da iyakoki na kan iyakoki, da kuma shading - an ambaci shi kuma an ajiye shi a matsayin ɓangare na aikin aiki .

Excel yana da tsarin da aka gina a cikin salula wanda za a iya amfani dashi kamar yadda yake zuwa takardar aiki ko gyare-gyare kamar yadda ake bukata. Wadannan hanyoyi masu ɗawainiya zasu iya zama tushen duniyar al'ada wanda za'a iya adana da kuma raba tsakanin littattafai .

Ɗaya daga cikin amfani da amfani ita ce idan an gyara salon salon bayan an yi amfani da ita a cikin takardun aiki, duk kwayoyin dake yin amfani da style za su sabunta ta atomatik don yin la'akari da canje-canje.

Bugu da ƙari, ƙwayoyin salula suna iya haɗa nau'in ɓangaren kulle Excel wanda za a iya amfani dashi don hana sauye-sauye mara izini ga ƙwayoyin maƙalai, dukan ɗawainiyar ɗawainiya, ko ɗayan littattafai.

Siffofin Cell da Takaddun Jigogi

Siffofin salula suna dogara ne akan taken jigo da ake amfani da shi a cikin ɗakin littafi. Jigogi daban-daban sun ƙunshi nau'ukan zabin daban-daban don haka idan an canza maɓallin daftarin aiki, sassan salula don wannan takardun ya canza.

Neman Tsarin Tsarin Ginin Yanki

Don amfani da ɗaya daga cikin tsarin tsarawa a cikin Excel:

1. Zaži kewayon Kwayoyin don tsara su;
2. A kan shafin shafin rijistar , danna kan icon na Cell Styles don bude gallery na samuwa;
3. Danna kan salon salon da ake bukata don amfani.

Ƙirƙirar Ƙaƙwalwar Yanayin Sanya

Don ƙirƙirar salon salon al'ada:

1. Zaɓi sautin ɗawainiya ɗaya;
2. Aiwatar da duk zaɓuɓɓukan tsarin tsarawa zuwa wannan tantanin halitta - za'a iya amfani dashi da aka gina a matsayin farawa;
3. Danna maɓallin shafin shafin kan rubutun.
4. Danna kan zaɓin Ƙungiyoyin Cell a kan rubutun don buɗe maɓallin Cell Styles .
5. Kamar yadda aka nuna a cikin hoton da ke sama, danna kan zaɓi na sabon cell din a kasa na gallery don buɗe akwatin maganganu na Style ;
6. Rubuta sunan don sabon salon a cikin akwatin sunan Style ;
7. Za'a lissafa zaɓuɓɓukan tsarawa da aka riga aka yi amfani da tantanin halitta wanda aka zaɓa a cikin akwatin maganganu.

Don yin ƙarin zaɓuɓɓukan tsarawa ko gyara da zaɓin yanzu:

1. Danna maɓallin Maɓallin a cikin akwatin maganganun Style don buɗe akwatin maganganun Siffofin Siffar.
2. Danna kan shafin a cikin akwatin maganganu don duba jerin zaɓuɓɓuka;
3. Aiwatar da duk canje-canje da ake so;
4. Danna Ya yi don komawa akwatin zane na Style ;
5. A cikin akwatin maganganu na Style, a ƙarƙashin ɓangaren mai suna " Style Includes" (ta hanyar misali) , share akwatinan dubawa don kowane tsarin da ba a so.
6. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

An saka sunan sunan sabon style a saman sashin launi na Cell Styles ƙarƙashin Siffar da aka nuna kamar yadda aka nuna a hoton da ke sama.

Don amfani da sabon salon zuwa sassan a cikin takardun aiki, bi samfurin lissafi a sama don amfani da tsarin da aka gina.

Yin kwaskwarima na Sanya

Don kwafe tsarin salon al'ada don amfani a cikin wani littafi daban-daban:

1. Bude littafi wanda ya ƙunshi tsarin al'ada don a kofe;
2. Bude littafi wanda aka kwafin shi zuwa.
3. A cikin wannan littafi na biyu, danna shafin shafin a kan rubutun.
4. Danna kan gunkin Siffofin Sigina a kan rubutun don buɗe maɓallin Cell Styles .
5. Danna kan zaɓin Ƙungiyar Zaɓuɓɓukan Ƙira a kasa na gallery don buɗe akwatin maganganun Fassara .
6. Danna sunan sunan littafi wanda ya ƙunshi salon da za a kofe;
7. Danna Ya yi don rufe akwatin maganganu.

A wannan lokaci, akwatin saƙo zai bayyana tambayarka idan kana so ka hada salon da sunan daya.

Sai dai idan kuna da siffofin al'ada tare da wannan suna amma bambancin tsarin tsarawa a cikin takardun aiki, wanda, a hanya, ba kyakkyawar ra'ayi ba ne, danna maɓallin Ee don kammala fasalin hanyar a cikin littafin littafin makaman.

Gyara Ɗaukar Tsunanin Tsarin Tsaya

Ga tsarin tsarin Excel, yawanci ya fi dacewa a canza tsarin zane maimakon salon kanta, amma dukansu tsarin da aka tsara da al'ada za a iya gyaggyara ta hanyar amfani da matakan da suka biyo baya:

1. A kan shafin shafin rubutun, danna kan gunkin Sigina ta Cell don buɗe labarun Labarai .
2. Danna-dama a kan salon salon don buɗe mahallin mahallin kuma zaɓi Sauyawa don buɗe akwatin maganganun Style ;
3. A cikin akwatin maganganu na Style , danna maɓallin Tsarin don buɗewa a cikin akwatin Siffofin Siffofin Siffar
4. A wannan akwatin zance, danna kan shafukan daban don duba zaɓuɓɓukan da aka samo;
5. Aiwatar da duk canje-canje da ake so;
6. Danna Ya yi don komawa akwatin zane na Style ;
7. A cikin akwatin maganganu na Style, a ƙarƙashin ɓangaren mai suna " Style Includes" (ta hanyar misali) , share akwatinan dubawa don kowane tsarin da ba a so.
8. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

A wannan lokaci, za a sake sabunta salon salon salula don yin la'akari da canje-canje.

Duplicating wani Tsarin Cell Cell

Ƙirƙirar hoto na hanyar da aka gina ko tsarin al'ada ta yin amfani da matakai na gaba:

1. A kan shafin shafin rubutun, danna kan gunkin Sigina ta Cell don buɗe labarun Labarai .
2. Danna-dama a kan salon salula don buɗe menu mahallin kuma zaɓi Duplicate don buɗe akwatin maganganun Style ;
3. A cikin akwatin maganganun Style , rubuta a cikin suna don sabon salon;
4. A wannan lokaci, sabon salon za a iya canza ta hanyar amfani da matakan da aka jera a sama domin gyaggyara salon da ake ciki;
5. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

An ƙara sunan sabon style a saman sashin launi na Cell Styles karkashin Ƙa'idar Custom .

Ana cire Tsarin Siffar Tsarin Siffar daga Siffofin Ayyuka

Don cire tsarin salon sirri daga sel daga bayanan ba tare da share tsarin salon salula ba.

1. Zaɓi sel waɗanda aka tsara tare da salon salon da kake so ka cire.
2. A kan shafin shafin rijistar, danna kan icon na Cell Styles don bude ɗakin launi na Cell Styles ;
3. A cikin Mai kyau, Ƙananan, da Ƙananan ɓangaren kusa da saman ɗakin gallery, danna kan Zaɓin al'ada don cire duk tsarin tsarawa.

Lura: Matakan da ke sama za a iya amfani da su don cire tsarin da aka amfani dasu da hannu zuwa sassan Kayan aiki.

Share Hanya Siffar

Baya ga al'ada na al'ada , wadda ba za a iya cire ba, duk sauran ɗakunan fasaha da al'ada na al'ada za a iya share su daga ɗakin launi na Cell Styles .

Idan an yi amfani da salon da aka share a kowane sel a cikin takardun aiki, za a cire dukkan zaɓuɓɓukan tsarawa da aka share tare da style da aka share daga cikin kwayoyin da aka shafa.

Don share salon salon salula:

1. A kan shafin shafin rubutun, danna kan gunkin Sigina ta Cell don buɗe labarun Labarai .
2. Danna-dama a kan salon salula don buɗe mahallin mahallin kuma zaɓi Kashe - an cire zangon salula daga gallery.