Zojambula Zowonongeka

Maphunzirowa akugwiritsira ntchito mafashoni oyimikiratu otsogolera mu Excel ndi zitsanzo zowonjezera ndi sitepe.

01 pa 10

Kugwiritsira ntchito Zithunzi Zojambula

Mu sitepe iyi, tidzatha kugwiritsa ntchito maonekedwe a Excel omwe adakonzeratu kale kuti tiwonjezere mtundu wathu pa tsamba . Kuchita zimenezi sikungowonjezera kuyang'ana kowonjezereka, komabe kungakhalenso kosavuta kuwerenga ndi kutanthauzira deta yolongosola .

Mwapadera, tidzagwiritsa ntchito shading ku mutu wa zolemba pa mizere 2 ndi 7 komanso mizere 3 ndi 6 pogwiritsa ntchito mawonekedwe Amasitala omwe ali pa Tsamba la Home la Ribbon .

Kuti tiyesetse kuchita bwino, tidzasankha maselo osayandikana a deta pogwiritsa ntchito makiyi a Ctrl pa makiyi. Izi zidzatilola kugwiritsa ntchito mapangidwe kwa maselo onse ofunika pa nthawi yomweyo.

Kuwonjezera Shading Kulemba Maofesi

1. Dinani pa selo loyanjanitsidwa mutu mzere 2.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Kokani osankhira maselo A7 mpaka F7 kuti muwawonetse iwo komanso selo loyanjanitsidwa mutu.
4. Tulutsani makiyi a Ctrl .
5. Dinani pamsana wotsika kumapeto kwa mndandanda wamasewero omwe alipo.
6. Sankhani njira yachinsinsi 3 kuchokera kumayendedwe omwe alipo.
7. Maselo ophatikizana omwe ali ogwirizana ndi mitu yomwe ili mu mzere 7 ayenera tsopano kukhala ndi zobiriwira zoyera malemba.
8. Kuti malemba oyerawo awoneke pang'ono, dinani pa Bold icon pa riboni.
9. Chizindikiro cholimba ndi kalata wakuda B pansi pazithunzi zazithunzi za riboni.

Kuwonjezera Shading ku Mizere 3 ndi 6

1. Kokani osankha maselo A3 kuti F3 awoneke.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Kokani osankhira maselo A6 mpaka F6 kuti muwaveke iwo komanso maselo A3 mpaka F3.
4. Dinani pamsana wotsika kumapeto kwa mndandanda wamasewero omwe alipo.
5. Sankhani 40% - Njira yachangu 3 kuchokera ku mafashoni omwe alipo.
6. Maselo A3 mpaka F3 ndi A6 mpaka F6 ayenera tsopano kukhala ndi zobiriwira zowala ndi zolemba zakuda.

02 pa 10

Maselo Achilili mwachidule

Maselo a selo mu Excel ndi kuphatikiza zosankha zojambula - monga maonekedwe a maonekedwe ndi mtundu, mawonekedwe a nambala , ndi malire a selo, ndi shading - yomwe imatchulidwa ndi kusungidwa monga gawo la tsamba.

Excel ili ndi masewera ambiri omwe amamangidwa mu selo omwe angagwiritsidwe ntchito monga momwe alili pa tsamba kapena kusintha momwe akufunira. Miyendo yowonjezerayi ingathenso kukhala maziko a mafayilo a maselo omwe angathe kupulumutsidwa ndi kugawa pakati pa mabuku ogwira ntchito.

Njira imodzi yogwiritsira ntchito masitayelo ndi yakuti ngati mawonekedwe a selo amasinthidwa atagwiritsidwa ntchito pa tsamba, ma selo onse ogwiritsira ntchito kalembedwe angasinthidwe kuti asonyeze kusintha.

Kuwonjezera apo, mafayilo a selo angaphatikizepo mawonekedwe a Excel's lock cells omwe angagwiritsidwe ntchito pofuna kuteteza kusintha kosaloledwa kwa maselo ena, masamba onse, kapena mabuku onse ogwira ntchito.

03 pa 10

Maselo Achilili ndi Zolemba Zakale

