Pangani, Lembani, ndi Kusintha Mafilimu Amtundu Wachikhalidwe mu Excel

Gwiritsani ntchito Masitime a Selo kuti Mwapangidwe Mapepala Okhazikika Mwamsanga

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.

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.

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.

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.

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.

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.

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 .

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.

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.