Koj puas tau txais cov ntaub ntawv nrog hnub tim ua hom ntawv tsis raug? Tej zaum koj yog tus uas tau ua yuam kev, lossis koj tsuas tau txiav txim siab mus rau lwm txoj kev. Txawm yog vim li cas los xij, koj tuaj yeem hloov pauv sai sai hauv hom ntawv hauv Microsoft Excel. Koj tuaj yeem xaiv hloov daim ntawv hnub tim rau cov ntaub ntawv tshwj xeeb hauv daim ntawv Excel, lossis koj tuaj yeem hloov cov txheej txheem hnub tim rau koj lub khoos phis tawj tag nrho txhawm rau siv hom ntawv ntawd rau txhua nplooj ntawv Excel yav tom ntej.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Hloov Tus Qauv Hnub Tim
Kauj Ruam 1. Mus rau lub sijhawm thiab hnub tim teeb tsa
Txhawm rau txhawm rau hloov tus txheej txheem hnub tim rau txhua daim ntawv Excel tshiab, koj yuav tsum tau hloov pauv hnub tim ua ntej rau koj lub khoos phis tawj. Ua ntej tshaj, nyem lub pob Pib. Cov kauj ruam tom ntej yuav vam khom lub operating system twg koj siv:
- Yog tias koj siv Windows Vista lossis Windows 8: Qhib Cov Tswj Vaj Huam Sib Luag. Tom qab ntawd, nyem "Clock, Language, and Region." Hloov pauv, hauv Windows 8, qhib Cov Ntawv Teev Npe thiab xaiv "Sijhawm & Lus".
- Yog tias koj siv Windows XP: Qhib Cov Tswj Vaj Huam Sib Luag. Tom qab ntawd, nyem "Hnub, Sijhawm, Lus, thiab Kev Xaiv Hauv Cheeb Tsam."
Kauj Ruam 2. Nkag mus rau Cov Kev Xaiv Hauv Cheeb Tsam
Ib zaug ntxiv, cov kev taug kev sib txawv sib txawv los ntawm kev ua haujlwm mus rau kev ua haujlwm.
- Yog tias koj siv Windows 8: Hauv Moos, Lus, thiab Cheeb Tsam nplaub tshev, xaiv "Hloov hnub, sijhawm, lossis tus lej" los ntawm hauv qab "Cheeb Tsam" nqe lus.
- Yog tias koj siv Windows Vista: Qhib Lub Hauv Paus thiab Cov Lus Xaiv Cov lus sib tham. Tom qab ntawd, xaiv Cov Qauv tab.
- Yog tias koj siv Windows XP: Qhib Lub Hauv Paus thiab Cov Lus Xaiv Cov lus sib tham. Tom qab ntawd, xaiv Cov Kev Xaiv Hauv Cheeb Tsam tab.
Kauj Ruam 3. Npaj los kho cov hom ntawv
Yog tias koj siv Windows 8: Nco ntsoov tias Lub Formats tab qhib. Yog tias koj siv Windows Vista: Nyem Customize hom ntawv no. Yog tias koj siv Windows XP: Nyem Customize.
Kauj Ruam 4. Xaiv hnub tim
Koj yuav muaj kev xaiv rau hnub luv thiab hnub ntev. Hnub luv hais txog cov ntawv luv: piv txwv. 6/12/2015. Hnub ntev hais txog daim ntawv lo lus piv txwv: xws li Lub Kaum Ob Hlis 31, 1999. Cov qauv uas koj xaiv ntawm no yuav raug coj los siv thoob plaws txhua qhov kev siv Windows, suav nrog Excel. Nyem "OK" los siv koj cov kev xaiv.
-
Txheeb xyuas cov hnub xaiv luv. Lub Rau Hli 2, 2015 raug siv ua piv txwv.
- M/d/xyoo: 6/2/2015
- M/d/yy: 6/2/15
- MM/dd/yy: 06/02/15
- MM/dd/xyoo: 2015-02-06
- yy/MM/dd: 15/06/02
- yyyy-MM-dd: 2015-06-02
- dd-MMM-yy: 02-Jun-15
-
Txheeb xyuas cov hnub xaiv ntev. Lub Rau Hli 2, 2015 raug siv ua piv txwv.
- dddd, MMMM dd, xyoo: Hnub Friday, Lub Rau Hli 02, 2015
- dddd, MMMM d, xyoo: Hnub Friday, Lub Rau Hli 2, 2015
- MMMM d, xyoo: Lub Rau Hli 2, 2015
- dddd, d MMMM, xyoo: Hnub Friday, 2 Lub Rau Hli, 2015
- d MMMM, xyoo: 2 Lub Rau Hli, 2015
Txoj Kev 2 ntawm 2: Hloov Cov Qauv Hnub Tim rau Cov Txheej Txheem Tshwj Xeeb
Kauj Ruam 1. Qhib daim ntawv nthuav tawm thiab nthuav qhia txhua qhov hnub tim cuam tshuam
Yog tias koj tsuas xav hloov daim ntawv hnub tim rau ib lub xovtooj: tsuas yog nyem rau ntawm lub xovtooj ntawd.
- Yog tias cov hnub tau koom ua ke hauv kab ntawv: xaiv thiab teeb tsa tag nrho kab ntawv los ntawm sab laug-nyem rau ntawm tsab ntawv nyob rau sab saum toj ntawm kab ntawv. Tom qab ntawd, txoj cai-nias kom coj los ua cov ntawv qhia zaub mov.
- Yog tias cov hnub tau teeb tsa ua kab: hais txog ntu lossis xov tooj ntawm tes uas koj xav hloov. Tom qab ntawd, sab laug-nyem rau tus lej ntawm sab laug-sab laug ntawm kab kom xaiv txhua lub cell.
Kauj Ruam 2. Xaiv qhov nco-down "Format" ntawv qhia zaub mov los ntawm cov toolbar
Nrhiav cov ntawv qhia zaub mov nco hauv "Cells" compartment (ntawm "Styles" thiab "Editing") thaum koj nyob hauv "Tsev" tab.
Hloov pauv: txoj cai-nias ntawm tus lej ntawm sab laug-kab ntawm kab lossis tsab ntawv nyob rau sab saum toj ntawm kab ntawv muab Qhov no yuav xaiv txhua lub cell hauv kab lossis kab ntawv ntawd, thiab nws yuav nthuav tawm cov ntawv qhia zaub mov. Xaiv "Format Cells" los ntawm cov ntawv qhia zaub mov kom teeb hnub rau txhua lub cell hauv kab ntawv ntawd
Kauj Ruam 3. Xaiv "Format Cells" los ntawm cov ntawv qhia zaub mov nco-down
Nrhiav qhov kev xaiv no hauv qab ntawm cov ntawv qhia zaub mov.
Kauj Ruam 4. Nkag mus rau "Tus lej" tab
Pom qhov no ntawm lub tab nyob rau sab saum toj-sab laug ntawm lub "Format Cells" qhov rai, tom ntej ntawm "Alignment," "Font," "Border," "Fill," and "Protection." "Tus lej" feem ntau yog lub neej ntawd.
Kauj Ruam 5. Xaiv "Hnub" los ntawm kab "Pawg" ntawm sab laug ntawm qhov screen
Qhov no yuav tso cai rau koj los hloov kho tus kheej cov txheej txheem hnub tim.
Kauj Ruam 6. Xaiv hom ntawv hnub koj xav tau
Qhia qhov kev xaiv ntawd, thiab nyem "OK" txhawm rau txuag cov hom ntawv. Tom qab ntawd, khaws cov ntawv kom ntseeg tau tias koj cov ntawv tau khaws tseg
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Nws yog qhov kev xyaum zoo tshaj plaws los thov tsuas yog ib hom ntawv hnub tim rau tag nrho kab lossis kab.
- Nco ntsoov tias hom ntawv hnub tsuas yog qhov tseem ceeb kom yooj yim ntawm kev siv. Excel yuav tuaj yeem txheeb los ntawm qhov qub mus rau qhov tshiab tshaj plaws (lossis tshiab tshaj plaws rau qhov qub tshaj plaws) tsis hais hnub twg.
- Txoj hlua tsis muaj qhov kawg ntawm cov cim phaus (####) qhia tias ib tus neeg tau sim nkag hnub tim ua ntej 1900.
-
Yog tias koj tsis tuaj yeem ua qhov no los ua haujlwm, hnub tim yuav raug khaws tseg ua cov ntawv. Qee tus neeg tau nkag mus lossis theej nws, tab sis nws tsis tau lees paub lossis lees txais raws li hnub tim los ntawm Excel. Excel tawv ncauj tsis kam siv lwm hom ntawv hnub tim rau cov ntawv zoo li "niam hnub yug", lossis "12.02.2009". Thaum thawj qhov piv txwv yog qhov pom tseeb, qhov thib ob tuaj yeem cuam tshuam ntau tus neeg sab nrauv ntawm Asmeskas. Tshwj xeeb tshaj yog thaum lawv cov ntawv hauv zos ntawm Excel lees txais nws.
- Txhua qhov nkag uas pib nrog cov ntawv sau tseg yuav raug khaws cia ua cov ntawv, tsis muaj teeb meem ntau npaum li cas lawv sim saib zoo li hnub tim. Tus kab lus tsis tshwm nyob rau ntawm tes, tsuas yog hauv tus khoos phis tawj ntawm tes.
- Qhov teeb meem thim rov qab kuj muaj. Ib tus tuaj yeem nkag mus rau 12312009 thiab cia siab tias yuav nkag mus rau lub Kaum Ob Hlis Tim 31st ntawm 2009. Txawm li cas los xij, coob leej yuav sau ncaj qha mus rau qhov chaw nyob rau hnub tim, thiab tus lej no tau txhais ua lub Tsib Hlis 5 ntawm 4670. Qhov no tej zaum yuav tsis meej pem thaum hnub ntawv hom ntawv tsis tsis qhia xyoo. Ib txwm siv cov hnub sib cais, xws li slash (/).
- Sim nthuav dav kab ntawv los ntsuas seb hnub tau txais lawm. Cov ntawv yog sab laug-sib dhos, thaum cov hnub tau ua raws txoj cai los ntawm lub neej ntawd.
- Qhov no yuav raug hloov pauv. Yog li, ib tus kuj tseem tuaj yeem sim thov tsis muaj hom ntawv hnub tim. Txhua hnub lees paub tau muab khaws cia ua tus lej, nrog tus nqi kwv yees li 40, 000 xyoo 2009. Sim ua hom ntawv los ua tus lej. Thaum qhov no ua tsis tau, nws yog ntawv nyeem. Thaum koj ua tiav, siv hom ntawv hnub zoo dua. Qhov ntsuas lawv tus kheej yuav tsis hloov pauv los ntawm qhov kev xeem no.
- Paub tias ntaus ntawv hom ntawv yog teem hnub tim rau cov txheej txheem muab. Thaum koj tau teeb tsa hom ntawv rau kab lus lossis kab lus, txhua hnub tshiab uas koj ntxiv yuav raug txais kev cawmdim nyob rau hauv hom ntawv hnub uas koj xaiv - tsis hais koj yuav ntaus lawv li cas.
