Yadda za a motsa kewaye da tsakanin Shafuka na Labarai a Excel

Ƙara zuwa wurare daban-daban sun fi sauki fiye da yadda kuke tunani

Excel yana da hanyoyi da dama don matsawa zuwa wurare daban-daban a cikin takardun aiki ko a tsakanin daban-daban ayyuka a cikin ɗayan littafin.

Wasu hanyoyi - irin su Go To umurni - za'a iya isa ta hanyar amfani da maɓallin gajeren hanya na keyboard, wanda, a wasu lokuta, zai iya zama sauki - da sauri - don amfani fiye da linzamin kwamfuta.

Yi amfani da gajerar hanyar da ke ƙoƙarin canza Canjin aiki a Excel

Ana sauya sauyawa tsakanin takardun aiki a cikin takarda na Excel da sauƙi ta danna kan shafuka a kasan takardun aiki , amma yana da jinkirin aiwatar da shi - akalla yana cikin ra'ayi na waɗanda suka fi son amfani da gajerun hanyoyin keyboard ko gajeren hanya keys a duk lokacin da zai yiwu.

Kuma, kamar yadda ya faru, akwai maɓallan gajeren hanya don sauyawa tsakanin takardun aiki a cikin Excel.

Makullin amfani da su shine:

Ctrl + PgUp (shafi na sama) - matsa daya takardar zuwa hagu Ctrl + PgDn (shafi na ƙasa) - matsar da takarda daya zuwa dama

Yadda za a sauya tsakanin ɗawainiya ta yin amfani da maɓallin hanyoyi

Don matsawa zuwa dama:

1. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
2. Latsa kuma saki maɓallin PgDn akan keyboard.
3. Don matsar da wata takarda zuwa dama kuma latsa maɓallin PgDn a karo na biyu.

Don matsawa zuwa hagu:

1. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
2. Latsa kuma saki maɓallin PgUp akan keyboard.
3. Don matsar da wata takarda zuwa hagu na hagu kuma saki maɓallin PgUp a karo na biyu.

Amfani da Go Ga Gajerun hanyar da ke Kwarewa don Matsar da Ayyukan Shafuka masu Magana

Ana zuwa Gudun umarni a Excel za a iya amfani dasu don hanzarta shiga cikin nau'ukan daban a cikin takarda.

Kodayake amfani da Go To ba abu ne da ke amfani da takardun aikin rubutu wanda ke dauke da wasu ginshiƙai da layuka, amma ga manyan fayilolin rubutu, wata hanya ce mai sauƙi ta tsalle daga wani yanki na takardar aikinku zuwa wani.

Je zuwa aiki ta hanyar:

1. Ana buɗe Go To akwatin zane-zane;
2. Rubuta a cikin maɓallin motsa jiki ta hanyar bincike a cikin sashin layi a kasa na akwatin maganganu;
3. Danna Ok ko latsa maɓallin shigarwa akan keyboard.

Sakamakon shi ne ƙirar mai aiki mai tsallewa zuwa tsinkayen tantanin halitta da aka shigar a cikin akwatin maganganu.

Kunna Go To

Goga Zuwa umarni za'a iya kunna hanyoyi uku:

• Ta danna gidan > Nemi & Zaɓa > Je zuwa menu na rubutun tare da linzamin kwamfuta.
• Ta danna maballin F5 akan keyboard.
• Ta latsa maɓallan Ctrl + g a haɗuwa a kan keyboard.

Ana adana bayanan salula don amfani

Wani ƙarin alama da Go To yana da cewa ya adana a baya ya shiga jerin sassan cikin manyan Go To window a saman akwatin maganganu.

Don haka idan kuna tsallewa da baya tsakanin wurare biyu ko fiye da wani aikin aiki, Go To zaku iya ceton ku har ma da karin lokaci ta amfani da bayanan salula a cikin akwatin maganganu.

Ana adana bayanan salula a cikin akwatin maganganun muddin littafi ya zauna a bude. Da zarar an rufe shi, an share jerin tsararren salula a cikin Go to maganin maganganu.

Nunawa tare da Go To Misali

