Njira 3 Zosinthidwa ndi Mtundu mu Excel

01 a 03

Kusankha ndi Maonekedwe a Chilichonse mu Excel

Kusankha ndi Mtundu mu Excel

Kuphatikiza pa kusankha ndi mfundo - monga malemba kapena manambala - Excel ali ndi njira zosankha zomwe zimaloleza mtundu.

Kusankha ndi mtundu kungakhale kopindulitsa pogwiritsa ntchito maonekedwe ovomerezeka , omwe angagwiritsidwe ntchito kusintha mtundu wa chiyambi kapena mtundu wa deta umene umagwirizana ndi zikhalidwe zina.

Monga momwe tawonetsera pa chithunzi pamwambapa, kusankhidwa ndi mtundu kungagwiritsidwe ntchito pagawidwe deta iyi palimodzi kuti zosavuta kuziyerekezera ndi kusanthula.

Zoterezi zimaphatikizapo njira zosiyanasiyana zosankhira deta ku Excel pogwiritsa ntchito mtundu. Mauthenga apadera a mtundu wosiyana ndi zosankha za mitundu angapezeke pamasamba otsatirawa:

1. Sungani ndi Cell Background Color (tsamba ili m'munsimu)
2. Sungani ndi Font Color
3. Sungani ndi Zizindikiro Zokonzera Maonekedwe

Kusankha Dongosolo kuti Likhale

Deta isanayambe kusankhidwa, Excel iyenera kudziwa momwe mungayankhire, ndipo kawirikawiri, Excel ndi yabwino kwambiri posankha dera lofanana ndi deta - pokhapokha italowa,

1. Palibe mizere kapena mizere yopanda kanthu yomwe inasiyidwa mkati mwa dera lofanana;
2. ndipo mizere yopanda kanthu ndi ndondomeko zatsalira pakati pa madera ofanana.

Excel idzatsimikiziranso, molondola, ngati deta ili ndi mayina amtundu ndikusiya mzerewu kuchokera ku zolemba zomwe zidzasankhidwe.

Kuloleza Excel kusankha zosankhidwa kuti zisankhidwe ndi zabwino kwazing'ono za deta zomwe zingayang'anidwe mofulumira kuti zitsimikizire:

• kuti maulendo olondola adasankhidwa;
• kuti palibe zofiira muzomwezo;
• kuti pambuyo pa mtunduwo, zolemba za deta sizili bwino ndi zolondola.

Kwa malo akuluakulu a deta, njira yosavuta yotsimikiziranso kuti malo oyenera amasankhidwa ndikuwonekera patsogolo musanayambe.

Ngati njira yofananayo iyenera kusankhidwa mobwerezabwereza, njira yabwino kwambiri ndiyipatsire dzina .

Ngati dzina limatanthauzidwa kuti mayendedwe angasankhidwe, lembani dzinali mu Bokosi la Dzina , kapena lisankhe kuchokera ku list of down list and Excel lidzawonetseratu deta yolondola.

Kusankhidwa ndi Mtundu ndi mtundu wa mtundu

Kusankha kumafuna kugwiritsa ntchito dongosolo la mtundu .

Mukasankha ndi zoyenera, pali maulamuliro awiri omwe angatheke - kukwera kapena kutsika. Mukasankha ndi mitundu, palibe dongosolo ilipo kotero ndilo wosuta yemwe amatha kupanga mtundu wa mtundu mu bokosi la mtundu wa mtundu.

Sungani ndi Chitsanzo cha Mtundu wa Cell

Mu chithunzi pamwambapa, pakuti maselo osiyanasiyana H2 mpaka L12 mawonekedwe ovomerezeka adagwiritsidwa ntchito kusintha mtundu wa chigawo cha ma rekodi malinga ndi msinkhu wa ophunzira.

Mmalo mosintha mtundu wa selo wa onse olemba mbiri, okhawo omwe ali ndi zaka 20 kapena aang'ono okha ndiwo omwe anakhudzidwa ndi maonekedwe ovomerezeka ndi otsala omwe sali okhudzidwa.

Zolembedwazi zinasankhidwa ndi maselo kuti agwirizane zolemba zochititsa chidwi pamwamba pamtunda kuti zikhale zosavuta komanso kufanizira.

Zotsatira zotsatirazi zinatsatidwa kuti athetse deta ndi mtundu wa magulu a selo.

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe - H2 mpaka L12
2. Dinani pa tabu la Home la riboni
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule mndandanda wotsika
4. Dinani pa Custom Custom mundandanda wotsika pansi kuti mulembe mtundu wa dialog box
5. Pogwiritsa ntchito mtundu womwe ukulowetsa mu bokosi, chotsani Cell Color kuchokera m'ndandanda wotsika
6. Pamene Excel imapeza mitundu yosiyanasiyana ya ma selo m'kati mwa deta yosankhidwa imapanga mitunduyo kuzinthu zomwe zalembedwa pansi pa Chilolezo cholowera ku bokosi
7. Pansi pa mutu wa Order, sankhani mtundu wofiira kuchokera m'ndandanda wotsika
8. Ngati ndi kotheka, sankhani Pa Top pansi pa dongosolo kuti deta yofiira ikhale pamwamba pa mndandanda
9. Dinani OK kuti musankhe deta ndi kutseka bokosi la dialog
10. Zolemba zinayi zomwe zili ndi selo lofiira ziyenera kusonkhanitsidwa pamodzi pamwamba pa deta

02 a 03

Sungani Deta Ndizojambula mu Excel

Sungani ndi Font Color

Zofanana kwambiri ndi kusankhidwa ndi mtundu wa selo, kusankhidwa ndi mtundu wazithunzithunzi zingagwiritsidwe ntchito mofulumira deta deta ndi malemba osiyana.

Kusintha kwa mtundu wa maonekedwe kungakhoze kuchitidwa pogwiritsa ntchito maonekedwe ovomerezeka kapena chifukwa cha maonekedwe a chiwerengero - monga powonetsera manambala osayera wofiira kuti apeze mosavuta.

Sankhani ndi mtundu wa mtundu wa mtundu

Mu chithunzi pamwambapa, pakuti maselo osiyanasiyana H2 kuti L12 apange maonekedwe ake adagwiritsidwa ntchito kusintha mtundu wa maonekedwe a ophunzira olemba pulogalamu yawo yophunzira:

• Mapepala ofiira - ophunzira olembetsa pulogalamu ya namwino
• Mndandanda wa buluu - ophunzira analembetsa pulogalamu ya sayansi

Zolembedwazi ndiye zinasankhidwa ndi mtundu wa fosholo kuti zilembetse zolemba zochititsa chidwi pamwamba pamtunduwu kuti zikhale zosavuta kufanana ndi kusanthula.

Kukonzekera kwa mtundu wa mazenera kunali wofiira kumbuyo ndi buluu. Zolemba ndi mtundu wosasintha wa ma tepi sizinasankhidwe.

Zotsatira zotsatirazi zinatsatidwa kuti athetse deta ndi mtundu wa maonekedwe.

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe - H2 mpaka L12
2. Dinani pa tabu la Home la riboni .
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule mndandanda wotsika.
4. Dinani pa Custom Custom mundandanda wotsika pansi kuti mulembe mtundu wa dialog box
5. Pansi pa Mndandanda womwe ukulowetsa mu bokosi la dialog, sankhani mtundu wa maonekedwe kuchokera m'ndandanda wotsika
6. Pamene Excel ikupeza mitundu yosiyanasiyana ya ma fonti mu deta yosankhidwa imaphatikizapo mitundu ija kumasankhidwe omwe ali pansi pa Order akulowa mu bokosi
7. Pansi pa mutu wa Order, sankhani mtundu wofiira kuchokera m'ndandanda wotsika
8. Ngati ndi kotheka, sankhani Pa Top pansi pa dongosolo kuti deta yofiira ikhale pamwamba pa mndandanda
9. Pamwamba pa bokosi la bokosi, dinani pa Bungwe Lonjezerani kuti muwonjeze mlingo wachiwiri wa mtundu
10. Kwa mlingo wachiwiri, pansi pa mutu wa Order, sankhani mtundu wa buluu kuchokera m'ndandanda wotsika
11. Sankhani Zapamwamba pansi pa dongosolo kuti deta ya mtundu wa buluu ikhale pamwamba pa zolembazo ndi mawonekedwe osasinthika wakuda
12. Dinani OK kuti musankhe deta ndi kutseka bokosi la dialog
13. Mapepala awiri omwe ali ndi mtundu wofiira wamasewera ayenera kusonkhanitsidwa pamodzi pamwamba pa deta yomwe ikutsatiridwa ndi zolemba ziwiri zofiira

03 a 03

Sankhani Dongosolo ndi Zithunzi Zojambula Zomwe Mu Excel

Sungani ndi Zizindikiro Zokonzera Maonekedwe

Njira ina yosankhidwa ndi mtundu ndiyo kugwiritsa ntchito chithunzi cha maonekedwe ovomerezeka kuti apange dongosolo .

Zithunzizi zimapereka njira zotsatizana ndi zosankha zomwe zimapangidwira nthawi zonse zomwe zimagwiritsidwa ntchito pazithunzi ndi kusintha kwa maselo.

Mofanana ndi kusankha mtundu wa selo, mukasankha ndi mtundu wazithunzi, wosuta amayambitsa dongosolo la mtundu wa bokosi.

Sungani ndi Chitsanzo cha mtundu wa Icon

Mu chithunzi pamwambapa, maselo ambiri omwe ali ndi deta ya Paris, France yakhala yokonzedweratu ndi chizindikiro choyimira chokhazikika chifukwa cha kutentha kwa tsiku ndi tsiku kwa July 2014.

Zithunzizi zagwiritsidwa ntchito poyeretsa deta ndi zojambula zojambula zithunzi zobiriwira zomwe zinkatsogoleredwa ndizithunzi zamatsenga, kenako zimakhala zofiira.

Zotsatira zotsatirazi zidatsatidwa kuti athetse deta ndi mtundu wa zithunzi.

1. Onetsetsani maselo osiyanasiyana kuti athetsedwe - I3 mpaka J27
2. Dinani pa tabu la Home la riboni .
3. Dinani pa mtundu wa Fuluta & Fyuluta paboni kuti mutsegule mndandanda wotsika.
4. Dinani pa Custom Custom mundandanda wotsika pansi kuti mulembe mtundu wa dialog box
5. Pogwiritsa ntchito mtundu womwe ukutsogolera mu bokosi la bokosi, sankhani chizindikiro cha selo kuchokera m'ndandanda wotsika
6. Pamene Excel imapeza zithunzi zam'manja pa deta yosankhidwayo imapanga zithunzizo pazomwe zili muyeso pansi pa Kulowera Kwadongosolo mu bokosi
7. Pansi pa mutu wa Order, sankhani chithunzi chobiriwira kuchokera m'ndandanda wotsika
8. Ngati ndi kotheka, sankhani Pa Top pansi pa dongosolo kuti deta ndi zithunzi zobiriwira zikhale pamwamba pa mndandanda
9. Pamwamba pa bokosi la bokosi, dinani pa Bungwe Lonjezerani kuti muwonjeze mlingo wachiwiri wa mtundu
10. Kwa msinkhu wachiwiri, pansi pa mutu wa Order, sankhani chizindikiro cha amber kapena chachikasu kuchokera pazndandanda
11. Apanso, sankhani pa Top pansi pa dongosolo ngati n'koyenera - izi ziika gulu lachiwiri la zolemba pansipa awo okhala ndi zithunzi zobiriwira, koma pamwamba pa zonse zolemba
12. Popeza pali zisankho zitatu zokhazokha, palibe chofunika kuwonjezera msinkhu wachitatu kuti muyese zojambulazo ndi zizindikiro zofiira, chifukwa ndizozolembedwa zokhazokha ndipo zidzakhala pansi pazomwezo
13. Dinani OK kuti musankhe deta ndi kutseka bokosi la dialog
14. Zolembedwa ndi zojambula zobiriwira ziyenera kusonkhanitsidwa palimodzi pamtundu wa deta zomwe zikutsatiridwa ndi zolemba ndi chizindikiro cha amber, ndiyeno omwe ali ndi chizindikiro chofiira