Momwe Mungagwiritsire Ntchito Masitayilo mu Microsoft Excel - Gawo 1

Munkhani iyi ya magawo awiri, Terry amalankhula za cholinga cha masitayilo mu Microsoft Excel. Mu gawo loyamba, muphunzira momwe mungasankhire ma cell mwanzeru, ndipo gawo lachiwiri, muphunzira njira zapamwamba zosinthira.

Mitundu mu Microsoft Excel Mosakayika ndi chimodzi mwazinthu zomwe zimanyalanyazidwa, zosagwiritsidwa ntchito mochepera, komanso zochepera pa Excel.

Ngakhale kuchuluka kwa danga pa Riboni ya Microsoft Excel 2007 yoperekedwa ku gawoli, ogwiritsa ntchito ambiri (ndine inenso) amalakwitsa posintha mawonekedwe a cell pamasamba, m'malo mowononga mphindi zochepa za nthawi yawo yamtengo wapatali kusinthira masitayelo omwe angafune. itha kugwiritsidwa ntchito ndikudina pang'ono chabe mbewa.

Mumaudziwa bwino uthenga wolakwikawu:Pali mitundu yambiri yama cell.“? Ngati inde, ndiye kuti ndizothandiza kugwiritsa ntchito masitayelo mu Microsoft Excel.

Masitayelo ogwiritsidwa ntchito mwanzeru a Excel adzakupulumutsirani nthawi m'kupita kwanthawi! Osanenapo za mpumulo wofunikira pakukonza ma cell, mawonekedwe ofanana a matebulo komanso kumasuka kwa kuzindikira kwawo. Ndipo komabe, ngakhale pakati pa ogwiritsa ntchito a Excel odziwa zambiri, chidachi sichinatchulidwebe.

Nkhaniyi sinapangidwe kuti iyankhe funso chifukwa chake sitigwiritsa ntchito masitayelo mu Microsoft Excel. Kwenikweni, komanso zokambirana za kulimbikitsa mabuku a Microsoft Excel pophatikiza masitayelo ndi zida zotsimikizira deta.

M'nkhaniyi, tiona ntchito ndi masitaelo, kumene ine ndikupatsani inu pang'onopang'ono malangizo a mmene ntchito ndi chida ichi, ndiyeno, mu gawo lachiwiri la phunziro, tiphunzira njira zosiyanasiyana ndi zoikamo. . Ndikuwonetsani momwe mungasamalire masitayelo, kugawana malingaliro ogwiritsira ntchito masitayelo a Microsoft Excel pantchito yanu yatsiku ndi tsiku, ndipo nthawi zonse mupeza malangizo othandiza molimba mtima m'nkhani zanga.

Pomaliza, ziyenera kunenedwa kuti, monga momwe zilili ndi zida zambiri za Microsoft, masitayelo amapezeka pamapulogalamu onse a Microsoft Office suite. Apa tiyang'ana masitayelo mu Microsoft Excel, koma zoyambira ndi njira zomwe zafotokozedwa zitha kugwiritsidwa ntchito pa pulogalamu iliyonse ya Microsoft Office.

Ndiye masitayilo mu Microsoft Excel ndi ati?

Mitundu mu Microsoft Excel ndi chida kufika pansi tabu Kunyumba (Kunyumba). Zimakupatsani mwayi wosankha masanjidwe okonzedweratu ku selo kapena gulu la ma cell ndikudina pang'ono.

Pali mndandanda wa masitayelo omwe adakhazikitsidwa kale ndi okonzeka kugwiritsidwa ntchito. Mukhoza kuwapeza mwa kungodina chizindikirocho. masitaelo (Masitayelo) monga momwe tawonera pachithunzi pamwambapa.

Mudzapatsidwa zosankha zingapo (onani chithunzi pansipa). M’chenicheni, zothandiza zake n’zokayikitsa. Koma musadandaule, ndizotheka kusintha masitayelo okonzedweratu kuti agwirizane ndi zosowa zanu, kapena, chosangalatsa kwambiri, pangani mawonekedwe anu amtundu wina! Tikhala pa izi mwatsatanetsatane mu gawo lachiwiri la nkhaniyi.

