Muaj qee zaum thaum, thaum ua haujlwm hauv Excel, tom qab nkag mus hauv tus xov tooj ntawm tes, nws tshwm rau hnub ntawd. Qhov teeb meem no yog qhov tshwj xeeb yog kev nyuab siab yog tias koj xav sau cov ntaub ntawv ntawm lwm hom, thiab tus neeg siv tsis paub yuav ua li cas. Wb saib yog vim li cas hauv Excel, es tsis txhob siv cov naj npawb, lub hnub pom, thiab tseem yuav txiav txim siab kho qhov teeb meem li cas.
Daws cov teeb meem ntawm cov zauv cim ua cov hnub
Tsuas yog vim li cas vim li cas cov ntaub ntawv hauv xovtooj thiaj tuaj yeem pom tshwm rau hnub ntawd yog tias nws muaj cov hom ntawv tsim nyog. Yog li, yuav kom kho cov ntaub ntawm cov ntaub ntawv raws li nws xav tau, tus neeg siv yuav tsum hloov nws. Koj tuaj yeem ua li no rau ntau txoj hauv kev.
Method 1: cov ntawv qhia zaub mov ntsiab lus teb
Cov neeg siv feem ntau siv cov ntsiab lus teb rau cov haujlwm no.
- Peb txoj cai-nias ntawm qhov ntau ntawm qhov uas koj xav hloov cov hom ntawv. Hauv cov ntawv qhia zaub mov uas tshwm tom qab cov kev ua no, xaiv qhov khoom "Qib hlwb ...".
- Lub formatting window opens. Mus rau lub tab "Tooj"yog hais tias nws tau dheev qhib hauv lwm tab. Peb yuav tsum tau hloov qhov parameter "Teeb Meem" los ntawm lub ntsiab lus "Hnub" rau tus neeg siv txoj cai. Feem ntau qhov no yog qhov tseem ceeb "General", "Numeric", "Nyiaj", "Cov ntawv nyeem"tab sis kuj yuav muaj lwm tus. Nws tag nrho yog nyob ntawm qhov teeb meem tshwj xeeb thiab lub hom phiaj ntawm cov ntaub ntawv tawm tswv yim. Tom qab hloov qhov ntsuas, nyem rau ntawm lub pob "OK".
Tom qab ntawd, cov ntaub ntawv nyob rau hauv lub hlwb xaiv yuav tsis muab tso tawm kom pom tias yog hnub tim, tab sis yuav muab tso tawm kom pom tseeb rau tus neeg siv. Ntawd yog, lub hom phiaj yuav ua tiav.
Txoj kev 2: Hloov lub formatting ntawm daim kab xev
Qhov thib ob yog ib qho yooj yim tshaj thawj zaug, tab sis vim qee yam tsis tshua muaj neeg nyiam ntawm cov neeg siv.
- Xaiv lub xov tooj ntawm tes los sis cov lej nrog rau hnub hom ntawv.
- Nyob hauv tab "Tsev" nyob rau hauv lub block ntawm cov cuab yeej "Tooj" qhib ib lub cim tshwj xeeb formatting. Nws pib ua cov qauv nrov tshaj plaws. Xaiv ib qho uas zoo tshaj plaws rau cov ntaub ntawv.
- Yog tias cov ntawm cov npe tau xaiv tsis tau xaiv, ces nias qhov khoom "Lwm cov ntaub ntawv numeric ..." nyob rau tib daim ntawv.
- Nws qhib tib qhov formatting qhov rai raws li nyob rau yav dhau los. Nws muaj ntau yam kev hloov ntawm cov ntaub ntawv hauv xovtooj. Raws li, cov kev ua ntxiv yuav yog qhov zoo tib yam li hauv thawj qhov kev daws teeb meem. Xaiv lub yam khoom thiab nias rau ntawm lub pob. "OK".
Tom qab ntawd, lub hom phaj nyob rau hauv lub hlwb xaiv yuav raug hloov mus rau qhov koj xav tau. Tam sim no cov zauv hauv lawv yuav tsis muab tso tawm kom pom tias yog hnub tim, tab sis yuav muab daim ntawv teev lus los ntawm tus neeg siv.
Raws li koj tau pom, qhov teeb meem ntawm kev tshwm sim hnub hauv lub hlwb tsis yog tus xov tooj tsis yog qhov teeb meem tshwj xeeb tshaj. Yuav kom daws tau qhov no nws yooj yim heev, tsuas yog ob peb nas lub cev. Yog hais tias tus neeg siv paub txog qhov kev ua ntawm kev nqis tes ua, ces txoj kev ua tiav no yuav pib rau qib qis. Koj tuaj yeem ua ob txoj hauv kev, tab sis ob leeg ntawm lawv raug txo kom hloov hom xovtooj ntawm hnub txij hnub mus rau lwm yam.
