Nzira Yokufamba Nayo uye Pakati Pebasa Remahwendefa eTabheji muExcel

Kufamba kune dzimwe nzvimbo dzakasiyana-siyana zviri nyore kupfuura iwe unofunga

Excel ine nzira dzinoverengeka dzekutamira kune dzimwe nzvimbo dzakasiyana-siyana mumashandisi ekushandura kana pakati pemashizha akasiyana mubhuku rimwechete rebhuku.

Dzimwe nzira - dzakadai seGo Go Kuraira - dzinogona kuwanikwa kuburikidza nekushandisa michina yekambani yekucheka kwekakiti, iyo dzimwe nguva, inogona kuva nyore - nekukurumidzira - kushandisa kupfuura mouse.

Shandisa Shortcut Keys Kuti Uchinje Mahwhepa Emashandi mu Excel

Kushandura mapepa ebasa mubhuku reku Excel rinoitwa nyore nyore kuburikidza nekukanda pamabhati ari pasi pemashizha , asi ndiyo nzira inononoka yekuita - kana iri iyo maonero evaya vanosarudza kushandisa zvidzitiro zve keyboard kana nzira shomanana kiyi kana zvichibvira.

Uye, sezvazvinenge zvichiitika, pane zvishoma zvitsva zvitsva zvekushandura pakati pepafashiti muExpcel.

Nheyo dzinoshandiswa ndezvekuti:

Ctrl + PgUp (peji kumusoro) - tumira imwe peji kuruboshwe Ctrl + PgDn (peji pasi) - tendera imwe shande kurudyi

Kugadzirisa Kushanda Pakati Pebasa Rokushandisa Kushandura Makombeki

Kuenda kurudyi:

1. Dhinda uye ubatisise kamba Ctrl pane keyboard.
2. Dhinda uye kusunungura pgDn chinhu pabhobhoyo.
3. Kuendesa imwe peji kudivi rekodzero uye kusunungura pgDn key kechipiri.

Kutamira kuruboshwe:

1. Dhinda uye ubatisise kamba Ctrl pane keyboard.
2. Dhinda nekusunungura pgUp key pane keyboard.
3. Kutamisa imwe peji kuruboshwe rworuboshwe uye kusunungura pgUp key kechipiri.

Uchishandisa Go Shortcut Keys Kuti Ufambe Pasi Pel Worksheets

Iyo Go Kuraira ku Excel inogona kushandiswa kukurumidzira kuenda kune masero akasiyana mune pepa rekushanda.

Kunyange zvazvo uchishandisa Go kune haisi iyo inobatsira pamashizha ebasa ane mashomanana mashoma nemitsara, asi nokuda kwemashizha makuru emabasa, imwe nzira iri nyore yekukwira kubva kune imwe nzvimbo yebasa rako rechikoro kune rimwe.

Endai Kunoshanda na:

1. Kuzarura Go kuenda kubhokisi rebhokisi;
2. Kunyora mumunzvimbo yekuenda kusero muReferensiro rezasi pazasi yebhokisi rebhokisi;
3. Kushandura KUSUNGA kana kuvhara muInoyiyo pikicha.

Chigumisiro ichocho chinoshandiswa sechinyorwa chinosimudzira chichikwira kune seferensi yecenery iyo yakaiswa mubhokisi rebhokisi.

Kushandura kuenda kune

Iko Go Kuraira inogona kushandiswa nenzira nhatu:

• Nokutsvaga Kumba > Tsvaga & Sarudza > Endai Kumubhoni yebhoni ne mouse.
• Nokufambisa f5 key pane keyboard.
• Nokudzvinyirira Ctrl + g kiyi pamwe chete pane keyboard.

Kuchengetedza Maferensi emunharaunda ekushandisa zvakare

Chimwe chimwe chekuti Go Inacho ndechekuti inotenga kare yapinda mujeri zvinyorwa muhombe Enda kuhwindo pane kwebhokisi rebhokisi.

Saka kana uri kutambaira mberi nepamusoro pakati pezvikamu zviviri kana kupfuura zvepuraneti, enda Kugona kukuponesa iwe nguva yakawanda nekushandisazve zvinyorwa zvinyorwa zvakachengetwa mubhokisi rebhokisi.

Maferensi esero akachengetwa mubhokisi rebhokisi chero bedzi bhuku rebhuku rikaramba rakazaruka. Kana yavharwa, mazita akachengeterwa masero ekupinda mubhokisi rebhokisi rinobviswa.

Kufamba neGo Go To Muenzaniso

