Momwe mungawerengere masamba mu Excel. Kuchokera patsamba linalake, kuchokera patsamba lachiwiri, poganizira kuchuluka kwa masamba omwe ali mufayilo

Kuwerengera ndi njira yabwino yopangira kuyenda momasuka komwe kumakupatsani mwayi wofufuza chikalata mwachangu. Ngati ntchitoyo ikuchitika patebulo limodzi, ndiye kuti palibe chifukwa chowerengera. Zowona, ngati mukukonzekera kusindikiza m'tsogolomu, ndiye kuti padzakhala kofunikira kuti muwerenge mosalephera kuti musasokonezedwe ndi mizere yambiri ndi mizere. Pali zosankha zingapo zapagination, zomwe tikambirana mwatsatanetsatane m'nkhaniyi.

Kusindikiza kosavuta

Njirayi ndiyosavuta kuposa zonse zomwe zilipo ndipo imakupatsani mwayi wowerengera masamba mwachangu. Kuti muchite izi, muyenera kuchita izi:

1. Muyenera yambitsani "Mitu ndi Mapazi", chifukwa cha izi muyenera kupita ku Excel pa toolbar mu gawo la "Insert". M'menemo, muyenera kusankha "Text" katunduyo kenako ntchito "Mitu ndi Mapazi". Mfundo yochititsa chidwi ndi yakuti mitu ndi mapepala amatha kuikidwa pamwamba ndi pansi, mwachisawawa siziwonetsedwa, ndipo panthawi yokonzekera koyambirira, mukhoza kuyika mawonetsedwe a chidziwitso pa tsamba lililonse la tebulo.

2. Mukapita ku gawo lomwe mukufuna, chinthu chapadera "Mitu ndi Mapazi" chidzawonekera, momwe mungasinthire makonda omwe alipo. Poyamba, malo amapezeka, ogawidwa m'magawo atatu pamwamba kapena pansi.

3. Tsopano zatsala kusankha gawo la mutu pomwe chidziwitso chidzawonetsedwa. Ndikokwanira kudina ndi LMB ndikudina "Nambala ya Tsamba".

4. Mukamaliza masitepewo, mfundo zotsatirazi zidzawonekera pamutu: &[Page].

5. Ingodinanso pamalo opanda kanthu mu chikalatacho kuti zomwe mwalemba zisinthe kukhala nambala yatsamba.

6. Ndizotheka kupanga zomwe zalowa. Kuti muchite izi, ingosankhani deta mwachindunji pamutu ndipo, mutasankha, pitani ku tabu "Home", momwe mungasinthire font, kuwonjezera kukula kwake, kapena kusintha magawo ena.

7. Zosintha zonse zikapangidwa, kumangodinanso malo opanda kanthu a fayilo, ndipo adzagwiritsidwa ntchito pamutu.

Kuwerengera kutengera kuchuluka kwamasamba omwe ali mufayiloyo

Palinso njira ina yowerengera masamba muzolemba potengera kuchuluka kwamasamba omwe ali patebulo. Kuti muchite izi, muyenera kuchita izi:

1. Poyamba, muyenera kugwiritsa ntchito malangizo a njira yoyamba ndendende mpaka pomwe mukupita ku gawo la "Mitu ndi Mapazi".
2. Chilembo choyamba chikangowonekera pamitu ndi m'munsi, muyenera kusintha pang'ono kuti mupeze zotsatirazi: Tsamba &[Page] kuchokera.

3. Mukamaliza kulemba "kuchokera", dinani batani la "Nambala yamasamba" pazida pamwamba.

4. Ngati zonse zachitika molondola, ndiye mukadina pa tsamba lopanda kanthu, mudzawona mutu womwe ukuwonetsa zambiri za nambala yatsamba ndi kuchuluka kwamasamba.

Kuwerengera kuchokera patsamba lachiwiri

Ngati mudalembapo kale pepala lachidule kapena lingaliro, ndiye kuti mukudziwa lamulo lalikulu la kapangidwe kake: nambala yatsamba siiyikidwa patsamba lamutu, ndipo tsamba lotsatira limayikidwa pa deuce. Matebulo angafunikenso njira yopangira iyi, chifukwa chake tikupangira kuti muchite izi:

1. Muyenera yambitsani mitu ndi pansi, chifukwa cha izi, gwiritsani ntchito malangizo a njira yoyamba.
2. Tsopano m'gawo lomwe likuwonekera, pitani ku "Parameters", momwe mungayang'anire bokosi pafupi ndi "mutu Wapadera watsamba loyamba".

3. Ndiko kuwerengera masamba m'njira iliyonse yomwe idaganiziridwa kale. Zowona, pakuwerengera, muyenera kusankha tsamba lachiwiri kuti muyike mutu.
4. Ngati muchita zonse bwino, mudzapeza zotsatira zomwe mukufuna. M'malo mwake, mutu womwe uli patsamba loyamba udzakhalapo, sudzawonetsedwa. Mapangidwe owoneka ayamba kale patsamba lachiwiri, monga momwe amafunikira poyambirira.

Njira yowerengera iyi ndiyoyenera kupanga mapepala osiyanasiyana asayansi komanso popereka tebulo ngati choyikapo mu pepala lofufuzira.

Kuwerengera kuchokera patsamba linalake

Mkhalidwe umathekanso ngati pakufunika kuti muyambe kulemba manambala osati patsamba loyamba, koma kuchokera patsamba lachitatu kapena lakhumi. Ngakhale izi ndizosowa kwambiri, sizingakhale zovuta kudziwa za kukhalapo kwa njira yotere, ma aligorivimu a zochita zake ndi awa:

1. Poyamba, m'pofunika kupanga manambala oyambira pogwiritsa ntchito imodzi mwa njira zomwe takambiranazi.
2. Mukamaliza zoyambira, muyenera kupita kugawo la "Mapangidwe a Tsamba" pazida.
3. Phunzirani mosamala gawoli ndikuyang'anitsitsa zolembedwa "Kukhazikitsa Tsamba" pansi pa zinthu "Print Area", "Breaks", etc. Pafupi ndi siginecha iyi mukhoza kuwona muvi, dinani.

4. A zenera ndi zina zoikamo adzaoneka. Pazenera ili, sankhani gawo la "Tsamba", ndiyeno pezani "Nambala Yoyamba Yatsamba". Mmenemo muyenera kufotokoza kuchokera patsamba lomwe mukufuna manambala. Zonse zikakhazikitsidwa, dinani "Chabwino".

5. Mukamaliza masitepe, manambala ayamba ndendende ndi nambala yomwe mudatchula mu magawo.

Ngati mukufuna kuchotsa manambala, ingosankhani zomwe zili mkati mwamutu ndikudina "Chotsani".

Kutsiliza

Njira yowerengera sizitenga nthawi yayitali ndipo imakupatsani mwayi wodziwa maluso ofunikirawa popanda vuto lililonse. Ndikokwanira kugwiritsa ntchito malingaliro omwe aperekedwa pamwambapa kuti amalize ntchitoyi.