Sero muExcel ndicho chinhu chikuru chechimiro chepepa kwaunogona kuisa data uye zvimwe zvirimo. Muchidzidzo chino, tichadzidza zvakakosha zvekushanda nemaseru uye zviri mukati mawo kuti tiite masvomhu, kuongorora uye kuronga data muExcel.
Kunzwisisa Masero muExcel
Pepa rega rega rekushanda muExcel rinoumbwa nezviuru zvemakona anonzi maseru. Sero ndiyo mharadzano yemutsara nekoromo. Makolamu muExcel anoratidzwa nemavara (A, B, C), nepo mitsetse ichiratidzwa nenhamba (1, 2, 3).
Zvichienderana nemutsara uye koramu, sero rega rega muExcel rinopihwa zita, rinozivikanwawo sekero. Semuenzaniso, C5 ndiyo sero iri pamharadzano yekoromo C uye mutsara 5. Paunosarudza sero, kero yaro inoratidzwa muZita munda. Ndokumbira utarise kuti kana sero rasarudzwa, misoro yemutsara nekoramu pamharadzano yairi inoiswa pachena.
Microsoft Office Excel inokwanisa kusarudza akawanda maseru panguva imwe chete. Seti yemasero maviri kana anopfuura inonzi range. Chero rudzi, sesero, rine kero yayo. Kazhinji, kero yemhando ine kero yekumusoro kuruboshwe uye pasi kurudyi maseru, akaparadzaniswa nekoloni. Rudzi rwakadaro runonzi contiguous kana continuous. Semuenzaniso, mutsara unosanganisira masero B1, B2, B3, B4, uye B5 anganyorwa kuti B1:B5.
Mufananidzo uri pazasi unoratidza marudzi maviri akasiyana emasero:
- Range A1:A8
- Range A1:B8
Kana makoramu ari papepa rebasa akamiririrwa nenhamba panzvimbo pemavara, unofanirwa kushandura iyo default link style muExcel. Kuti uwane rumwe ruzivo, tarisa kuchidzidzo: Ndeipi maitiro ezvekubatanidza muExcel.
Sarudza masero muExcel
Kuisa data kana kugadzirisa zviri mukati mesero, unofanira kutanga wasarudza.
- Dzvanya pasero kuti usarudze.
- Sero rakasarudzwa richaganhurwa uye kolamu nemisoro yemitsara icharatidzwa. Sero icharamba yakasarudzwa kusvika wasarudza chero imwe sero.
Iwe unogona zvakare kusarudza maseru uchishandisa makiyi emiseve pane yako keyboard (arrow keys).
Sarudza huwandu hwemasero muExcel
Paunenge uchishanda neExcel, zvinowanzodikanwa kusarudza boka guru remasero kana mutsara.
- Dzvanya pasero rekutanga muchikamu uye, pasina kuburitsa bhatani, fambisa mbeva kusvika maseru ari padyo aunoda kusarudza asarudzwa.
- Sunungura bhatani rembeva, chiyero chinodiwa chichasarudzwa. Masero acharamba akasarudzwa kusvika wasarudza chero imwe sero.
