Momwe Mungayendetse Pakati Pakati pa Pakati pa Tsambali Zopangira Mauthenga mu Excel

Kusunthira kumadera osiyana siyana ndi osavuta kuposa momwe mukuganizira

Excel ili ndi njira zingapo zosamukira kumadera osiyanasiyana a deta muzitsamba kapena pa mapepala osiyana omwe ali m'buku lomwelo.

Njira zina - monga Go To Command - zikhoza kupezeka pogwiritsa ntchito makina ogulira makiyi, omwe nthawi zina angakhale ophweka - komanso mofulumira - kugwiritsa ntchito kuposa mbewa.

Gwiritsani ntchito Zowonjezera Zowonjezera Kusintha Ma Worksheet mu Excel

Kusintha pakati pa ma worksheets mu buku la Excel likuphweka mosavuta podalira pazithunzi pansi pa mapepala, koma ndi njira yochepetsera kuchita - mwina ndi omwe akuganiza kugwiritsa ntchito njira zachinsinsi kapena njira yachidule makiyi kulikonse.

Ndipo, zikachitika, pali njira zochepetsera zosintha pakati pa maofesi a Excel.

Mafungulo ogwiritsidwa ntchito ndi awa:

Ctrl + PgUp (tsamba pamwamba) - kusuntha pepala limodzi kumanzere Ctrl + PgDn (tsamba pansi) - kusuntha pepala limodzi kumanja

Mmene Mungasinthire Pakompyuta Momwe Mungagwiritsire Ntchito Masewu Odule

Kupita kumanja:

1. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
2. Sakanizani ndi kumasula fungulo la PgDn pa kibokosilo.
3. Kusuntha pepala lina kumakina abwino ndikumasula kachiwiri PgDn kachiwiri.

Kupita kumanzere:

1. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
2. Dinani ndi kumasula fungulo la PgUp pa kambokosi.
3. Kusuntha pepala lina kumanzere lakumanzere ndikumasula kachiwiri PgUp .

Pogwiritsa ntchito njira zochepetsera zovuta kuti muyambe kuzungulira pazomwe mukulemba

The Go Kulamulira mu Excel angagwiritsidwe ntchito mwamsanga kupita maselo osiyana pa tsamba.

Ngakhale kugwiritsira ntchito Go To sikuli kofunika pa masamba omwe ali ndi zigawo zingapo ndi mizere pang'ono, koma pamabuku akuluakulu, ndi njira yowonjezera yodumphira kuchokera kumalo ena a tsamba lanu kupita kumalo ena.

Pitani kukagwira ntchito ndi:

1. Kutsegula kupita ku bokosi la bokosi;
2. Kujambula mu malo ofotokozera malo mu Reference Line pansi pa bokosi la dialog;
3. Kusindikiza Kulungama kapena kupanikiza Mphindi ya Kulowa pa makiyi.

Zotsatira zake ndizochitika zogwiritsa ntchito maselo akudumpha ku ndondomeko ya selo yomwe inalowa mu bokosi la bokosi.

Kugwiritsa Ntchito Pita

Kupita Kulamula kungayambitsidwe njira zitatu:

• Pogwiritsa Ntchito > Fufuzani & Sankhani > Pitani ku menyu yavini ndi mouse.
• Mwa kukanikiza fungulo F5 pa kambokosi.
• Pogwiritsa ntchito makiyi a Ctrl + g kuphatikiza pa keyboard.

Kusungirako Mafotokozedwe a Milipi kuti agwiritsirenso ntchito

Mbali yowonjezera yomwe Amapitako ndikuti imasunga mafotokozedwe a maselo omwe amalowetsedwera kale Pita pawindo pamwamba pa bokosi la bokosi.

Kotero ngati mukudumphira mmbuyo ndi mtsogolo pakati pa magawo awiri kapena kuposerapo pa tsamba, Pitani kukhoza kukupulumutsani nthawi yochulukirapo pogwiritsira ntchito zolemba zomwe zasungidwa mu bokosi.

Zolemba za magulu zimasungidwa mu bokosi la malingaliro malinga ngati buku la ntchito likutseguka. Akadzatsekedwa, mndandanda wa ma selo omwe ali m'Bailo la bokosi amachotsedwa.

Kuyenda ndi Go To Exitsanzo

