MuExcel, miganhu ndiyo miganhu yakawedzerwa kumiganhu yesero kana boka remasero.
Mitsara yemigwagwa inogona kushandiswa kumiganhu inosanganisira isina imwe, kaviri, uye dzimwe nguva miganhu yakaputsika. Uturu hwemitsara hunogona kusiyana sezvinokwanisa ruvara.
Mhirizhonga inogadzirisa zvinhu zvinoshandiswa kugadzirisa kuonekwa kwebasa rako rekushanda . Vanogona kuita kuti zvive nyore kuwana uye kuverenga zvakananga data.
Zvinogonawo kushandiswa kutora pfungwa kune zvakakosha data dzakadai semigumisiro yemafomu .
Kuwedzera mitsetse nemiganhu inzira inokurumidza kuisa mazano anokosha muExpcel.
Nhamba yematombo, mabheji e data , kana mazita anokosha uye misoro inogona kuita zvose kuonekwa nekuwedzera kwemiganhu nemiganhu.
Kuwedzera Muganhu uchishandisa Keyboard Shortcut
Cherechedza: Ichitsvaga ichi chinowedzera muganhu kune mhiri dzenhengo imwechete kana kupfuura yakasarudzwa mashandisi anoshandisa mutsara wekutsvaga mutsara uye uwandu.
Iko kusanganisa kukuru kwekuwedzera miganhu ndeyokuti:
Ctrl + Shift + & (ampersand key)Muenzaniso weNzira yekuwedzera micheche uchishandisa Keyboard Shortcut
- Simbisai madivi akareba aidiwa mubasa rekushanda
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye usunungure nhamba ya ampersand key (&) - pamusoro pe nhamba ye 7 pabhobhodi - pasina kusunungura Ctrl uye Shift keys.
- Masero akasarudzwa anofanira kunge akakomberedzwa nemuganhu wakanga.
Kuwedzera Muganhu muEccel Uchishandisa Ribbon Options
Sezvinoratidzwa mumufananidzo wepamusoro, sarudzo yeMiganhu iri pasi peKumba tab yebhoni .
- Simbisai madivi akareba aidiwa mubasa rekushanda
- Dzvanya paImba yebhu yebhoni;
- Dzvanya paMiganhu yeChirungu paibhoni kuti uzarure mhando yezvinyorwa sezvinoratidzwa mumufananidzo uri pamusoro;
- Dzvanya pamhando yaidiwa yemuganhu kubva kumenyu;
- Muganhu wakasarudzwa unofanira kuonekwa kumativi ose masero akasarudzwa.
Border Options
Pane zvakawanda zvakawanda zvingasarudzwa kana zvasvika pakuwedzera nekugadzirisa miganhu nemiganhu:
- miganhu inogona kuwedzerwa kune rimwe kana mativi ose eesero kana bhokisi remasero;
- Kusika kwakasiyana kwemitsara kunogona kushandiswa;
- mhando dzakasiyana dzemitambo dziripo;
- kune mavara emarudzi ekusarudza kubva;
- Excel's draw draw borders inogona kushandiswa kukwevera miganhu yakapoteredza zvisikwa zvakasiyana-siyana zvematare, sezvinoratidzwa mumufananidzo wemufananidzo.
Drawing Borders
Sezvinoratidzwa mumufananidzo, Dhimbwa yeBorder Border inowanikwa pasi peMiganhu yeDoner down-menu sezvinoratidzwa mumufananidzo pamusoro apa.
Chimwe chekushandisa kushandisa mitsara yekutora ndeyekuti hazvifaniri kusarudza masero kutanga. Pane kudaro, kana mitsetse yakasarudzwa sarudzo inosarudzwa miganhu inogona kuwedzerwa zvakananga pane pepa rekushanda, sezvaratidzwa kurudyi rwemufananidzo.
Kushandura Mutsara Muvara uye Mutsara
Dhonza Mitsara inewo zvigadzirisho zvekuchinja mutsara wemutsetse uye mararamiro emutsetse, izvo zvinoita kuti zvive nyore nyore kusiyanisa maitiro emiganhu inoshandiswa kujekesa zvakakosha mabheji e data.
Nzira dzekutsvaga mutsara dzinokubvumira kuti uise miganhu ne:
- mitsetse yakasiyana-siyana
- mitsara yakazara uye yakasvibiswa
- miganhu miviri
Achishandisa Draw Borders
- Dzvanya paImba yebhu yebhoni;
- Dzvanya paMiganhu yechisarudzo pane ribhoni kuti uzarure pasi redu;
- Shandura mutsara wemutsetse uye / kana mutsara wemutsara kana uchida;
- Dzvanya paDraw Border pane pasi pekuderera pasi menyu;
- Purogiramu yeganda inopinda mupeni-sezvinoratidzwa kurutivi rworudyi rwemufananidzo;
- Dzvanya pamunhu oga gridlines kuti uwedzere miganhu imwe chete munzvimbo idzi;
- Dzvanya uye dhonza nenhainter kuti uwedzere kunze kwemiganhu kusero kana masero.
Dhonza Border Grid
Imwe sarudzo yeDraw Border ndeyekuwedzera zvose kunze uye mukati memiganhu kune imwe kana mamwe masero panguva imwechete.
Kuti uite kudaro, chengeta uye dhonza kumativi ose masero uye "shandisa grid yemuganhu" kuti ugadzire mhiri kumativi ose masero ari chikamu chekusarudzwa.
Rega Kuchera Mitsva
Kuti urege kugadzira miganhu, zvinyorai kechipiri pane muganhu wepakati pamabhoni.
Mhando yekupedzisira yemuganhu inoshandiswa inorangarirwa nehurongwa, zvisinei, saka kubhadharira mifananidzo yemiganhu zvakare kunogonesa iyo mode.
Erase Borders
Iyi sarudzo, sezvinoratidzwa nezita, inoita kuti zvive nyore kubvisa miganhu kubva pamaseji ekushanda. Asi zvakasiyana neChina Border sarudzo kubva pamiganhu yakasarudzwa, Erase Borders inokubvumira kubvisa miganhu yemuganhu mumwe nomumwe - kungozvinyorwa pazviri.
Mipaka yakawanda inogonawo kubviswa kushandiswa nekudhonza.