Thaum lub rooj sib txawv ntawm lub rooj hauv Microsoft Office Excel, tus neeg siv yuav xav tau qhov tsis pub muaj kab yog kom nws ib txwm nyob rau qhov chaw thaum kos. Ua li no, koj yuav tsum tau tsim kho qhov chaw tsim nyog.
Cov Lus Qhia
Kauj ruam 1
Tshaj tawm MO Excel, tsim daim ntawv tshiab, lossis qhib ib tus uas twb muaj lawm los kho kom raug. Xaiv kab ntawv uas yuav siv tau los ua tus taw tes nias los ntawm sab laug nas khawm ntawm nws tus naj npawb, lossis tsuas tso tus cursor rau hauv lub xovtooj saum toj no uas kab txuas yuav nyob. Nco ntsoov tias cov kab xaiv (lossis xovtooj ntawm tus kheej) yuav tsis raug kho. Thaj chaw saum toj xaiv yog anchored.
Kauj ruam 2
Tom qab kab ntawv lossis xov tooj ntawm tes tau cim, mus rau "Saib" tab. Ntawm tus txheej txheem toolbar, nrhiav ntu "Qhov rai" thiab nyem lub pob xub ntiag cuam tshuam nrog "Cov chaw kom khov" duab kheej. Cov ntawv qhia zaub mov qhib yuav qhib, xaiv cov lus hais "Dawb Cheeb Tsam".
Kauj ruam 3
Nco ntsoov tias muaj cov lus txib cais rau thawj kab thiab thawj kem hauv cov ntawv qhia. Yog cov kab koj xav kom khov yog thawj kab, koj tuaj yeem siv Freeze Top Row qhov lus txib. Yog tias yav tom ntej koj yuav tsum xa daim ntawv rov qab rau nws cov qauv yav dhau los, rov qhib qhov View tab thiab xaiv Unpin Areas cov lus txib los ntawm Freeze Regions context menu.
Kauj ruam 4
Txhawm rau ua cov kab khov sawv ntsug hauv koj daim ntawv, koj yuav xav hloov nws xim lossis kho ciam teb. Qhov no tuaj yeem ua los ntawm ntau txoj kev. Xaiv kab pined thiab mus rau qhov Home tab. Hauv ntu ntu, siv tus Sau Kab Nkaum thiab Ciam Ntsej khawm.
Kauj ruam 5
Lwm qhov kev xaiv: xaiv cov ntau yam xav tau thiab nyem rau ntawm cov xaiv nrog cov khawm xis. Hauv cov ntawv qhia ua zaub mov, xaiv Hom Ntawv Qhia Qiv. Lub thawv tshiab yuav qhib. Nkag ciam teb thiab Sau tabs los kho cov kev xaiv koj xav tau. Txhawm rau kom paub tseeb cov kev teeb tsa tshiab, nyem khawm OK hauv qab ntawm lub qhov rais.
