Zamkatimu
Mu gawo lachiwiri la nkhaniyi, muphunzira njira zapamwamba kwambiri zogwirira ntchito ndi masitayelo mu Microsoft Excel.
Mugawoli, muwona momwe mungasinthire masitayelo osakhazikika a Excel ndikugawana pakati pa mabuku ogwirira ntchito. Apa mupeza malingaliro okuthandizani kuti mupindule kwambiri pogwiritsa ntchito masitayelo mu Microsoft Excel.
Kodi mungasinthire bwanji kalembedwe?
Mutha kusintha kalembedwe kalikonse, komabe, simungathe kusintha dzina lake!
Kusintha chinthu cha chimodzi mwamawonekedwe a kalembedwe:
- Pa Riboni ya Excel pitani ku: Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (ma cell styles).
- Dinani kumanja pa sitayilo yomwe mukufuna kusintha ndikudina Sinthani (Sintha).
- Chotsani kuchongani mabokosi omwe ali pafupi ndi zomwe zayatsidwa, kapena dinani batani kukula (Format) ndikusintha mawonekedwe mu bokosi la zokambirana zamaselo.
- Sankhani ankafuna masanjidwe ndi kumadula OK.
- Press OK mu dialog box kalembedwe (Style) kuti mumalize kukonza.
Kodi mungapange bwanji mawonekedwe anu atsopano?
Inemwini, ndimakonda kupanga masitayelo atsopano m'malo mosintha masitayelo a Microsoft, pazifukwa zosavuta kuti mutha kupatsa dzina lopangidwa ndi tanthauzo. Komatu iyi ndi nkhani ya kusankha kwaumwini!
Pali njira ziwiri zopangira masitayelo atsopano:
Njira 1: Koperani kalembedwe kuchokera mu cell
Kukopera masanjidwe a ma cell a masitayelo atsopano:
- Pangani selo momwe mukufuna kuti mawonekedwe atsopano aziwoneka.
- Press Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (Mawonekedwe a Ma cell) pa Microsoft Excel Ribbon.
- Sankhani chinthu Mtundu Watsopano Waselo (Pangani Mtundu wa Maselo), bokosi la zokambirana lidzawoneka. Zindikirani kuti zosintha pazenera ili zadzazidwa ndi zosintha zomwe zakhazikitsidwa mu gawo 1.
- Perekani kalembedwe dzina loyenerera.
- Press OK. Chonde dziwani kuti tsopano kalembedwe kanu katsopano kakupezeka pazenera losankhira mwambo (Mwambo).
Njira 2: Pangani sitayilo Yatsopano mu Bokosi la Masanjidwe a Masanjidwe
Kapenanso, mutha kupanga masitayelo atsopano muzokambirana za masanjidwe. Za ichi:
- Press Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (Mawonekedwe a Ma cell) pa Microsoft Excel Ribbon
- Sankhani chinthu Mtundu Watsopano Waselo (Pangani Mawonekedwe a Maselo) kuti mutsegule bokosi la zokambirana.
- atolankhani kukula (Format) kuti mutsegule bokosi la zokambirana za mawonekedwe a cell.
- Tchulani zomwe mukufuna kupanga ma cell ndikudina OK.
- Press OK pawindo kalembedwe (Style) kuti mupange masitayilo atsopano.
Njira zonsezi zimapanga kalembedwe kameneka mubuku lanu lantchito.
Malangizo othandiza: Osatayanso nthawi pamanja pokonza masanjidwe a ma cell, gwiritsani ntchito masitayelo kuntchito, wongolerani masitayilo mwachangu komanso mwaluso kwambiri ndi menyu ya zoikamo.
Osapanganso mawonekedwe omwewo kawiri! Ngakhale masitayelo amasungidwa m'bukhu lopangira momwe adapangidwira, ndizotheka kutumiza (kuphatikiza) masitayelo ku bukhu lantchito latsopano pogwiritsa ntchito kuphatikiza.
Momwe mungaphatikizire masitaelo a mabuku awiri ogwira ntchito?
Kusuntha masitaelo pakati pa mabuku ogwirira ntchito:
- Tsegulani bukhu lantchito lomwe lili ndi kalembedwe komwe mukufuna komanso buku lantchito lomwe sitayeloyo iyenera kutumizidwa kunja.
- M'buku lomwe mukufuna kuyika kalembedwe, dinani Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (Mawonekedwe a Ma cell) pa Microsoft Excel Ribbon
- Sankhani chinthu Gwirizanitsani Masitayilo (Merge Styles) kuti mutsegule bokosi la zokambirana monga momwe zilili pansipa.
- Sankhani buku lomwe lili ndi kalembedwe komwe mukufuna (kwa ine ndi bukulo styles template.xlsx, bukhu lotseguka lokhalo kusiyapo logwira ntchito).
- Press OK. Dziwani kuti masitayelo achikhalidwe aphatikizidwa ndipo tsopano akupezeka kuti mugwiritse ntchito mubuku lofunidwa.
Malangizo othandiza: Mutha kusunga masitayilo a cell omwe mumakonda m'bukhu lapadera kuti muphatikize mosavuta ndi mabuku ogwirira ntchito, m'malo mofufuza mosalekeza mafayilo amwazikana pamafoda angapo pagalimoto yanu yamakompyuta.
Momwe mungachotsere kalembedwe kamakonda?
Kuchotsa sitayilo ndikosavuta monga kupanga. Kuchotsa masitayelo achizolowezi:
- Kuthamanga: Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (Mawonekedwe a Ma cell) pa Microsoft Excel Ribbon.
- Dinani kumanja pamalembedwe omwe mukufuna kuchotsa.
- Sankhani lamulo kuchokera pa menyu Chotsani (Chotsani).
Zonse ndi zoyambira! Palibe amene angakane kuphweka kwa chida ichi!
Mwachiwonekere, munthu aliyense payekha adzasankha yekha njira zomwe chida choperekedwa chingagwiritsire ntchito bwino. Kuti ndikupatseni malingaliro, ndikupatsani malingaliro anga ogwiritsira ntchito masitayelo mu Microsoft Excel.
Momwe Mungagwiritsire Ntchito Masitayelo mu Microsoft Excel
- Kupanga kusasinthika kwathunthu muzolemba zanu kapena zolemba za gulu lanu / kampani.
- Kuchepetsa kwambiri kuyesayesa kwinaku mukuthandizira kupanga ma cell mtsogolo.
- Kutha kugawana masitayelo ndi munthu yemwe sangathe kupanga mawonekedwe ake chifukwa chaukadaulo kapena zovuta za nthawi.
- Kukhazikitsa masitayilo omwe ali ndi mtundu wa manambala omwe mumagwiritsa ntchito pafupipafupi. Ndine wokondwa kuti pamapeto pake ndakhazikitsa masanjidwe achikhalidwe: # ##0;[Red]-# ##0ngati style.
- Kuonjezera zizindikiro zowonetsera zomwe zimasonyeza ntchito ndi cholinga cha selo. Maselo olowetsa - mumayendedwe amodzi, ma cell okhala ndi ma formula - mwanjira ina, maselo otulutsa - munjira yachitatu, maulalo - muchinayi.
Kodi mwaganiza zogwiritsa ntchito masitayelo mu Microsoft Excel? Ndili ndi chidaliro kuti chida ichi chikhoza ndipo chidzakupangitsani bwino. N’chifukwa chiyani anthu ambiri sangamukondebe? - funsoli limandisokoneza kwambiri !!!
Kodi muli ndi malingaliro ena amomwe mungagwiritsire ntchito masitayilo mu Excel spreadsheets? Kodi mukuganiza kuti n’chifukwa chiyani timapeputsa kugwiritsa ntchito chida ichi? Kodi nkhaniyi mwapeza zothandiza?
Chonde siyani ndemanga zanu pansipa! Malingaliro ndi ndemanga ndizolandiridwa!