Maitiro ekushandura kutaridzika kweexcel sheet kuita landscape. Maitiro ekugadzira iyo landscape sheet muExcel

Makambani anoda magwaro mumhando dzakasiyana. Kune mamwe mapepa, kurongeka kwakatwasuka kwemashoko kwakakodzera, kune vamwe - vertical. Zvinowanzoitika kuti mushure mekudhinda, tafura yeExcel isina kukwana inooneka papepa - data inokosha inogurwa nokuti tafura haina kukwana papepa. Gwaro rakadaro harigone kupihwa kune vatengi kana manejimendi, saka dambudziko rinofanira kugadziriswa risati radhindwa. Kuchinja iyo skrini yekutarisa kunobatsira mune mazhinji ezviitiko izvi. Ngatitarisei nzira dzinoverengeka dzekupepeta pepa reExcel zvakachinjika.

Kutsvaga Sheet Oriental muExcel

Mashiti mugwaro reMicrosoft Excel anogona kuve emhando mbiri dzekutarisa - mufananidzo uye mamiriro. Musiyano uripo pakati pawo uri muaspect ratio. Peji remifananidzo rakareba kudarika rakafara - sepeji riri mubhuku. Mamiriro emamiriro ekunze - iyi ndiyo mamiriro apo hupamhi hwepepa hwakakura kupfuura hurefu, uye pepa rinoiswa kunze.

Iyo purogiramu inoseta kutaridzika kwemufananidzo webepa rega rega nekukasira. Kana gwaro racho rikagamuchirwa kubva kune mumwe mushandisi, uye mamwe mashizha anoda kutumirwa kuti adhindwe, zvakakodzera kutarisa kuti ndeapi maitiro akaiswa. Kana iwe ukasateerera kune izvi, unogona kutambisa nguva, pepa neingi kubva pakaturiji. Ngatione kuti chii chinoda kuitwa kuti uone kutaridzika kwepepa:

1. Ngatizadzei pepa - rinofanira kunge riine ruzivo rushoma kuitira kuti iyo skrini ionekwe zvakare. Kana pane data pane pepa, enda mberi.
2. Vhura iyo Faira tebhu uye tsvaga iyo "Printa" menyu chinhu. Hazvina mhosva kana pane printer iri pedyo uye kana yakabatanidzwa kune kombiyuta - ruzivo rwakakosha ruchaonekwa pachikona zvakadaro.
3. Ngatitarisei runyorwa rwezvasarudzo padivi pebepa, imwe yematabo inotaura kuti kutaridzika kwebepa ndeyei (munyaya iyi, mufananidzo). Iwe unogona zvakare kuona izvi nechitarisiko cheshizha, sezvo preview yayo ichivhura kurudyi rwechidzitiro. Kana shiti rakatwasuka - iri bhuku fomati, kana rakachinjika - landscape.

Zvinokosha! Mushure mekutarisa, mutsara une doti unoonekwa papepa, uchikamura munda kuita zvikamu. Zvinoreva miganhu yemapeji kana yakadhindwa. Kana iyo tafura yakakamurwa nemutsara wakadaro kuita zvikamu, haizodhindwe zvachose, uye iwe unofanirwa kugadzira iyo pepa fomati yekudhinda yakachinjika.

Funga nzira dzinoverengeka dzekushandura nzvimbo yepepa nhanho nhanho.

Kuchinja Maonero Kuburikidza Nekudhinda Zvaunoda

Usati wadhinda, haugone kutarisa chete kuti pepa uye mapeji ari pairi anotariswa sei, asi zvakare shandura maitiro ayo.

1. Vhura iyo "Faira" tebhu zvakare pane iyo toolbar uye enda kune "Printa" chikamu.
2. Isu tinotarisa kuburikidza nerondedzero yezvasarudzo uye tinowana mairi pani ine chinyorwa "Portrait oientation". Iwe unofanirwa kudzvanya pamuseve uri kurudyi rwepaneru iyi kana pane imwe nzvimbo mairi.

3. Menyu diki ichaonekwa. Nzvimbo yakatwasuka yepepa inodiwa, saka isu tinosarudza mamiriro ekutarisa.

