Momwe mungadziwitsire malire a tebulo pa Excel

Kusankhidwa kwa malire ku Microsoft Excel ndi imodzi mwanjira ya mawonekedwe ake, komabe, mu pulogalamuyi pali njira zina zomwe zimakupatsani njira zomwe zimakupatsani mwayi kapena tebulo lanyumba. Ngati simunachitebe izi ndipo muli ndi chidwi ndi mutuwo, onetsetsani kuti mwawerenga chitsogozo pansipa kapena pitani ku njira zotsatirazi zophunzirira momwe mungasankhire malire a tebulo.

Werengani zambiri: kupanga tebulo ku Microsoft Excel

Njira 1: Kugwiritsa Ntchito Makina Osiyanasiyana

Excel ali ndi zilembo zodziwika bwino zomwe nthawi zambiri ndizoyenera ogwiritsa ntchito pafupipafupi kuti atanthauze malire a tebulo. Amalimbikitsa kupembedzera kosiyanasiyana kwa mizere ndi kusintha kwake, motero adzakhala othandiza pamilandu yapadera. Kuti muwonjezere malire oterewa, muyenera kupanga ma disiki angapo.

1. Ndi batani lakumanzere, sonyezani zinthu zonse zomwe zaphatikizidwa patebulo kuti kusintha kowoneka zikugwirizireni onse.



2. Gutsani mndandanda wa "malire", omwe ali pa tabu yakunyumba, ndikusankha njira imodzi yopangira. Mu menyu yemweyo, mutha kuwona zosintha zomwe zimapangidwa patebulo kudzera kumanzere.



3. Mukatha kugwiritsa ntchito malirewo, kubwerera patebulo ndikuyamikira mawonekedwe ake. Ngati zili zoyenera kwa inu, mutha kusiya zonse monga ziliri, apo ayi pitani ku makonda ena.



4. Mwachitsanzo, palibe chomwe chingasokoneze kutsegulidwa kwameza zomwezo ndikusintha mtunduwo pogwiritsa ntchito mitundu ya mitundu, mutu wa mithunzi kapena miyambo yamakhalidwe.



5. Zomwezo zimagwiranso ntchito pamzere wa mizere, komabe, malowo amangokhala osankha zingapo zopitilira muyeso.



6. Ngati mtundu ndi mitundu ya mizere imasankhidwa pambuyo pakupanga malire, aliyense wa iwo adzafunidwa mosiyana, dinani batani lakumanzere ndi chida chosinthira.



7. Panthawi imeneyi, mizere yolakwika imatha kuoneka ngati makina osindikizira.



8. Kenako chotsani mumenyu yofananira yomwe ija pogwiritsa ntchito chida 'chofananira malire ".

Ngati simugwirizana ndi zosankha zapamwamba kapena kufunikira kwachilendo kwachilendo kwa malire a tebulo kwabuka, gwiritsani ntchito njira zotsatirazi.

Njira 2: Zojambula Zam'manja

Chojambula cha malire a tebulo pa gombe la Excel lipanga kapangidwe kake ka mzere uliwonse momwe zimafunikira kwa wosuta yekha. Kuti muchite izi, gwiritsani ntchito mndandanda womwewo wotsalira, koma chitani zinthu zina.

1. Tsegulani mndandanda "malire" momwe mumasankha "kujambula malire".



2. Ngati mzere wamtunduwu ndi mtundu wake umasiyana ndi osasunthika, nthawi yomweyo asinthe kuti apange kapangidwe kolondola mukajambula.



3. Yambitsani kujambula malire, kudina pamagawo ofunikira kapena kuwononga ndalama, nthawi yomweyo kupanga zowoneka m'munda uliwonse.

Njira 3: Kugwiritsa Ntchito Chida cha "Malire"

Chida chotchedwa "malire ena" amakupatsani mwayi woti mupange mizere yomwe si gawo la template yokhazikika, mwachitsanzo, mukafuna kuwoloka khungu kapena kuwonjezera kapangidwe kake.

1. Pankhaniyi, tsegulani "menyu" onse omwewo, koma sankhani zida zomaliza zomaliza. Malamulo ena ".



2. Yambani kupanga mizere mu zenera loperekedwa ndi izi. Ili yoyimiriridwa ngati khungu lakukulitsidwa ndi template yolembedwa, ndipo kukanikiza muyeso kumatha kuwonjezera kapena kuchotsa mzere.



3. Mu tabu iyi, mutha kusintha mtundu wa malire ndi mtundu wake, kuwerenga zotsatira za zenera lowonetsera.



4. Pitani ku "Dzazani" tabu, ngati mukufuna kusintha mtundu wa khungu lililonse lomwe ndi gawo la tebulo.



5. Mu chithunzi chotsatira, mukuwona njira yowonjezera malire onjezerani malire, mwachitsanzo, ndikupanga momwe maselo odutsira odutsawo kapena mzere wopitilira.

Njira 4: Kugwiritsa ntchito "masitayilo a cell"

Monga njira yomaliza, tikuganiza kuti tidziwe za "masitaelo a cell" omwe angagwiritsidwenso ntchito kupanga mapangidwe opanda malire, kuphatikizapo ma cell ena omwe ali patebulo labwino. Makonda anu pa chida ichi siochuluka, ma template okonzeka okonzeka nthawi zambiri amakhudzidwa.

1. Choyamba, gawani tebulo lonse lomwe maselo omwe mukufuna kusintha mothandizidwa ndi "masitaelo a cell". Kanikizani mzere ndi dzina la ntchito mu "masitayilo" block yomwe ili pa tabu yakunyumba.



2. Windo limodzi limatseguka ndi zitsanzo za maselo amitundu ya deta ya data, maudindo kapena mitundu yambiri. Nyamula zogwiritsira ntchito ndikudina kawiri pa izi kuti mugwiritse ntchito.



3. Mukangotseka zenera, mutha kuyang'ana zotsatira zake. Mwachitsanzo, chithunzi chomwe chili pansipa chikuwonetsa mawonekedwe achilendo okhala ndi malire a kawiri, zomwe ndizovuta kuti mudzipangire nokha, koma kugwiritsa ntchito ma tempulo omwe ali pachibwenzi awiri.



4. Ngati mungathe kupita ku "Pangani Chida Chake cha foni" mukamacheza ndi chida ichi, mutha kukhazikitsa zomwe mungagwiritse ntchito, kenako ndikuupereka ndi malo amodzi.