Lattice m'malo mwa manambala mu Excel. Zoyenera kuchita ngati ma lattice akuwonetsedwa m'malo mwa manambala mu Excel

Nthawi zambiri zimachitika kuti polowa mu Microsoft Excel, zilembo zapadera, monga zizindikiro za mapaundi, zimawonetsedwa m'malo mwa manambala ena. Izi zimalepheretsa kugwira ntchito kwa chikalata chamagetsi, kotero muyenera kudziwa momwe mungakonzere vutoli. Nkhaniyi ikupereka njira zingapo zothandiza zothetsera vutoli mwamsanga.

Zifukwa za maonekedwe a lattices

Maselo a lattice amawonekera pamene chiwerengero cha zilembo zomwe zalowamo zimadutsa malire. Nthawi yomweyo, pulogalamuyo imakumbukira zomwe mudalemba, koma siziwonetsa bwino mpaka kuchuluka kwa zilembo zitachotsedwa. Ngati polowetsa manambala mu cell Excel 2003 idaposa chiwerengero cha mayunitsi 255, iwonetsa octothorp m'malo mwa manambala. Izi ndizomwe zimatchedwa lattice m'chinenero cha mapulogalamu.

Momwemonso, malembawo adziwonetsera okha ngati mulowetsa mu selo la mtundu waposachedwa. Chiwerengero chachikulu cha zilembo zomwe zimaloledwa mu gawo la Excel 2007 ndi 1024. Izi ndizofanana ndi zomwe zili mu Excel isanafike 2010. Mabaibulo atsopano saperekanso malire. Komanso, zifukwa zikhoza kukhala:

• kukhalapo kwa zolakwika za galamala m'malemba kapena zilembo zosavomerezeka;
• ndalama zowerengedwa molakwika;
• kugwiritsa ntchito molakwika mafomu ndi kuwerengera kolakwika m'maselo;
• zolephera pamlingo wa pulogalamu (izi zimatsimikiziridwa motere: ngati mukamayendayenda pa selo, zonse zikuwonetsedwa bwino, ndipo mukasindikiza "Enter", mtengowo umasanduka octotorp, ndiye kuti akadali chiwerengero chowonjezera cha zilembo. ).

Tcherani khutu! Mawonekedwe a mipiringidzo m'magawo a Excel atha kukhala chifukwa cha kusanjika kwa kiyibodi molakwika.

Komanso, vuto lofananalo litha kuwoneka ngati mayina amafoni olakwika asankhidwa kuti afotokoze mwachidule deta. Mutha kuthetsa vutoli ndikuwonetsa zambiri zanu pogwiritsa ntchito njira zingapo zothandiza.

Yankho

Kungochotsa chiwerengero chowonjezera cha zilembo sikokwanira. Muyenera kugwiritsa ntchito njira zomwe zimapangitsa kuti zilembo zolakwika zizisowa. Tiyeni tichoke ku zosavuta kupita ku zovuta.

Njira 1: kukulitsa malire pamanja

Kukulitsa malire mu Microsoft Excel, ndikokwanira kuwatambasula pamanja. Iyi ndi njira yodalirika komanso yosavuta yomwe ingathandize kuthetsa vutoli ngakhale kwa oyamba kumene omwe adagwiritsa ntchito ntchito ya ofesi.. Tsatirani malangizo:

1. Pazenera la Microsoft Excel lomwe limatsegulidwa, dinani pa cell yomwe mipiringidzo idawonekera.
2. Sunthani cholozera kumalire akumanja, pomwe dzina la selo lakhazikitsidwa. Malire a cell amathanso kutambasulidwa kumanzere, koma mbali iyi, maselo omwe ali kutsogolo adzasinthidwa.

3. Tikudikirira cholozera kuti chitenge mawonekedwe a mivi iwiri. Kenako dinani pamalire ndikukoka mpaka malowo mpaka zilembo zonse ziwonekere.
4. Kumapeto kwa ndondomekoyi, ma lattice onse adzawonetsedwa mu mawonekedwe a manambala omwe adalowa kale.

