Txhawm rau qhov muag pom lub rooj cov hlwb uas muaj qee yam sib xws - tag nrho lossis ib nrab ntawm cov nqi sib xws, tib tus ntawv, keeb kwm yav dhau, thiab lwm yam - hauv Microsoft Office Excel muaj ib qho kev xaiv hu ua "Kev Tswj Cov Ntawv". Nws tso cai rau tus neeg siv taw qhia rau cov ntaub ntawv tshaj tawm cov ntawv sau uas ntais ntawv yuav tsum tau qhia hauv cov hlwb, nruj npaum li cas ntawm kev tshuaj xyuas tus kheej yuav tsum tau nqa tawm, yuav ua li cas hais txog qhov yuam kev thiab lwm cov kev txwv ntawm kev ua haujlwm no.
Nws yog qhov tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Pib Excel thiab thauj khoom ntawm qhov xav yam rau nws. Tshaj tawm cov ntau ntawm cov hlwb nyob rau hauv uas txhawm rau tshawb cov ntais ntawv - nws tuaj yeem yog ib kem lossis kab, ib pawg ntawm kab / kab, qee thaj tsam hauv ib lub rooj, lossis txawm tias muaj ntau thaj tsam tsis cuam tshuam.
Kauj ruam 2
Nthuav Cov Kev Uas Txheeb Ze-Cov Ntawv Uas Qhia nyob rau hauv cov qauv pab pawg ntawm cov lus txib ntawm lub Tsev tab ntawm Excel cov zaub mov. Ntu mus rau ntawm Ntaw Xaiv Cell ntawm tshooj thiab xaiv Qhov Rho Tawm Qhov Muaj nuj nqis. Raws li qhov tshwm sim, lub thawv ntawv qhib yuav qhib uas koj yuav tsum sau hauv ob daim teb nkaus xwb.
Kauj ruam 3
Yog tias koj xav khij txhua lub hlwb ntawm thaj chaw xaiv, cov ntsiab lus ntawm uas tau rov ua hauv nws tsawg kawg ib zaug, tseg cov nqi qub "dua" rau hauv cov npe xaiv tseg. Tsuas muaj ob txoj hauv kev hauv cov npe no, qhov thib ob - "tshwj xeeb" - tso cai rau koj kom nthuav tawm cov hlwb uas tsis muaj qhov cuam tshuam.
Kauj ruam 4
Nyob rau hauv txoj cai daim ntawv teev nco-down, xaiv ib qho ntawm cov kev xaiv rau qhov tseem ceeb pom cov hlwb tshawb pom. Nws muaj rau txoj hauv kev rau kev sau keeb kwm yav dhau, hloov cov xim xim thiab ciam teb ntawm pom cov ntsiab lus hauv lub rooj. Yog tias tsis muaj ib qho ntawm cov kev xaiv uas haum rau qhov tsim ntawm koj cov lus, xaiv cov khoom hauv qab - "Hom ntawv kev cai" - thiab siv lub chaw teeb tsa uas qhib los tsim koj cov qauv ntawm cov hlwb sib txuam.
Kauj ruam 5
Nyem OK thiab Excel yuav khij lub hlwb sib txuam raws li cov ntsuas koj teev.
Kauj Ruam 6
Cov txheej txheem piav qhia tso cai rau koj xaiv txhua lub hlwb uas muaj qhov cuam tshuam, tab sis txoj cai xaiv tus qauv yuav siv tau lwm txoj kev. Yog tias koj xav tau ntsiab hauv lub rooj tsuas yog theej tawm uas muaj cov nqi tshwj xeeb, tom qab ntawv ntawm "Cov kev xaiv ntawm tes" ntawm seem "Cov" ntawv "uas muaj" xaiv ", tus xaiv xaiv lwm yam -" sib npaug ". Tom qab qhib cov ntawv sib tham, nyem rau ntawm lub xovtooj ntawm tes, txhua qhov luam tawm ntawm qhov koj xav kom txheeb xyuas, thiab nws qhov chaw nyob yuav tshwm nyob rau sab laug. Tus so ntawm cov kev coj ua hauv qhov no yuav tsis txawv ntawm qhov tau hais tseg. Yog tias nws yog qhov tsim nyog los hais txog lub hlwb sib txuam nrog tus nqi sib txawv ntawm cov xim sib txawv, rov ua qhov haujlwm no, qhia qhov chaw nyob ntawm lwm lub cell.
