Cov ntawv sau npe feem ntau tso cai rau koj teev cov npe kab thiab kab. MS Excel tsis muaj txoj hauv kev zoo li no: cov ntaub ntawv kos npe yuav tsum tau nkag ncaj qha rau hauv lub rooj. Tab sis qhov no nws muaj nws tus kheej kom zoo dua. Qhov kev pabcuam no ua rau nws tawm ntawm cov ntawv pom kom pom mus rau kev sib txawv thaum sau lub rooj los ntawm muaj pes tsawg tus hlwb ntsug thiab kab rov tav.
Cov Lus Qhia
Kauj ruam 1
Yog li, cov ncauj lus thiab koob npe yuav raug tso tseg kom pom, thiab cov ntaub ntawv tuaj yeem hloov thiab txav ob qho tib si thiab sab laug. Qhov no ua rau kev nkag siab thaum lub rooj loj thiab koj nkag mus lossis saib cov ntaub ntawv nyob ntawm qhov kawg ntawm cov kab lossis kab ntawv. Txhawm rau kom tsis meej pem thiab tsis txhob nkag mus rau cov ntaub ntawv hauv lub xovtooj uas tsis tsim nyog, nws yooj yim rau cov kos npe kom pom tseeb nyob rau txhua lub sijhawm.
Kauj ruam 2
Hauv lwm cov ntaub ntawv thiab cov chaw khaws cia, cov npe kab (rau kab rov tav toj) lossis cov npe kem (rau scrolling ntsug) yuav pom. Cov no yog, piv txwv li, MS Access, Statistica rau lub Windows thiab lwm tus. Hauv Excel, koj tuaj yeem theej tawm tib lub qhov rais rau ntawm ib daim ntawv, thiab cov ntawv sau cov ntaub ntawv yuav nyob rau sab saum toj ntawm lub rooj nws tus kheej, thiab kev siv tswv yim nrog lawv tuaj yeem nqa tawm ntawm lawv tus kheej.
Kauj ruam 3
Txhawm rau ua qhov no, ua ntej ntawm tag nrho cov sau cov ntawv sau rau hauv kab ntawv thiab kab lus rau cov kab. Nws tsis muaj teeb meem yog tias koj siv cov kev sib koom tes, ntau npaum li cas rau cov kab lus thiab subheadings yuav muaj: ua muaj qhov, koj tuaj yeem faib daim ntawv rau cov chaw ruaj thiab scrollable raws li koj cov kev xav tau.
Kauj ruam 4
Tau kos npe rau cov kab hauv qab thiab cov npe ntawm kab, hauv cov ntawv qhia zaub mov tseem ceeb ntawm qhov program, xaiv kab ntawv "Qhov rai" thiab nrhiav cov "Txaws" nyob hauv. Los ntawm lub neej ntawd, pom cov ntawv qhib qhov rai yuav muab faib ua plaub ntu sib luag los ntawm kab kev txav mus los. Hauv qhov no, qhov seem sab saum toj thiab sab laug ntawm nplooj ntawv, cais cov kab sib cais ntawm thaj chaw, yuav muab theej tawm dua lub rooj qub los ntawm ntau cov kab thiab kab ntawv uas muaj cov kab thiab kab sab rau sab laug thiab saum cov separator.
Kauj ruam 5
Muaj tsis muaj kiag li tsis xav tau rau xws li doubling. Yog li, yog tias koj yuav tsum tso tsuas yog cov kab npe pom, muab ob npaug rau nyem rau kab rov tav faib cov kab. Nws yuav ploj, raws li yuav muaj ob npaug ntawm cov npe npe. Tom qab ntawd tshem tus cursor dhau ntawm kab ntsug, thiab nws tus pointer yuav hloov nws qhov tsos. Thaum tuav sau lub pob nyem lawm, cab kab sib cais rau sab xis ntawm txoj kab npe.
Kauj Ruam 6
Txhawm rau tshem tawm cov tsis tseem ceeb ntawm cov npe ob tog, mus rau ntawm Ntawv Qhia Ntawv Xaiv thiab xaiv qhov Freeze Regions yam nyob hauv. Lub ទ្វេ npe ntawm cov npe yuav ploj dua, thiab cov kab ntsug yuav hloov los ntawm 3D rau 2D thiab yuav raug kho ruaj khov. Tam sim no, thaum scrolling kab rov tav nyob rau hauv lub rooj, cov kab ntawv yuav pom tas li, tsis muaj teeb meem pes tsawg cov nplooj ntawv ntawm cov ntaub ntawv koj kos.
Kauj Ruam 7
Hauv txoj kev zoo tib yam, koj tuaj yeem cais cov ntawv kab lus qhia, los yog ob qho tib lub sijhawm. Txawm li cas los xij, nws tsis tuaj yeem tshem tawm lossis tsiv cov kab sib cais hauv hom no. Yog tias koj tau ua yuam kev, thiab koj yuav tsum txav ib los yog ob qhov ntawm txoj kab sib faib, hauv "Cov Qhov rai" ntawv xaiv, xaiv "Hloov chaw". Cov dividers yuav thim rov qab mus rau peb-seem pom, thiab koj tuaj yeem rub lawv mus rau qhov chaw xav tau ntawm nplooj ntawv nrog nas. Tom qab ntawd rov tus pin rau cov chaw. Thaum qhov xav tau los cais cov cheeb tsam yog tsis tsim nyog ntxiv lawm, hauv "Ntawv qhia zaub mov", xaiv "Tsis Xaiv". Txawm li cas los xij, qhov no tsis yog txhua qhov tsim nyog, txij li cov kab no yuav tsis tshwm sim ntawm lub luam.