Njira iyi imagwira ntchito m'mitundu yonse ya Excel.

Njira 2: Kuchepetsa Mafonti

Yankho loyamba la vutoli ndiloyenera kwambiri pazochitikazo pamene mizati 2-3 yokha imakhala pa pepala ndipo palibe deta yambiri. Koma kuti mukonze zilembo zapadera mu e-book pamlingo waukulu, muyenera kugwiritsa ntchito malangizo omwe ali pansipa.

1. Timasankha selo kapena ma cell angapo momwe timafuna kuti tiwone mwatsatanetsatane za manambala.

2. Timaonetsetsa kuti tili mu "Home" tabu, ngati sichoncho, ndiye dinani pamwamba pa tsamba. Mu gawo la "Font", timapeza kukula kwake ndikuchepetsa mpaka chiwerengero chofunikira cha zilembo chikuwonetsedwa m'maselo mumtundu wofunikira wa digito. Kuti musinthe font, mutha kungolowetsa kukula kwake m'gawo loyenera.

Zolemba! Mukakonza font ndikusintha mawonekedwe, seloyo imatenga m'lifupi mwake momwe imayenderana ndi nambala yayitali kwambiri yomwe yalembedwa mkati mwake.

Njira 3: kukula kwapawiri

Kusintha font m'maselo kumapezekanso m'njira yomwe ili pansipa. Zimaphatikizapo kusankha m'lifupi pogwiritsa ntchito zida zomangira za Microsoft Excel.