1. Latsa F5 ko Ctrl + g a kan keyboard don gabatar da Go To akwatin maganganu.
2. Rubuta a cikin tantanin halitta game da maƙasudin da ake buƙata a Tsarin Lissafi na akwatin maganganu. A wannan yanayin: HQ567 .
3. Danna maɓallin OK ko latsa maɓallin Shigar da ke keyboard.
4. Akwatin baki wanda ke kewaye da tantanin halitta ya kamata ya yi tsalle zuwa cell HQ567 yana sa shi sabon sabon aiki.
5. Don matsawa zuwa wani cell, sake maimaita matakai 1 zuwa 3.

Nunawa tsakanin Cikin Shafuka tare da Go To

Go To kuma za a iya amfani dasu don kewaya zuwa shafuka daban-daban a cikin ɗayan littafi ɗaya ta shigar da takardar suna tare da tantancewar salula.

Lura: Alamar motsa jiki ( ! ) - wanda yake sama da lambar 1 a kan keyboard - ana amfani dashi a matsayin mai raba tsakanin maƙallan aiki da kuma tantance halitta - ba a halatta sarari ba.

Alal misali, don matsawa daga Sheet 1 zuwa cell HQ567 a kan Sheet 3, shigar da Sheet3! HQ567 a cikin maƙallan tunani na Go To maganganun maganganu kuma danna maɓallin Shigar .

Amfani da Akwatin Akwatin don Matsar da Ayyukan Shafuka masu Magana

Kamar yadda aka nuna a cikin hoton da ke sama, Akwatin Sunan yana samin shafi na A a cikin takarda na Excel kuma za'a iya amfani dashi don yin tafiya zuwa wurare daban-daban na wannan takaddun aiki ta yin amfani da nassoshi .

Kamar yadda Go to umurni, akwatin Shafin bai iya taimakawa a cikin takardun aiki waɗanda ke dauke da wasu ginshiƙai da layuka na bayanai ba, amma ga manyan fayilolin rubutu, ko don waɗanda ke da wurare dabam dabam ta yin amfani da Akwatin Akwati don sauƙin tsalle daga wuri ɗaya zuwa na gaba zai iya zama hanya mai inganci don aiki.

Abin takaici, babu wata hanya ta samun dama ga Akwatin Akwati ta amfani da keyboard ba tare da ƙirƙirar VBA macro ba. Yin aiki na al'ada yana buƙatar danna Akwatin Akwati tare da linzamin kwamfuta.

Siffar ta Active Cell a akwatin Akwati

Yawanci, Akwatin Akwatin yana nuna alamar tantancewa ko kuma mai suna na haɗewa don halin yanzu ko tantanin halitta - tantanin halitta a cikin aikin aiki na yau da aka bayyana ta bakin iyakar baki ko akwatin.

Lokacin da aka buɗe sabon littafi na Excel, ta hanyar tsoho, cell A1 a cikin kusurwar hagu na takarda aiki shi ne tantanin halitta mai aiki.

Shigar da sabon ƙirar salula ko sunan layi a cikin Akwatin Akwati kuma danna maɓallin Shigar yana canza canjin mai aiki kuma yana canza akwatin akwatin baki - kuma abin da ke bayyane akan allon tare da ita - ga sabon wuri.

Nunawa da Akwatin Akwatin

1. Danna akwatin Akwati na sama a sama a A don nuna hasken salula na tantanin halitta.
2. Rubuta a cikin tantanin halitta game da maƙasudin da ake so - irin su HQ567.
3. Latsa maɓallin shigarwa a kan keyboard.
4. Akwatin baki wanda ke kewaye da tantanin halitta ya kamata ya yi tsalle zuwa cell HQ567 yana sa shi sabon sabon aiki.
5. Don motsawa zuwa wani tantanin halitta, danna wani maƙallin ƙwayar salula a akwatin Akwatin kuma danna maɓallin shigarwa akan keyboard.

Nunawa tsakanin Cikin Shafuka Tare da Akwatin Akwatin

Kamar Go , ana iya amfani da Akwatin Akwatin don kewaya zuwa shafuka daban-daban a cikin littafin nan ta shigar da takardar suna tare da tantancewar salula.

Lura: Alamar motsa jiki ( ! ) - wanda yake sama da lambar 1 a kan keyboard - ana amfani dashi a matsayin mai raba tsakanin maƙallan aiki da kuma tantance halitta - ba a halatta sarari ba.

Alal misali, don matsawa daga Sheet 1 zuwa cell HQ567 a kan Sheet 3, shigar da Sheet3! HQ567 a akwatin Akwati kuma danna maɓallin Shigar .