Yuav ua li cas khov ntau kab hauv Excel

Lub peev xwm los khov kab hauv Excel yog qhov muaj txiaj ntsig zoo hauv qhov kev pab cuam uas tso cai rau koj kom khov ib cheeb tsam kom khaws cov ntaub ntawv pom. Nws muaj txiaj ntsig zoo thaum ua haujlwm nrog cov ntxhuav loj, piv txwv li, thaum koj xav tau kev sib piv. Nws tuaj yeem khov ib kem lossis ntes ob peb zaug ib zaug, uas peb yuav tham txog ntau yam hauv qab no.

Yuav ua li cas khov thawj kab hauv Excel?

Yuav kom khov ib kem ib leeg, koj yuav tsum ua cov hauv qab no:

1. Qhib cov ntaub ntawv lub rooj koj xav hloov.
2. Mus rau lub toolbar hauv seem "Saib".
3. Nrhiav nyob rau hauv lub tswv yim functionality "Xov chaw".
4. Hauv daim ntawv teev npe, xaiv "Qhib thawj kab".

Tom qab ua tiav cov kauj ruam, koj yuav pom tias ciam teb tau hloov me ntsis, ua rau tsaus thiab me ntsis tuab, uas txhais tau hais tias nws tau kho, thiab thaum kawm lub rooj, cov ntaub ntawv ntawm thawj kab yuav tsis ploj thiab, qhov tseeb, yuav kho qhov muag pom.

Yuav ua li cas khov ntau kab hauv Excel?

Txhawm rau txhim kho ob peb kab ib zaug, koj yuav tsum ua ntau cov kauj ruam ntxiv. Qhov tseem ceeb tshaj plaws uas yuav tsum nco ntsoov yog cov kab ntawv suav los ntawm cov qauv sab laug, pib nrog A. Yog li ntawd, nws yuav tsis tuaj yeem khov ob peb kab sib txawv qhov chaw nyob nruab nrab ntawm lub rooj. Yog li, txhawm rau siv qhov haujlwm no, koj yuav tsum ua cov hauv qab no:

1. Cia peb hais tias peb yuav tsum khov peb kab ib zaug (teev A, B, C), yog li ua ntej xaiv tag nrho kem D lossis cell D

2. Tom qab ntawd, koj yuav tsum mus rau lub toolbar thiab xaiv lub tab hu ua "Saib".
3. Nyob rau hauv nws, koj yuav tau siv cov kev xaiv "Freeze cheeb tsam".

4. Hauv daim ntawv teev npe koj yuav muaj ntau lub luag haujlwm, ntawm lawv koj yuav tsum xaiv "Kho qhov chaw".
5. Yog tias txhua yam ua tiav lawm, ces peb kab lus qhia yuav raug kho thiab siv tau los ua cov ntaub ntawv los yog sib piv.

Ua tib zoo mloog! Koj tsuas yog yuav tsum khov kab yog tias lawv pom ntawm qhov screen. Yog tias lawv tau muab zais lossis mus dhau qhov pom kev pom, tom qab ntawd cov txheej txheem kho yuav tsis zoo li xaus. Yog li ntawd, thaum ua txhua yam kev ua, koj yuav tsum tau ceev faj heev thiab sim tsis txhob ua yuam kev.

Yuav ua li cas khov kab thiab kab tib lub sijhawm?

Tej zaum yuav muaj qhov xwm txheej zoo li no uas koj yuav tsum tau khov ib kem ib zaug nrog rau kab nyob ze, txhawm rau txhawm rau ua kom khov, koj yuav tsum ua cov hauv qab no:

1. Thaum xub thawj, koj yuav tau siv lub xovtooj ntawm tes ua lub hauv paus taw tes. Lub ntsiab yuav tsum tau muaj nyob rau hauv cov ntaub ntawv no yog hais tias lub cell yuav tsum tau nruj me ntsis nyob rau hauv kev sib tshuam ntawm kab thiab kab. Thaum xub thawj, qhov no yuav zoo li nyuaj, tab sis ua tsaug rau qhov txuas nrog lub screenshot, koj tuaj yeem nkag siab tam sim ntawd cov intricacies ntawm lub sijhawm no.
2. Mus rau lub toolbar thiab siv lub "Saib" tab.
3. Nyob rau hauv nws koj yuav tsum nrhiav tau cov khoom "Txias cheeb tsam" thiab nyem rau ntawm nws nrog rau sab laug nas khawm.
4. Los ntawm daim ntawv teev npe poob, tsuas yog xaiv qhov kev xaiv "Freeze areas".

Nws tuaj yeem txhim kho ntau lub vaj huam sib luag ib zaug rau kev siv ntxiv. Piv txwv li, yog tias koj xav tau kho thawj ob kab thiab ob kab, tom qab ntawd rau kev taw qhia meej koj yuav tsum xaiv cell C3. Thiab yog hais tias koj yuav tsum tau kho peb kab thiab peb kab ib zaug, rau qhov no koj yuav tau xaiv cell D4 twb. Thiab yog tias koj xav tau cov txheej txheem tsis zoo, piv txwv li, ob kab thiab peb kab, ces koj yuav tsum xaiv cell D3 los kho nws. Kev kos duab sib luag, koj tuaj yeem pom lub hauv paus ntsiab lus ntawm kev kho thiab ua siab tawv siv nws hauv txhua lub rooj.

Yuav ua li cas unfreeze cheeb tsam hauv Excel?

Tom qab cov ntaub ntawv los ntawm cov kab pinned tau siv tag nrho, koj yuav tsum xav txog yuav ua li cas tshem tawm cov pinning. Muaj ib txoj haujlwm tshwj xeeb rau qhov no, thiab siv nws, koj yuav tsum ua cov hauv qab no:

1. Thawj kauj ruam yog kom paub tseeb tias cov kab pinned tsis xav tau ntxiv rau koj txoj haujlwm.
2. Tam sim no mus rau lub toolbar nyob rau sab saum toj thiab mus rau "Saib" tab.
3. Siv lub Freeze Regions feature.
4. Los ntawm cov npe drop-down, xaiv cov khoom "Unfreeze regions".

Thaum txhua yam ua tiav, lub pinning yuav raug tshem tawm, thiab nws yuav siv tau qhov qub saib ntawm lub rooj dua.

xaus

Raws li koj tuaj yeem pom, kev siv lub pinning muaj nuj nqi tsis yog qhov nyuaj, nws yog txaus kom txawj siv txhua yam uas muaj thiab ua tib zoo ua raws li cov lus pom zoo. Qhov kev ua haujlwm no paub tseeb tias tuaj yeem siv tau, yog li koj yuav tsum nco ntsoov lub hauv paus ntsiab lus ntawm nws siv.