Khaws Kem thiab Tshaj Lub Npe Nyob Hauv Kev Ntsuas nrog Lub Nkoj Khov

Nyob twj ywm khiav nrog koj nyob rau hauv daim ntawv khom nqi

Thaum ua hauj lwm nrog cov ntaub ntawv loj heev, cov npe nyob rau saum toj thiab sab laug sab ntawm daim ntawv khij nquag ploj yog tias koj txav deb dhau mus rau sab xis lossis dhau deb. Txhawm kom tsis txhob muaj qhov teeb meem no, siv Excel lub khov ntais panes feature. Nws tsis khov los yog xauv txhua cov kab los yog kab ntawm daim ntawv ua haujlwm kom lawv pom nyob rau txhua lub sijhawm.

Yog tsis muaj lub hau lus, nws yog ib qho yooj yim kom khiav ntawm cov kab twg los yog kab ntawm cov ntaub ntawv koj tab tom saib.

Cov kev xaiv sib txawv rau cov khov nab kuab:

• Khov sab saum toj ntawm daim ntawv ua haujlwm
• Khov thawj kab ntawm daim ntawv ua haujlwm
• Khov ib tug neeg txhais cov zauv ntawm txhua kab thiab kab
• Unfreeze txhua kab thiab kab

01 ntawm 04

Cia Li Cia Li Sab Saum Tshaj ntawm Daim Ntawv Lij Choj

1. Qhib ib daim ntawv ua haujlwm uas muaj ntau kab thiab kab ntawm cov ntaub ntawv.
2. Nias rau ntawm saib daim ntawv ntawm txoj hlua .
3. Nias ntawm qhov Freeze Panes option hauv thaj chaw nruab nrab ntawm cov ntawv sau los qhib qhov khov pane nqes zaub mov.
4. Nias ntawm Freeze Top Leej twg xaiv hauv cov ntawv qhia zaub mov.
5. Ib sab ciam teb yuav tsum tshwm sim hauv qab kab 1 hauv daim ntawv hais qhia tias thaj tsam saum toj kab ntawm txoj kab tau khov lawm .
6. Tshem hauv qab ntawm daim ntawv ua haujlwm. Yog tias koj khoov deb txaus, cov kab hauv qab kab 1 yuav pib ploj thaum khoob 1 yuav nyob ntawm qhov screen.

02 ntawm 04

Khov Tshaj Xub Thawj Sab ntawm Daim Ntawv Cais

1. Nias rau ntawm saib daim ntawv ntawm txoj hlua .
2. Nias ntawm qhov Freeze Panes nyob nruab nrab ntawm cov ntawv sau kom qhib lub npe cia.
3. Nias ntawm Khov thawj Kem xaiv nyob hauv daim ntawv.
4. Ib sab ciam teb yuav tsum tshwm rau sab xis ntawm sab sau nyob rau hauv daim ntawv ua haujlwm qhia tias cheeb tsam ntawm txoj kab ntawm txoj kab tau khov lawm.
5. Dhau mus rau sab xis nyob rau hauv tsab ntawv. Yog tias koj khoov deb txaus, txhua sab rau sab xis ntawm sab A yuav pib ploj thaum kem A yuav nyob twj ywm ntawm qhov screen.

03 ntawm 04

Khov Ob Tog Txhua Yam Ntawm Cov Ntawv Sau Npe

Qhov Kev Ntseg Qhov Kev Xaiv Cov freezes tag nrho cov natwm saum toj ntawm lub xovtooj ntawm tes thiab tag nrho cov kab rau sab laug ntawm lub xovtooj ntawm tes.

Kom khov tsuas yog cov kab thiab cov kab uas koj xav nyob twj ywm hauv npo, nias ntawm lub xovtooj mus rau sab xis ntawm cov kab thiab cia li qis dua cov kab uas koj xav nyob twj ywm hauv npo.

Piv txwv ntawm Freezing Panes Siv lub Active Cell

Txhawm rau kom kab 1, 2, thiab 3 ntawm qhov screen thiab kab A thiab B:

1. Nias nyob rau ntawm tes C4 nrog nas ua nws lub xovtooj ntawm tes.
2. Nias rau ntawm saib daim ntawv ntawm txoj hlua .
3. Nias ntawm qhov Freeze Panes nyob nruab nrab ntawm cov ntawv sau kom qhib lub npe cia.
4. Nias ntawm qhov Freeze Panes option nyob rau hauv daim ntawv kom khov txhua kab thiab kab.
5. Ib sab ciam teb yuav tsum tshwm rau sab xis ntawm B nyob rau hauv daim ntawv ua haujlwm thiab hauv qab kab 3 qhia tias cov cheeb tsam saum toj thiab rau sab xis ntawm txoj kab tau khov lawm.
6. Dhau mus rau sab xis nyob rau hauv tsab ntawv. Yog tias koj txav deb txaus, txhua sab mus rau sab xis ntawm B yuav pib ploj thaum tag nrho A thiab B yuav nyob twj ywm ntawm qhov screen.
7. Tshem hauv qab ntawm daim ntawv ua haujlwm. Yog tias koj khoov deb txaus, cov kab hauv qab kab 3 yuav pib ploj thaum nruab nrab ntawm kab 1, 2, thiab 3 yuav nyob ntawm qhov screen.

04 ntawm 04

Unfreezing Tag Nrho Cov Kab Txhua Yam thiab Cov Npe ntawm Daim Ntawv Lij Choj

1. Nias rau ntawm saib daim ntawv ntawm txoj hlua.
2. Nias ntawm Qhov Cuam Tshuam Cuam Tshuam rau ntawm txoj hlua qhib qhov khov pane tee npe.
3. Nias ntawm Unfreeze Panes xaiv hauv daim ntawv qhia zaub mov.
4. Ciam teb dub (s) uas qhia cov kab uas khov thiab kab yuav tsum ploj ntawm cov ntawv ua haujlwm .
5. Thaum koj tig mus rau sab xis los yog cia rau hauv daim ntawv ua haujlwm, cov hau lus nyob rau sab saum toj kab thiab nyob rau hauv sab laug plawg feem ntau tawm ntawm qhov screen.