Maselo a magulu amachokera pamutu walemba umene umagwiritsidwa ntchito ku buku lonse la ntchito. Mitu yosiyana imakhala ndi mitundu yosiyana yopanga maonekedwe kotero ngati mutu wa chikalata umasinthidwa, mawonekedwe a selo a chikalatacho amasintha.

04 pa 10

Kugwiritsa Ntchito Zomwe Zidamangidwa M'suntha

Kugwiritsa ntchito imodzi mwazojambula zojambulidwa mu Excel:

1. Sankhani ma selo osiyanasiyana kuti apangidwe;
2. Pabupi la kunyumba la riboni, dinani pa Cell Styles chizindikiro kuti mutsegule zithunzi za mafilimu omwe alipo;
3. Dinani pa selo yoyenera ya selo kuti mugwiritse ntchito.it.

05 ya 10

Kupanga Chizolowezi Chamtundu Wachikhalidwe

Kupanga chizolowezi chachizolowezi cha selo:

1. Sankhani selo limodzi lamasamba;
2. Gwiritsani ntchito zosankhidwa zonse zofunikirako pa selo ili - ndondomeko yokhazikika ingagwiritsidwe ntchito ngati chiyambi;
3. Dinani kabukhu Kakang'ono pa makina.
4. Dinani pa Cell Styles kusankha pa riboni kuti mutsegule Cell Styles gallery.
5. Monga momwe chikuwonetsedwera pa chithunzi pamwambapa, dinani pa Selo Yatsopano yazithunzi mawonekedwe pansi pa gallery kuti mutsegule dialog dialog box ;
6. Lembani dzina la ndondomeko yatsopano muzolemba dzina la bokosi;
7. Zosankha zojambulidwa kale zomwe zimagwiritsidwa ntchito ku selo losankhidwa zidzatchulidwa mu bokosi la zokambirana.

Kuti mupange zina zowonjezera maonekedwe kapena kusintha zosankha zamakono:

1. Dinani pa batani la fomu mu bokosi la mazokambirana kuti mutsegule bokosi la bokosi la mawonekedwe.
2. Dinani pa tabu mu bokosi la bokosi kuti muwone zoyenera;
3. Ikani kusintha konse komwe mukufuna;
4. Dinani OK kuti mubwerere ku bokosi la mafotokozedwe;
5. Mu bokosi la dialog box, pansi pa gawo lakuti Style Includes (Mwa Chitsanzo) , tsambulani mabokosi ochezera maonekedwe omwe sakufunidwa.
6. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.

Dzina lachikhalidwe chatsopano likuwonjezeredwa pamwamba pa magalasi a Cell Styles pansi pa Machitidwe a mwambo monga momwe tawonetsera pa chithunzi pamwambapa.

Kuti mugwiritse ntchito kalembedwe katsopano kumaselo pa tsamba, tsatirani ndondomeko yomwe ili pamwambayi kuti mugwiritse ntchito kalembedwe kake.

06 cha 10

Kujambula Miyeso Yam'manja

Kujambula kalembedwe ka selo yogwiritsidwa ntchito mu bukhu losiyana:

1. Tsegulani buku lokhala ndi kalembedwe kamene mungakopere;
2. Tsegulani bukhu lolembedwa lomwe kalembedwe likukopedwa.
3. Mu bukhu ili lachiwiri, dinani Kabukhu Kakang'ono pa kabati.
4. Dinani pazithunzi za Cell Styles paboni kuti mutsegule zithunzi za Cell Styles .
5. Dinani pazithunzi Zogwirizanitsa Zojambula pansi pa nyumbayi kuti mutsegule Bokosi la Mawonekedwe a Merge .
6. Dinani pa dzina la bukhuli lomwe lili ndi kalembedwe kopezedwa;
7. Dinani OK kuti mutseke bokosi la dialog.

Pano, bokosi lodziwitsidwa lidzawonekera ngati mukufuna kuphatikiza mafashoni ndi dzina lomwelo.

Pokhapokha mutakhala ndi zojambulazo ndi dzina lomwelo koma zosiyanitsa zosiyana mu mabuku awiri ogwirira ntchito, omwe, mwa njira, sali lingaliro labwino, dinani bokosi la Inde kuti mutsirize kalembedwe kake ku bukhu la ntchito.

