Cov kev muaj nuj nqis muaj nyob hauv hlwb ntawm Microsoft Office Excel cov ntawv nthuav qhia feem ntau yog los ntawm cov qauv sau hauv lawv. Cov txiaj ntsig ntawm kev suav tseem tuaj yeem yog tus nqi xoom, uas yog qhov tsis xav qhia nyob rau hauv ntawm tes. Zeros tsis txhim kho qhov nyeem tau tag nrho ntawm cov txiaj ntsig, tshwj xeeb tshaj yog yog cov qauv tso ua cov ntawv nyeem es tsis siv cov nuj nqis hauv lwm lub hlwb ntawm kem. Muaj ob peb txoj hauv kev los daws cov teeb meem no.
Nws yog qhov tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Txhawm rau kev cuam tshuam cov zaub ntawm xoom qhov tseem ceeb hauv txhua lub hlwb ntawm daim ntawv qhib ntawm Excel daim ntawv, siv ib qho ntawm cov chaw hauv cov teeb tsa dav dav ntawm cov ntawv tshaj tawm. Cov kev teeb tsa no tau qhib los ntawm cov ntawv qhia zaub mov tseem ceeb - nyob rau xyoo 2010, nyem rau lub pob "Cov Ntaub Ntawv" kom nkag mus tau nws, thiab hauv xyoo 2007, khawm puag ncig Lub Chaw Haujlwm tau npaj rau qhov no. Nyem rau ntawm cov ntawv qhia zaub mov "Xaiv" (version 2010) lossis nyem lub pob "Excel Xaiv" (version 2007).
Kauj ruam 2
Xaiv tshooj "Advanced" los ntawm daim ntawv teev npe thiab kos los ntawm cov npe teev tseg rau "Pom xaiv rau lwm daim ntawv tom ntej." Khij lub npov nyob ntawm Show Zeros hauv cov xoos uas muaj zeros thiab nyem OK.
Kauj ruam 3
Lwm txoj kev tso cai rau koj mus nkaum tsis muaj nuj nqis tsis yog hauv txhua daim ntawv, tab sis nyob rau hauv kev xaiv cov pab pawg ntawm cov hlwb. Xaiv cov cheeb tsam uas xav tau ntawm lub rooj thiab nyem xaiv nrog khawm xis. Hauv cov ntawv qhia pop-up, xaiv kab "Format cells" kab, thiab nyob rau sab laug sab laug ntawm lub qhov rai uas qhib, nyem rau hauv qab kab - "Txhua hom".
Kauj ruam 4
Hauv daim teb hauv qab "Ntaus" daim ntawv lo, nkag mus rau cov cim hauv qab no: "0; -0;; @" (tsis muaj npe). Yog tias tsis yog-xoom qhov tseem ceeb ntawm cov xaiv yog yuav tsum tau tso tawm nrog qee tus lej ntawm cov naj npawb nruab nrab, tom qab txhua xoom hauv cov khoom nkag no, ntxiv cov lej tsis sib xws ntawm tus lej, cais lawv nrog lub chaw pib. Piv txwv li, txhawm rau muab qhov ntsuas qhov ntsuas txog pua pua, cov ntaub ntawv sau tseg no yuav tsum zoo li no: "0, 00; -0, 00;; @". Tom qab ntawd nyem OK thiab lub zeros yuav ploj.
Kauj ruam 5
Qhov thib peb hom tsis tshem tawm tus nqi xoom, tab sis xim tsev rau lawv nyob rau tom qab xim ntawm lub xov tooj thiab yog li ua rau lawv pom tsis tau. Cov qauv no siv cov txheej txheem tsis raug cai - xaiv cov kab uas yuav tsum tau lossis teeb ntawm kab ntawv thiab nyem rau lub pob nrog lub npe no hauv "Cov Qauv" pab pawg ntawm cov lus txib. Hauv daim ntawv teev npe cia, mus rau tshooj "Cell xaiv cov cai" thiab xaiv kab "Equal".
Kauj Ruam 6
Hauv daim teb sab laug ntawm daim foos uas tshwm sim, nkag mus rau xoom, thiab hauv cov npe ntawm txoj cai teb, xaiv "Custom Format". Lub pob ntawv "Format Cells" yuav qhib, ntawm "Font" tab uas koj xav tau cov ntawv teev hauv qab ntawm kab ntawv "Xim" - qhib nws thiab hauv cov rooj xim xaiv qhov ntxoov ntxoo ntawm keeb kwm ntawm tes (feem ntau yog dawb). Nyem OK hauv ob qho tib si qhib kev sib tham thiab cov haujlwm yuav ua tiav.
