Chii chiri 'Active Cell' uye 'Active Active Sheet' muExcel uye Ndingawana Kupi?
Mune mapurogiramu epadheseti akadai seExcel kana Google Spreadsheets, sero rinoshandiswa rinoratidzwa nemuganhu wakaita ruvara kana rutivi rwakapoteredza sero , sezvaratidzwa mumufananidzo.
Inoshandiswa seki inozivikanwawo seyero ikozvino kana sero iyo inotarisa .
Kunyange kana masero akawanda akaiswa pachena, imwe chete inowanzotarisa, iyo, kana isipo, inosarudzwa kuti iwane rubatsiro.
Semuenzaniso, data yakaiswa nebhokisi kana kuti yakadhindwa kubva pa clipboard inotumirwa kusero iyo inotarisa.
Saizvozvowo, pepa rinoshandiswa kana pepa redu ikozvino pepa rekushandisa rinoshandisa sero rinoshanda.
Sezvinoratidzwa mumufananidzo wepamusoro, zita rinoshandiswa pepaiti muExcel pasi pekona ndeye ruvara rwakasiyana uye rutsanangurwa kuti zvive nyore kuziva.
Kufanana nesero rinoshandiswa, shanduro inoshandiswa inofungidzirwa kuti inonyanya kukoshesa kana ichiita kuita zviito zvinoshandisa imwe kana mamwe masero - zvakadai sekugadzirisa - uye kuchinja kunowanikwa kune pepa rinoshandiswa nekusafa.
Iyo inoshandiswa sero uye pepa inogona kushandurwa nyore nyore. Muchiitiko chechiitiko chinoshandiswa, kuvhara pane imwe sero ine mouse pointer kana kumanikidza tsvimbo dze arrow pabhobhoyo zvose zvinoguma mune imwe itsva kushanda sekusarudzwa.
Kushandura pekushanda pepaiti kunogona kuitwa kuburikidza kune rimwe divi pepa tabu ine mouse pointer kana kushandisa kadhi yekambani.
Maseji Akawanda Akasarudzwa - Achiri Chete Rimwe Chete Rinoshanda
Kana iyo pointer kana keyboard keyboard inoshandiswa kujekesa kana kusarudza maviri kana kupfuura mamwe masero ari pedyo mukati meeseji kuitira kuti ruvara rutsvuku rwunopoteredza masero akawanda, pane imwe chete sero rinoshandiswa - sero rine ruvara rwemutsvuku.
Kazhinji, kana dhaka rapinda kana pane imwe kero imwe yakasimbiswa, data inongopinda muchikamu chinoshanda.
Zvimwe chete izvi zvinenge apo apo nzira yakagadzirwa inopinda mumasero akawanda panguva imwe chete.
Active Cell uye Zita Bhokisi
Sero rinoreva seki rinoshanda rinoratidzwawo muBhokisi Razita , riri pamusoro peChongwe A mune pepa rekushanda.
Kusiyana nemamiriro ezvinhu aya kunoitika kana sero rinoshandiswa rakapiwa zita -kana riri roga kana sechikamu chemazana emasero. Muchiitiko ichi, zita rezita rinoratidzwa muBhokisi Razita.
Kuchinja Cell Inoshanda mukati meboka reMamwe maCD
Kana boka kana mapoka emasero akasarudzwa sero rinoshandiswa rinogona kushandurwa pasina kusarudzazve mararamiro uchishandisa zvinotevera zvinotevera pa keyboard:
- Pinda kiyi: inoshandisa sero rinoshanda rinosimudzira pasi rimwe sero mukati meurongwa hwakasarudzwa;
- Shift + Pinda : inotungamirira sero rinoshanda rinosimudza imwe sero mukati meurongwa hwakasarudzwa;
- Tab key: inotungamirira sero rinoshandiswa rimwe sero kuenda kurudyi mukati mezera rakasarudzwa;
- Shift + Pinda : inotungamirira sero rinoshandiswa rimwe sero kuruboshwe mukati meurongwa hwakasarudzwa;
- Ctrl + . (nguva): inofambisa sero rinoshandiswa kumaawa nechepamusoro kune kona inotevera yepamusoro yakasarudzwa.
Kufambisa Sero Rakatendeka Kuboka Rakasiyana reMasero Akasarudzwa
Kana boka rinopfuura rimwe chete kana rutivi rwemamwe masero asingasviki akasimbiswa mubhuku rimwechete rekushanda, iyo inoshandiswa sechinyorwa chinosimudzirwa inogona kutamirwa pakati pemapoka aya emasero akasarudzwa achishandisa zvinyorwa zvinotevera pa keyboard:
- Ctrl + Alt + Right Arrow key: inofambisa kushandiswa kwesero kusimbisa kune imwe nzvimbo yakasara iri pedyo neyakarurama yenzvimbo yazvino
- Ctrl + Alt + Kuruboshwe Rakakosha key: inotungamirira sero rinoshanda rinosimudzira kune rimwe rinotevera risina kureva kurudyi kuruboshwe rweanhasi
Kusarudza Mahwendefa Akawanda uye Sheet Active
Kunyange zvazvo zvichikwanisika kusarudza kana kusimbisa pane rimwe pepaji rimwechete panguva imwe chete, zita rekushanda rinoshandiswa riri mukati uye rakashandurwa kakawanda rinowanikwa apo mavara akawanda akasarudzwa achangoramba achingoita purogiramu inoshanda.
Kushandura Active Sheet ne Shortcut Keys
Dhizha rinoshandiswa rinogona kuchinjwa nekutsvaga pane tab yeimwe shati ine mouse inonyorera.
Kuchinja pakati pepafashiti kunogonawo kuitwa nechekugadzirisa maki.
In Excel
- Kufamba kune pepa kuruboshwe: Ctrl + PgUp (peji yepamusoro)
- Kufamba kune peji kune kurudyi: Ctrl + PgDn (peji pasi key)
MuGoogle Spreadsheets
- Kufamba kune peji kuruboshwe: Ctrl + Shift + PgUp (peji yepamusoro)
- Kuenda kune peji kune kurudyi: Ctrl key + Shift + PgDn (peji pasi key)