Kupanga matebulo mu Excel. Momwe Mungasankhire Matebulo - Gawo ndi Gawo Buku

Kupanga ndi imodzi mwazinthu zazikulu mukamagwira ntchito ndi spreadsheet. Pogwiritsa ntchito masanjidwe, mutha kusintha mawonekedwe a data ya tabular, komanso kusankha ma cell. Ndikofunikira kuti muzitha kuzigwiritsa ntchito moyenera kuti mugwire ntchito yanu mu pulogalamuyi mwachangu komanso moyenera. Kuchokera m'nkhaniyi muphunzira momwe mungapangire tebulo molondola.

Mapangidwe a Table

Kupanga ndizinthu zomwe zimafunikira kusintha mawonekedwe a tebulo ndi zizindikiro mkati mwake. Njirayi imakulolani kuti musinthe kukula kwa font ndi mtundu, kukula kwa selo, kudzaza, mawonekedwe, ndi zina zotero. Tiyeni tiwunike chinthu chilichonse mwatsatanetsatane.

Zosintha zokha

Autoformatting itha kugwiritsidwa ntchito pama cell amtundu uliwonse. Purosesa ya spreadsheet idzasintha payokha mndandanda wosankhidwa, kugwiritsa ntchito magawo omwe apatsidwa. Kuyenda:

1. Timasankha selo, maselo osiyanasiyana kapena tebulo lonse.

2. Pitani ku gawo la "Home" ndikudina "Format as Table". Mutha kupeza izi mu block "Styles". Mukadina, zenera lomwe lili ndi masitayelo okonzeka okonzeka limawonekera. Mutha kusankha masitayelo aliwonse. Dinani pa njira yomwe mumakonda.

3. Zenera laling'ono lidawonetsedwa pazenera, zomwe zimafuna kutsimikizira kulondola kwa ma coordinates omwe adalowetsedwa. Ngati muwona kuti pali zolakwika mumtundu, mukhoza kusintha deta. Muyenera kuganizira mosamala chinthucho "Table with headers." Ngati tebulo lili ndi mitu, ndiye kuti katunduyu ayenera kufufuzidwa. Mukapanga zokonda zonse, dinani "Chabwino".

4. Okonzeka! Mbale yatenga maonekedwe a kalembedwe kamene mwasankha. Nthawi iliyonse, kalembedwe kameneka kakhoza kusinthidwa kukhala wina.

Kusintha kwa masanjidwe

Kuthekera kwa masanjidwe odzipangira okha sikufanana ndi onse ogwiritsa ntchito purosesa ya spreadsheet. Ndizotheka kupanga pamanja mbale pogwiritsa ntchito magawo apadera. Mutha kusintha mawonekedwewo pogwiritsa ntchito menyu yankhani kapena zida zomwe zili pa riboni. Kuyenda:

1. Timasankha malo oyenera kusintha. Dinani pa izo RMB. Menyu yankhani ikuwonetsedwa pazenera. Dinani pa "Format Maselo ...".

2. Bokosi lotchedwa "Format Cells" limapezeka pa zenera. Pano mukhoza kuchita zosiyanasiyana tabular deta kusintha mpheto.

Gawo la Home lili ndi zida zosiyanasiyana zojambulira. Kuti muwagwiritse ntchito m'maselo anu, muyenera kuwasankha, kenako dinani iliyonse ya iwo.

Kusintha kwa Data

Mawonekedwe a cell ndi amodzi mwazinthu zoyambira kupanga. Izi sizimangosintha mawonekedwe, komanso zimauza purosesa ya spreadsheet momwe angagwiritsire ntchito selo. Monga momwe zidalili m'mbuyomu, izi zitha kuchitika kudzera pazosankha kapena zida zomwe zili mu riboni yapadera ya tabu Yanyumba.

Mwa kutsegula zenera la "Format Cells" pogwiritsa ntchito menyu yankhaniyo, mutha kusintha mawonekedwewo kudzera pagawo la "Number Formats", lomwe lili mu "Number" block. Apa mutha kusankha imodzi mwamawonekedwe awa:

• tsiku;
• nthawi;
• wamba;
• manambala;
• zolemba, etc.

Pambuyo kusankha chofunika mtundu, alemba "Chabwino".

Kuphatikiza apo, mawonekedwe ena ali ndi zosankha zina. Posankha mtundu wa nambala, mutha kusintha kuchuluka kwa manambala pambuyo pa nambala ya decimal pa manambala ang'onoang'ono.

Pokhazikitsa mtundu wa "Date", mutha kusankha momwe tsikulo lidzawonekere pazenera. "Nthawi" parameter ili ndi zoikamo zomwezo. Mukadina chinthu cha "Mafomu Onse", mutha kuwona mitundu yonse yamitundu yosinthira muselo.

Mwa kupita ku gawo la "Home" ndikukulitsa mndandanda womwe uli mu "Nambala" block, mutha kusinthanso mawonekedwe a cell kapena ma cell angapo. Mndandandawu uli ndi mitundu yonse yayikulu.

Mukadina chinthucho "Mawonekedwe ena a manambala ..." zenera lodziwika kale "Mawonekedwe a Ma cell" liziwonetsedwa, momwe mungapangire zosintha zatsatanetsatane zamtunduwo.

Kugwirizana kwazinthu

Popita ku bokosi la "Format Cells", ndiyeno ku gawo la "Kulinganiza", mukhoza kupanga zowonjezera zowonjezera kuti mawonekedwe a mbale awonekere. Zenerali lili ndi zoikamo zambiri. Poyang'ana bokosi pafupi ndi gawo limodzi kapena lina, mutha kuphatikiza ma cell, kukulunga mawu ndi mawu, ndikuyikanso kusankha m'lifupi mwake.

Kuphatikiza apo, mu gawoli, mutha kugwiritsa ntchito malo alemba mkati mwa cell. Pali kusankha kwa mawu owuma ndi opingasa.

Mugawo la "Orientation", mutha kusintha momwe mungakhazikitsire zolemba zomwe zili mkati mwa cell.

Mu gawo la "Home" pali chipika cha zida "Kulinganiza". Apa, monga mu "Format Maselo" zenera, pali deta mayikidwe zoikamo, koma kwambiri cropped mawonekedwe.

Kuyika mafonti

Gawo la "Font" limakupatsani mwayi wochita zinthu zambiri kuti musinthe zambiri mu cell yosankhidwa kapena ma cell angapo. Apa mutha kusintha zotsatirazi:

• choyimira;
• kukula;
• Mtundu;
• style, etc.

Pa riboni yapadera pali chipika cha zida "Font", zomwe zimakulolani kuti musinthe zomwezo.

Malire ndi mizere

Mu gawo la "Border" pawindo la "Format Cells", mutha kusintha mitundu ya mzere, komanso kukhazikitsa mtundu womwe mukufuna. Pano mukhoza kusankha kalembedwe ka malire: kunja kapena mkati. N'zotheka kuchotsa kwathunthu malire ngati sakufunika patebulo.

Tsoka ilo, palibe zida zosinthira malire a tebulo pamwamba pa riboni, koma pali chinthu chaching'ono chomwe chili mu block "Font".

Kudzaza ma cell

Mugawo la "Dzazani" la bokosi la "Format Cells", mukhoza kusintha mtundu wa maselo a tebulo. Pali mwayi wowonjezera wowonetsa mitundu yosiyanasiyana.

Monga momwe zilili m'mbuyomu, pali batani limodzi lokha pazida, lomwe lili mu block "Font".

Zimachitika kuti wogwiritsa ntchito alibe mithunzi yokwanira yogwira ntchito ndi chidziwitso cha tabular. Pakadali pano, muyenera kupita kugawo la "mitundu ina ..." kudzera pa batani lomwe lili mu block "Font". Mukadina, zenera limawonekera lomwe limakupatsani mwayi wosankha mtundu wina.

