Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys

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:

  1. Wamba.
  2. Zandalama.
  3. Nambala.
  4. Zachuma.
  5. Zolemba.
  6. Tsiku.
  7. Nthawi.
  8. Small.
  9. Peresenti.
  10. zowonjezera

Mawonekedwe ena ali ndi ma subspecies awo owonjezera. Pali njira zingapo zosinthira mawonekedwe. Tiyeni tipende chilichonse mwatsatanetsatane.

Njira 1: menyu yankhani

Kugwiritsa ntchito menyu yankhani kuti musinthe mawonekedwe ndi imodzi mwa njira zomwe zimagwiritsidwa ntchito kwambiri. Kuyenda:

  1. 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 ...".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
1
  1. 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".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
2
  1. 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:

  1. Timasinthira ku gawo la "Home". Kenako, sankhani cell yomwe mukufuna kapena ma cell angapo ndikutsegula bokosi losankhira mu block "Nambala".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
3
  1. Zosankha zazikulu zamawonekedwe zidawululidwa. Sankhani yomwe mukufuna pagawo losankhidwa. Mapangidwe asintha.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
4
  1. Ziyenera kumveka kuti mndandandawu uli ndi mawonekedwe akuluakulu okha. Kuti muwonjezere mndandanda wonse, muyenera dinani "Mawonekedwe ena a manambala".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
5
  1. Mukadina pa chinthuchi, zenera lodziwika bwino liziwoneka ndi zosankha zonse zosinthira (zoyambira ndi zowonjezera).
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
6

Njira 3: "Maselo" bokosi lazida

Yotsatira mtundu kusintha njira ikuchitika kudzera chipika "Maselo". Kuyenda:

  1. 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 ...".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
7
  1. 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.

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
8

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:

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
9

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:

  1. Nambala 1 ndi Januware 1, 1900.
  2. Nambala 0 ndi Januware 1, 1904, ndipo nambala 1 ndi 02.01.1904/XNUMX/XNUMX.

Kusintha mawonekedwe a masiku kumachitika motere:

  1. Pitani ku "Fayilo".
  2. Dinani "Zosankha" ndikupita ku gawo la "Advanced".
  3. 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.

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
10

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:

  1. Njira imodzi. Sankhani selo, pitani ku gawo la "Home" ndikusankha chinthu cha "Font". Mndandanda umatsegulidwa pomwe wogwiritsa ntchito aliyense angasankhe yekha font yoyenera.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
11
  1. Njira yachiwiri. Sankhani selo, dinani pomwepa. Menyu yankhani ikuwonetsedwa, ndipo pansi pake pali zenera laling'ono lomwe limakupatsani mwayi wopanga mawonekedwe.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
12
  1. 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 mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
13

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:

  1. Kugwiritsa ntchito zosakaniza zazikulu:
  • Ctrl + B - molimba mtima;
  • Ctrl+I - italic;
  • Ctrl + U - kutsindika;
  • Ctrl + 5 - kuwoloka;
  • Ctrl+= - subscript;
  • Ctrl+Shift++ - superscript.
  1. Kugwiritsa ntchito zida zomwe zili mu "Font" block ya "Home" tabu.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
14
  1. Pogwiritsa ntchito bokosi la Format Cells. Apa mutha kukhazikitsa zokonda zomwe mukufuna mugawo la "Sinthani" ndi "Zolemba".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
15

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.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
16
  • M'bokosi la "Format Cells", pitani ku gawo la "Malumikizidwe". Apa mutha kusankhanso mitundu yonse yomwe ilipo.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
17

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:

  1. 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.
  2. 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.

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
18

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:

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
19

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.

Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
20

Chifukwa Chake Masitayelo Otchulidwa Ndi Ofunika

Zolinga zazikulu zogwiritsira ntchito masitayelo:

  1. Pangani masitayelo apadera kuti musinthe mitu, mitu yaing'ono, mawu, ndi zina zambiri.
  2. Kugwiritsa ntchito masitayelo opangidwa.
  3. 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:

  1. Pitani ku "Home" tabu, pezani chipika cha "Mawonekedwe a Ma cell".
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
21
  1. Laibulale ya masitaelo okonzeka ikuwonetsedwa pazenera.
  2. Sankhani cell yomwe mukufuna ndikudina pamayendedwe omwe mumakonda.
  3. 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:

  1. Sankhani selo iliyonse ndikuikonza. Tipanga masitayilo kutengera masanjidwe awa.
  2. Pitani ku gawo la "Home" ndikusunthira ku block "Mawonekedwe a Ma cell". Dinani "Pangani Mawonekedwe a Ma cell". Zenera lotchedwa "Style" limatsegulidwa.
Momwe mungasinthire mawonekedwe a cell mu Excel. Kupyolera mu mndandanda wa nkhani, zida ndi hotkeys
22
  1. Lowetsani "Dzina Lamtundu uliwonse".
  2. Timayika magawo onse ofunikira omwe mukufuna kuyika pamayendedwe opangidwa.
  3. Timadina "Chabwino".
  4. 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:

  1. Pitani ku gawo la "Home" ndikusankha "Mawonekedwe a Ma cell".
  2. Dinani kumanja pamalembedwe omwe mukufuna kusintha ndikudina Sinthani.
  3. Zenera la Style limatsegulidwa.
  4. Dinani "Format" ndi kuwonetseredwa zenera "Format Maselo" kusintha masanjidwe. Pambuyo pochita zosintha zonse, dinani "Chabwino".
  5. 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:

  1. Timadula chikalata chomwe masitayelo opangidwa alimo.
  2. Kuphatikiza apo, tsegulani chikalata china chomwe tikufuna kusamutsa kalembedwe kameneka.
  3. Pachikalata chokhala ndi masitayelo, pitani ku tabu ya "Home" ndikupeza chipika cha "Masitayelo a Ma cell".
  4. Dinani "Konzani". Zenera lotchedwa "Merge Styles" linawonekera.
  5. 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.

Siyani Mumakonda