Txoj hauv kev yooj yim kom khov Ntau dua Ib Kab hauv Excel: 5 Kauj Ruam

Cov txheej txheem:

Txoj hauv kev yooj yim kom khov Ntau dua Ib Kab hauv Excel: 5 Kauj Ruam
Txoj hauv kev yooj yim kom khov Ntau dua Ib Kab hauv Excel: 5 Kauj Ruam

Video: Txoj hauv kev yooj yim kom khov Ntau dua Ib Kab hauv Excel: 5 Kauj Ruam

Video: Txoj hauv kev yooj yim kom khov Ntau dua Ib Kab hauv Excel: 5 Kauj Ruam
Video: YUAV UA LI CAS THIAJ TSIS TSW TSOG! DIY 2024, Tej zaum
Anonim

Cov wikiHow no yuav qhia koj yuav ua li cas khov panes kom xauv kab hauv Excel. Thaum koj khov ib kem, nws yuav nyob twj ywm pom thaum koj rub tawm los ntawm daim ntawv ntawd.

Cov kauj ruam

Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 1
Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib koj qhov haujlwm hauv Excel

Koj tuaj yeem qhib qhov program hauv Excel los ntawm txhaj File> Qhib, lossis koj tuaj yeem nyem qhov ntawv hauv koj cov ntaub ntawv tshawb nrhiav.

Qhov no yuav ua haujlwm rau Windows thiab Macs siv Excel rau Chaw Ua Haujlwm 365, Excel rau lub vev xaib, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007

Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 2
Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 2

Kauj Ruam 2. Xaiv lub cell rau sab xis ntawm kab ntawv uas koj xav kom khov

Cov kab khov yuav nyob twj ywm pom thaum koj nqes los ntawm daim ntawv ua haujlwm.

Koj tuaj yeem nias Ctrl los yog Cmd raws li koj nyem lub xov tooj kom xaiv ntau dua ib qho, lossis koj tuaj yeem khov txhua kab ntawm tus kheej.

Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 3
Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Saib

Koj yuav pom qhov no ib qho hauv kev kho kab kab saum toj ntawm daim ntawv lossis nyob rau sab saum toj ntawm koj lub vijtsam.

Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 4
Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 4

Kauj Ruam 4. Nyem rau Freeze Panes

Cov ntawv qhia zaub mov yuav poob qis. Koj muaj kev xaiv kom khov tshwj xeeb panes lossis khov thawj kab thiab kab.

Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 5
Khov Ntau Tshaj Ib Kab hauv Excel Kauj Ruam 5

Kauj Ruam 5. Nyem Khov Khov

Qhov no yuav khov lub panes hauv kab ntawm ib sab ntawm qhov koj tau xaiv.

Lub tswv yim

Unfreeze kab los ntawm mus rau Saib> Unfreeze Panes.

Pom zoo: