Momwe mungapitirize tebulo pa Excel

Njira 1: Chida Chachikulu

Chida cha "kukula" cha "kukula" chimakupatsani mwayi wosintha tebulo lomalizidwa posintha mitundu yake polowetsa zatsopano. Ngati simunapangepo patebulopo kotero kuti mutha kusintha, muchite izi, kutsatira mafotokozedwe pansipa, kenako ndikupeza momwe mungasinthire kukula kwake.

1. Pakupanga maselo ophatikizidwa a patebulo lokhazikika, mutha kutchula nthawi yomweyo mizere ndi malire kuti isapitirize. Kuti muchite izi, sonyezani maselo onse ofunikira pogwira batani lakumanzere.



2. Tsegulani kuyika.



3. Kukulitsa gawo loyambalo "matebulo".



4. Mumenyu zomwe zimawoneka, sankhani njira yoyenera kupanga tebulo pophunzira za zomwe tafotokozazo.



5. Mukamapanga malo omwe data akuwonetsedwa kutengera maselo osankhidwa, motero sikofunikira kusintha parameter.



6. Gome lidapangidwa kale ndi mzere wa zingwe, motero kupitirira kwake sikungafunikire.

Ngati tebulo lidapangidwa kale, muyenera kuchita mosiyana:

1. Pa Stone Tab, dinani pa batani la "tebulo".



2. Windo lidzaonekera lomwe limalowa mu mtundu watsopanowu ndi kuwerengetsa kwa tebulo, kenako tsimikizani kusintha.



3. Bwererani patebulo ndikuwonetsetsa kuti machitidwe onse amalizidwa molondola ndipo zotsatira zake zikukuyenere.

Tsopano, posachedwa kwambiri patebulopo ikangofunikanso, itanani chida ichi ndikukhazikitsa mfundo zatsopano kuti ziwonjezere mizere yomwe ikufunika.

Njira 2: Matebulo

Mukamagwira ntchito ndi tebulo lomalizidwa kuti muwonjezere, mutha kugwiritsa ntchito zakudya zake komanso "ikani". Izi zikuwonjezera mzere umodzi wokha, koma palibe chomwe chingalepheretse kuyankhanso kwa kuchuluka kwa tebulo.

1. Dinani imodzi mwa mizere ya tebulo ndi batani lamanja mbewa.



2. Pankhani yankhani, sankhani "Ikani" chingwe.



3. Chingwe chopanda kanthu chidzawonjezedwa pamalo pomwe pa PKM Dinani zidachitidwa.

Njira 3: "Menyu"

Mu "cell", pali gawo losiyana pakuyika zingwe zomwe zingakhale zothandiza ngati malo omwe ali patebulo tsopano atha kale. Imagwira ntchito chida ichi poyerekeza ndi dzina lake, koma limatchedwa osiyana.

1. Pa tabu yakunyumba, yowonjezera gawo la "Cell".



2. Mu gawo lomwe limawoneka, dinani "phala".



3. Sankhani njira yogwiritsira ntchito zingwe kapena zigawo, kutengera mbali yomwe tebulo likupitilira.

Ngati nthawi zambiri mumakumana ndi kufunika kokulira matebulo, samalani ndi "anzeru" awo. Pakupanga zinthu zoterezi, werengani nkhaniyi pansipa.

Werengani zambiri: Kugwiritsa ntchito "anzeru" pa Microsoft Excel