Qhov wikiHow qhia koj yuav ua li cas khov kab thiab kab tshwj xeeb hauv koj daim ntawv Microsoft Excel. Khaws kab lossis kab kom khov kom ntseeg tau tias qee lub cell tseem pom thaum koj nqes los ntawm cov ntaub ntawv. Yog tias koj xav tau kho kom yooj yim ob ntu ntawm daim ntawv nthuav tawm ib zaug, faib koj lub panes yuav ua rau txoj haujlwm yooj yim dua.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Khaws Thawj Kab lossis Kab
Kauj Ruam 1. Nyem rau Saib tab
Nws yog nyob rau sab saum toj ntawm Excel. Cov khov khov yog kab lossis kab uas tseem pom tau thaum koj nqes los ntawm ib daim ntawv ua haujlwm. Yog tias koj xav tau kab ntawv kab taub hau lossis kab ntawv kab kom pom tau zoo li koj ua haujlwm nrog cov ntaub ntawv ntau, koj yuav pom tias nws muaj txiaj ntsig los xauv cov cell ntawd.
Tsuas yog kab lossis kab tuaj yeem khov tau. Nws tsis tuaj yeem khov ib tus tib neeg cov cell
Kauj Ruam 2. Nyem rau Freeze Panes khawm
Nws nyob hauv ntu "Window" ntawm qhov toolbar. Ib txheej ntawm peb txoj kev xaiv khov yuav tshwm sim.
Kauj Ruam 3. Nyem Freeze Top Row los yog Khov Thawj Kab.
Yog tias koj xav khaws cov kab saum toj kawg nkaus ntawm cov cell nyob hauv qhov chaw thaum koj nqes los ntawm koj cov ntaub ntawv, xaiv Khov Top Row. Txhawm rau kom thawj kab nyob hauv qhov chaw thaum koj nqes kab rov tav, xaiv Khov Thawj Kab.
Kauj Ruam 4. Unfreeze koj cov cell
Yog tias koj xav qhib lub cell khov, nyem rau Khov Panes ntawv qhia zaub mov dua thiab xaiv Unfreeze Panes.
Txoj Kev 2 ntawm 2: Khaws Ntau Kab lossis Kab
Kauj Ruam 1. Xaiv kab lossis kab tom qab cov uas koj xav khov
Yog tias cov ntaub ntawv koj xav kom nyob ruaj khov yuav siv ntau dua ib kab lossis kab, nyem kab ntawv lossis kab lej tom qab cov uas koj xav khov. Piv txwv li:
-
Yog tias koj xav khaws kab 1, 2, thiab 3 nyob rau qhov chaw thaum koj nqes los ntawm koj cov ntaub ntawv, nyem kab
Kauj ruam 4. xaiv nws.
- Yog tias koj xav tau kab A thiab B kom nyob twj ywm thaum koj nqes mus los ntawm koj cov ntaub ntawv, nyem kab ntawv C xaiv nws.
- Cov khov khov yuav tsum txuas rau sab saud lossis sab laug ntawm daim ntawv teev npe. Nws tsis tuaj yeem khov kab lossis kab hauv nruab nrab ntawm daim ntawv.
Kauj ruam 2. Nyem rau Saib tab
Nws yog nyob rau sab saum toj ntawm Excel.
Kauj Ruam 3. Nyem rau Freeze Panes khawm
Nws nyob hauv ntu "Window" ntawm qhov toolbar. Ib txheej ntawm peb txoj kev xaiv khov yuav tshwm sim.
Kauj Ruam 4. Nyem rau Freeze Panes ntawm cov ntawv qhia zaub mov
Nws nyob rau sab saum toj ntawm cov ntawv qhia zaub mov. Qhov no khov cov kab lossis kab ua ntej tus koj xaiv.
Kauj Ruam 5. Unfreeze koj lub cell
Yog tias koj xav qhib lub cell khov, nyem rau Khov Panes ntawv qhia zaub mov dua thiab xaiv Unfreeze Panes.
