Yuav Paub
- Go to File > Options, xaiv Advanced hauv cov ntawv qhia zaub mov sab laug, ces scroll nqes mus rau Display Options for This Workbook kom pom cov kev xaiv scroll.
- Txhim kho qhov kab rov tav scroll bar, tso tus nas pointer hla peb ntsug dots, tom qab ntawd nyem-thiab-luag mus rau sab xis lossis sab laug.
- txhawm rau txhim kho cov teeb meem nrog cov kab ntsug ntsug scroll slider ntau, nrhiav thiab tshem tawm kab uas muaj lub xov tooj ntawm tes ua haujlwm kawg.
Kab lus no piav qhia yuav ua li cas nkaum thiab rov pib dua Excel cov kab tuav. Cov lus qhia siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, thiab Excel 2010.
Hide and View Scroll Bars
Los ntawm lub neej ntawd, Excel qhia cov kab kab rov tav thiab ntsug scroll nyob rau hauv qab thiab sab xis ntawm Excel screen, tab sis koj tuaj yeem nkaum lawv los ntawm kev saib. Yog tias koj xav ua kom pom thaj tsam ntawm daim ntawv ua haujlwm, nkaum kab rov tav thiab ntsug scroll bars.
- mus rau File tab.
- Xaiv Options.
-
In the Excel Options dialog box, xaiv Advanced.
Image -
Scroll down mus rau xaiv kev xaiv rau phau ntawv nontu (txog ib nrab nqes).
Image - Txhawm rau nkaum kab kab rov tav scroll, tshem qhov Show kab rov tav scrollbar kos lub thawv.
-
Txhawm rau nkaum qhov ntsug scroll bar, tshem tawm Qhia ntsug scroll bar kos lub thawv.
Yuav kom pom cov kab ntawv zais zais, xaiv lub Show kab rov tav scroll bar kos lub thawv lossis xaiv lub Show ntsug scroll bar kos lub thawv.
- Xaiv OK txhawm rau kaw lub dialog thiab rov qab mus rau daim ntawv ua haujlwm.
Hloov seb qhov scroll bar pom tsuas yog cuam tshuam rau phau ntawv ua haujlwm tam sim no.
Resize kab rov tav Scroll Bar
Yog tias tus lej ntawm cov ntawv hauv phau ntawv ua haujlwm nce mus rau qhov uas cov npe ntawm txhua nplooj ntawv tsis tuaj yeem nyeem ib zaug, ib txoj hauv kev los kho qhov no yog kom txo qhov loj ntawm kab rov tav scroll bar.
- Muab tus nas pointer hla lub ntsug ellipsis (peb ntsug dots) ib sab ntawm kab rov tav scroll bar.
- Tus nas pointer hloov mus rau ob lub taub hau xub.
- Txoj mus rau sab xis kom txo qis kab rov tav scroll lossis rub mus rau sab laug kom nthuav dav scroll bar.
Kho qhov Vertical Scroll Bar Slider Range
Lub slider nyob rau hauv ntsug scroll bar-lub thawv uas txav mus rau thiab down lub scroll bar-hloov loj raws li tus naj npawb ntawm kab nyob rau hauv ib daim ntawv uas muaj cov ntaub ntawv hloov. Raws li tus naj npawb ntawm kab nce, qhov luaj li cas ntawm tus slider txo.
Yog tias daim ntawv ua haujlwm muaj cov kab me me uas muaj cov ntaub ntawv, tab sis cov slider me me thiab txav nws ua rau daim ntawv ua haujlwm dhia nce lossis nqis ntau pua kab, ib kab lossis ib lub xov tooj nyob deb ntawm daim ntawv ua haujlwm yuav tau ua. qhib. Txhawm rau kho qhov teeb meem, nrhiav thiab tshem tawm kab uas muaj lub xov tooj ntawm tes ua haujlwm kawg.
Activated cells tsis tas muaj cov ntaub ntawv. Hloov cov kev sib raug zoo ntawm ib lub xovtooj, ntxiv ib tug ciam teb, los yog siv bold lossis underline formatting rau ib lub xovtooj khoob yuav qhib lub xovtooj.
Nrhiav kab ua haujlwm kawg
Kom pom kab kawg hauv daim ntawv ua haujlwm uas muaj lub xov tooj ntawm tes uas tau qhib:
-
Back up the workbook.
Cov kauj ruam tom qab suav nrog kev rho tawm kab hauv daim ntawv ua haujlwm. Yog tias cov kab uas muaj cov ntaub ntawv zoo raug muab tshem tawm, qhov yooj yim tshaj kom tau lawv rov qab yog kom muaj daim ntawv theej.
-
Nias lub Ctrl+ Home tus yuam sij txav mus rau ntawm tes A1 hauv daim ntawv ua haujlwm.
- Nias lub Ctrl+ End tus yuam sij kom txav mus rau lub xov tooj kawg hauv daim ntawv ua haujlwm. Lub xovtooj ntawm no yog qhov kev sib tshuam ntawm cov kab qis tshaj plaws thiab sab xis tshaj plaws qhib.
Delete the Last Active Kab
Vim koj tsis tuaj yeem paub tseeb tias lwm cov kab tsis tau qhib nruab nrab ntawm kab kawg ntawm cov ntaub ntawv zoo thiab kab ua haujlwm kawg, tshem tawm tag nrho cov kab hauv qab koj cov ntaub ntawv thiab kab ua haujlwm kawg.
- Highlight cov kab kom tshem tawm. Xaiv cov kab header nrog tus nas lossis nias lub Shift+ Space tus yuam sij ntawm cov keyboard.
- Right-click the row header of one of the selected rows to open the context menu.
- Xaiv Delete txhawm rau tshem cov kab xaiv.
Qhia Ua Ntej Koj Rho Tawm
Ua ntej rho tawm ib kab, ua kom paub tseeb tias kab kawg ntawm cov ntaub ntawv tseem ceeb yog kab kawg ntawm cov ntaub ntawv tseem ceeb, tshwj xeeb tshaj yog tias phau ntawv ua haujlwm tau siv ntau dua ib tus neeg. Nws tsis yog qhov tsis yooj yim rau kev zais cov ntaub ntawv hauv phau ntawv ua haujlwm, yog li ua tib zoo tshawb nrhiav ua ntej tshem cov ntaub ntawv.
Txuag Phau Ntawv Ua Haujlwm
Tom qab cov kab raug tshem tawm, khaws phau ntawv ua haujlwm. Txog thaum phau ntawv ua haujlwm tau txais kev cawmdim, yuav tsis muaj qhov hloov pauv ntawm qhov loj thiab tus cwj pwm ntawm tus slider hauv scroll bar.
