Zamkatimu
Tiyerekeze kuti tili ndi spreadsheet ya Excel yomwe ili ndi chidziwitso chonse. Ndizosanjidwa bwino, zosinthidwa, ndipo zimawoneka momwe mukufunira. Ndipo apa mwasankha kusindikiza papepala. Ndiyeno akuyamba kuoneka woipa.
Maspredishiti samawoneka bwino nthawi zonse pamapepala chifukwa sanapangidwe kuti azisindikizidwa. Amapangidwa mwapadera kuti akhale aatali komanso otambalala momwe amafunikira.
Izi ndizothandiza pamene tebulo liyenera kusinthidwa ndikutsegulidwa pazenera, koma zikutanthauza kuti deta yake siwoneka bwino pa pepala lokhazikika.
Koma mulimonse, palibe chosatheka, makamaka zikafika pa chida chosinthika ngati Excel. Komanso, sizovuta konse. Nawa maupangiri amomwe mungasindikizire zolemba za Excel kuti ziwoneke bwino pamapepala.
Langizo 1: Gwiritsani Ntchito Njira Yowoneratu Kusindikiza Musanasindikize
Mutha kuwona momwe spreadsheet yanu idzawonekere ikasindikizidwa ngati mutagwiritsa ntchito izi. Chida ichi ndi chamtengo wapatali kwambiri ndipo chidzathandiza kusunga nthawi ndi mapepala ambiri. Mutha kusinthanso momwe zidzawonekere zikasindikizidwa monga kukulitsa m'mphepete ndi zina zotero.
Mukhoza kuyang'ana momwe zimagwirira ntchito, ndipo zidzakhala zosavuta kukhazikitsa mawonedwe a tebulo patsamba.
Sankhani zomwe mukufuna kusindikiza
Ngati mukungofunika kusindikiza deta yeniyeni, simukusowa kusindikiza buku lonse, deta yeniyeni. Mukhoza kusindikiza, mwachitsanzo, pepala lokha kapena fayilo yeniyeni. Mukhozanso kusindikiza pang'ono deta. Kuti muchite izi, muyenera kuwasankha, ndikusankha chinthu cha "Highlighted range" pazokonda zosindikiza.
Wonjezerani malo anu
Mumachepetsedwa ndi kukula kwa pepala lomwe mumasindikiza, koma pali njira zingapo zomwe mungawonjezere malowo. Mwachitsanzo, sinthani mawonekedwe a pepala. Chosakhazikika ndi mawonekedwe azithunzi. Ndikoyenera kwa matebulo okhala ndi mizere yambiri, ndi malo - ngati pali mizati yambiri.
Ngati mukufuna malo ochulukirapo, mutha kuchepetsa m'mphepete mwa pepalalo. Zing'onozing'ono, zambiri zambiri zimatha kulowa papepala limodzi. Pomaliza, ngati tebulo lili laling'ono, mutha kugwiritsa ntchito Custom Scaling Options kuti mugwirizane ndi chikalata chonse papepala.
Gwiritsani ntchito mitu posindikiza
N’zovuta kumvetsa kumene munthu ali patebulo ngati n’zosatheka kusindikiza tebulolo papepala limodzi. Pankhaniyi, muyenera kugwiritsa ntchito "Print headers". Zimakupatsani mwayi wowonjezera mitu ya mzere kapena mizati patsamba lililonse la tebulo.
Gwiritsani ntchito zodulira masamba
Ngati chikalata chanu chili ndi mapepala angapo, ndi bwino kugwiritsa ntchito zoduka masamba kuti zikuthandizeni kumvetsetsa zomwe zikuyenera kukhala pamalo enaake. Mukayika tsamba losweka mu tebulo, zonse zomwe zili pansipa zimapita patsamba lotsatira. Izi ndizothandiza chifukwa zimakulolani kugawanitsa deta m'njira yomwe munthu akufuna.
Mukatsatira izi, mutha kuphweka kwambiri kuwerenga kwa zolemba za Excel zomwe zasindikizidwa papepala.