Mukati
Kana tafura iri muExcel yakareba uye paine data yakawanda mairi, unogona kushandisa basa rakavakwa muchirongwa chinoratidza misoro yetafura pane imwe neimwe yemapeji. Izvi ndezvechokwadi kunyanya pakudhinda mashoko akawanda. Basa rakadaro rinodanwa kuburikidza nemitsara.
Chii chinonzi through line?
Kana iwe uchida kudhinda nhamba huru yemashizha, saka kazhinji pane chido chezita rimwechete kana musoro pane peji imwe neimwe. Kugadzirisa iyi data muExcel spreadsheet ndeye kuburikidza nemutsara. Ichi chimiro hachingodzikisi huwandu hwebasa, asiwo chinobatsira kuita kuti peji yekugadzira iwedzere kunaka.. Kunze kwezvo, nekuda kwemitsara zvinokwanisika kumaka mapepa zviri nyore.
Nzira yekuita sei kuburikidza nemitsara?
Kuti urege kuita nemaoko basa rinorwadza sekupinza ruzivo rwakafanana muzvikamu zvakasiyana zvegwaro, basa rakanakira rakagadzirwa - kuburikidza nemutsara. Zvino, nekungodzvanya kamwe chete, unogona kugadzira musoro mumwe uye musoro, siginecha kana peji yekumaka pane yega gwaro, zvichingodaro.
Teerera! Pane mutsauko wekuti kuburikidza nemitsetse, iyo inomisikidzwa pachiratidziri, asi mukudhinda inodzokororwa kamwe chete pa peji. Muchiitiko ichi, gwaro riri muchirongwa rinogona kupetwa. Uye kune basa re kuburikidza nemitsara, iyo inogona kuratidzwa pane imwe neimwe yemapeji muchimiro chemusoro nhamba yakasarudzwa yenguva. Ichi chinyorwa chichatarisa sarudzo yekupedzisira.
Zvakanakira kuburikidza nemitsara zviri pachena, nekuti nerubatsiro rwavo unogona kuderedza huwandu hwemaawa ekushanda pakombuta, uchiwana mhedzisiro yaunoda. Kuti uite mutsara kuguma-kumagumo, zvakakosha kutevedzera imwe nhevedzano yezviito, zvinoti:
- Enda kumusoro weExcel muchikamu che "Peji Layout", sarudza "Print Headers" uye "Peji Setup".
Izvo zvakakosha kuti uzive! Mukushaikwa kweprinta uye mukati mekugadzirisa maseru, kuseta uku hakuzovepo.
- Mushure mokunge "Peji Setup" chinhu chinowanikwa mukushanda, unofanirwa kuenda kwairi uye chengeta pa "Sheet" tab nemouse, sezvinoratidzwa mumufananidzo. Muhwindo iri, "Kuburikidza nemitsetse" basa rava kutooneka. Dzvanya pandima yekupinza.
- Ipapo iwe unofanirwa kusarudza iyo mitsetse mundiro inoda kugadziriswa. Iwe unofanirwa kusarudza mutsara wekupfuura wakachinjika. Iwe unogona zvakare kuisa nhamba dzemutsara nemaoko.
- Pakupera kwesarudzo, tinya bhatani re "OK".
Nzira yekuongorora kuburikidza nemitsara?
Kuongorora chimiro ichi mumatafura kwakakosha zvakare. Kuti tisaparadze mavhoriyamu makuru ezvinyorwa, tichaita cheki yekupedzisira. Kuti uite izvi, tevera zvinotevera zviito:
- Kutanga, enda kuchikamu che "Faira", icho chiri mumusoro wetafura mukona yekuruboshwe. Wobva wadzvanya bhatani rekuti “Printa”, rinoonekwa paMufananidzo 2.
- Kutariswa kwegwaro kunovhura kurudyi, kwaunogona kutarisa kutevedza kweiyo yakatarwa paramita. Skroka nemapeji ese uye ita shuwa kuti mitsetse yakagadzirwa kare ndeyechokwadi.
- Kuti uende kune rinotevera pepa, ingobaya pavhiri remupumburu padivi rekurudyi. Iwe unogona zvakare kuita izvi negumbo rembeva.
Sezvakangoita kuburikidza nemitsara, unogona kuomesa makoramu chaiwo mugwaro. Iyi parameter inoiswa padanho rakafanana neyekupfuura mutsetse, poindi imwe chete pasi, sezvakaratidzwa mumufananidzo 2.
mhedziso
MuExcel spreadsheet processor, iyo yakaoma inova nyore, uye basa rakareba sekukopa musoro kana peji musoro uye kuuendesa kune vamwe zviri nyore otomatiki. Kugadzira mitsetse inokurumidza uye nyore, ingotevera mirairo iri pamusoro.