Rimwe pepa kana peji peji imwe chete mune faira yakagadzirwa neprogram yepurogiramu yepurogiramu yeElectel kana Google Sheets. Bhuku rebasa ndiro zita rakapiwa kune Excel file uye rine rimwe kana mamwe mapepa ebasa. Izwi rokuti spreadsheet rinowanzoshandiswa kureva bhuku rebhuku, apo, sezvinotaurwa, rinonyatsotaura nezvekombiyuta purogiramu pachayo.
Saka, kunyatsotaura, paunoshandisa purogiramu yepadheseti yepakombiyuta inotakura bhuku risina basa risina faira iri rine rimwe kana mamwe mahwendefa asina kukwana aunofanira kushandisa.
Zvinyorwa zvemashizha
Rimwe pepa rekushandiswa rinoshandiswa kuchengeta, kushandisa, uye kuratidza data .
Chinhu chekuchengetedza chekuchengetedza kwedhesi mune pepa rekuita masero akafanana nemakona akagadzirwa mukati megridhi yepaji mune rimwe pepa pepaji.
Masero ega ega e data anotsanangurwa uye akarongwa achishandisa mabhesi ekutenderera uye nhamba dzakatsetseka dzemahwendefa ebasa rinoita sero reference - yakadai seA1, D15, kana Z467.
Tsananguro yepurogiramu yezvinobudiswa zvezvinobudiswa zve Excel zvinosanganisira:
- 1,048,576 rows pamushandi webasa;
- 16 384 columns pamushandi webasa;
- 17 179 869 184 masero pamushandi webasa;
- pepa rimwe chete rekushandira mafaira matsva (default);
- muganhu pahuwandu hwemashizha nefaira. Izvi zvinongogumira chete nehuwandu hwemangariro inowanika pamakombiyuta.
NeGoogle Sheets:
- Pane huwandu hwemaseri 256 pa peji.
- Nhamba yepamusoro yemasero emafashoni ose ari faira ndeye 400,000.
- Nhamba yemazuva ano inoshandiswa yemashiripiti emafaira matsva ndeye.
- Pane huwandu hwemasvomhu makumi maviri emahwendefa ega padhigiramu yepadheseti.
Pepa Rokushanda Mazita
Mune zvose Excel neGoogle Spreadsheets, peji rimwe nerimwe rine zita. Nokusakwanisa, mapepa epazita anonzi Sheet1, Sheet2, Sheet3 nezvimwe zvakadaro, asi izvi zvinogona kushandurwa nyore nyore.
Nhamba yepaPepa yeMashoko
Nekusavapo, kubvira paExcel 2013, pane pepa rekushanda pebhuku rimwe nerimwe rebhuku reExpcel, asi ichi chinotengeswa chinogona kuchinjwa. Kuita izvi:
- Dzvanya paFirimu menyu.
- Dzvanya pane Zvimwe zviri mu menu kuti uzarure Excel Options dialog box .
- Mukati Paunenge uchitanga mapeji ebhuku rebasa mukakona kwakarurama kwebhokisi rebhokisi, wedzera kukosha kwaunoita Kuisa iyi mapepa mazhinji.
- Dzvanya kuri OK kuti upedze shanduko uye uvhare bhokisi rebhokisi.
Cherechedza : Nhamba isina kukwana yemashizha muGoogle Spreadsheets faira ndeye, uye izvi hazvigoni kuchinjwa.
Bhuku reBhuku reBhuku
- Zvimwe zvinyorwa zvebhuku zvinogona kuwedzerwa kubhuku rekushandisa uchishandisa kushandisa mamiriro ekutenderera kana kuti Chikwata Chekuwedzera (pamwe nechiratidzo) pedyo nepamakiti mapepa anoonekwa sezvinoonekwa mumufananidzo uri pamusoro.
- Zvinogona kuvhara kana kuvhara mapepa ega ega mubhuku rebhuku.
- Zvinogona zvakare kutora mazita emashandi ega ega uye kushandura mapepa emabhasiro emapuraneti kuti zvive nyore kuziva mahwendefa ega mubhuku rebhuku uchishandisa mamiriro ekutenderera.
- Kuchinja kubva pane rimwe pepa mazano kune rimwe mubhuku rebhuku rinogona kuitwa nekukanda pane pepa pebhu pasi pekona.
- MuchiExcel, kuwirirana kwekutsvaga kwekutsvaga kunogona kushandiswa kushandura pakati pepafashiti :
- Ctrl + PgUp (peji kumusoro) - enda kune kurudyi
- Ctrl + PgDn (peji pasi) - enda kuruboshwe
- Pamusoro peGoogle Spreadsheets, kushamwaridzana kwekatsinhanisi ekutsinhanisa pakati pepafashiti ndiko:
- Ctrl + Shift + PgUp - enda kune kurudyi
- Ctrl + Shift + PgDn - enda kuruboshwe