Maitiro ekudhinda tafura yekunyanyisa pane imwe pepa. Kuchinja tsika, kurongedza miganhu yemakoramu uye mitsara, peji uye prineta paramita

Pakupera kwebasa kuMicrosoft Office Excel, vashandisi vane kuda kudhinda gwaro. Zvishandiso zvakavakwa muhurongwa hunokutendera kuti udanidze tafura yacho zvachose pane iyo A4 pepa. Nekudaro, izvi zvinoda huwandu hwenhamba dzinoverengeka dzichakurukurwa munyaya ino.

Kumisikidza parameter peji

Chekutanga pane zvese, iwe unofanirwa kutarisa marongero eiyo iripo yekushanda pepa uye uchengetedze kana zvichidikanwa. Kune akati wandei ma parameter yakadaro muBudiriki, kuti unzwisise zvakakwana wenyaya, zvakafanira kufunga zvakadzama mumwe nemumwe wavo.

Nzira ye "Peji Paramende" hwindo. Iyo algorithm inoshanda kune ese shanduro dze Excern tabs

Iyi ndiyo interface kubva kumusoro kwehwindo rechirongwa. Zvimwe zvezvinhu zvayo zvichafanira kushandisa kana uchiisa iyo sheet parameter.

Peji

Kuti utarise kutaridzika kweiyo pepa uye kugadziridza, zvakakodzera kuita zviito zvinotevera pane algorithm:

1. Chinja kune "peji peji marongep" tab kumusoro kweMicrosoft Excel.
2. Pazasi pechikamu chekutsvaga peji "Peji Zvirongwa" uye tinya pamukuru, iri mukona yekurudyi. Hwindo rinoenderana rinofanira kuvhura.
3. Enda ku "Peji" kuti uite zvakakodzera marongero.

Zviito zvinoda kuurayiwa mu "peji" kuisa tafura pane imwe yebasa pepa

Kana matafura ekudhinda muExcel, zvakakosha kufunga nezvehukuru hwemunda. Iyi ndiyo chinhambwe iyo inokwanirwa kubva kumucheto kweshizha risati ratanga rugwaro. Tarisa kukosha kwakaratidzwa kune minda seinotevera:

1. Maererano nehurongwa hwakafanana hunokurukurwa mundima yapfuura, fambisa kuchikamu chePage "Peji Makoku" pamusoro pechirongwa, uye wobva wadzvanya LKM pane "Peji Zvirongwa" bhatani.
2. Mune hwindo rinozivikanwa, iyo icharatidzwa mushure mekuita izvi manipulations, iwe unofanirwa kuenda kune "minda" tab.
3. Ichi chikamu chemushandisi chinofarira chinhu "pakati pamapeji". Zvichienderana neyekutarisa kwepepa pano iwe unofanirwa kuisa tick kana yakatarisana nemunda "yakatwasuka" kana padivi peiyo kukosha ".
4. Chinja hunhu hwepamusoro uye pasi pehunhu kana zvichidikanwa. Nekudaro, izvi hazvigone kuitwa panguva ino.

Chinja tsika dzepamusoro uye footer muminda yeminda. Iyo zvakare inokurudzirwa kushandisa iyo sheet internet basa.

Iyi ndiyo yekupedzisira tab iri mupeji "Peji Zvirongwa", iyo ine mutoro wemhando yezvinyorwa zvakadhindwa. Muchikamu chino, iwe unogona kududzira imwe yemhando dzekudhinda: Grid, dema uye chena, yakaoma, tambo misoro uye makoramu uye makoramu. Izvo zvakare zvinokwanisika kutsanangura chikamu chetafura yekudhinda kana iyo ndiro yese isina kuiswa pane imwe pepa nekunyora zviyero zvaunoda mu "purinda" row.

Kutaridzika sepuru "pepa" mu "Peji Paramende" hwindo retsoka

Idzi ndidzo dzimwe nzvimbo dzegwaro dzinozotendiswa pachinhu chimwe nechimwe. Yakaderedza kukosha kweanofambaguru, mushandisi anosunungura nzvimbo yekuwedzera pane pepa rebasa, rinobatsira kuratidza chiratidzo. Kuti ubvise zvachose kuburikidza nekunyora kubva kune ese magwaro ayo achaonekwa kana achidhinda, iwe unofanirwa kuita maererano nemirairo:

1. Enda kune "peji peji marongep" tab pamusoro pemenyu huru yechirongwa.
2. Dzvanya kamwe chete pa "Peji Zvirongwa" bhatani.
3. Dzvanya pane izwi rekuti "tsoka" mumusoro wepamhepo graphice graph yakaratidza windows.
4. Muminda "yepamusoro footer" uye "footer" seta kukosha "(kwete)" kusabvisa zvachose kuburikidza zvakanyorwa.

Kudzima misoro mune yakakodzera subsection

Kana mushandisi airatidza zvese zvinodiwa paramita, zvichave zvinokwanisika kuti uchinje kugwaro rekudhinda. Nechinangwa ichi, iwe unofanirwa kuita matanho anotevera:

