Yuav Paub
- Top row: View > Freeze Panes (Windows only) > Freeze Top Row.
- First column: View > Freeze Panes (Windows only) > Freeze First Column.
- Kem thiab kab: Xaiv kab thiab kab, tom qab ntawd View > Freeze Panes (Windows nkaus xwb) > Freeze Panes.
Kab lus no piav qhia yuav ua li cas khov kab thiab kab hauv Excel kom lawv pom txhua lub sijhawm, txawm tias koj mus qhov twg. Cov lus qhia siv rau Excel 2019, 2016, 2013, 2010, 2007; Excel Online; thiab Excel rau Mac 2016 thiab tom qab.
Txhob Cia Siab Rau Kab
Ua raws li peb kauj ruam no kom tau txais koj daim ntawv ua haujlwm lub taub hau kom nyob hauv qhov chaw.
- Select View ntawm ribbon.
- Xaiv Ntxhi Panes. Yog tias koj siv Excel rau Mac, hla cov kauj ruam no.
-
Xaiv Txias Sab saum toj.
Image - Ib ciam teb zoo li hauv qab Kab 1 los qhia tias thaj chaw saum kab tau khov lawm. Cov ntaub ntawv nyob rau hauv kab 1 tseem pom thaum koj scroll vim tias tag nrho cov kab yog pinned rau saum.
Txhob Cia Thawj Kab
Kho kom khov thawj kab ntawm daim ntawv ua haujlwm:
- Select View.
- Xaiv Ntxhi Panes. Yog tias koj siv Excel rau Mac, hla cov kauj ruam no.
-
Xaiv Txias Thawj Kab.
Image - Tag nrho kab A cheeb tsam yog khov, qhia los ntawm ciam teb dub ntawm kab A thiab B. Sau qee cov ntaub ntawv rau hauv kab A thiab txav mus rau sab xis; koj yuav pom cov ntaub ntawv txav nrog koj.
Txuag Ob Kab thiab Kab
Kom kom pom kab thiab kab ke pom:
- Xaiv ib lub xovtooj hauv qab kab uas koj xav kom khov thiab mus rau sab xis ntawm kab koj xav kom khov. Cov no yog cov kab thiab kab uas yuav nyob twj ywm pom thaum koj scroll.
- Select View.
- Xaiv Ntxhi Panes. Yog tias koj siv Excel rau Mac, hla cov kauj ruam no.
-
Xaiv Ntxhiab Panes.
Image - Ob kab dub tshwm rau ntawm daim ntawv qhia tias cov panes tau khov. Cov kab saum toj ntawm kab rov tav yog khaws cia pom thaum scrolling. Cov kab nyob rau sab laug ntawm kab ntsug yog khaws cia pom thaum scrolling.
Unfreeze kab thiab kab
Thaum koj tsis xav kom qee kab thiab kab nyob hauv qhov chaw thaum koj scroll, unfreeze tag nrho cov panes hauv Excel. Cov ntaub ntawv hauv cov thav ntawv yuav nyob twj ywm, tab sis cov kab thiab kab uas tau khov yuav rov qab mus rau lawv qhov chaw qub.
To unfreeze panes, xaiv View > Txias Panes > Unfreeze Panes . Ntawm Excel rau Mac, xaiv View > Unfreeze Panes hloov.
FAQ
Vim li cas kuv thiaj khov kab hauv Microsoft Excel?
Cov kab khov ua kom lawv pom nyob rau sab saum toj ntawm koj lub vijtsam, txawm tias koj nqes mus deb npaum li cas. Qhov no yog qhov muaj txiaj ntsig zoo thaum cov kab ntawv nthuav dav txuas ntxiv mus dhau qhov siab ntawm koj lub khoos phis tawj lub vijtsam thiab muaj ntau kab.
Vim li cas kuv thiaj tso cov kab hauv Microsoft Excel?
Cov kab khov ua kom lawv pom ntawm sab laug ntawm koj lub vijtsam, txawm tias nyob deb npaum li cas rau sab xis koj scroll. Qhov no muaj txiaj ntsig zoo thaum cov kab ntawv nthuav dav txuas mus rau sab xis dhau los ntawm qhov dav ntawm koj lub khoos phis tawj lub vijtsam thiab muaj ntau kab.
