Zamkatimu
Selo lililonse lili ndi mawonekedwe akeake omwe amakulolani kuti muzitha kusanthula zidziwitso mwanjira ina. Ndikofunikira kuyiyika bwino kuti mawerengedwe onse ofunikira achitike molondola. Kuchokera m'nkhaniyi muphunzira momwe mungasinthire mawonekedwe a ma cell mu Excel spreadsheet.
Mitundu yayikulu ya masanjidwe ndi kusintha kwawo
Pali mitundu khumi yoyambira:
- Wamba.
- Zandalama.
- Nambala.
- Zachuma.
- Zolemba.
- Tsiku.
- Nthawi.
- Small.
- Peresenti.
- zowonjezera
Mawonekedwe ena ali ndi ma subspecies awo owonjezera. Pali njira zingapo zosinthira mawonekedwe. Tiyeni tipende chilichonse mwatsatanetsatane.
Kugwiritsa ntchito menyu yankhani kuti musinthe mawonekedwe ndi imodzi mwa njira zomwe zimagwiritsidwa ntchito kwambiri. Kuyenda:
- Muyenera kusankha ma cell omwe mtundu womwe mukufuna kusintha. Timadina pa iwo ndi batani lakumanja la mbewa. Zosankha zapadera zatsegulidwa. Dinani pa chinthu "Format Maselo ...".
- Bokosi la mtundu lidzawonekera pazenera. Timapita ku gawo lotchedwa "Nambala". Samalani ku block "Mafomu a Nambala". Nawa mitundu yonse yomwe ilipo yomwe idaperekedwa pamwambapa. Timadina mtundu womwe umagwirizana ndi mtundu wa chidziwitso chomwe chimaperekedwa muselo kapena m'magulu osiyanasiyana. Kumanja kwa chipika cha mawonekedwe ndi mawonekedwe a subview. Mukapanga zokonda zonse, dinani "Chabwino".
- Okonzeka. Kusintha kwamtundu kwapambana.
Njira 2: Nambala bokosi lazida pa riboni
Chida cha riboni chili ndi zinthu zapadera zomwe zimakulolani kuti musinthe mawonekedwe a maselo. Kugwiritsa ntchito njirayi ndikothamanga kwambiri kuposa yoyambayo. Kuyenda:
- Timasinthira ku gawo la "Home". Kenako, sankhani cell yomwe mukufuna kapena ma cell angapo ndikutsegula bokosi losankhira mu block "Nambala".
- Zosankha zazikulu zamawonekedwe zidawululidwa. Sankhani yomwe mukufuna pagawo losankhidwa. Mapangidwe asintha.
- Ziyenera kumveka kuti mndandandawu uli ndi mawonekedwe akuluakulu okha. Kuti muwonjezere mndandanda wonse, muyenera dinani "Mawonekedwe ena a manambala".
- Mukadina pa chinthuchi, zenera lodziwika bwino liziwoneka ndi zosankha zonse zosinthira (zoyambira ndi zowonjezera).
Njira 3: "Maselo" bokosi lazida
Yotsatira mtundu kusintha njira ikuchitika kudzera chipika "Maselo". Kuyenda:
- Timasankha selo kapena maselo osiyanasiyana omwe timafuna kusintha. Timapita ku gawo la "Home", dinani "Format". Izi zili mu block "Maselo". Pamndandanda wotsikira pansi, dinani "Format Maselo ...".
- Zitatha izi, zenera losasintha lanthawi zonse lidawonekera. Timachita zonse zofunika, kusankha mtundu womwe tikufuna ndikudina "Chabwino".
Njira 4: ma hotkeys
Maselo amtundu amatha kusinthidwa pogwiritsa ntchito ma hotkey apadera a spreadsheet. Choyamba muyenera kusankha ma cell omwe mukufuna, ndiyeno dinani makiyi ophatikizira Ctrl + 1. Pambuyo pakusintha, zenera lodziwika bwino losintha lidzatsegulidwa. Monga njira zapita, sankhani mtundu womwe mukufuna ndikudina "Chabwino". Kuphatikiza apo, pali njira zazifupi za kiyibodi zomwe zimakupatsani mwayi wosintha mawonekedwe a cell popanda kuwonetsa bokosi lamtundu:
- Ctrl+Shift+-- general.
- Ctrl+Shift+1 - manambala okhala ndi koma.
- Ctrl+Shift+2 - nthawi.
- Ctrl+Shift+3 - tsiku.
- Ctrl+Shift+4 - ndalama.
- Ctrl+Shift+5 - peresenti.
- Ctrl+Shift+6 - O.OOE+00 mtundu.
Mawonekedwe a deti okhala ndi nthawi mu Excel ndi machitidwe 2 owonetsera
Mtundu wa deti ukhoza kusinthidwanso pogwiritsa ntchito zida za spreadsheet. Mwachitsanzo, tili ndi piritsi ili ndi zambiri. Tiyenera kuwonetsetsa kuti zisonyezo zomwe zili m'mizere zabweretsedwa ku mawonekedwe omwe akuwonetsedwa m'mayina amzawo.
M'gawo loyamba, mtunduwo umayikidwa bwino. Tiyeni tione gawo lachiwiri. Sankhani ma cell onse azizindikiro zagawo lachiwiri, dinani makiyi ophatikizira CTRL + 1, mugawo la "Nambala", sankhani nthawi, ndipo pagawo la "Mtundu", sankhani njira yowonetsera yogwirizana ndi chithunzi chotsatirachi:
Timachitanso chimodzimodzi ndi mizati yachitatu ndi yachinayi. Timayika mafomuwo ndi mitundu yowonetsera yomwe ikugwirizana ndi mayina omwe atchulidwa. Pali 2 machitidwe owonetsera masiku mu spreadsheet:
- Nambala 1 ndi Januware 1, 1900.
- Nambala 0 ndi Januware 1, 1904, ndipo nambala 1 ndi 02.01.1904/XNUMX/XNUMX.
Kusintha mawonekedwe a masiku kumachitika motere:
- Pitani ku "Fayilo".
- Dinani "Zosankha" ndikupita ku gawo la "Advanced".
- Mu block "Mukamawerengeranso bukuli", sankhani "Gwiritsani ntchito dongosolo la masiku a 1904".
Alignment Tab
Pogwiritsa ntchito tabu ya "Malumikizidwe", mutha kuyika malo omwe mtengowo uli mkati mwa cell ndi magawo angapo:
- kulowera;
- mopingasa;
- choongoka;
- wachibale pakati;
- ndi zina zotero.
Mwachikhazikitso, nambala yotayidwa mu selo imakhala yolondola, ndipo zolemba zimayikidwa kumanzere. Mu chipika cha "Malumikizidwe", tabu ya "Home", mutha kupeza zofunikira zosinthira.
Mothandizidwa ndi zinthu za riboni, mutha kusintha mawonekedwe, kukhazikitsa malire ndikusintha kudzaza. Mukungoyenera kusankha selo kapena ma cell angapo ndikugwiritsa ntchito chida chapamwamba kuti muyike makonda onse omwe mukufuna.
Ndikusintha mawu
Tiyeni tiwone njira zingapo zosinthira malemba m'maselo kuti apange matebulo omwe ali ndi chidziwitso chowerengeka momwe angathere.
Momwe mungasinthire mafonti a Excel
Tiyeni tiwone njira zingapo zosinthira mawonekedwe:
- Njira imodzi. Sankhani selo, pitani ku gawo la "Home" ndikusankha chinthu cha "Font". Mndandanda umatsegulidwa pomwe wogwiritsa ntchito aliyense angasankhe yekha font yoyenera.
- Njira yachiwiri. Sankhani selo, dinani pomwepa. Menyu yankhani ikuwonetsedwa, ndipo pansi pake pali zenera laling'ono lomwe limakupatsani mwayi wopanga mawonekedwe.
- Njira yachitatu. Sankhani selo ndikugwiritsa ntchito kuphatikiza kiyi Ctrl + 1 kuti muyitane "Maselo a Format". Pazenera lomwe likuwoneka, sankhani gawo la "Font" ndikupanga zosintha zonse zofunika.
Momwe Mungasankhire Masitayilo a Excel
Masitayelo olimba, mopendekera, ndi pansi pamizere amagwiritsidwa ntchito kuwunikira mfundo zofunika pamatebulo. Kuti musinthe mawonekedwe a cell yonse, muyenera kudina ndi batani lakumanzere. Kuti musinthe gawo lokha la selo, muyenera kudina kawiri pa selo, kenako sankhani gawo lomwe mukufuna kupanga. Mukasankha, sinthani kalembedwe pogwiritsa ntchito imodzi mwa njira izi:
- Kugwiritsa ntchito zosakaniza zazikulu:
- Ctrl + B - molimba mtima;
- Ctrl+I - italic;
- Ctrl + U - kutsindika;
- Ctrl + 5 - kuwoloka;
- Ctrl+= - subscript;
- Ctrl+Shift++ - superscript.
- Kugwiritsa ntchito zida zomwe zili mu "Font" block ya "Home" tabu.
- Pogwiritsa ntchito bokosi la Format Cells. Apa mutha kukhazikitsa zokonda zomwe mukufuna mugawo la "Sinthani" ndi "Zolemba".
Kuyanjanitsa mawu m'maselo
Kuyanjanitsa kwa mawu m'maselo kumachitika ndi njira izi:
- Pitani ku gawo la "Kulinganiza" la gawo la "Home". Apa, mothandizidwa ndi zithunzi, mutha kugwirizanitsa deta.
- M'bokosi la "Format Cells", pitani ku gawo la "Malumikizidwe". Apa mutha kusankhanso mitundu yonse yomwe ilipo.
Sinthani mawu mu Excel
Tcherani khutu! Mawu aatali omwe alowetsedwa mu selo mwina sangakwanemo ndiyeno adzawonetsedwa molakwika. Pali zosintha zokha kuti mupewe vutoli.
Njira ziwiri zopangira autoformating:
- Kugwiritsa ntchito kukulunga mawu. Sankhani ma cell omwe mukufuna, pitani ku gawo la "Home", kenako ku "Alignment" block ndikusankha "Sungani Zolemba". Kutsegula gawoli kumakupatsani mwayi woti mugwiritse ntchito kukulunga kwa mawu ndikuwonjezera kutalika kwa mzere.
- Kugwiritsa ntchito AutoFit. Pitani ku bokosi la "Format Cells", kenako "Malumikizidwe" ndikuwona bokosi pafupi ndi "AutoFit Width".
Momwe mungaphatikizire ma cell mu Excel
Nthawi zambiri, pogwira ntchito ndi matebulo, zimakhala zofunikira kuphatikiza ma cell. Izi zitha kuchitika pogwiritsa ntchito batani la "Gwirizanitsani ndi Pakati", lomwe lili mugawo la "Alignment" la gawo la "Home". Kugwiritsa ntchito njirayi kudzaphatikiza ma cell onse osankhidwa. Makhalidwe amkati mwamaselo amagwirizana ndi pakati.
Kusintha Kayendetsedwe ndi Kayendetsedwe ka Mawu
Kayendetsedwe ka mameseji ndi mawonekedwe ndi zokonda ziwiri zosiyana zomwe ogwiritsa ntchito ena amasokoneza wina ndi mnzake. Pachithunzichi, gawo loyamba limagwiritsa ntchito njira yolowera, ndipo gawo lachiwiri limagwiritsa ntchito malangizo:
Popita ku gawo la "Home", "Alignment" block ndi "Orientation", mutha kugwiritsa ntchito magawo awiriwa.
Kugwira ntchito ndi Mawonekedwe a Ma cell a Excel
Kugwiritsa ntchito masitayelo a masanjidwe kumatha kufulumizitsa kwambiri njira yopangira tebulo ndikupangitsa kuti ikhale yokongola.
Chifukwa Chake Masitayelo Otchulidwa Ndi Ofunika
Zolinga zazikulu zogwiritsira ntchito masitayelo:
- Pangani masitayelo apadera kuti musinthe mitu, mitu yaing'ono, mawu, ndi zina zambiri.
- Kugwiritsa ntchito masitayelo opangidwa.
- Makina ogwiritsira ntchito ndi data, popeza pogwiritsa ntchito kalembedwe, mutha kupanga zonse zomwe mwasankha.
Kugwiritsa ntchito masitayelo ku ma cell sheet
Pali mitundu yambiri ya masitaelo ophatikizika opangidwa kale mu purosesa ya spreadsheet. Ndondomeko ya sitepe ndi sitepe yogwiritsira ntchito masitayelo:
- Pitani ku "Home" tabu, pezani chipika cha "Mawonekedwe a Ma cell".
- Laibulale ya masitaelo okonzeka ikuwonetsedwa pazenera.
- Sankhani cell yomwe mukufuna ndikudina pamayendedwe omwe mumakonda.
- Mtunduwu wagwiritsidwa ntchito ku selo. Mukangoyang'ana mbewa yanu pamndandanda womwe mukufuna, koma osadina, mutha kuwona momwe idzawonekere.
Kupanga Masitayilo Atsopano
Nthawi zambiri, ogwiritsa ntchito alibe masitayelo okwanira opangidwa kale, ndipo amayamba kupanga zawo. Mutha kupanga mawonekedwe anu apadera motere:
- Sankhani selo iliyonse ndikuikonza. Tipanga masitayilo kutengera masanjidwe awa.
- Pitani ku gawo la "Home" ndikusunthira ku block "Mawonekedwe a Ma cell". Dinani "Pangani Mawonekedwe a Ma cell". Zenera lotchedwa "Style" limatsegulidwa.
- Lowetsani "Dzina Lamtundu uliwonse".
- Timayika magawo onse ofunikira omwe mukufuna kuyika pamayendedwe opangidwa.
- Timadina "Chabwino".
- Tsopano mawonekedwe anu apadera awonjezedwa ku laibulale ya kalembedwe, yomwe ingagwiritsidwe ntchito m'chikalatachi.
Kusintha Masitayelo Adalipo
Masitayilo okonzeka omwe ali mulaibulale amatha kusinthidwa paokha. Kuyenda:
- Pitani ku gawo la "Home" ndikusankha "Mawonekedwe a Ma cell".
- Dinani kumanja pamalembedwe omwe mukufuna kusintha ndikudina Sinthani.
- Zenera la Style limatsegulidwa.
- Dinani "Format" ndi kuwonetseredwa zenera "Format Maselo" kusintha masanjidwe. Pambuyo pochita zosintha zonse, dinani "Chabwino".
- Dinani Chabwino kachiwiri kuti mutseke bokosi la Style. Kusintha kwa kalembedwe komalizidwa kwatha, tsopano kutha kugwiritsidwa ntchito pazolemba.
Kusamutsa Masitayelo ku Bukhu Lina
Zofunika! Mtundu wopangidwa ukhoza kugwiritsidwa ntchito muzolemba zomwe zidapangidwira, koma pali mawonekedwe apadera omwe amakulolani kusamutsa masitayilo ku zolemba zina.
Kuyenda:
- Timadula chikalata chomwe masitayelo opangidwa alimo.
- Kuphatikiza apo, tsegulani chikalata china chomwe tikufuna kusamutsa kalembedwe kameneka.
- Pachikalata chokhala ndi masitayelo, pitani ku tabu ya "Home" ndikupeza chipika cha "Masitayelo a Ma cell".
- Dinani "Konzani". Zenera lotchedwa "Merge Styles" linawonekera.
- Zenera ili lili ndi mndandanda wa zolemba zonse zotsegula za spreadsheet. Sankhani chikalata chimene mukufuna kusamutsa analenga kalembedwe ndi kumadula "Chabwino" batani. Okonzeka!
Kutsiliza
Pali njira zambiri zomwe zimakulolani kuti musinthe mawonekedwe a cell mu spreadsheet. Chifukwa cha izi, munthu aliyense wogwira ntchito mu pulogalamuyi akhoza kusankha yekha njira yabwino yothetsera mavuto ena.