07 pa 10

Kusintha Chizindikiro Chamoyo Chopezekapo

Kwa mafashoni omangidwe a Excel, kawirikawiri zimasintha kusintha kamasewero m'malo mwa kalembedwe kokha, koma mawonekedwe onse omwe amamangidwe ndi amtundu angasinthidwe pogwiritsa ntchito njira zotsatirazi:

1. Pabupi la kunyumba la riboni, dinani pa Cell Styles chizindikiro kuti mutsegule zithunzi za Cell Styles .
2. Dinani pa selo ya selo kuti mutsegule masewera omwe mumakhala nawo ndikusintha Sinthani kuti mutsegule dialog box;
3. Mu bokosi la dialog dialog, dinani pa Fomatiyiyi kuti muwatsegule mu bokosi la Mauthenga a Mafomu
4. Mu bokosi lino, dinani pazithunzi zosiyanasiyana kuti muwone njira zomwe zilipo;
5. Ikani kusintha konse komwe mukufuna;
6. Dinani OK kuti mubwerere ku bokosi la mafotokozedwe;
7. Mu bokosi la dialog box, pansi pa gawo lakuti Style Includes (Mwa Chitsanzo) , tsambulani mabokosi ochezera maonekedwe omwe sakufunidwa.
8. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.

Panthawiyi, mawonekedwe osinthidwawo amasinthidwa kuti asonyeze kusintha.

08 pa 10

Kuphatikiza mawonekedwe a selo

Pangani choyimira cha kalembedwe kake kapena kachitidwe kachitidwe pogwiritsa ntchito njira zotsatirazi:

1. Pabupi la kunyumba la riboni, dinani pa Cell Styles chizindikiro kuti mutsegule zithunzi za Cell Styles .
2. Dinani pa selo ya selo kuti mutsegule masewera ozungulira ndikusankha Duplicate kuti mutsegule dialog dialog box;
3. Mu bokosi la dialog dialog, lembani mu dzina la kalembedwe;
4. Panthawiyi, kalembedwe katsopano kakasinthidwa pogwiritsa ntchito ndondomeko zotchulidwa pamwambapa kuti musinthe mawonekedwe omwe alipo kale;
5. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.

Dzina lachikhalidwe chatsopano likuwonjezeredwa pamwamba pa zithunzi za Cell Styles pansi pa mutu wa Custom .

09 ya 10

Kuchotsa Mafelelo a Cell Kusintha kuchokera ku Maofesi Athu Othandizira

Kuchotsa mawonekedwe a selo ya selo kuchokera ku maselo popanda kudula mawonekedwe a selo.

1. Sankhani maselo omwe apangidwe ndi selo ya selo yomwe mukufuna kuchotsa.
2. Pabupi la kunyumba la riboni, dinani pa Cell Styles icon kuti mutsegule Galaxy Cell ;
3. Mubwino, Zoipa, ndi Gawo Landale pafupi ndi pamwamba pa nyumbayi, dinani pa Njira Yowonongeka kuti muchotse mawonekedwe onse ogwiritsidwa ntchito.

Zindikirani: Zomwe takambirana pamwambazi zingagwiritsidwe ntchito kuchotsa maonekedwe omwe agwiritsidwa ntchito pamaselo apakompyuta.

10 pa 10

Kutulutsa mawonekedwe a Cell

Kupatula kachitidwe kachizolowezi , kamene sikanatha kuchotsedwa, mawonekedwe ena onse omangidwa ndi mwambo akhoza kuchotsedwa ku Galaxy Cell .

Ngati chidindo chochotsedwacho chagwiritsidwa ntchito ku maselo onse omwe ali pa tsambalo, zonse zomwe mungasankhe pophatikizapo kalembedwe zingachotsedwe ku maselo okhudzidwa.

Kuchotsa mawonekedwe a selo:

1. Pabupi la kunyumba la riboni, dinani pa Cell Styles chizindikiro kuti mutsegule zithunzi za Cell Styles .
2. Dinani pa selo ya selo kuti mutsegule mndandanda wa masewera ndikusankha Chotsani - mawonekedwe a selo amachotsedwa nthawi yomweyo kuchokera ku nyumbayi.