Kusintha pakati pa mapepala a Excel. Hotkeys

Nthawi zambiri, ogwiritsa ntchito mkonzi wa spreadsheet amafunika kutsatira njira yosinthira pakati pamasamba. Pali njira zambiri zogwiritsira ntchito njirayi yosavuta. Izi ziyenera kuchitika pamene chikalata cha spreadsheet chili ndi mapepala ambiri ogwira ntchito. Njira zosinthira zikuphatikiza: kugwiritsa ntchito ma hotkey apadera, kugwiritsa ntchito mipukutu, ndikuyenda pogwiritsa ntchito ma hyperlink. M'nkhaniyi, tipenda njira iliyonse mwatsatanetsatane.

Njira Yoyamba: Kugwiritsa Ntchito Ma Hotkey Apadera

Hotkeys amakulolani kuti mugwiritse ntchito nthawi yomweyo zochita zosiyanasiyana mumkonzi wa spreadsheet. Kuti mugwiritse ntchito kusinthana pakati pa mapepala, mitundu iwiri ya makiyi otentha amagwiritsidwa ntchito:

• Kuphatikiza koyamba: "Ctrl + Tsamba Up".
• Kuphatikiza kwachiwiri: "Ctrl + Tsamba Pansi".

Zophatikizira ziwirizi zimapereka kusintha kwanthawi yomweyo pakati pa mapepala ogwirira ntchito a chikalata cha spreadsheet pepala limodzi kumbuyo kapena kutsogolo.

Njirayi ndi yabwino kwambiri pamene bukhu la zolemba lili ndi mapepala ochepa. Ndibwinonso kugwira ntchito ndi mapepala oyandikana nawo a spreadsheet.

Njira Yachiwiri: Kugwiritsa Ntchito Mwambo Mpukutu Bar

Njirayi ndiyoyenera kugwiritsa ntchito ngati chikalata cha spreadsheet chili ndi masamba ambiri ogwirira ntchito. Chowonadi ndi chakuti ngati pali mapepala ambiri mu fayilo, ndiye kuti kugwiritsa ntchito makiyi apadera otentha kudzatenga nthawi yambiri ya wogwiritsa ntchito. Chifukwa chake, kuti mupulumutse nthawi yayitali, muyenera kugwiritsa ntchito mipukutu yomwe ili pansi pa mawonekedwe a Excel spreadsheet editor. Malangizo atsatanetsatane osinthira masamba pogwiritsa ntchito scrollbar amawoneka motere:

1. Timasunthira pansi pa mawonekedwe a tebulo la mkonzi. Tikupeza apa malo apadera osindikizira.
2. Dinani pa scrollbar ndi batani lakumanja la mbewa.
3. Chiwonetserocho chinawonetsa mndandanda wawung'ono, womwe umasonyeza mapepala onse a pepala la spreadsheet.
4. Timapeza tsamba lomwe tikufuna ndikudina LMB.

5. Okonzeka! Takhazikitsa kusintha pakati pa mapepala a spreadsheet pogwiritsa ntchito bar scroll bar.

Njira Yachitatu: Kugwiritsa Ntchito Ma Hyperlink mu Spreadsheet Document

Njira yovutayi imaphatikizapo kupanga pepala lothandizira lothandizira, lomwe lidzakhala ndi mndandanda wa zomwe zili mkati, zomwe zimagwiritsidwa ntchito pogwiritsa ntchito ma hyperlink apadera. Ma hyperlink awa adzatsogolera wogwiritsa ntchito kumasamba ofunikira a chikalata cha spreadsheet.

Njirayi ili ndi njira zopangira ma hyperlink. Mndandanda wa ma hyperlink amapangidwa pogwiritsa ntchito GET.WORKBOOK operator. Malangizo atsatanetsatane amawoneka motere:

1. Poyamba, timapita ku "Name Manager". Timasunthira ku gawo la "Formulas", pezani chipika cha "Defined names" ndikuyika dzina latsopano pamenepo, mwachitsanzo, "List_sheets". Mu mzere "Range:" lowetsani fomula ili: =KUSINTHA(PEZA.BUKU LA NTCHITO(1),1,PEZANI(“]”,PEZA.BUKU LA NTCHITO(1)),””).

2. Itha kugwiritsidwanso ntchito ngati fomula =PEZA.BUKU LA NTCHITO(1), koma kenako mayina a mapepalawo adzakhalanso ndi dzina la bukhu (mwachitsanzo, [Book1.xlsb]Sheet1).
3. Timachotsa zidziwitso zonse mpaka kumabwalo otsekera akunja, kotero kuti pamapeto pake patsala dzina lokha la pepala "Sheet1". Kuti tisamagwiritse ntchito njirayi nthawi zonse tikamapeza zinthu za "List_sheets" pogwiritsa ntchito ma formula, timayika nthawi imodzi pa chinthu chilichonse.
4. Chifukwa chake, mayina amasamba onse a chikalata cha spreadsheet ali mumtundu watsopano wopangidwa "LIST_SHEETS". Mwa kuyankhula kwina, tili ndi mndandanda wapadera wokhala ndi makhalidwe. Tiyenera kuchotsa mfundo izi.
5. Kuti mugwiritse ntchito njirayi, muyenera kugwiritsa ntchito INDEX yapadera, yomwe imakulolani kuti mutenge chinthu chotsatira ndi nambala ya serial. Kuphatikiza apo, timagwiritsa ntchito wogwiritsa ntchito dzina lake STRING kupanga manambala pafupipafupi.

6. Pa gawo lotsatira, kuti tipange kuyenda momasuka, timagwiritsa ntchito HYPERLINK woyendetsa. Tidzakhazikitsa njira yowonjezerera ma hyperlink ku mayina amasamba.

7. Pamapeto pake, ma hyperlink onse adzalumphira ku selo A1, lolingana ndi dzina la pepala la spreadsheet.

Kuphatikiza apo, mutha kupanga pepala lokhala ndi ma hyperlink pogwiritsa ntchito chilankhulo chophatikizika cha mapulogalamu VBA.

Malangizo atsatanetsatane amawoneka motere:

1. Dinani kuphatikiza kiyi "Alt + F11".
2. Tikupanga gawo latsopano.
3. Ikani khodi ili mmenemo:

   Mndandanda wa Mapepala (N Monga Integer)

   SheetList = ActiveWorkbook.Worksheets(N).Name

   Ntchito Yomaliza.

4. Timabwerera kumalo ogwirira ntchito, pogwiritsa ntchito pulogalamu yopangidwa, timagwiritsa ntchito kupanga mndandanda wa mapepala ogwira ntchito. Kuti tichite izi, monga momwe tafotokozera pamwambapa, timagwiritsa ntchito ROW kuti tipeze manambala okhazikika.

5. Timachita kubwereza kuwonjezera ma hyperlink.

6. Okonzeka! Tapanga pepala lomwe limakulolani kuti musinthe mwachangu pakati pa mapepala ogwirira ntchito mu chikalata cha spreadsheet.

Mapeto ndi ziganizo ndi kusinthana pakati pa mapepala ogwirira ntchito

Tinapeza kuti pali njira zambiri zomwe zimakulolani kuti musinthe pakati pa mapepala ogwirira ntchito mu chikalata cha spreadsheet. Mutha kuchita izi pogwiritsa ntchito makiyi otentha apadera, mipiringidzo, ndikupanga ma hyperlink. Ma hotkeys ndi njira yosavuta yosinthira, koma siyoyenera kugwira ntchito ndi zidziwitso zambiri. Ngati chikalata cha spreadsheet chili ndi chiwerengero chachikulu cha deta ya tabular, ndiye kuti ndi bwino kugwiritsa ntchito kupanga ma hyperlink, komanso mipiringidzo ya mpukutu.