Qhov wikiHow no qhia koj li cas xaiv ntau yam ntawm cov ntaub ntawv hauv Excel thiab suav nws qhov sib txawv, siv lub khoos phis tawj.
Cov kauj ruam
Kauj Ruam 1. Qhib Excel cov ntaub ntawv uas koj xav kho
Nrhiav Excel cov ntaub ntawv koj xav kho hauv koj lub computer, thiab qhib nws.
Kauj Ruam 2. Nyem rau ntawm tes tsis muaj dab tsi
Nrhiav lub xov tooj ntawm tes khoob ntawm daim ntawv uas koj xav ua koj cov lej, thiab nyem rau nws.
Kauj Ruam 3. Nyem rau khawm fx
Lub pob no nyob ib sab ntawm tus lej bar nyob rau sab saud sab laug ntawm koj daim ntawv teev npe. Nws yuav qhib Formula Builder vaj huam sib luag ntawm sab xis ntawm koj lub vijtsam.
Kauj Ruam 4. Scroll down thiab ob npaug nias VAR. P
Lub luag haujlwm no suav qhov sib txawv raws li tag nrho cov pej xeem. Ob-nias yuav ntxig qhov tsis sib xws ua haujlwm mus rau hauv lub cell xaiv.
Xwb, koj tuaj yeem xaiv VAR. S tau. Txoj haujlwm no kwv yees qhov sib txawv raws tus qauv piv rau xam tag nrho cov tib neeg qhov sib txawv.
Kauj Ruam 5. Xaiv qhov ntau ntawm cov ntaub ntawv koj xav ntsaws rau hauv cov mis
Nyem koj thawj cov ntaub ntawv taw qhia ntawm daim ntawv nthuav qhia, thiab rub tus nas kom txog thaum kawg ntawm cov ntaub ntawv teeb tsa. Qhov no yuav ntsaws txhua qhov txiaj ntsig hauv qhov xaiv tau rau hauv koj cov qauv sib txawv.
Kauj Ruam 6. Ntaus Enter los yog Rov qab los ntawm koj cov keyboard.
Qhov no yuav ua cov txheej txheem xaiv cov ntaub ntawv, thiab suav nws qhov sib txawv. Cov zauv tshwm sim yuav tshwm nyob rau hauv lub cell xaiv.