Thaum koj nqes mus rau sab xis lossis deb dhau los, koj poob cov nqe lus nyob rau saum toj thiab sab laug ntawm daim ntawv ua haujlwm hauv Excel. Freeze Panes pab koj taug qab kab lossis kab ntawm cov ntaub ntawv koj tab tom saib.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, 2016, 2013, thiab 2010.
Txias Panes Siv Lub Cev Muaj Zog
Thaum koj siv Freeze Panes hauv Excel, tag nrho cov kab saum toj kawg nkaus ntawm tes thiab tag nrho cov kab nyob rau sab laug ntawm nws tau khov rau hauv qhov chaw.
Thaum koj scroll hla daim ntawv nthuav dav, cov hlwb yuav tsis txav mus.
- Xaiv lub xovtooj mus rau sab xis ntawm cov kab thiab hauv qab cov kab uas koj xav kom khov rau hauv qhov chaw. Piv txwv li, txhawm rau khaws kab 1, kab 2, thiab kab A ntawm qhov screen thaum koj scroll, xaiv cell B3.
-
Select the View tab.
Image -
Xaiv Freeze Panes los tso saib cov npe poob.
Tau khov panes hauv Microsoft Excel 2010, xaiv View > Txhua txhua > Freeze Panes.
Image -
Xaiv Ntxhi Panes. Qhov no freezes tag nrho cov kab thiab kab mus rau sab saum toj thiab sab laug ntawm lub cell xaiv. Cov xwm txheej ntawm cov hlwb khov los yog txhua kab yog pom los ntawm cov kab tsaus nti hauv qab cov kab khov thiab rau sab xis ntawm cov kab khov.
Image
Unfreeze Panes hauv Excel
Thaum koj khov kab lossis kab hauv Excel thiab tom qab ntawd txuag cov ntaub ntawv, cov xwm txheej ntawm cov panes khov tseem raug cawm. Qhov no txhais tau hais tias lwm zaus koj qhib daim ntawv, cov kab uas khov thiab cov kab ntawv tseem nyob hauv qhov chaw.
Yog tias koj tsis xav kom cov kab lossis kab ntawv nyob zoo li qub ntxiv lawm, tshem tawm txhua kab thiab kab nrog Unfreeze Panes cov lus txib.
Txhim kho cov kab thiab kab kom koj tuaj yeem rub tau tag nrho daim ntawv teev npe:
- Select View.
- Xaiv Freeze Panes txhawm rau qhib cov npe poob.
- Xaiv Unfreeze Panes.
Txias kab laug sab hauv Excel
Koj tuaj yeem khov rau sab laug ntawm ib daim ntawv nthuav dav sai sai uas siv lub Freeze First Column hais kom ua. Cov lus txib no tso cai rau sab laug ntawm koj daim ntawv teev npe, tsis hais lub xov tooj twg koj tau xaiv. Qhov no muaj txiaj ntsig zoo thaum kab laug sab muaj cov ntaub ntawv hais txog txhua tus lej ntawm sab xis ntawm nws hauv daim ntawv.
Txhim kho sab laug:
- Select View.
- Xaiv Freeze Panes txhawm rau qhib cov npe poob.
-
Xaiv Txuag Thawj Kab.
Qhov no tam sim ntawd khov rau sab laug kom koj tuaj yeem rub daim ntawv mus rau sab xis raws li koj nyiam, tab sis tseem pom kab laug.
Yog tias koj xav mus rau Khov Thawj Kab uas siv koj cov keyboard, nias Alt+ W, nias F , thiab nias C.
Image
Txias kab saum toj kawg nkaus hauv Excel
Yog tias koj xav khaws cov kab saum toj kawg nkaus pom hauv Excel, siv lub Freeze Top Kab hais kom ua. Cov lus txib no tso tseg tsuas yog kab saum toj kawg nkaus ntawm koj daim ntawv nthuav qhia, tsis hais lub xov tooj twg koj tau xaiv. Qhov no feem ntau siv thaum kab saum toj kawg nkaus muaj cov ntaub ntawv header rau tag nrho cov ntaub ntawv hauv daim ntawv nthuav dav.
Kho kom khov kab saum toj kawg nkaus hauv daim ntawv nthuav qhia:
- Select View.
- Xaiv Freeze Panes los tso saib cov npe poob.
-
Xaiv Txias Sab saum toj.
Ntawm no tso rau kab saum toj kawg nkaus kom rub daim ntawv nqes mus kom deb li deb li koj nyiam tab sis tseem pom kab saum toj.
Tsis muaj cov keyboard shortcut kom khov cov kab saum toj kawg nkaus hauv Excel, tab sis koj tuaj yeem nias ob peb lub yuam sij hauv ib ntu los mus rau qhov Freeze Top Pane hauv cov ntawv qhia zaub mov siv koj cov keyboard. Txhawm rau ua qhov no, nias Alt+ W, nias F, thiab nias R.
Image Yog tias koj siv lub Freeze Panes feature ntau hauv Excel, koj tuaj yeem ntxiv tag nrho cov lus txib khov rau hauv Quick Access Toolbar rau saum Excel Ribbon.