1. Dhinda F5 kana Ctrl + g pabhobhoyo kuti uise Go Go dialog box.
2. Tora mu cell reference yeaida kuenda kunotarisa mutsara webhokisi rebhokisi. Munyaya iyi: HQ567 .
3. Dzvanya paIndaneti kana kuvhara muIndiniti yebhokisi.
4. Bhokisi dema rakapoteredza sero rinoshanda rinofanira kusvetera kune imwe sero HQ567 ichiita kuti ive itsva inoshanda masero.
5. Kuti uende kune imwe sero, dzokorora matanho 1 kusvika ku3.

Kufamba Pakati Pebasa Rokushandisa neGo To

Endai kunogonawo kushandiswa kuenda kune mavara mapepa akasiyana-siyana mubhuku rimwechete rebhuku nokupinda muzita remashizha pamwe nesero rinoshandiswa.

Cherechedza: chirevo chei ( ! ) - chiri pamusoro pe nhamba 1 pane keyboard - inoshandiswa separarator pakati pezita rebasa rekushanda uye sero rinoreva - nzvimbo dzisingabvumirwi.

Somuenzaniso, kutama kubva kuSheet 1 kusvika kune imwe nzvimbo HQ567 pane Sheet 3, pinda Sheet3! HQ567 mumutsara wekutarisa weGo kuenda kubhokisi rebhokisi uye tapinda kuIno .

Kushandisa Bhokisi Razita Kuti Ufambise Around Excel Worksheets

Sezvinoratidzwa mumufananidzo wepamusoro, Bhokisi reZita riri pamusoro pemusoro weA A mune rimwe rekushandura kweExpcel uye rinogona kushandiswa kuenderera kunzvimbo dzakasiyana dzebhuku iroro rekushandisa uchishandisa zvinyorwa .

Sezvo neGo Go Kurayira, Bhokisi Razita rinogona kunge risina kubatsira mumashandisi ekushanda ane zvishoma zvinyorwa zvitsvene nemitsetse yedata, asi pamashizha makuru, kana kune avo vane nzvimbo dzakasiyana dzekushandisa vachishandisa Bhokisi Razita kuti nyore nyore kubva kune imwe nzvimbo kuenda kune imwe nzvimbo iyo inotevera inogona kuva nzira yakanakisisa yekushanda.

Zvinosuruvarisa, hapana nzira yekuwana nayo Bhokisi reZita uchishandisa keyboard kunze kwekusika VBA macro. Basa rinowanzodikanwa rinofanira kuvhara paZita reBhokisi ne mouse.

The Active Cell Reference muBhokisi Razita

Kazhinji, Bhokisi Razita rinoratidza sero rinotaridzwa kana rakanzi zita rayo nekuda kweiyo ikozvino kana inoshandiswa masero - iri sero mune pepa rekushanda riripo rinoratidzwa nemuganhu wakaipa kana bhokisi.

Apo bhuku idzva reBurcel Excel razaruka, zvisingaitiki, sero A1 riri kumusoro kwekona yakasara rebasa riri basa rinoshanda.

Kupinda itsva sero reference kana zita rezera muZita Zita uye kuvhara muKiyiyi inoshandura shanduro inoshandiswa uye inoshandura bhokisi rakasviba - uye chii chinoratidzika pahwindo pamwe chete naro-kunzvimbo itsva.

Kufamba Nezita Zita Bhokisi

1. Dzvanya paZita reBhokisi riri pamusoro pekorori A kuti uise pachena sero retaiti inoshanda.
2. Tora mu cell cell reference yaunoda kuenda - yakadai seHQ567.
3. Dhinda pikicha inopinda mubhokisi.
4. Bhokisi dema rakapoteredza sero rinoshanda rinofanira kusvetera kune imwe sero HQ567 ichiita kuti ive itsva inoshanda masero.
5. Kuti uende kune imwe sero, tanga rimwe sero rekushandisa muZita Raiti uye shandisai Enter kiyi pane keyboard.

Kufamba Pakati Pemahwhepa Anoshandisa Bhokisi Razita

Kufanana neKuenda , Bhokisi Razita rinogona kushandiswawo kuenda kune mapepa akasiyana-siyana mubhuku rimwechete rebhuku nokupinda muzita remashizha pamwe nesero rinoshandiswa.

Cherechedza: chirevo chei ( ! ) - chiri pamusoro pe nhamba 1 pane keyboard - inoshandiswa separarator pakati pezita rebasa rekushanda uye sero rinoreva - nzvimbo dzisingabvumirwi.

Somuenzaniso, kutama kubva kuSheet 1 kusvika kune imwe nzvimbo HQ567 pane Sheet 3, pinda Sheet3! HQ567 muZita reBhokisi uye chengetedza muIki yeUno .