Qhov wikiHow qhia koj txoj hauv kev sib txawv los ntxig cov hnub rau hauv koj daim ntawv Microsoft Excel.
Cov kauj ruam
Txoj Kev 1 ntawm 4: Hloov Tus Nqi Raws Li Hnub Tim
Kauj Ruam 1. Ntaus hnub uas xav tau rau hauv lub cell
Nyem ob npaug ntawm lub xovtooj uas koj xav sau hnub tim, thiab tom qab ntawd nkag mus rau hnub uas siv hom ntawv pom hnub twg. Koj tuaj yeem sau hnub tim hauv ntau hom kev sib txawv.
Siv Lub Ib Hlis 3 los ua piv txwv, qee qhov kev lees paub yog "Jan 03," "January 3", "1/3," thiab "01-3."
Kauj Ruam 2. Nias tus ↵ Enter qhov tseem ceeb
Tsuav Excel lees paub hnub tim hom ntawv, nws yuav rov tsim cov xov tooj ntawm tes raws li hnub tim, uas feem ntau yog hli/hnub/xyoo/xyoo lossis dd/hli/xyoo, nyob ntawm koj thaj chaw.
- Yog tias cov ntawv tau ua raws mus rau sab xis, tom qab ntawd Excel lees paub nws ua hnub tim thiab rov ua dua tshiab.
- Yog tias cov ntawv nyob ua ke mus rau sab laug, Excel tab tom kho cov lus nkag ua cov ntawv ntau dua li hnub tim. Qhov no tuaj yeem yog vim nws tsis tuaj yeem lees paub koj cov lus nkag ua hnub tim, lossis vim tias lub xov tooj ntawm tes tau teeb tsa rau qee yam ntxiv rau hnub tim.
Kauj Ruam 3. Txoj cai-nias lub hnub tim cell thiab xaiv Hom Ntawv Cells
Ib lub qhov rai tshiab yuav tshwm tuaj.
Kauj Ruam 4. Nyem rau Tus lej tab
Nws yog thawj tab.
Kauj Ruam 5. Xaiv Hnub Tim hauv "Pawg" vaj huam sib luag
Ntau hom hnub tim yuav tshwm nyob rau sab xis ntawm lub qhov rais.
Kauj Ruam 6. Xaiv qhov koj xav tau hnub ua hom ntawv hauv qab "Hom
Qhov kev hloov pauv no ntawm cov xov tooj uas tau xaiv los tso tawm hauv hom ntawv no.
Koj kuj tseem tuaj yeem hloov pauv koj thaj tsam kom nkag tau rau hnub tim siv hauv koj qhov chaw
Kauj Ruam 7. Nyem OK
Cov xov tooj uas tau xaiv tam sim no yuav tso tawm hnub nyob hauv hom ntawv xaiv.
Txoj Kev 2 ntawm 4: Ntxig Hnub Tam Sim No
Kauj Ruam 1. Nyem rau ntawm tes uas koj xav kom hnub no tshwm sim
Qhov no tuaj yeem yog hauv tus qauv uas twb muaj lawm, lossis hauv lub cell tshiab.
Kauj Ruam 2. Ntaus qhov kos npe sib npaug = ua raws cov qauv TODAY ()
Yog tias koj xav khaws lub sijhawm tam sim no ib yam nkaus, siv TAM SIM NO () hloov TODAY ().
Kauj Ruam 3. Ntaus ↵ Enter
Excel yuav rov qab hnub no raws li tus nqi ntawm tes. Nov yog hnub hloov pauv, lub ntsiab lus nws yuav hloov pauv raws li thaum koj tab tom saib daim ntawv.
Siv cov shortcuts Ctrl +; thiab Ctrl + Ua haujlwm +; hloov los teeb tsa tus nqi ntawm tes rau hnub no hnub thiab sijhawm raws li tus nqi zoo li qub. Cov txiaj ntsig no yuav tsis hloov kho, thiab ua raws li lub sijhawm
Txoj Kev 3 ntawm 4: Siv DATE Function
Kauj Ruam 1. Nyem rau ntawm tes uas koj xav ntaus hnub
Kauj Ruam 2. Ntaus qhov kos npe sib npaug = ua raws daim ntawv qhia hnub tim DATE (xyoo, hli, hnub)
Xyoo, hli, thiab hnub yuav tsum yog cov lej nkag.
Kauj Ruam 3. Ntaus ↵ Enter
Excel yuav xa rov qab lub hnub tim hom ntawv, uas feem ntau yog hli/dd/xyoo los yog dd/hli/xyoo nyob ntawm koj thaj tsam.
Kauj Ruam 4. Nthuav tawm ntawm cov mis yog xav tau
Koj tuaj yeem tsim cov qauv rau xyoo, hli, thiab hnub qhov tseem ceeb. Lossis, koj tuaj yeem siv DATE ua haujlwm hauv lwm cov qauv.
Piv txwv li, DATE (2010, MONTH (TODAY ()), HNUB (TODAY ())) teev cov xov tooj ntawm tus nqi raws li hnub no lub hli thiab hnub no hauv 2010. Cov qauv DATE (2020, 1, 1) -10 teeb tus nqi rau 10 hnub ua ntej 1/1/2020
Txoj Kev 4 ntawm 4: Sau Hnub Tim Siv Sau Ua Ntej
Kauj Ruam 1. Ntaus hnub uas xav tau rau hauv lub cell
Nyem ob npaug ntawm lub xovtooj uas koj xav ntaus hnub, thiab tom qab ntawd nkag mus rau hnub uas siv hom ntawv pom hnub twg. Koj tuaj yeem sau hnub tim hauv ntau yam sib txawv.
Siv Lub Ib Hlis 3 los ua piv txwv, qee qhov kev lees paub yog "Jan 03," "January 3", "1/3," thiab "01-3."
Kauj ruam 2. Ntaus ↵ Enter
Excel yuav rov kho lub xovtooj ntawm tes thiab kho cov ntawv kom raug yog tias nws tau lees paub tias nws yog hnub tim.
Kauj Ruam 3. Xaiv txhua lub cell uas koj xav sau nrog cov hnub
Suav nrog lub xovtooj uas koj nyuam qhuav nkag rau hnub tim. Txhawm rau xaiv, luag koj tus nas hla txhua lub cell, xaiv tag nrho kab lossis kab, lossis tuav Ctrl (PC) lossis ⌘ Cmd (Mac) thaum nyem rau txhua lub cell.
Kauj Ruam 4. Nyem Sau rau ntawm Lub Tsev tab
Nws nyob rau sab saum toj ntawm Excel hauv ntu "Kho" thiab zoo li lub npov dawb nrog xiav xub xub.
Kauj Ruam 5. Nyem Series…
Nws nyob ze rau hauv qab.
Kauj Ruam 6. Xaiv "Hnub tim tsev
Excel yuav siv qhov no los sau cov cell dawb paug raws qhov teeb tsa no.
Piv txwv li, yog tias koj xaiv "Hnub Ua Haujlwm," txhua lub cell tsis muaj dab tsi yuav nyob nrog cov hnub ua haujlwm tom qab hnub pib nkag
Kauj Ruam 7. Nyem OK
Xyuas kom tseeb tias cov hnub tau sau kom raug.