Hauv cov ntxhuav nrog ntau ntau ntawm txhua kab, nws yog qhov tsis yooj yim rau cov txheej txheem. Tom qab tag nrho, yog hais tias lub rooj dav tshaj qhov ciam teb ntawm qhov dav hlau qhov dav hlau, ces kom pom cov npe ntawm cov kab uas muaj cov ntaub ntawv, koj yuav tsum tau lossi mus rau sab phab laug mus rau sab laug, thiab rov qab mus rau sab xis dua. Yog li, cov haujlwm no yuav siv sij hawm ntau ntxiv. Hauv kev txiav txim rau tus neeg siv yuav txuag nws lub sijhawm thiab kev rau siab, nws tseem muaj peev xwm khov txhua kab hauv Microsoft Excel. Tom qab ua tiav cov txheej txheem no, sab laug ntawm lub rooj, uas cov kab npe sawv nyob, yuav tas rau tag nrho saib ntawm tus neeg siv. Cia peb xav paub seb yuav kho cov kab hauv Excel.
Hnab kem sab nraud
Txhawm rau txhim kho sab sab nraud ntawm daim ntawv, los yog hauv ib lub rooj, nws yooj yim heev. Ua li no, koj yuav tsum tau nyob hauv "View" tab, nias qhov "Kho Kom Zoo Tshaj Teb" khawm.
Tom qab cov kev ua no, kem sab nrauv yuav nyob hauv koj qhov kev ua tsis pom kev, tsis hais txawm koj nyob ntawm daim ntawv mus rau sab xis.
PIN ntau kab
Tab sis yuav ua li cas yog tias koj xav tau kho dua ib kem hauv ob peb? Lo lus nug no tseem ceeb dua yog tias, ntxiv nrog rau lub npe ntawm kab, koj xav tau qhov tseem ceeb ntawm ib lossis ob peb ntawm cov kab hauv qab no rau hauv koj qhov kev ua yog qhov tsis pom kev. Tsis tas li ntawd, tus qauv, uas peb yuav tham txog hauv qab no, tuaj yeem siv yog, vim qee zaum muaj ntau kab ntawm sab laug ntawm lub rooj thiab sab laug daim ntawv.
Xaiv lub pob saum toj kawg nkaus rau ntawm daim ntawv mus rau sab xis ntawm sab cheeb tsam uas koj xav pin. Tag nrho nyob rau hauv tib lub tab "Saib", nias rau khawm "Fasten areas". Nyob rau hauv cov npe uas tau qhib, xaiv qhov khoom nrog tib lub npe tib yam.
Tom qab ntawd, tag nrho cov kab ntawm lub rooj mus rau sab laug ntawm lub xov tooj ntawm tes xaiv yuav raug kho.
Kev cais tawm
Yuav kom tshem tawm cov kab nrawm tas lawm, rov qab nyem rau ntawm lub khawm "Kho qhov chaw" rau daim nplaum. Lub sijhawm no nyob rau hauv lub npe qhib yuav tsum muaj ib lub pob "Unpinning areas".
Tom qab ntawd, txhua qhov chaw pinned uas tau nyob rau daim ntawv tam sim no yuav muab cais tawm.
Raws li koj tau pom, txhua kab ntawv hauv Microsoft Excel yuav muab kho tau ob txoj kev. Tus thawj ib tsuas yog tsim rau pinning ib kem. Siv ob txoj kev, koj tuaj yeem kho ua ib kem lossis ntau ntau. Tab sis tsis muaj ntau qhov sib txawv ntawm cov kev xaiv no.
