"Shandisai Mhedziso" Tsanangudzo yakashandiswa mu Excel neGoogle Spreadsheets
Tsanangudzo:
Kuchengetedza kana kusarudza masero muExcel kana Google Spreadsheets ndeyekushandisa purogiramu yeguru kuti uone pane sero kana masero. Iyo inozivikanwawo sekusarudza deta.
Kushandiswa kwekusimbisa kunosanganisira:
- kuwedzera kuisa maitiro ekufambisa kusero kana ku data iri muchitokisi - yakadai semasero emusana kana shanduko yemuvara
- kusanganisira masero ekudzokorora paunowedzera fomu kune rimwe pepa
- kusarudza huwandu hwemashoko hunoshandiswa mukugadzira chati
- kuisa sero kana uwandu hwemasero mubhokisi rebasa rebasa kuti zviite sharo .
Kune nzira dzakawanda dzekusimudzira masero kusanganisira:
- Kusarudza masero anoshandisa piritsi - kushandura pakudhonza uye kukoka kune dzakawanda masero ari pedyo
- kusarudza mashese ari pedyo achishandisa Shift key nemakona emiseve pane keyboard
- kuisa maruva muBhokisi Razita
- kunyora zita rezita kana zita rinotsanangurwa muBhokisi Razita
- kusarudza zita remhando kubva muZita reBhokisi raderera pasi
Kuratidza Mhedziso Mitsvuku
Ctrl + A - kusimbisa masero ose ari mubasa rekushanda
Ctrl + Shift + 8 - tsanangurira data yose mutafura yedata
Yakaratidza Ranges uye Cell Active
Apo masero akawanda anotsanangurwa mune pepa rekushanda kune rimwe chete rimwechete rinoshanda rinoshandiswa mumufananidzo uri pamusoro.
Izvi zvinoreva kuti kunze kwekuti boka rakasikwa, kana dheta rapinda ine mazana masero akasarudzwa, iyo data inongopinda mumusero unoshanda.
Uyewo Anozivikanwa Se: kusarudza masero