Khaws kab thiab kab hauv Microsoft Excel cov qauv 2013, 2010, thiab 2007 tuaj yeem pab tau yog tias koj xav khaws ib feem ntawm koj daim ntawv nthuav tawm pom txhua lub sijhawm thaum koj tsiv mus thiab ua haujlwm hauv lwm ntu ntawm koj daim ntawv. Cov tib neeg lub cev tsis tuaj yeem khov thiab xauv rau hauv qhov chaw; Txawm li cas los xij, koj tuaj yeem khov ib lossis ntau kab thiab kab nyob rau sab saum toj thiab sab laug ntawm koj daim ntawv nthuav dav, feem.
Cov kauj ruam
Kauj Ruam 1. Xaiv kab (kab) lossis kab (kab) nyob hauv qab no lossis mus rau sab xis ntawm kab (kab) lossis kab (kab) koj xav khov
Piv txwv li, yog tias koj xav kom khov kab 1, xaiv kab 2.
Thaum khov kab (s) thiab kab ntawv (s) tib lub sijhawm, nyem rau ntawm ib lub xovtooj uas nyob hauv qab no thiab mus rau sab xis ntawm kab (s) thiab kab (s) koj xav khov. Piv txwv li, yog tias koj xav kom khov kab 1 thiab kab A, nyem rau ntawm lub xov tooj ntawm tes nyob hauv B2
Kauj Ruam 2. Nyem rau ntawm daim ntawv sau "Saib" nyob rau sab saum toj ntawm koj qhov kev sib tham Excel
Kauj Ruam 3. Nyem rau qhov xub me me nyob ib sab ntawm "Freeze Panes" nyob hauv Pawg Window
Kauj Ruam 4. Nyem rau “Freeze Top Row” lossis “Freeze First Column,” raws li koj xaiv
Kab (s) thiab/lossis kab (s) koj tau xaiv tam sim no yuav khov nyob hauv qhov chaw.
Xaiv "Freeze Panes" thaum khov kab (s) thiab kem (s) tib lub sijhawm
Lub tswv yim
Khov qee kab lossis kab ntawv uas muaj cov ntawv sau kom ua haujlwm hauv koj daim ntawv nthuav qhia ua haujlwm yooj yim dua. Khov kab lossis kab nrog cov ntawv yuav tso cai rau koj nqes mus lossis hla mus rau lwm ntu ntawm daim ntawv nthuav tawm thiab ua haujlwm txuas ntxiv yam tsis plam qhov pom ntawm koj daim ntawv lo
Lus ceeb toom
- Koj yuav tsis muaj peev xwm ua kom khov kab, kab, lossis panes yog tias koj daim ntawv nthuav tawm raug tiv thaiv lossis yog tias koj tab tom kho ib lub cell tshwj xeeb. Kom tau txais kev nkag mus rau lub ntsej muag khov lub ntsej muag, tshem tawm kev tiv thaiv los ntawm koj daim ntawv teev npe, lossis ua tiav kho lub xovtooj.
- Yog tias siv Excel Starter, koj yuav tsis muaj peev xwm khov thiab xauv kab thiab kab vim yog qhov txwv ntawm cov yam ntxwv tshwj xeeb hauv no tshwj xeeb version ntawm Excel. Txhawm rau nkag tau mus rau qhov khov ntawm lub ntsej muag, koj yuav tsum tau ua haujlwm hauv lwm qhov hloov pauv ntawm Excel.