1. Muyenera kuwunikira ma cell omwe amafunikira masanjidwe (ndiko kuti, omwe ali ndi zilembo zosavomerezeka m'malo mwa manambala). Kenako, dinani kumanja pa kachidutswa osankhidwa ndi pop-up zenera kupeza Format Maselo chida. M'matembenuzidwe akale a Excel, menyu amatha kusintha malo a zida.

2. Pazenera lomwe likuwoneka, sankhani gawo la "Kulinganiza". Tidzagwira nawo ntchito m'tsogolomu, ndikuyika chizindikiro kutsogolo kwa "Auto-fit width". Ili pansipa mu block "Zowonetsa". Pamapeto pake, dinani batani "Chabwino". Pambuyo pazomwe zachitika, zikhalidwe zimatsika ndikupeza mawonekedwe ofanana ndi kukula kwazenera mu e-book.

Njira imeneyi ndi yabwino kwambiri ndipo imasiyanitsidwa ndi mphamvu zake. Mutha kupanga pepala la Excel moyenera mumasekondi pang'ono.

Tcherani khutu! Njira zonse zosinthira ndizovomerezeka pokhapokha ngati ndinu wolemba fayiloyo kapena ili lotseguka kuti lisinthidwe.

Njira 4: Kusintha manambala

Njirayi ndi yoyenera kwa iwo omwe amagwiritsa ntchito mtundu wakale wa Microsoft Excel. Zoona zake n’zakuti pali malire pa kutchula manambala, monga tafotokozera kumayambiriro kwa nkhaniyi. Ganizirani njira yokonza pang'onopang'ono:

1. Sankhani selo kapena magulu angapo omwe akufunika kusinthidwa. Kenako, dinani kumanja pa iwo. Pa mndandanda wa ntchito zomwe zikuwoneka, pezani chida cha "Format Cells", dinani pamenepo.
2. Tikadina pa "Nambala" tabu, tikuwona kuti "Text" mtundu wakhazikitsidwa pamenepo. Sinthani kukhala "Zambiri" mugawo la "Number Formats". Kuti muchite izi, dinani chomaliza ndikutsimikizira zomwe mwachita podina batani la "Chabwino" pansi pazenera la masanjidwe.

Tcherani khutu! M'mitundu yosinthidwa ya Excel, mawonekedwe a General amakhazikitsidwa mwachisawawa.

Chiletsochi chikachotsedwa, manambala onse adzawonetsedwa mumtundu womwe mukufuna. Pambuyo pakusintha kwachitika, mutha kusunga fayilo. Mukatsegulanso, ma cell onse aziwonetsedwa munjira yoyenera.

Mutha kusintha mtundu wa manambala mwanjira ina yabwino:

1. Kuti muchite izi, lowetsani fayilo ya spreadsheet ya Excel, pomwe manambala akuwonetsedwa molakwika, pitani ku tabu ya "Home" kugawo la "Nambala".
2. Dinani muvi kuti mubweretse mndandanda wotsikira pansi ndikusintha mawonekedwe a "Text" kukhala "General".
3. Mutha kupanga imodzi mwamaselo, momwe muli ma gridi angapo, mu dongosolo limodzi, osasankha mafomu a pepala lonse. Kuti muchite izi, dinani pawindo lomwe mukufuna, dinani batani lakumanja la mbewa.
4. Mu tumphuka zenera, kupeza Delimited Format chida, alemba pa izo.
5. Kuphatikiza apo, magawo onse ayenera kusinthidwa monga momwe tafotokozera m'mbuyomu.

Zolemba! Kuti musinthe mwachangu kumitundu yama cell, ingogwiritsani ntchito kiyi "CTRL + 1". Ndikosavuta kusintha apa, pa selo imodzi yeniyeni komanso pagulu lonse.

Kuti muwonetsetse kuti zomwe zachitika ndi zolondola, tikupangira kuti mulembe zilembo kapena manambala ambiri. Ngati malire atatha, ma gratings sanawonekere, motero, munachita zonse bwino.

Njira 5: Sinthani mawonekedwe a cell

Ndizotheka kusintha mawonekedwe a cell kuti awonetse bwino zilembo pogwiritsa ntchito zida zingapo zomwe zimagwiritsidwa ntchito mosakhazikika mu Microsoft Excel spreadsheet. Tiyeni tiwone njira iyi mwatsatanetsatane:

1. Choyamba, sankhani selo lomwe lili ndi vuto, kenako dinani pomwepa. Menyu imatuluka pomwe muyenera dinani "Maselo a Format". Kupanga ma cell kumangochitika mu mawonekedwe a "Numeric", ngati bukhuli lili ndi manambala.

2. Mu "Nambala" chipika chomwe chimatsegula, kuchokera pamndandanda, sankhani mtundu womwe mtengo womwe walowa m'maselo udzagwirizana nawo. Mu chitsanzo ichi, mawonekedwe a "Ndalama" amaganiziridwa. Pambuyo posankha, timatsimikizira zochita zathu podina batani "Chabwino" pansi pa zenera la zoikamo. Ngati mukufuna kuti comma iwoneke mu manambala, muyenera kudina pa "Ndalama" masanjidwe.

3. Ngati simukupeza njira yoyenera yopangira masanjidwe pamndandanda, yesani kubwerera patsamba loyambira ndikupita kugawo la Nambala. Apa muyenera kutsegula mndandanda ndi akamagwiritsa, ndipo pansi kwambiri alemba pa "Zina nambala akamagwiritsa", monga momwe chithunzi cha skrini. Poyambitsa njirayi, mudzapita ku zoikamo zomwe zadziwika kale kuti musinthe mawonekedwe a selo.

Ngati palibe njira yomwe idathandizira, mutha kuyesa kuyika mfundo osati mu cell, koma pamzere womwe uli pansi pa gulu lolamulira la Microsoft Excel e-book. Ingodinani pa izo ndi kuyamba kulowa zofunika deta.

Kutsiliza

Nthawi zambiri, kuwonetsa ma gridi m'malo mwa manambala kapena zilembo m'maselo a Microsoft Excel sikulakwa. Kwenikweni, kuwonetsera kotereku kwa zilembo kumadalira zochita za ogwiritsa ntchito, kotero ndikofunikira kulabadira kutsata malire mukamagwiritsa ntchito mitundu yakale ya spreadsheet.