Hloov ntawm cov ntawv Excel. Hotkeys

Feem ntau, cov neeg siv ntawm cov ntawv sau ntawv yuav tsum tau ua cov txheej txheem rau kev hloov ntawm nplooj ntawv. Muaj ntau txoj hauv kev los siv cov txheej txheem yooj yim no. Qhov kev txiav txim no yuav tsum muaj peev xwm ua tau nyob rau hauv rooj plaub uas cov ntaub ntawv nthuav dav muaj ntau daim ntawv ua haujlwm. Cov kev hloov pauv muaj xws li: siv cov kev sib txuas tshwj xeeb hotkey, siv lub scroll bar, thiab navigating siv hyperlinks. Hauv tsab xov xwm, peb yuav txheeb xyuas txhua txoj hauv kev kom ntxaws.

Thawj Txoj Kev: Siv Cov Kub Kub Tshwj Xeeb

Hotkeys tso cai rau koj tam sim siv ntau yam kev nqis tes ua hauv phau ntawv kho mob. Txhawm rau siv kev hloov ntawm cov ntawv ua haujlwm, ob qho kev sib txuas ntawm cov yuam sij kub yog siv:

• Ua ntej ua ke: "Ctrl + Nplooj Ntawv".
• Kev sib xyaw thib ob: "Ctrl + Nplooj Ntawv".

Ob qhov kev sib txuas ua ke no muab kev hloov pauv tam sim ntawm cov ntawv ua haujlwm ntawm daim ntawv nthuav qhia ib daim ntawv rov qab lossis rau pem hauv ntej.

Txoj kev no yog qhov yooj yim tshaj plaws nyob rau hauv cov xwm txheej uas ib phau ntawv muaj cov ntaub ntawv me me. Nws kuj yog qhov zoo rau kev ua haujlwm nrog cov ntawv uas nyob ib sab ntawm ib daim ntawv nthuav qhia.

Txoj Kev Thib Ob: Thov Kev Cai Scroll Bar

Txoj kev no yog pom zoo siv yog tias daim ntawv teev cov ntaub ntawv muaj ntau cov ntawv ua haujlwm. Qhov tseeb yog tias muaj ntau nplooj ntawv hauv cov ntaub ntawv, ces kev siv cov yuam sij kub tshwj xeeb yuav siv sij hawm ntau ntawm cov neeg siv. Yog li ntawd, txhawm rau txuag lub sijhawm, koj yuav tsum tau siv lub scroll bar nyob hauv qab ntawm Excel spreadsheet editor interface. Cov lus qhia ntxaws ntxaws rau kev hloov cov nplooj ntawv siv lub scrollbar zoo li no:

1. Peb txav mus rau hauv qab ntawm lub rooj editor interface. Peb pom ntawm no ib qho tshwj xeeb scroll bar.
2. Nyem rau ntawm qhov scrollbar nrog txoj cai nas khawm.
3. Cov zaub tau pom ib daim ntawv me me, uas qhia tag nrho cov ntawv ua haujlwm ntawm daim ntawv nthuav dav.
4. Peb pom daim ntawv ua haujlwm peb xav tau thiab nyem rau ntawm nws LMB.

5. Npaj txhij! Peb tau siv qhov kev hloov pauv ntawm cov ntawv ua haujlwm ntawm cov ntaub ntawv nthuav dav siv ib qho scroll bar.

Txoj Kev XNUMX: Siv Hyperlinks hauv Daim Ntawv Tshaj Tawm

Txoj kev nyuaj no suav nrog kev tsim cov ntawv ua haujlwm pabcuam ntxiv, uas yuav muaj cov ntsiab lus, siv los siv tshwj xeeb hyperlinks. Cov hyperlinks no yuav hloov tus neeg siv mus rau cov ntawv ua haujlwm uas xav tau ntawm daim ntawv nthuav dav.

Txoj kev no muaj cov qauv tsim los tsim hyperlinks. Ib daim ntawv teev npe ntawm hyperlinks yog tsim los ntawm GET.WORKBOOK tus neeg teb xov tooj. Cov lus qhia ntxaws ntxaws zoo li no:

