Maitiro ekutambanudza tafura kune yakazara sheet muExcel

Paunenge uchigadzira matafura muMicrosoft Office Excel, mushandisi anogona kuwedzera saizi yehurongwa kuti awedzere ruzivo rwuri mumaseru. Izvi zvinobatsira kana zviyero zvepakutanga zvidiki uye zvisingaite kushanda nazvo. Ichi chinyorwa chinopa maficha ekuwedzera matafura muExcel.

Maitiro ekuwedzera saizi yematafura muExcel

Pane nzira mbiri huru dzekuzadzisa chinangwa ichi: kuwedzera masero ega ega eplate manually, somuenzaniso, makoramu kana mitsetse; shandisa iyo skrini zoom basa. Muchiitiko chekupedzisira, chiyero chepepa rekushanda chichave chakakura, sechikonzero chekuti zviratidzo zvose zviri pairi zvichawedzera. Nzira mbiri idzi dzichakurukurwa zvakadzama pasi apa.

Nzira 1. Nzira yekuwedzera sei hukuru hwemasero ega ega etafura yetafura

Mitsara iri patafura inogona kukwidziridzwa sezvinotevera:

1. Isa mutsara we mouse pazasi pemutsara kuti uwedzere pamuganhu wayo nemutsara unotevera.
2. Tarisa kuti cursor yashanduka kuita museve une mativi maviri.

3. Bata LMB uye fambisa mbeva pasi, kureva kubva pamutsetse.
4. Pedzisa basa rekudhonza kana musono wasvika pakukura kwaidiwa nemushandisi.

5. Saizvozvo, wedzera chero imwe mutsara mutafura yakaratidzwa.

Teerera! Kana, wakabata LMB, tanga kufambisa mbeva kumusoro, mutsara uchatetepa.

Saizi yemakoramu inowedzera nenzira imwechete:

1. Gadzirisa mbeva kudivi rekurudyi rakanyanyisa mbiru, kureva pamuganhu wayo nekoramu inotevera.
2. Ita shuwa kuti cursor inochinja kuita museve wakapatsanuka.
3. Bata bhatani rekuruboshwe uye fambisa mbeva kurudyi kuti uwedzere saizi yekoramu yekutanga.

4. Tarisa mhinduro.

Nenzira yakatariswa, iwe unogona kuwedzera makoramu nemitsara mutafura kusvika kune isingaverengeki kukosha kusvikira hurongwa hwatora nzvimbo yese yepepa rebasa. Kunyangwe miganhu yemunda muExcel isina miganhu.

Nzira 2. Kushandisa chigadziro chakavakwa kuti uwedzere hukuru hwezvinhu zvetafura

Kune zvakare imwe nzira yekuwedzera saizi yemitsara muExcel, iyo inosanganisira anotevera manipulations:

1. Sarudza LMB mutsara mumwe kana kupfuura nekufambisa mbeva munzira "yepamusoro-pasi" yepepa rebasa, kureva kuti yakamira.
2. Tinya-kurudyi pachimedu chakasarudzwa.
3. Mune menyu yemukati, tinya pane "Row urefu ...".

4. Mumutsara wega wehwindo rinovhurwa, tsiva iyo yakanyorwa urefu kukosha nenhamba yakakura uye tinya "OK" kushandisa shanduko.

5. Tarisa mhinduro.

Kutambanudza makoramu uchishandisa chishandiso chakavakirwa muchirongwa, unogona kushandisa murairo unotevera:

1. Sarudza mune yakachinjika nzira iyo chaiyo column yetafura inoda kukwidziridzwa.
2. Tinya-kurudyi kwese kwese muchikamu chakasarudzwa uye sarudza iyo "Column wide ..." sarudzo kubva kumenyu.

3. Iwe unofanirwa kunyoresa hurefu hunokosha huchave hwakakura kudarika huripo.

4. Ita shuwa kuti chinhu chetafura array chakawedzera.

Zvinokosha! Mu "Column Width" kana "Row Height" windows, unogona kushandura maitiro akatsanangurwa kakawanda kusvika mushandisi awana mhedzisiro yaunoda.

Nzira 3: Kugadzirisa kuyera kwekutarisa

Iwe unogona kutambanudza pepa rose muExcel nekuwedzera kuyera skrini. Iyi ndiyo nzira yakareruka yekupedzisa basa iri, iro rakakamurwa kuita zvinotevera:

1. Vhura gwaro reMicrosoft Excel raunoda nekumhanyisa faira rakachengetwa pakombuta yako.
2. Bata pasi "Ctrl" bhatani paPC keyboard uye uibate.
3. Pasina kuburitsa "Ctrl", penya vhiri regonzo kumusoro kusvika chidzitiro chawedzera kusvika kuhukuru hunodiwa nemushandisi. Nokudaro, tafura yose ichakura.
4. Iwe unogona kuwedzera kuyera skrini neimwe nzira. Kuti uite izvi, paunenge uri pane pepa reExcel, unofanirwa kufambisa inotsvedza mukona yekurudyi yekona kubva - kuenda +. Sezvo ichifamba, iyo zoom mugwaro inowedzera.

Mamwe Mashoko! Excel zvakare ine yakakosha "Zoom" bhatani mu "Tarisa" tebhu, iyo inokutendera iwe kuti uchinje iyo skrini inokwira kumusoro nekudzika.

Nzira 4. Shandura chiyero chetafura yetafura usati wadhinda gwaro

Usati wadhinda tafura kubva kuExcel, unofanirwa kutarisa chiyero chayo. Pano iwe unogona zvakare kuwedzera saizi yearray kuitira kuti itore rose A4 sheet. Zooming isati yadhinda inoshanduka zvichienderana nechirongwa chinotevera:

1. Dzvanya bhatani re "Faira" mukona yepamusoro kuruboshwe rwechidzitiro.
2. Muwindo remhando yezvinyorwa, tinya LMB pamutsara wekuti "Printa".

3. Muchikamu che "Settings" mumenu inooneka, tsvaga bhatani rekushandura chiyero. Mune ese mavhezheni eExcel, inowanikwa kwekupedzisira mune rondedzero uye inonzi "Yazvino".
4. Wedzera iyo column ine zita rekuti "Yazvino" uye tinya pamutsara "Custom scaling options ...".

5. Mu "Peji Sarudzo" hwindo, enda kune yekutanga tebhu, muchikamu che "Chiyero", isa shanduko yekuchinja mumutsara we "Set" uye isa nhamba yekukura, semuenzaniso, 300%.
6. Mushure mekudzvanya "OK" tarisa mhedzisiro pahwindo rekuona.

Teerera! Kana iyo tafura isiri pane iyo yese A4 peji, saka iwe unofanirwa kudzokera kune imwechete hwindo uye tsanangura imwe nhamba. Kuti uwane mhedzisiro yaunoda, iyo nzira ichafanirwa kudzokororwa kakawanda.

mhedziso

Nekudaro, zviri nyore kutambanudza tafura muExcel kune yakazara peji uchishandisa iyo skrini yekuyera nzira. Yakatsanangurwa zvakadzama pamusoro apa.