Nrog rau cov chaw pib, Microsoft Office Excel cov ntawv sau tawm tswv yim kho cov txheej txheem ntawm tes uas pib nrog kev kos npe sib npaug raws li tus qauv. Qhov kev teeb tsa no tuaj yeem hloov pauv los ntawm kev hloov pauv hom ntawv ntawm tes thiab yog li kev xiam oob qhab kev siv cov txheej txheem hauv thaj chaw tau teev tseg ntawm pob ntawv. Tsis tas li ntawd, Excel muaj cov chaw los ua kom qhib lossis ua haujlwm rau cov tsis ua haujlwm cov qauv.
Tsim nyog
Tabular editor Microsoft Office Excel 2010 lossis 2007
Cov Lus Qhia
Kauj ruam 1
Los ntawm lub neej ntawd, Excel siv hom ntawv hu ua "dav dav" rau txhua tus ntawm tes hauv daim ntawv nthuav dav. Nws txhais tau hais tias muaj kev sib txig sib luag thaum pib ntawm cov ntsiab lus ntawm tes txhais tau hais tias ib lub mis muab tso rau hauv nws. Qhov no tsis yooj yim yog tias, qhov tseeb, daim paib tsis sib npaug tsuas yog ib feem ntawm cov ntawv sau. Nyob rau hauv cov xwm txheej zoo li no, tus khoos phis tawm feem ntau qhia cov lus yuam kev hauv cov qauv hloov cov ntawv sau. Koj tuaj yeem kho qhov teeb meem los ntawm kev hloov pauv ntawm hom ntawv mus rau "ntawv". Ua li no, pib los ntawm qhov tseem ceeb thaj chaw uas xav tau ntawm lub rooj - kem, kab, lossis pab pawg tshwj xeeb ntawm cov hlwb.
Kauj ruam 2
Qhib cov ntawv teev cia nyob hauv kab sab saum toj ntawm "Tus naj npawb" cov lus txib ntawm "General" tab ntawm daim ntawv thov zaub mov. Scroll rau hauv qab thiab xaiv kab hauv qab - "Ntawv". Qhov zoo ib yam tuaj yeem ua lwm txoj hauv kev - nyem txoj cai xaiv ntau yam thiab xaiv kab "Format hlwb" kab hauv cov ntawv qhia zaub mov. Nyem rau ntawm kab "Ntawv" hauv kab "Number Formats" thiab nyem rau lub pob lus OK. Qhov no ua tiav txoj kev ua.
Kauj ruam 3
Yog hais tias lub hlwb tso tawm cov qauv hloov ntawm lawv cov txiaj ntsig, nws zoo li tias ib qho ntawm kev nyiam Excel yuav tsum tau hloov. Txhawm rau ua qhov no, mus rau "Formulas" tab thiab nyem rau ntawm "Show formulas" icon - nws nyob rau sab xis ntawm "Cov Ntawv Cuam Tshuam (Cell Influencing cells)" hauv "Formula dependencies" cov pab pawg. Thaum ua kom pom zoo, lub cim no yuav tsum tau muab sau ua daj.
Kauj ruam 4
Xws li qhov tsis xws luag tuaj yeem rov ua dua txhua zaus daim ntawv qhib, yog tias qhov kev xaiv no tau tsau hauv Excel chaw. Txhawm rau hloov cov chaw sib haum, qhib cov ntawv qhia zaub mov tseem ceeb ntawm cov ntawv tshaj xo thiab xaiv cov khoom "Kab Txwv". Hauv kab ntawv ntawm cov kem, nyem rau kab "Advanced" thiab kos cov npe teev rau hauv seem "Qhia cov ntsiab lus rau daim ntawv txuas ntxiv". Kos cim lub thawv "Qhia cov qauv, tsis yog lawv cov nqi" thiab nyem OK. Thaum koj kaw daim ntawv, tsis txhob hnov qab khaws nws kom qhov xwm txheej tsis rov ua nws tus kheej rau lwm zaus koj thauj nws mus rau hauv cov ntawv tshaj tawm.