1. Thaum pib, peb tsiv mus rau "Npe Manager". Peb tsiv mus rau "Formulas" ntu ntu, nrhiav "Cov npe txhais" thaiv thiab ntxig ib lub npe tshiab rau ntawd, piv txwv li, "List_sheets". Hauv kab "Range:" sau cov qauv hauv qab no: =REPLACE(GET.WORKBOOK(1),1,FIND(“]”,GET.WORKBOOK(1),””).

2. Nws kuj tseem siv tau los ua ib qho qauv =GET.WORKBOOK(1), tab sis tom qab ntawd cov npe ntawm cov ntawv ua haujlwm tseem yuav muaj lub npe ntawm phau ntawv (piv txwv li, [Book1.xlsb]Sheet1).
3. Peb tshem tawm tag nrho cov ntaub ntawv mus rau sab nraud kaw square bracket, yog li thaum kawg tsuas yog lub npe ntawm daim ntawv ua haujlwm "Sheet1" tseem nyob. Txhawm rau kom tsis txhob siv cov txheej txheem no txhua zaus thaum nkag mus rau cov khoom ntawm "List_sheets" hloov pauv siv cov qauv, peb siv qhov no 1 zaug rau txhua lub caij.
4. Raws li qhov tshwm sim, cov npe ntawm txhua daim ntawv ua haujlwm ntawm daim ntawv nthuav qhia yog nyob rau hauv qhov hloov pauv tshiab "LIST_SHEETS". Hauv lwm lo lus, peb tau txais ib qho tshwj xeeb array nrog cov nqi. Peb yuav tsum rho tawm cov nqi no.
5. Txhawm rau siv cov txheej txheem no, koj yuav tsum siv tus neeg teb xov tooj tshwj xeeb INDEX, uas tso cai rau koj kom khaws cov khoom array los ntawm tus lej xov tooj. Tsis tas li ntawd, peb siv tus neeg teb xov tooj hu ua STRING los tsim tus lej tsis tu ncua.

6. Nyob rau theem tom ntej, los tsim kom muaj kev yooj yim dua navigation, peb siv HYPERLINK tus neeg teb xov tooj. Peb yuav ua raws li cov txheej txheem rau ntxiv hyperlinks rau cov npe ntawm cov ntawv ua haujlwm.

7. Thaum kawg, tag nrho cov hyperlinks yuav hloov mus rau ntawm tes A1, sib xws rau lub npe ntawm daim ntawv ua haujlwm ntawm daim ntawv nthuav qhia.

Tsis tas li ntawd, koj tuaj yeem tsim ib daim ntawv nrog hyperlinks siv cov lus sib xyaw ua ke VBA.

Cov lus qhia ntxaws ntxaws zoo li no:

1. Nias qhov tseem ceeb ua ke "Alt + F11".
2. Peb tab tom tsim lub module tshiab.
3. Muab cov code hauv qab no rau hauv:

   Function SheetList(N As Integer)

   SheetList = ActiveWorkbook.Worksheets(N).Npe

   End Function.

4. Peb rov qab mus rau qhov chaw ua haujlwm, siv qhov program tsim, peb siv qhov tsim cov npe ntawm cov ntawv ua haujlwm. Ua li no, zoo li hauv qhov piv txwv saum toj no, peb siv tus neeg teb xov tooj ROW los tsim tus lej tsis tu ncua.

5. Peb ua qhov rov ua dua ntawm kev ntxiv hyperlinks.

6. Npaj txhij! Peb tau tsim ib daim ntawv uas tso cai rau koj hloov pauv ntawm cov ntawv ua haujlwm sai sai hauv cov ntawv teev lus.

Qhov xaus thiab xaus thiab hloov ntawm cov ntawv ua haujlwm

Peb pom tias muaj ntau txoj hauv kev uas tso cai rau koj hloov pauv ntawm cov ntawv ua haujlwm hauv daim ntawv nthuav qhia. Koj tuaj yeem siv qhov kev txiav txim no siv cov yuam sij kub tshwj xeeb, cov kab tuav, thiab tsim cov hyperlinks. Hotkeys yog txoj kev yooj yim tshaj plaws rau kev hloov pauv, tab sis lawv tsis haum rau kev ua haujlwm nrog cov ntaub ntawv loj. Yog tias daim ntawv teev cov ntaub ntawv muaj ntau cov ntaub ntawv tabular, nws yog qhov tsim nyog los siv kev tsim cov hyperlinks, nrog rau cov kab tuav.