Maitiro ekubvisa zvakanyorwa "Peji 1" muExcel

Excel chirongwa chepasirese uye chine mazana emabasa akasiyana anoita kuti zvive nyore kushanda negwaro, kukurumidza kugadzirisa ruzivo, uye kunyange kushanda pakugadzira peji re data. Ichokwadi, nekuda kwekuwanda kwemabasa akasiyana-siyana, vashandisi vazhinji vanotarisana nedambudziko rekutsvaga mune gwaro, uye dzimwe nguva mamiriro akasiyana anogona kungotungamirira kune stupor. Ichi chinyorwa chinoongorora mamiriro ezvinhu apo, pakuvhura gwaro, mapeji akati wandei anoonekwa kamwechete kana yekumashure yekupinda "Peji 1" inopindira.

Ndezvipi zvimiro zvechimiro chechimwe chinyorwa?

Usati wagadzirisa dambudziko racho, unofanira kunyatsoridzidza. Haisi chakavanzika kuti mafaera ane Excel yekuwedzera anogona kuchengetwa mune akasiyana mafomati. Semuenzaniso, muyero ndeye "Regular Format", iyo inopa tafura yakazara ine ruzivo uye kugona kuigadzirisa zvakasununguka.

Inotevera inouya "Peji Layout", iyi ndiyo chaiyo fomati ichakurukurwa. Inowanzochengetedzwa nemushandisi akagadzirisa zvirimo uye akagadzirisa kutaridzika kwetafura yekuzodhinda gare gare. Muchidimbu, hapana chekunetsekana nacho, nekuti chimiro chekuchengetedza chakadaro mhedzisiro yekuyedza kugadzirisa gwaro sezvinodiwa pakuona kwekuona.

Kune zvakare "Peji modhi", iyo inoitirwa chete kudzidza ruzivo muchimiro che "chinangwa" kuzara. Ndiko kuti, mune iyi modhi, zvisingakoshi zvinyorwa uye masero asina chinhu anonyangarika mutafura, iyo chete nzvimbo yakazadzwa yakazara inosara.

Ese mamodhi aya akagadzirwa chete kumushandisi anoda kudzora zvese uye anoshandisa zvizere iyo iripo mashandiro. Kana iwe kazhinji uchifanirwa kushanda nematafura, saka imwe neimwe yeaya mafomati ichave yakashinga kushandiswa kwete chete pakunyatsoongorora ruzivo rwese, asiwo nekugadzira matafura ekuzodhinda.

Nzira yekutanga yekushandura fomu yegwaro

Zvino ngatitarisei nzira yekutanga yekushandura dhizaini fomati, iri nyore uye yakatwasuka sezvinobvira. Ichakubvumidza kuti uchinje tafura fomati mune imwe nyaya yemasekonzi kuitira kuti usakanganiswe nezvimwe zviito uye nekukurumidza tanga kushanda nedata. Kuti aite izvi, unofanira kuita zvinotevera:

1. Tangisa Excel uye vhura faira rine isina kujairika tafura fomati.
2. Mushure mekuvhura gwaro, teerera kune yezasi yekurudyi chikamu chepaneru, uko inoverengeka font size control inowanzo kuwanikwa. Ikozvino, mukuwedzera kune iyo zoom shanduko basa pachayo, kune mamwe matatu mifananidzo: tafura, peji, uye universal markup.
3. Kana ukasangana nefomati yefaira ine akawanda mapeji kana "Peji 1" yekumashure yekupinda, ipapo iyo "Peji Layout" fomati inovhurwa uye inomiririrwa sechipiri chiratidzo kubva kuruboshwe.
4. Tinya kuruboshwe pane yekutanga "Regular Format" icon, uye iwe uchaona kuti kutaridzika kwetafura kwachinja.
5. Iwe unogona kugadzirisa ruzivo rwuripo kana kushandura zvachose tafura.

Nenzira iyi, unogona kukurumidza kushandura chimiro chegwaro uye uwane kutaridzika kunoshandiswa nevashandisi vazhinji. Iyi ndiyo nzira yakapusa uye inokurumidza yave kuwanikwa mushanduro itsva dzeExcel.

Yechipiri nzira yekushandura iyo gwaro fomati

Zvino funga nzira yechipiri yekushandura chimiro chegwaro, izvo zvinokutendera iwe kuti uwane yaunoda rudzi rwe data kuti ushandise gare gare kana kugadzirisa. Iwe unofanirwa kuita zvinotevera:

1. Tanga chirongwa cheExcel.
2. Vhura gwaro rine fomati isiriyo.
3. Enda kune yepamusoro basa bar.
4. Sarudza iyo View tab.
5. Izvo zvinodiwa kuti usarudze chimiro chegwaro.

Iyi nzira inotora nguva yakati wandei, asi ndeyese uye inoshanda, mushure mezvose, zvisinei neshanduro yechirongwa, unogona kuenda kwairi uye kumisa iyo yaunoda gwaro fomati.

mhedziso

Tinokurudzira kushandisa chero nzira dziripo, sezvo imwe neimwe yadzo inoshanda uye inokwanisika. Nekuda kwezviito izvi, unogona kukurumidza kushandura fomati yegwaro kuti uwedzere kushandisa ruzivo. Shandisa mazano uye uvandudze hunyanzvi hwako seyepamusoro Excel mushandisi.