Kuchinja pakati peExcel sheets. Hotkeys

Kazhinji, vashandisi vespredishiti mupepeti vanofanirwa kuita maitiro ekuchinja pakati pemashizha. Kune nhamba huru yenzira dzekushandisa iyi iri nyore maitiro. Ichi chiito chinofanira kukwanisa kuita mumamiriro ezvinhu apo gwaro respredishiti rine nhamba huru yemashizha ekushanda. Kuchinja nzira dzinosanganisira: kushandisa yakakosha hotkey musanganiswa, kushandisa scroll bar, uye kufamba uchishandisa hyperlink. Muchinyorwa, tichaongorora imwe neimwe yenzira zvakadzama.

Nzira Yokutanga: Kushandisa Special Hotkeys

Mahotkeys anotendera iwe kuti uite nekukurumidza zviito zvakasiyana mupepeti yespredishiti. Kuita shanduko pakati pemashizha ekushanda, maviri masanganiswa emakiyi anopisa anoshandiswa:

• Musanganiswa wekutanga: "Ctrl + Peji Kumusoro".
• Kusanganiswa kwechipiri: "Ctrl + Peji Pasi".

Aya masanganiswa maviri anopa shanduko yekukurumidza pakati pemapepa ebasa egwaro respredishiti pepa rimwe kumashure kana kumberi.

Iyi nzira inonyanya nyore mumamiriro ezvinhu apo bhuku rezvinyorwa rine nhamba shomanana yemashizha ekushanda. Izvo zvakare zvakanaka pakushanda nemapepa ari pedyo egwaro respredishiti.

Yechipiri Nzira: Kushandisa Custom Scroll Bar

Iyi nzira inokurudzirwa kushandisa kana gwaro respredishiti rine nhamba huru yemashizha ebasa. Ichokwadi ndechokuti kana pane mapepa akawanda mufaira, ipapo kushandiswa kwemakiyi anokosha ekupisa kunotora nguva yakawanda yenguva yemushandisi. Naizvozvo, kuti uchengetedze nguva zvakanyanya, iwe unofanirwa kushandisa iyo scroll bar iri pazasi peExcel spreadsheet editor interface. Murairo wakadzama wekuchinja mapepa uchishandisa scrollbar inoita seizvi:

1. Isu tinoenda kuzasi kwetafura mupepeti interface. Isu tinowana pano yakakosha scroll bar.
2. Dzvanya pakapumburu nebhatani rekurudyi rembeva.
3. Chiratidziro chakaratidza runyoro rudiki, runoratidza ese mapepa ebasa egwaro respredishiti.
4. Isu tinowana pepa rebasa ratinoda uye tinya pairi LMB.

5. Ready! Taita shanduko pakati pemapepa ebasa egwaro respredishiti tichishandisa scroll bar.

Nzira Yetatu: Kushandisa Hyperlink muSpreadsheet Document

Iyi nzira yakaoma inosanganisira kugadzira pepa rekuwedzera rekuwedzera, iro rine tafura yezviri mukati, rinoshandiswa uchishandisa akakosha hyperlink. Aya ma hyperlink anozotungamira mushandisi kune anodiwa mapepa ebasa respredishiti gwaro.

Iyi nzira ine mafomula ekugadzira hyperlink. Rondedzero ye hyperlink inogadzirwa pachishandiswa GET.WORKBOOK operator. Detailed mirairo inoita seizvi:

1. Pakutanga, tinotamira ku "Name Manager". Isu tinotamira kune "Formulas" chikamu, tsvaga "Mazita Akatsanangurwa" block uye isa zita idzva ipapo, semuenzaniso, "List_sheets". Mumutsara we "Range:" isa inotevera fomula: =REPLACE(GET.WORKBOOK(1),1,TSVAGA(“]”,GET.WORKBOOK(1)),””).

2. Inogonawo kushandiswa sefomula =GET.BHUKU REBASA(1), asi ipapo mazita emapepa ebasa anenge aine zita rebhuku (semuenzaniso, [Book1.xlsb]Sheet1).
3. Isu tinodzima data rese kusvika kune yekunze yekuvhara sikweya bracket, kuitira kuti pakupedzisira chete zita rebasa rebasa "Sheet1" rinosara. Kuti usaite maitiro aya nguva dzese kana tichiwana zvinhu zve "List_sheets" chinja tichishandisa mafomula, isu tinoisa iyi kamwechete pane chimwe nechimwe chinhu.
4. Nekuda kweizvozvo, mazita emapepa ebasa ese egwaro respredishiti anowanikwa mune itsva yakagadzirwa musiyano "LIST_SHEETS". Nemamwe manzwi, isu tine mutsara unokosha une tsika. Tinofanira kubvisa zvinhu izvi.
5. Kuti uite maitiro aya, unofanirwa kushandisa yakakosha INDEX opareta, iyo inokutendera kuti utorezve chinhu chakarongeka neserial nhamba. Pamusoro pezvo, tinoshandisa opareta anonzi STRING kugadzira manhamba enguva dzose.

6. Padanho rinotevera, kugadzira kufamba kwakasununguka, tinoshandisa HYPERLINK opareta. Isu tichashandisa maitiro ekuwedzera hyperlink kune mazita emapepa ekushanda.

7. Pakupedzisira, ese hyperlink anozotungamira kune sero A1, inoenderana nezita rebasa rebasa respredishiti gwaro.

Mukuwedzera, iwe unogona kugadzira pepa rine hyperlink uchishandisa yakasanganiswa programming mutauro VBA.

Detailed mirairo inoita seizvi:

1. Dzvanya kiyi musanganiswa "Alt + F11".
2. Tiri kugadzira module itsva.
3. Isa kodhi inotevera imomo:

   Basa SheetList(N Se Integer)

   SheetList = ActiveWorkbook.Worksheets(N).Zita

   End Function.

4. Isu tinodzokera kunzvimbo yebasa, tichishandisa purogiramu yakagadzirwa, tinoshandisa kusikwa kwechinyorwa chemagwaro ekushanda. Kuti tiite izvi, semumuenzaniso wepamusoro, tinoshandisa ROW opareta kugadzira nhamba yenguva dzose.

5. Isu tinoita kudzokorora kwekuwedzera hyperlink.

6. Ready! Isu takagadzira pepa rinokutendera iwe kukurumidza kushandura pakati pemashizha ebasa mugwaro respredishiti.

Mhedziso uye mhedziso uye kuchinja pakati pemashizha ekushanda

Takaona kuti kune nzira dzakawanda dzinokutendera kuti uchinje pakati pemapepa ebasa mugwaro respredishiti. Iwe unogona kuita chiitiko ichi uchishandisa akakosha makiyi ekupisa, skroti mabara, uye kugadzira hyperlink. Hotkeys ndiyo nzira iri nyore yekushandura, asi haina kukodzera kushanda nehuwandu hwemashoko. Kana gwaro respredishiti rine huwandu hukuru hwetabular data, saka zvakanyanya kufanira kushandisa kusikwa kwe hyperlink, pamwe nekupumburudza mabhawa.