1. Saizvozvo, pinda mu "Peji Zvirongwa" hwindo.
2. Muwindo rinovhura, enda ku "peji" tab.
3. Pazasi pemenyu, iwe unofanirwa kudzvanya pane "maonero" bhatani, mushure meizvozvo iyo huru yekudhinda yekubuditsa inobuda.
4. Kurudyi kwehwindo iro rakavhurika richaratidzwa nzvimbo yefurafura papepa rekushandira. Kana zvese zvive masutu pano, saka iwe unofanirwa kudzvanya pane "prinda" bhatani riri mukona yekumusoro kuruboshwe. Kana zvichidikanwa, muhwindo urwu, iwe unogona kugadzirisa iyo parmeter yekudhinda uye nekukurumidza tarisa shanduko.

Kubuda kwegwaro rekudhinda rine fungidziro

Maitiro ekudzora (compress) tafura yakakura yekudhinda pane imwe pepa reA4 fomati

Dzimwe nguva tafura yakakura saizi muExcel haina kukwana pane rimwe pepa. Mumamiriro ezvinhu aripo, iwe unogona kuderedza tafura yakarongedza kune iyo yaunoda saizi kuti ienderane pane imwe chete A4 pepa. Maitiro aya anoitwa mumatanho akati wandei, imwe neimwe ichatsanangurwa pazasi.

Isa pepa mune peji rimwe

Iyi nzira yakakodzera kana imwe diki ye tafura ichienda kupfuura imwe chete yekushanda pepa reA4 fomati. Kuti ubvise ndiro kune imwe pepa, iwe uchafanirwa kuita huwandu hwezviito zvisina kuoma:

• Wedzera chikamu chefaira mukona yekumusoro kuruboshwe rwechirongwa nekudzvanya pairi kamwechete iyo lkm.
• Mukati menyu, tinya pane "Prinda" mutsara.

Nzira yeku "kudhinda parameter" hwindo muExcel

• Padivi kurudyi kwehwindo inoratidza zvese ruzivo pane kudhinda kwegwaro. Pano mushandisi anozoda kuwana iyo "Setup" Subsection.
• Dzvanya pane mukuru naRomd ne "ikozvino" poindi uye tinya pane sarudzo "pinda pepa re peji rimwe."
• Mirira kusvikira Microsoft Office Excel inopedzisa maitiro ekukodzera tafura uye kuvhara hwindo nemamiriro acho.
• Tarisa uone mhedzisiro yacho.

Shanduko yeMunda

Iyo yakajairwa munda kukosha yakaratidza mukubiridzira inotora nzvimbo yakawanda pane pepa. Kusunungura nzvimbo, paramende iyi inofanira kuderedzwa. Ipapo tafura inogona kusarudza kana kuiswa pane rimwe pepa. Izvo zvinodikanwa kuita seinotevera:

• Maererano nehurongwa hwakakurukurirana pamusoro, enda kuchikamu "peji peji peji", uye wobva wadzvanya pane "Peji Zvirongwa" bhatani.

Kuvhura iyo peji "Peji Zvirongwa". Nhanho nedanho algorithm

• Muwindo rinoratidzwa, swachinja kune chikamu "minda".
• Deredza kumusoro, pasi, kuruboshwe uye kuruboshwe ndima yeminda kana kuita iyi parameter zero, wobva wadzvanya "OK".

Kuchinja saizi yeminda mune inoenderana tab ye "Peji Paramende" Peji Mode

Iyi sarudzo muExcel, inobvumidza iwe kuti uone kuoneka miganhu yeiyo inoshanda pepa, fungidzira saizi yavo. Maitiro ekumanikidza tafura uchishandisa iyo peji mode yakakamurwa kuita matanho akati wandei, imwe neimwe yakafanirwa nekunyatsodzidza:

• Vhura iyo razvino pepa uye switch kune iyo "maonero" tab, iri pamusoro pemamenji makuru epurogiramu.
• Muvhudzi rakavhurika, tinya pane bhatani "GAP Mode" kuti uite sarudzo.

Zviito zvekumisa iyo peji mamiriro muExcel

• Mune hwindo idzva, tsvaga yechipiri yebhuruu yakadonhedzwa mutsara uye uibvise kubva kuruboshwe chinzvimbo kune zvakanyanyisa kurudyi. Sezvo izvi strip inofamba, saizi yetafura ichaderera.

LEFIF TORIEST

Kuti ubvise tafura yakarongeka pane pepa rimwe, zvakakosha kusarudza kutaridzika kwayo nenzira kwayo. Iyo inotevera algorithm ichabatsira kuchinja razvino kutaridzika kwegwaro:

1. Vhura nzira yemugwagwa, iyo iyo ichave inokwanisika kuti unzwisise chimiro chedanda riri papepa rebasa. Kuti uite kuti mode, iwe unofanirwa kuenda ku "maonero" tab pamusoro pemamenji makuru echirongwa, uyezve mune mudziyo pazasi, tinya pa "Peji Markup" bhatani.
2. Iye zvino iwe unofanirwa kuenda kuchikamu "peji peji peji" uye tinya pane "kutaridzika" mutsara.
3. Chinja chirongwa chazvino uye tarisa kunzvimbo yetafura. Kana iyo yakarongedzwa yakavezwa pane yebasa pepa, saka iyo yakasarudzwa kutaridzika kunogona kusiiwa.

Kuchinja iyo yekutarisa kwepepa muExcels kuchinja masayizi emasero

Dzimwe nguva ndiro yacho haina kupindira neiyo yeiyo A4 pepa nekuda kwemasero makurukota. Kuti ugadzirire dambudziko remasero, zvinodikanwa kuderedza chero munzira yakatwasuka kana yakatwasuka zvichienderana nemamiriro ezvinhu chaiwo. Kuti udzorere zvinhu zve tafura yetafura, iyo inotevera manipolations inofanira kuitwa:

• Sarudza zvizere denderedzwa raunoda kana tambo patafura neiyo yekuruboshwe kiyi yeanipulator.
• Dzvanya iyo LKM Cell pamuromo weiyo dombo rekutenderera kana mitsara uye kuifambisa munzira yakakodzera: yakatwasuka kuruboshwe kana yakatwasuka. Kunzwisisa kunonzwisisika kuratidzwa mune skrini pazasi.

Manual Kuderera kweCell Saizi muMicrosoft Office Excel

• Kana zvichidikanwa, shandura hukuru hwemasero ese. Nechinangwa ichi, iwe unotanga kuchinjisa kune "imba" tab, uye wozoenda kuchikamu "masero".
• Tevere, isaira iyo "fomati" inotevera uye mune iyo mamiriro menyu, tinya pane mutsara "mutsara urefu mutsara".

Activation yekuzadza basa rekureba kwekureba

Dhinda chikamu kana chidimbu chakazvitsaurira

Mukurinda, unogona kupurinda chete iyo mushandisi chikamu chetafura. Kuti uite izvi, iwe uchafanira kuita matanho akati wandei pane algorithm:

1. Sarudza iyo inodiwa nzvimbo yeTafura Array kuruboshwe bhatani bhatani.
2. Dzvanya pane "Faira" bhatani mukona yekumusoro kuruboshwe rwekona.
3. Dzvanya "PRIND" mutsara.
4. Muchikamu chikamu, kumisikidza kurudyi rwechidzitiro, tinya LKM maererano ne "Dhinda Akazvitsaurira Fragment" sarudzo.
5. Tarisa uone mhedzisiro yacho. Yakasarudzwa kare chikamu chetafura inofanira kudhindwa.

Kudhinda chete zvakasarudzika zviratidzo zvechiratidzo

Maitiro ekudhinda tafura isina chinhu kuti izadze nemasero eiyo peji rese

Kuita basa raunoda:

1. Saizvozvo activate iyo "peji peji" nekutendeuka kuita "maonero" tab. Mitsetse yakagadzirwa iyo iyo nharaunda ichave yakanyorwa ndeye miganhu yemashiti ebasa.
2. Sarudza chero sero nekudzvanya kiyi yekuruboshwe yeanipulator.
3. Dzvanya pane iyo PCM Cell uye sarudza iyo sarudzo ye "cell form fomati" mune iyo mamiriro ewindows.
4. Menyu yekuwedzera ichavhura, umo iwe unofanirwa kuchinjisa kuchikamu che "muganho" kubva kumusoro.
5. Dzvanya "kunze" uye "zvemukati" mabhatani nekusarudza iyo yakakodzera mapikicha.

Activation yekunze uye yemukati mapikicha ekudhinda tafura isina bata

1. Dzvanya "OK" pazasi pewindo uye tarisa mhedzisiro yacho.

Dhinda mapeji maviri egwaro reExel pane rimwe chete pepa

Ichi chiito chinosanganisira kuiswa kwekutenderera kwekudhinda. Kuita izvi kugona kuda:

1. Dzvanya iyo LKM pane iyo "Faira" bhatani pamusoro pemamenji makuru.
2. Enda ku "prinda" chikamu.
3. Wedzera iyo "Bilateral Dhinda" Subsection uye sarudza imwe yenzira dzinogona nekuverenga tsananguro yavo.

Activation yekudhinda kaviri kudhinda muExcel

Mhedziso

Nekudaro, muExcel, kukodzera tafura ine huwandu hwakawanda hwe data pane imwe pepa iri nyore. Chinhu chikuru chekuita huwandu hwehunyanzvi hwakakodzera, iyo huru yeiyo yakatsanangurwa pamusoro apa.

Mharidzo Maitiro Ekudhinda tafura yekunyanyisa pane rimwe pepa. Kushandura iyo nzira yekutarisa, kurongedza miganhu yemakoramu uye mitsara, iyo paramita yepeji uye kudhinda yakatanga kuoneka pane technologies.