2 Nzira dzekusunungura Masero muExcel Tafura

Iyo sero kupatsanura chimiro chiri kudiwa pakati pevashandisi vanogara vachifanira kushanda nematafura. Vanogona kushandisa zvakasiyana-siyana zvekugadzirisa kutora nhamba huru yemasero, ayo anobatanidzwawo kugadzira nzvimbo dzakajairika dzemashoko. Kana ndiro yakadaro yakasikwa nemushandisi pachake, ipapo hapazovi nematambudziko nekubviswa. Zvakanyanya kuomesa mamiriro ezvinhu apo mushandisi anofanirwa kushanda netafura yakatofomatidzwa.

Asi usakurumidza kugumbuka, munyaya ino tichakurukura nzira mbiri dziripo dzokubvisa. Imwe yakatarisana nekushandiswa kuri nyore kwemabasa echirongwa, imwe yacho yakagadzirirwa kushandisa mapaneru ane maturusi makuru.

Zvimiro zvekuparadzaniswa kwesero

Sezvo iyi nzira iri reverse yekubatanidza nzira, kuitira kuti iite, zvakakwana kusunungura ketani yezviito zvakaitwa pavakabatanidzwa.

Teerera! Izvi zvinogoneka zviripo chete kune sero iro rine zvinhu zvakati wandei zvakambobatanidzwa.

Method 1: Sarudzo muMafomati Window

Vazhinji vashandisi vakataura kuti vanoda kushandisa Format Cells kubatanidza maseru. Nekudaro, zviri mune iyi menyu kuti zvinokwanisika kuvabvisa pasina matambudziko, zvakakwana kutevedzera zvinotevera kurudziro:

1. Danho rekutanga nderekusarudza sero rakasanganiswa. Wobva wadzvanya-kurudyi pairi kuti uunze menyu yemukati, panguva imwe chete kuenda kuchikamu che "Format Cells". Sarudzo yakafanana yekudaidza imwe menyu ndeye kushandisa nzira yekudimbudzira "Ctrl + 1".

2. Muhwindo rinoonekwa, iwe unofanirwa kuenda pakarepo kuchikamu che "Alignment", uchiteerera chikamu che "Ratidza". Mariri iwe unogona kuona chiratidzo chakatarisana nechinhu "Sanganisa maseru". Inosara chete kubvisa mucherechedzo uye kuongorora mhedzisiro.

3. Mushure mekupedza matanho, unogona kuona kuti sero yakadzosa iyo yekutanga fomati, uye ikozvino yakakamurwa kuita maseru akati wandei. Masero akasanganiswa emhando ipi neipi anogona kubviswa nenzira iyi.

Zvinokosha! Kiyi yefomati iyi ndeyekutsvaga ruzivo rwakatsanangurwa musero rakabatanidzwa. Nekumisikidza, data rese richaendeswa kumusoro kuruboshwe sero, zvisinei nehuwandu hwemashoko kana rumwe ruzivo rwakatsanangurwa mairi.

Nzira 2: Ribhoni Zvishandiso

Zvino iwe unofanirwa kutarisisa kune mamwe echinyakare sarudzo dzekuparadzanisa maseru. Kuti uite izvi, zvichave zvakakwana kuvhura chirongwa cheExcel, vhura tafura inodiwa uye uite zvinotevera matanho:

1. Danho rekutanga nderekusarudza sero rabatanidzwa. Wobva waenda kuchikamu che "Kumba" pabhari rekushandisa, kwaunoda kushandisa chiratidzo chakakosha mu "Alignment" chinhu, iyo sero ine museve wakapetwa kaviri.

2. Somugumisiro wezviito zvakatorwa, zvichave zvichiita kuparadzanisa masero uye kuona kuti chigumisiro chinenge chakafanana nechakawanikwa mushure mekushandisa nzira yekutanga.

Chenjerera! Pakutanga kuona, zvingaita sekuti nzira dzacho dzinenge dzakafanana, asi pane musiyano mukuru mumwe unofanira kusimbiswa. Semuyenzaniso, kana ukafunga kushandisa nzira yekutanga, ipapo mavara akachengetwa musero rekumusoro kuruboshwe anenge aine kurongeka uye kwakachinjika. Uye kana ukashandisa nzira yechipiri, ipapo kurongeka kwemavara kunenge kwakamira chete.

mhedziso

Iye zvino une nzira dzese dziripo dzekubvisa maseru. Ndokumbira utarise kuti nzira 2 inonyanya kukosha uye iri kudiwa, asi mushanduro nyowani dzeExcel. Ichokwadi ndechokuti mune zvitsva zvepurogiramu, chikamu che "Kumba" chinovhura nekukasira. Uye iwe unogona nekukurumidza kushandisa imwechete yekubvisa icon pasina kushandisa chero humwe hunyengeri.