Mukati
Ngatiti isu tine Excel spreadsheet izere neruzivo. Yakanyatsorongeka, yakarongwa, uye inotaridzika chaizvo sezvaunoda. Uye pano iwe unosarudza kudhinda papepa. Uye ipapo anotanga kutaridzika zvakaipa.
Maspreadsheets haaitike zvakanaka pabepa nekuti haana kugadzirwa kuti ashandiswe mukudhindwa. Iwo akanyatsogadzirwa kuti akareba uye akafara sezvinodiwa.
Izvi zvinoshanda kana tafura ichida kugadziridzwa uye kuvhurwa pachiratidziri, asi zvinoreva kuti data rayo harizotaridzike zvakanaka pabepa rakajairwa.
Asi chero zvakadaro, hapana chisingagoneki, kunyanya kana zvasvika kune chakadaro chinochinjika chishandiso seExcel. Uyezve, hazvina kuoma zvachose. Heano mamwe matipi ekuti ungaprinda sei magwaro eExcel kuti aite seakanaka pabepa.
Zano 1: Shandisa iyo Print Preview Option Usati Wadhinda
Unogona kuona chaizvo kuti spreadsheet yako ichataridzika sei kana yakadhindwa kana ukashandisa chimiro ichi. Ichi chishandiso chinonyanya kukosha uye chichabatsira kuchengetedza yakawanda nguva uye bepa. Iwe unogona kutoita dzimwe shanduko kuti ichataridzika sei kana yakadhindwa sekuwedzera miganho uye zvichingodaro.
Iwe unogona kutarisa kuti inoshanda sei mukuita, uye zvichange zviri nyore kwazvo kumisa kuratidzwa kwetafura pane peji.
Sarudza zvauri kuronga kudhinda
Kana iwe uchingoda kudhinda chaiyo chidimbu che data, haufanire kudhinda bhuku rese, iyo chaiyo data. Iwe unogona kudhinda, semuenzaniso, pepa chete kana faira chaiyo. Iwe unogona zvakare kudhinda zvishoma data. Kuti uite izvi, unofanirwa kuzvisarudza, uye wozosarudza chinhu che "Highlighted range" muzvirongwa zvekudhinda.
Wedzera nzvimbo yako
Iwe unoganhurirwa nehukuru hwebepa raunodhinda pariri, asi kune nzira dzakati wandei dzaunokwanisa kuwedzera iyo nzvimbo. Semuenzaniso, shandura kutaridzika kwebepa. Iyo yakasarudzika ndeyekutariswa kwemufananidzo. Inonyatsokodzera matafura ane nhamba yakawanda yemitsara, uye nzvimbo - kana pane mbiru dzakawanda.
Kana iwe uchida yakawedzera nzvimbo, unogona kuderedza migero pamicheto yepepa. Izvo zviduku zvavari, ruzivo rwakawanda runogona kukwana pane rimwe pepa. Chekupedzisira, kana tafura iri diki, unogona kushandisa iyo Custom Scaling Options chimiro kuti ikwane iro gwaro rese pane pepa.
Shandisa misoro pakudhinda
Zvakaoma zvikuru kunzwisisa kuti munhu ari papi patafura kana zvisingakwanisi kudhinda tafura pane rimwe bepa. Muchiitiko ichi, unofanirwa kushandisa "Printa misoro" basa. Zvinokutendera kuti uwedzere mitsara kana misoro yemisoro kune peji yega yega yetafura.
Shandisa mapeji ekutyora
Kana gwaro rako richipfuura pepa rimwechete, ipfungwa yakanaka kushandisa mapeji kutsemuka kuti ikubatsire kunzwisisa chaizvo kuti ndeipi data inofanirwa kunge iri mune imwe nzvimbo. Kana iwe ukaisa peji yekutyora mutafura, zvese zviri pazasi zvinoenda kune inotevera peji. Izvi zviri nyore nekuti zvinokutendera kuti upatsanure data nenzira iyo munhu anoda.
Kana iwe ukatevera kurudziro idzi, unogona kurerutsa kuverenga kweExcel magwaro akadhindwa pabepa.