Cov teeb meem los qhia cov naj npawb hauv cov hnub tim hom hauv Excel

Muaj cov xwm txheej thaum, thaum ua haujlwm hauv Excel, tom qab nkag mus rau hauv tus lej hauv ib ntawm tes, nws tau tshwm sim yog hnub tim. Qhov xwm txheej no yog qhov tshwj xeeb tshaj yog tias koj xav tau nkag mus rau cov ntaub ntawv ntawm ntau hom, thiab tus neeg siv tsis paub yuav ua li cas. Cia peb pom vim li cas hauv Excel, hloov cov lej, hnub tim raug tso tawm, thiab kuj tseem yuav txiav txim siab yuav kho cov xwm txheej no li cas.

Kev daws teeb meem ntawm kev ua kom pom cov naj npawb raws li cov hnub tim

Tsuas yog vim li cas vim li cas cov ntaub ntawv hauv lub xov tooj ntawm tes tuaj yeem tshwm sim ua hnub tim yog tias nws muaj hom ntawv tsim nyog. Yog li, txhawm rau kho cov zaub cov ntaub ntawv raws li nws xav tau, tus neeg siv yuav tsum hloov nws. Qhov no tuaj yeem ua los ntawm ntau txoj kev.

Txoj Kev 1: cov ntawv qhia zaub mov

Cov neeg siv feem ntau siv cov ntawv qhia zaub mov los daws cov teeb meem no.

1. Txoj cai-nias rau ntawm ntau yam uas koj xav kom hloov hom ntawv. Hauv cov ntawv qhia zaub mov uas tshwm sim tom qab cov yeeb yam no, xaiv "Cell hom ...".



2. Lub qhov rai qhib ntsej muag qhib. Mus rau hauv lub tab "Tooj"yog tias nws cia li qhib dua hauv lwm lub tab. Peb yuav tsum pauv qhov hloov pauv "Cov Naj Npawb Cov Qauv" los ntawm tus nqi Hnub Tim rau tus neeg siv khoom xav tau. Feem ntau cov kev ntseeg no "General", "Numeric", "Nyiaj", "Ntawv"tab sis tej zaum yuav muaj lwm tus. Txhua yam nws yog nyob ntawm qhov xwm txheej tshwj xeeb thiab lub hom phiaj ntawm cov ntaub ntawv sau. Tom qab hloov lub parameter, nyem rau ntawm lub pob "OK".

Tom qab ntawv, cov ntaub ntawv hauv cov xovtooj uas raug xaiv yuav tsis muab tso tawm tam li hnub, tab sis yuav tso tawm ua hom ntawv uas tsim nyog rau tus neeg siv. Ntawd yog, lub hom phiaj yuav ua tiav.

Txoj Kev 2: hloov cov ntawv sau rau ntawm daim kab xev

Qhov txheej txheem thib ob tseem yooj yim dua li thawj zaug, txawm hais tias vim li cas nws tsis tshua nrov ntawm cov neeg siv.

1. Xaiv lub xov tooj ntawm tes lossis ntau yam nrog hnub tim.



2. Nyob hauv kab "Tsev" hauv lub thawv "Tooj" qhib qhov tshwj xeeb daim teb. Nws nthuav tawm cov hom ntawv uas nrov tshaj plaws. Xaiv qhov uas zoo tshaj plaws rau cov ntaub ntawv tshwj xeeb.



3. Yog tias ntawm cov ntawv teev hauv daim ntawv uas tau xaiv qhov tsis tsim nyog tau pom, ces nyem rau ntawm qhov khoom "Lwm tus qauv naj npawb ..." hauv tib cov npe.



4. Raws nraim tib yam formatting qhov rais qhib li nyob rau hauv cov qauv dhau los. Nws muaj cov kab sau ntau dua ntawm cov ntaub ntawv hloov pauv hauv lub xovtooj ntawm. Raws li, cov kev nqis tes ua ntxiv yuav tseem yuav yog qhov tseeb tib yam li ntawm thawj qhov kev daws teeb meem. Xaiv yam xav tau thiab nyem rau ntawm lub pob "OK".

Tom qab ntawv, hom ntawv nyob hauv cov xov tooj xaiv yuav raug hloov mus rau qhov koj xav tau. Tam sim no cov naj npawb hauv lawv yuav tsis muab tso rau hauv daim ntawv ntawm hnub, tab sis yuav siv daim ntawv-txiav txim siab los ntawm cov neeg siv.

Raws li koj tuaj yeem pom, teeb meem ntawm kev qhia hnub hauv lub hlwb hloov cov lej tsis yog qhov teeb meem nyuaj tshwj xeeb. Kev daws nws yog qhov yooj yim heev, tsuas yog ob peb nas nias tau txaus. Yog tias tus neeg siv paub qhov kev daws teeb meem ntawm cov kev coj ua, tom qab ntawd tus txheej txheem no tau ua theem pib. Muaj ob txoj hauv kev los ua nws, tab sis ob qho tib si nqis los pauv hloov hom ntawv ntawm tes txij hnub mus rau lwm yam.