Teerera! Mushure mekushandura kutaridzika kune preview, pepa rakachinjika rinofanira kuoneka. Ngatitarisei kana makoramu ese etafura ave kusanganisirwa papeji. Mumuenzaniso, zvose zvakashanda, asi izvi hazvisi nguva dzose. Kana, mushure mekugadzirisa mamiriro ekunze, tafura haina kukwana zvakakwana pane peji, unoda kutora mamwe matanho, semuenzaniso, shandura chiyero chekubuda kwemashoko kune peji paunenge uchidhinda.

Oientation shanduko kuburikidza neToolbar

Chikamu chine maturusi ePeji Setup chichabatsirawo kuita kuti shizha rive mufomati. Unogona kusvika kwairi kuburikidza nemhando dzekudhinda, asi hazvibatsiri kana ukagona kushandisa bhatani re “Portrait/landscape”. Ngatione kuti chii chimwe chingaitwe kushandura chikamu cheshizha.

1. Vhura iyo Peji Yekumisikidza tebhu patoolbar. Kuruboshwe kwaro kune chikamu che "Peji Setup", tsvaga iyo "Oriental" sarudzo mairi, tinya pairi.

2. Chinhu "Landscape orientation" ndicho chaunoda kusarudza. Mushure meizvozvo, mutsara une doti unokamura pepa mumapeji unofanirwa kufamba.

Kuchinja kutaridzika kwemapepa akawanda mubhuku

Nzira dzekare dzekutenderedza bepa kuenda panzvimbo yakachinjika dzinoshanda pabepa rimwe chete rebhuku. Dzimwe nguva zvakakosha kudhinda mapepa akawanda ane maitiro akasiyana, nokuda kweizvi tichashandisa nzira inotevera. Fungidzira kuti iwe unofanirwa kushandura chinzvimbo chemashizha ari kuenda zvakarongeka. Hezvino izvo zvaunofanira kuita kune izvi:

1. Bata pasi kiyi ye "Shift" uye tsvaga yekutanga tebhu ine chekuita nebepa raunoda kuchinja.
2. Sarudza akati wandei mapepa kusvika mapepa ese anodiwa asarudzwa. Ruvara rwematabo runozoreruka.

Iyo algorithm yekusarudza mapepa asina kurongeka akasiyana zvishoma.

1. Bata pasi "Ctrl" kiyi uye tinya pane yekutanga yaunoda tab.
2. Sarudza ma tabo anotevera nekudzvanya mbeva pasina kuburitsa "Ctrl".

3. Kana ma tabo ese asarudzwa, unogona kusunungura "Ctrl". Iwe unogona kuziva kusarudzwa kwematabo nemuvara.

Zvadaro, unofanirwa kushandura kutaridzika kwemashizha akasarudzwa. Isu tinoita zvinoenderana neinotevera algorithm:

1. Vhura iyo "Peji Layout" tab, tsvaga iyo "Oriental" sarudzo.
2. Sarudza landscape orientation kubva pane rondedzero.

Zvakakosha kutarisa kutaridzika kwemashizha pamwe chete nemitsetse ine dotted. Kana dziripo sezvinodiwa, unogona kuenderera mberi nekudhinda gwaro. Zvikasadaro, iwe unofanirwa kudzokorora matanho acho zvakanyatsoenderana neiyo algorithm.

Kana kudhinda kwapera, unofanira kubvisa mapepa ari muboka kuitira kuti kuungana uku kusazokanganisa kushanda kweramangwana nematafura ari mugwaro iri. Isu tinodzvanya pane rimwe remapepa akasarudzwa ane bhatani rekurudyi uye tsvaga "Ungroup Sheets" bhatani mune menyu inooneka.

Chenjerera! Vamwe vashandisi vari kutsvaga kugona kushandura mafambiro emapeji akati wandei mukati mepepa rimwe chete. Nehurombo, izvi hazvigoneke - hapana sarudzo dzakadaro muMicrosoft Excel. Kushandura kutaridzika kwemapeji ega hakugone kuwanikwa nemaadd-ons kana.

mhedziso

Mamiriro eExcel sheet ipikicha uye mamiriro, mutsauko uripo pakati pawo uri muchikamu chechikamu. Unogona kushandura kutarisisa uchishandisa madhinda marongero kana sarudzo paPeji Kumisikidzwa tebhu, uye unogona zvakare kutenderedza akawanda mapepa, kunyangwe ari kunze kwehurongwa.