Momwe mungasewere data mu Excel ndi mtundu

Mu Microsoft Office Excel, kuyambira mtundu 2007, zidakhala zotheka kusanja ndikusefa ma cell a tebulo ndi mtundu. Izi zimakuthandizani kuti muzitha kuyang'ana patebulo mwachangu, kumawonjezera mawonekedwe ake komanso kukongola kwake. Nkhaniyi ifotokoza njira zazikulu zosefera zambiri mu Excel ndi mtundu.

Makhalidwe a kusefa ndi mtundu

Musanayambe kuganizira njira zosefera deta ndi mtundu, m'pofunika kusanthula ubwino umene njirayi imapereka:

• Kupanga ndi kuyitanitsa zambiri, zomwe zimakupatsani mwayi wosankha chidutswa chomwe mukufuna ndikuchipeza mwachangu pama cell angapo.
• Maselo owunikiridwa omwe ali ndi chidziwitso chofunikira akhoza kufufuzidwanso.
• Kusefa ndi mtundu kumawunikira zambiri zomwe zikugwirizana ndi zomwe zatchulidwa.

Momwe mungasefere data ndi utoto pogwiritsa ntchito njira yopangiramo ya Excel

Algorithm yosefa zambiri ndi mtundu mu gulu la tebulo la Excel lagawidwa m'njira zotsatirazi:

1. Sankhani maselo ofunikira omwe ali ndi batani lakumanzere ndikusunthira ku tabu ya "Home" yomwe ili pazida zapamwamba za pulogalamuyi.
2. M'dera lomwe likuwonekera mugawo la Kusintha, muyenera kupeza batani la "Sankhani ndi Sefa" ndikulikulitsa podina muvi womwe uli pansipa.

3. Mu menyu omwe akuwoneka, dinani mzere wa "Zosefera".

4. Fyulutayo ikawonjezedwa, mivi yaing'ono idzawonekera m'maina a tebulo. Pakadali pano, wogwiritsa ntchito ayenera kudina LMB pamivi iliyonse.

5. Mukadina muvi womwe uli m'gawolo, menyu yofananira idzawonetsedwa, momwe muyenera kudina Zosefera ndi mzere wamtundu. Tabu yowonjezera idzatsegulidwa ndi ntchito ziwiri zomwe zilipo: "Sefa ndi mtundu wa selo" ndi "Sefa ndi mtundu wa font".

6. Pagawo la "Zosefera ndi mtundu wa cell", sankhani mthunzi womwe mukufuna kusefa tebulo loyambira podina ndi LMB.
7. Onani zotsatira. Pambuyo popanga zomwe zili pamwambapa, maselo okhawo omwe ali ndi mtundu womwe watchulidwa kale ndi omwe atsalira patebulo. Zinthu zotsalira zidzatha, ndipo mbale idzachepetsedwa.

Mutha kusefa pamanja deta mu gulu la Excel pochotsa mizere ndi mizati yokhala ndi mitundu yosafunikira. Komabe, wogwiritsa ntchitoyo ayenera kuthera nthawi yowonjezera kuti amalize ntchitoyi.

Ngati musankha mthunzi womwe mukufuna mu gawo la "Zosefera ndi mtundu wa font", ndiye kuti mizere yokhayo yomwe malembedwe amalembedwa mumtundu wosankhidwayo ndiyotsalira patebulo.

Tcherani khutu! Mu Microsoft Office Excel, kusefa ndi mtundu wa ntchito kumakhala ndi vuto lalikulu. Wogwiritsa ntchito amatha kusankha mthunzi umodzi wokha, womwe gulu la tebulo lidzasefedwa. Sizingatheke kutchula mitundu ingapo nthawi imodzi.

Momwe mungasinthire deta ndi mitundu ingapo mu Excel

Nthawi zambiri palibe zovuta pakusankha ndi mtundu mu Excel. Imachitidwa mwanjira yomweyo:

1. Poyerekeza ndi ndime yapitayi, onjezerani fyuluta kumagulu a tebulo.
2. Dinani pa muvi womwe umapezeka mu dzina lazambiri, ndikusankha "Sankhani ndi mtundu" mu menyu yotsitsa.

3. Tchulani mtundu wofunikira wa masanjidwe, mwachitsanzo, sankhani mthunzi womwe mukufuna mugawo la "Sankhani ndi mtundu wa selo".
4. Pambuyo pochita zosinthika zam'mbuyomu, mizere ya tebulo yokhala ndi mthunzi wosankhidwa kale idzakhala pamalo oyamba muzotsatira. Mukhozanso kusankha mitundu ina.

Zina Zowonjezera! Muthanso kusanja zomwe zili patebulo pogwiritsa ntchito "Kusanja Mwamakonda", ndikuwonjezera magawo angapo ndi mtundu.

Momwe mungasefe zidziwitso patebulo potengera mtundu pogwiritsa ntchito makonda

Kuti Microsoft Office Excel isankhe fyuluta kuti iwonetse mitundu ingapo patebulo nthawi imodzi, muyenera kupanga zina zowonjezera ndi zodzaza. Malingana ndi mthunzi wopangidwa, deta idzasefedwa m'tsogolomu. Ntchito yokhazikika mu Excel imapangidwa motsatira malangizo awa:

1. Pitani ku gawo la "Developer", lomwe lili pamwamba pa menyu yayikulu ya pulogalamuyi.
2. Pa tabu yomwe imatsegulidwa, dinani batani la "Visual Basic".
3. Mkonzi womangidwa mu pulogalamuyi adzatsegulidwa, momwe mudzafunika kupanga gawo latsopano ndikulemba code.

Kuti mugwiritse ntchito zomwe zidapangidwa, muyenera:

1. Bwererani ku tsamba la Excel ndikupanga mizati iwiri yatsopano pafupi ndi tebulo loyambirira. Akhoza kutchedwa "Cell Colour" ndi "Text Color" motsatira.

2. Lembani ndondomekoyi mu gawo loyamba “= ColorFill()». Mkanganowo uli m'makolo. Muyenera alemba pa selo ndi mtundu uliwonse mbale.

3. Mugawo lachiwiri, onetsani mkangano womwewo, koma ndi ntchitoyo “=ColourFont()».

4. Tambasulani zotulukazo mpaka kumapeto kwa tebulo, kukulitsa chilinganizo kumitundu yonse. Deta yolandilidwa imayang'anira mtundu wa selo lililonse patebulo.

5. Onjezani fyuluta kumagulu a tebulo molingana ndi dongosolo lomwe lili pamwambapa. Deta idzasanjidwa ndi mtundu.

Zofunika! Kusankha mu Excel pogwiritsa ntchito ntchito yofotokozedwa ndi ogwiritsa ntchito kumachitika chimodzimodzi.

Kutsiliza

Chifukwa chake, mu MS Excel, mutha kusefa mwachangu mndandanda wa tebulo loyambirira ndi mtundu wamaselo pogwiritsa ntchito njira zosiyanasiyana. Njira zazikulu zosefera ndi kusanja, zomwe zimalimbikitsidwa kuti zigwiritsidwe ntchito pochita ntchitoyi, zidakambidwa pamwambapa.