Thaum tso cov ntaub ntawv los ntawm ib qhov program twg rau hauv Excel 2007, cov kab nrog cov kab khoob tas li feem ntau tsim tawm. Kev ua haujlwm ntxiv, koj yuav tsum tshem tawm cov kab tawm ntawm daim ntawv Excel. Muaj cov qauv txheej txheem rau qhov no, kos rau hauv cov haujlwm ntawm daim ntawv thov, thiab cov uas tsis yog tus qauv, siv macros thiab ntxiv-ons.
Kev cais tawm
Txoj kev yooj yim tshem tawm cov kab tas ntawm lub rooj yog kom cov kem tawm. Txhawm rau ua qhov no, koj yuav tsum xaiv qhov ntau ntawm qhov rooj uas nyob ze. Hu rau tus txheej txheem toolbar "Tsev / Teeb" thiab "Lim / Txig los ntawm qhov tsawg kawg rau ntau kawg". Cov kab tsis pom tshwm tau thaum pib ntawm lub rooj. Lawv tuaj yeem xaiv thiab tshem tawm.
Thaum siv cov ntawv txheeb, muaj qhov txaus ntshai tias cov xov tooj nrog cov ntaub ntawv yuav dhia mus rau lwm kab, yog li nco ntsoov teeb tus cim rau hauv lub npov xov xwm mus rau qhov chaw ntawm tsis siv neeg ntau qhov chaw. Hauv qhov no, kev xaiv yuav tshwm sim ib kab los ntawm kab.
Siv lub taub lim
Lub taub lim tuaj yeem siv los kuaj cov khoob khoob. Txhawm rau teeb tsa lub lim, xaiv ib kem thiab hu nws rau ntawm "Cov Ntaub Ntawv / Lim" toolbar. Tom qab ntawd lim cov qhov tseem ceeb hauv kem los ntawm kev xaiv txoj haujlwm hauv lim nrog dawb hlwb. Tam sim no lub rooj ntawv yuav tso saib tsuas yog cov tsis muaj hlwb uas yuav tsum tau lwv tawm.
Siv txoj haujlwm xaiv ntawm pawg ntawm hlwb
Lwm txoj hauv kev txheem yog xaiv cov pab pawg ntawm lub hlwb. Txhawm rau ua qhov no, xaiv lub cuab yeej xaiv nyob rau "Lub Tsev / Nrhiav thiab Xaiv / Xaiv Ib Pawg ntawm Lub Hlwb" ntawm tes. Ib lub npov yuav tsum tshwm sim, nyob rau hauv uas nws yog qhov tsim nyog los cim qhov kev xaiv ntawm cov khoob. Tom qab ntawd xaiv "Home / Cell / Delete" los ntawm cov ntawv qhia zaub mov. Txhua lub hlwb khoob yuav tshem tawm.
Yog hais tias ib kab muaj puv hlwb ntxiv rau cov kab dawb, Excel 2007 yuav tso tawm cov lus qhia tias qhov kev tshem tawm tsis siv rau ntau yam sib tshooj.
Siv macros thiab ntxiv-ins
Yuav kom daws tau qhov teeb meem ntawm kev tshem cov kab khoob ntawm lub rooj, koj tuaj yeem siv macro lossis ntxiv-hauv tshwj xeeb tsim rau lub hom phiaj no. Ib macro yog txheej txheem sau nyob rau VBA cov lus programming. Siv cov ntawv loj loj tso cai rau koj ua ib theem zuj zus ntawm kev nqis tes hauv Excel 2007. Koj tuaj yeem sau macro kom tshem tawm kab kab ntawm koj tus kheej lossis rub tawm ib qho npaj tiav hauv Is Taws Nem. Koj tseem tuaj yeem pom nws hauv Is Taws Nem thiab siv cov ntawv macros npaj - ib qho ntxiv-tawm uas coj los ua haujlwm ntawm kev nrhiav thiab tshem tawm cov kab khoob.