Mitundu yama cell

Simungathe kuyika kalembedwe ka selo nokha, komanso kusankha kuchokera kuzomwe zimaphatikizidwa mu spreadsheet yokha. Laibulale ya masitaelo ndi yayikulu, kotero wogwiritsa ntchito aliyense azitha kusankha masitayilo oyenera.

Kuyenda:

1. Sankhani maselo ofunikira kuti mugwiritse ntchito kalembedwe komalizidwa.
2. Pitani ku gawo la "Home".
3. Dinani "Mawonekedwe a Ma cell".
4. Sankhani masitayilo omwe mumakonda.

Chitetezo cha data

Chitetezo chimakhalanso chamtundu wa masanjidwe. Pazenera lodziwika bwino la "Maselo a Format", pali gawo lotchedwa "Chitetezo". Apa mutha kukhazikitsa njira zachitetezo zomwe zingaletse kusintha ma cell omwe asankhidwa. Komanso apa mutha kuloleza kubisa mafomu.

Pa riboni ya zida za gawo la Home, mu block ya Maselo, pali chinthu cha Format chomwe chimakulolani kuti muchite masinthidwe ofanana. Mwa kuwonekera pa "Format", chinsalu chidzawonetsa mndandanda womwe chinthu cha "Chitetezo" chilipo. Mwa kuwonekera pa "Tetezani pepala ...", mutha kuletsa kusintha chikalata chonse chomwe mukufuna.

Mitu yamndandanda

Mu Excel spreadsheet, komanso mawu processor Word, mukhoza kusankha mutu wa chikalatacho.

Kuyenda:

1. Pitani ku tabu "Mapangidwe a Tsamba".
2. Dinani pa "Themes".
3. Sankhani imodzi mwamitu yomwe yapangidwa kale.

Kusintha kukhala "Smart Table"

Gome la "smart" ndi mtundu wapadera wa mapangidwe, pambuyo pake gulu la selo limalandira zinthu zina zothandiza zomwe zimapangitsa kuti zikhale zosavuta kugwira ntchito ndi deta yambiri. Pambuyo pa kutembenuka, kuchuluka kwa maselo kumaganiziridwa ndi pulogalamuyo ngati chinthu chonsecho. Kugwiritsa ntchito ntchitoyi kumapulumutsa ogwiritsa ntchito kuti asawerengenso ma formula atawonjezera mizere yatsopano patebulo. Kuphatikiza apo, tebulo la "Smart" lili ndi mabatani apadera pamitu yomwe imakulolani kusefa deta. Ntchitoyi imapereka mwayi wokhomerera mutu wa tebulo pamwamba pa pepala. Kusintha kukhala "Smart Table" kumachitika motere:

1. Sankhani malo ofunikira kuti musinthe. Pazida, sankhani chinthu cha "Styles" ndikudina "Format as Table".

2. Chophimba chimasonyeza mndandanda wa masitayelo okonzeka omwe ali ndi magawo omwe adakhazikitsidwa kale. Dinani pa njira yomwe mumakonda.

3. Iwindo lothandizira lidawoneka lokhala ndi zoikamo zamitundu yosiyanasiyana ndi mawonetsedwe a mitu. Timayika magawo onse ofunikira ndikudina batani "Chabwino".

4. Titapanga zoikamo izi, piritsi yathu idasandulika kukhala Smart Table, yomwe ndiyosavuta kugwiritsa ntchito.

Table Formating Chitsanzo

Tiyeni titenge chitsanzo chophweka cha momwe mungapangire tebulo sitepe ndi sitepe. Mwachitsanzo, tapanga tebulo motere:

Tsopano tiyeni tipitirire kukusintha kwake mwatsatanetsatane:

1. Tiyeni tiyambe ndi mutu. Sankhani mtundu A1 ... E1, ndikudina "Gwirizanitsani ndikusunthira pakati." Chinthuchi chili mu gawo la "Formatting". Maselo amaphatikizidwa ndipo mawu amkati amalumikizana pakati. Khazikitsani font kukhala "Arial", kukula kwa "16", "Bold", "Underlined", mtundu wamtundu kukhala "Purple".
2. Tiyeni tipitirire pakukonza mitu yandalama. Sankhani ma cell A2 ndi B2 ndikudina "Phatikizani Maselo". Timachita zofanana ndi ma cell A7 ndi B7. Timayika zidziwitso zotsatirazi: font - "Arial Black", kukula - "12", kuyanjanitsa - "Kumanzere", mthunzi wazithunzi - "Purple".
3. Timasankha C2 ... E2, tikugwira "Ctrl", timasankha C7 ... E7. Apa timayika magawo otsatirawa: font - "Arial Black", kukula - "8", kuyanjanitsa - "Centered", mtundu wamtundu - "Purple".
4. Tiyeni tipitirire kukonza zolemba. Timasankha zizindikiro zazikulu za tebulo - awa ndi maselo A3 ... E6 ndi A8 ... E8. Timayika magawo otsatirawa: font - "Arial", "11", "Bold", "Centered", "Blue".
5. Gwirizanitsani kumanzere kwa B3 ... B6, komanso B8.
6. Timawulula mtundu wofiira mu A8 ... E8.
7. Timasankha D3 ... D6 ndikusindikiza RMB. Dinani "Format Maselo ...". Pazenera lomwe likuwoneka, sankhani mtundu wa data ya manambala. Timachita zofanana ndi selo D8 ndikuyika manambala atatu pambuyo pa decimal.
8. Tiyeni tipitirire pakukonza malire. Timasankha A8 ... E8 ndikudina "Malire Onse". Tsopano sankhani "Thick Outer Border". Kenako, timasankha A2 ... E2 ndikusankhanso "Malire akunja okhuthala". Momwemonso, timapanga A7 ... E7.
9. Timayika mitundu. Sankhani D3…D6 ndikusankha mtundu wa turquoise wowala. Timasankha D8 ndikuyika utoto wonyezimira wachikasu.
10. Timapitiriza kuyika chitetezo pa chikalatacho. Timasankha selo D8, dinani kumanja kwake ndikudina "Maselo a Format". Apa timasankha chinthu cha "Chitetezo" ndikuyika chizindikiro pafupi ndi chinthu cha "Protected cell".
11. Timasunthira ku mndandanda waukulu wa pulogalamu ya spreadsheet ndikupita ku gawo la "Service". Kenako timapita ku "Chitetezo", komwe timasankha chinthu "Tetezani Mapepala". Kuyika mawu achinsinsi ndi chinthu chomwe mungafune, koma mutha kuyiyika ngati mukufuna. Tsopano selo ili silingasinthidwe.

Muchitsanzo ichi, tapenda mwatsatanetsatane momwe mungapangire tebulo mu spreadsheet sitepe ndi sitepe. Zotsatira za masanjidwe zikuwoneka motere:

Monga tikuonera, chizindikirocho chasintha kwambiri kuchokera kunja. Maonekedwe ake akhala omasuka komanso owoneka bwino. Mwa zochita zofananira, mutha kupanga mwamtheradi tebulo lililonse ndikuyika chitetezo kuti lisasinthidwe mwangozi. Njira yosinthira pamanja ndiyothandiza kwambiri kuposa kugwiritsa ntchito masitayelo omwe tafotokozeratu, popeza mutha kukhazikitsa pamanja magawo apadera amtundu uliwonse wa tebulo.

Kutsiliza

Purosesa ya spreadsheet ili ndi zosintha zambiri zomwe zimakulolani kuti musinthe deta. Pulogalamuyi ili ndi masitayelo okonzeka okonzeka omwe ali ndi zosankha zosintha, ndipo kudzera pazenera la "Format Cells", mutha kukhazikitsa zokonda zanu pamanja.