1. Dinani F5 kapena Ctrl + g pa kibokosilo kuti mubweretse ku Bukhu la zokambirana.
2. Lembani mndandanda wa selo la malo omwe mukufuna kuti mulowetsedwe mu bokosi la bokosi. Pankhaniyi: HQ567 .
3. Dinani ku BUKHU LOPHUNZITSANI
4. Bokosi lakuda lomwe liri pafupi ndi selo yogwira ntchito liyenera kulumphira ku selo HQ567 kuti likhale selo yatsopano yogwira ntchito.
5. Kuti mupite ku selo lina, bweretsani masitepe 1 mpaka 3.

Kuyenda Pakati pa Masamba Athu ndi Go

Pitani kuti mutha kugwiritsanso ntchito popita kumabuku osiyana mu bukhu lomwelo pogwiritsa ntchito pepala dzina limodzi ndi selo.

Dziwani: mawu okweza ( ! ) - omwe ali pamwamba pa nambala 1 pa kibodiboli - nthawi zonse amagwiritsidwa ntchito ngati olekanitsa pakati pa dzina lamasewero ndi selo - malo osaloledwa.

Mwachitsanzo, kuchoka ku Mapepala 1 kupita ku selo HQ567 pa Tsamba 3, lowetsani Sheet3! HQ567 mulozera la bokosi la Pitani ku bokosi ndipo pindani mu Enter key.

Kugwiritsa Ntchito Dzina la Bokosi Kuti Limuke Padziko Lonse

Monga momwe tawonetsera pa chithunzi pamwambapa, Bokosi la Dzina lili pamwamba pa ndime A mu sepala la Excel ndipo lingagwiritsidwe ntchito popita kumadera osiyanasiyana a tsambalo pogwiritsa ntchito ma selo .

Monga momwe amachitira kuti alamulire, Bokosi la Dzina lisakhale lothandiza m'makalata omwe ali ndi zigawo zochepa chabe za deta, koma ndi malemba akuluakulu, kapena omwe ali ndi malo osiyana omwe akugwiritsa ntchito Dzina la Bokosi kuti afumire mosavuta kuchokera pamalo amodzi kupita Chotsatira chingakhale njira yothandiza kwambiri yogwirira ntchito.

Tsoka ilo, palibe njira yofikira Dzina la Dzina pogwiritsa ntchito kibokosi popanda kupanga VBA macro. Kuchita mwachizolowezi kumafuna kudalira pa Bokosi la Dzina ndi mbewa.

Tsamba la Active Cell mu Box Name

Kawirikawiri, Bokosi la Dzina limatanthauzira selo kapena lotchulidwa pa selo yeniyeni kapena yogwira ntchito - selo mu tsamba lomwe liripo lomwe likufotokozedwa ndi malire akuda kapena bokosi.

Pamene bukhu latsopano la Excel likutsegulidwa, mwachisawawa, selo A1 pamwamba pa ngodya yapamwamba ya tsambali ndi selo yogwira ntchito.

Kulowetsa mndandanda wa selo watsopano kapena mayina mu Dzina la Bokosi ndi kukanikiza fungulo lolowamo limasintha selo yogwira ntchito ndikusintha bokosi lakuda - ndi zomwe zimawoneka pazenera pamodzi ndizo - kumalo atsopano.

Kuyenda ndi Dzina la Bokosi

1. Dinani pa Bokosi la Dzina pamwamba pa ndime A kuti muwonetsetse sewero la maselo la selo yogwira ntchito.
2. Lembani mu selo lofotokozera za malo omwe mukufuna - monga HQ567.
3. Dinani ku key lolowamo pa khibhodi.
4. Bokosi lakuda lomwe liri pafupi ndi selo yogwira ntchito liyenera kulumphira ku selo HQ567 kuti likhale selo yatsopano yogwira ntchito.
5. Kuti mupite ku selo lina, lembani tsamba lina lachinsinsi mu Bokosi la Dzina ndipo pindani makiyi a Enter mu makiyi.

Kuyenda Pakati pa Masamba Athu Ndi Dzina la Bokosi

Monga Pitani , Bokosi la Dzina lingagwiritsidwenso ntchito popita ku maofesi osiyanasiyana m'buku lomwelo polemba dzina lamasamba pamodzi ndi selo.

Dziwani: mawu okweza ( ! ) - omwe ali pamwamba pa nambala 1 pa kibodiboli - nthawi zonse amagwiritsidwa ntchito ngati olekanitsa pakati pa dzina lamasewero ndi selo - malo osaloledwa.

Mwachitsanzo, kuchoka ku Chigawo 1 kupita ku selo HQ567 pa Tsamba 3, lowetsani Sheet3! HQ567 mu Bokosi la Dzina ndipo pindani muzipinda .