Kugwiritsa ntchito masitayelo mu Excel kumakupatsani chidaliro kuti masanjidwe ali pansi paulamuliro wanu. Kugwiritsa ntchito masitayelo kumakupulumutsirani nthawi yomwe mumawononga pamanja masanjidwe a tebulo ndikukupatsani chidziwitso chochulukirapo, makamaka mukamagwirira ntchito limodzi (tikambirana zambiri za ogwiritsa ntchito mtsogolomo).

Kodi muyenera kudziwa chiyani kuti mugwiritse ntchito masitayelo mu Microsoft Excel?

Mudzakhala okondwa kumva kuti palibe zofunikira zenizeni zogwiritsira ntchito masitayelo mu Microsoft Excel.

Zoonadi, ndizothandiza kudziwa bwino zokambirana zamapangidwe ndi mawonekedwe amunthu payekha, makamaka ngati mukufuna kupanga kalembedwe kanu, koma izi sizofunikira. M'malo mwake, chida ichi ndi chosavuta kugwiritsa ntchito, ngakhale kwa iwo omwe adayambitsa Excel koyamba!

Zosankha zomwe zilipo za masanjidwe zimakhala ndi ma cell asanu ndi limodzi, omwe amafanana ndi ma tabo asanu ndi limodzi mubokosi la zokambirana. Sakani Maselo (mtundu wa cell).

Titha kugwiritsa ntchito nambala iliyonse yamapangidwe omwe amapezeka pamtundu uliwonse, chofunikira kwambiri ndikukwanira m'malire omwe afotokozedwa ndi Microsoft Excel, omwe ali pafupifupi 4000 ma cell osiyanasiyana mubuku limodzi (kupewa uthenga wolakwika wa Excel womwe watchulidwa pamwambapa).

Zolemba Zomasulira: Kwa Excel 2003 ndi m'mbuyomo (.xls extension), chiwerengero chachikulu cha mawonekedwe omwe angasungidwe mufayilo ndi 4000 kuphatikiza kwapadera. Mu Excel 2007 ndi kenako (extension .xlsx), chiwerengerochi chawonjezeka kufika ku 64000 formats.

Ndikofunika kukumbukira kuti, monga macro, mawonekedwe atsopano a Microsoft amasiyana ndi buku. Izi zikutanthauza kuti zasungidwa mu bukhu linalake la ntchito ndipo zizipezeka mu bukhu lantchito mpaka mutalowetsa kalembedwe kake mu bukhu lina. Tiona mmene zimenezi zimachitikira m’chigawo chachiwiri cha nkhaniyi.

Momwe mungagwiritsire ntchito kalembedwe kake?

Kuti mugwiritse ntchito kalembedwe kokonzedweratu pama cell a Excel:

1. Sankhani ma cell omwe sitayelo ikuyenera kugwiritsidwa ntchito.
2. Tsegulani pa Microsoft Excel Ribbon: Kunyumba (Kunyumba) > masitaelo (Njira) > Mitundu yama cell (ma cell styles)

Malangizo othandiza! Chonde dziwani kuti posankha masitayelo, zowonera zolumikizana zimagwira ntchito - izi zikutanthauza kuti mukamayendayenda pazosankha zosiyanasiyana, maselo osankhidwa amasintha. Lingaliro labwino, Microsoft!

3. Sankhani masitayilo aliwonse amagulu podina ndi mbewa.

Ndichoncho! Maselo onse osankhidwa adzasinthidwa molingana ndi kalembedwe kosankhidwa!

Malangizo othandiza! Mukangofotokozera kalembedwe ka ma cell, kusintha chilichonse mwamapangidwe nthawi imodzi kudzakhala ntchito ya mphindi imodzi kwa inu, kuchepetsedwa kuti musinthe mawonekedwe, m'malo mokhala ndi maola obwerezabwereza ndikusintha pamanja mawonekedwe. mu tebulo!

Kwa aliyense amene ali ndi chidwi chophunzira zambiri za njira zapamwamba za Microsoft Excel, onani gawo lachiwiri la nkhani yanga.