Mukati
Saka, iwe wakagadzira bhuku rebasa muExcel rizere nedata. Yakanyatso kurongeka, ruzivo rwacho nderwechizvino-zvino, kufomatirwa kwacho kuri sezvakarongwa. Wafunga kudhinda bepa vhezheni yetafura iyi… uye zvese zvakakanganisika.
Maspredishiti eExcel haagare achitaridzika zvakanaka pabepa nekuti haana kugadzirwa kuti akwane peji rakadhindwa. Izvo zvakagadzirirwa kuti zvive kureba uye zvakafara sezvinodiwa. Izvi zvakanakira kugadzirisa uye kuona pachiratidziri, asi zvinonetsa kudhinda zvinyorwa nekuti data racho hariwanzo kuenderana pabepa rakajairwa.
Matambudziko ese aya haareve kuti hazvigoneke kuita kuti Excel spreadsheet itaridzike yakanaka pabepa. Chaizvoizvo, hazvina kuoma zvachose. Aya mashanu anotevera matipi ekudhinda muExcel achakubatsira kugadzirisa dambudziko iri. Vose vanofanira kushanda zvakafanana muExcel 5, 2007, uye 2010.
1. Ongorora peji usati wadhinda
Nechokushandisa Print Preview (Preview) Unogona kuona chaizvo kuti tafura ichataridzika sei pane yakadhindwa peji. Panyaya yekuchengetedza nguva uye bepa, Print Preview (Preview) ndicho chishandiso chako chikuru chekudhinda. Iwe unogona kutogadzirisa zvimwe, sekukweva miganho yekudhinda kuti iwedzere kana kutetepa. Shandisa chishandiso ichi mushure mekugadzirisa zvakadhinda uye marongero ako kuti uve nechokwadi chekuti spreadsheet inotaridzika sezvaunoda.
2. Sarudza kuti chii chinofanira kudhindwa
Kana iwe uchingoda chikamu chidiki che data, usaprinda bhuku rese rebasa - dhinda data rakasarudzwa. Unogona kudhinda chete shizha rauri kuona izvozvi nekusarudza mumasetin'i ekudhinda Dhinda Anoshanda Sheets (Dhinda mapepa anoshanda), kana sarudza Dhinda Bhuku Rebasa Rese (Dhinda Bhuku Rese) kudhinda faira rose. Mukuwedzera, iwe unogona kudhinda chikamu chidiki che data rako nekusimbisa nzvimbo yaunoda uye kusarudza Dhinda Sarudzo (Dhinda sarudzo) mumaseta ekudhinda.
3. Kurisa nzvimbo iripo
Iwe unoganhurirwa nehukuru hwebepa raunodhinda pariri, asi kune nzira dzekuwana zvakanyanya kubva munzvimbo yaro. Edza kushandura kutariswa kwepeji. The default orientation yakanaka kune data uko kune mitsetse yakawanda kupfuura makoramu. Kana tafura yako yakapamhama kupfuura kureba, shandura kutariswa kwepeji kuti landscape (nyika). Uchiri kuda imwe nzvimbo? Iwe unogona kushandura hupamhi hwemiganhu kumativi ose epeji. Izvo zviduku zvavari, nzvimbo yakawanda inosara yedata. Pakupedzisira, kana tafura yako isiri yakakura kwazvo, edza kutamba nechombo Custom Scalling Options (Chikero) kuti ikwane mitsara yese kana makoramu ese, kana njodzi yekuisa tafura yese pabepa rakadhindwa.
4. Shandisa musoro wekudhinda
Kana iyo tafura yakatambanudzira anopfuura peji rimwe, zvino zvinozonetsa kunzwisisa kuti nderipi data rinorehwa, sezvo Excel inongodhinda misoro misoro papepa rekutanga nekukasira. Team Dhinda Zvinyorwa (Dhinda Misoro) inobvumidza iwe kudhinda mutsara kana makoramu misoro pane yega yega peji, zvichiita kuti data rive nyore kuverenga.
5. Shandisa kutyora peji
Kana tafura yacho ichitambanudzira pepa rinopfuura rimwe chete, tinokurudzira kushandisa mapeji kutsemuka kuti uone kuti ndeipi data ichawira papepa rega rega. Kana iwe ukaisa peji rekuvhara, zvese zviri pasi pekuzorora zvinoparadzaniswa kubva kune zvese zviri pamusoro pekuzorora uye zvinoenda kune inotevera peji. Izvi zviri nyore, nekuti Iwe unogona kupatsanura iyo data chaizvo nenzira yaunoda.
Nekushandisa matipi aya, unogona kuita kuti maspredishiti ako ave nyore kuverenga. Iwe uchawana rumwe ruzivo nezve matekiniki anotsanangurwa pamusoro muzvidzidzo zvechidzidzo chedu:
- Dhinda mapaneru muMicrosoft Excel
- Seta nzvimbo yekudhinda muExcel
- Kuisa mariji uye chiyero paunenge uchidhinda muExcel