Yuav Paub
- Easyest: Download tau tus qauv ua ntej los ntawm Microsoft Excel.
- Create template: Xaiv A1:E2 > Merge & Center > hom WEEKLY SCHEDULE > xaiv Middle Align.
- Ntxiv ciam teb thiab nqe lus. Hauv A3, ntaus TIME. Hauv A4 thiab A5, nkag mus rau lub sijhawm > sau cov hlwb > ntxiv hnub > txuag template.
Kab lus no piav qhia yuav ua li cas los tsim lub sijhawm hauv Microsoft Excel, los ntawm kev siv tus qauv ua ntej lossis tsim ib qho los ntawm kos. Cov lus qhia siv rau Excel 2019, Excel 2016, Excel rau Microsoft 365, thiab Excel 2013.
Yuav ua li cas los tsim ib lub sijhawm hauv Excel
Microsoft Excel muab cov qauv rau lub sijhawm ua haujlwm txhua lub limtiam, cov sijhawm kawm ntawv, sijhawm ua haujlwm txhua hnub, thiab ntau ntxiv. Koj tuaj yeem rub tawm qhov koj xav tau thiab kho nws nrog koj tus kheej cov ntaub ntawv, lossis koj tuaj yeem kawm paub tsim lub sijhawm los ntawm kos.
Ua raws li cov kauj ruam no los tsim lub sijhawm xya hnub nrog kev thaiv ib teev rau ib tus neeg siv.
-
Pib Excel thiab qhib phau ntawv ua haujlwm tshiab.
-
Xaiv lub xovtooj ntawm A1:E2, tom qab ntawd xaiv Merge & Center hauv pawg Alignment ntawm lub Tsev tab.
-
Type " WEEKLY SCHEDULE" rau hauv A1:E2, hloov qhov loj ntawm font rau 18, thiab xaiv Middle Align hauv pawg Alignment.
-
Xaiv hlwb F1:H2, xaiv lub Borders poob rau hauv pawg Font ntawm lub Tsev tab, tom qab ntawd xaivTxhua tus ciam teb.
-
Enter " Lub Sijhawm Pib Txhua Hnub" rau hauv F1; " Lub Sijhawm Sijhawm " rau hauv G1; thiab " Starting Date" rau hauv H1. Xaiv lub Xaiv Tag Nrho icon (nruab nrab ntawm 1 thiab A ntawm daim ntawv ua haujlwm), tom qab ntawd nyem ob npaug rau kab sib cais ob kab los hloov pauv txhua lub hlwb kom haum rau cov ntsiab lus.
-
Xaiv tes A3 thiab sau " TIME."
-
Xaiv tes A4 thiab nkag mus rau lub sijhawm koj xav kom koj lub sijhawm pib. Ua raws li qhov piv txwv no, sau " 7:00."
-
Hauv cell A5, nkag mus rau lub sijhawm tom ntej uas koj xav sau rau hauv lub sijhawm. Ua raws li qhov piv txwv no, nkag mus rau " 7:30." Xaiv A4:A5 thiab luag tus lej sau cia kom sau lub sijhawm nce ntxiv rau hnub so.
Yog tias koj xav hloov lub sijhawm, xaiv kab ntawv, nyem nyem, tom qab ntawd xaiv Format Cells. Xaiv Time nyob rau hauv qeb npe ntawm tus lej tab thiab xaiv lub sijhawm hom ntawv koj xav siv.
-
Hauv cell B3, nkag rau hnub ntawm lub lim tiam uas koj xav kom koj lub sijhawm pib. Ua raws li qhov piv txwv no, nkag mus rau " SUNDAY."
-
Txawj tus ua tus tuav mus rau sab xis kom tau txais cov hnub seem ntawm lub lim tiam ntawm lub sijhawm.
-
Xaiv Raw 3. Ua tus font Bold thiab hloov font loj rau 14.
-
Hloov qhov loj me ntawm lub sijhawm hauv Kab A rau 12.
Yog tias tsim nyog, xaiv lub Xaiv Tag Nrho icon (nruab nrab ntawm 1 thiab A ntawm daim ntawv ua haujlwm) thiab nyem ob npaug rau kab sib cais ob kab los hloov kho txhua lub hlwb kom haum rau cov ntsiab lus ib zaug ntxiv.
-
Xaiv tus Xaiv Txhua lub cim lossis nias Ctrl + A thiab xaiv Center hauv kev sib tw pab pawg ntawm Tsev tab.
-
Select cells A1:H2. Xaiv lub Fill Color poob los ntawm pawg Font ntawm lub Tsev tab thiab xaiv cov xim sau rau cov hlwb xaiv.
-
Xaiv cov xim sau tshwj xeeb rau txhua lub hlwb hauv qab no lossis ntau yam:
- A3
- B3:H3
- A4:A28 (los yog ntau lub hlwb uas muaj sijhawm ntawm koj daim ntawv ua haujlwm)
- B4:H28 (los yog ntau lub hlwb ua cov seem ntawm koj lub sijhawm)
Hla cov kauj ruam no yog tias koj nyiam lub sijhawm teem caij dub thiab dawb.
-
Xaiv lub cev ntawm lub sijhawm. Xaiv qhov Ciam Teb poob rau hauv pawg Font thiab xaiv Txhua Ciam Teb.
- Txuag lub sijhawm.
Txuag Lub Sijhawm Ua Haujlwm Ua Haujlwm
Txuag lub sijhawm ua tus qauv tso cai rau koj rov siv nws yam tsis tau ua ib qho tshiab txhua zaus lossis tshem tawm cov ntsiab lus ntawm koj lub sijhawm uas twb muaj lawm.
-
Xaiv File > Export > Hloov hom ntaub ntawv.
-
Xaiv Template > Save As. Lub thawv Txuag Raws li lub thawv yuav qhib.
-
Qhib Kev Cai Chaw Ua Haujlwmfolder.
-
Sau lub npe rau tus qauv thiab xaiv Save.
-
Txhawm rau siv tus qauv yav tom ntej, xaiv qhov Tus kheejtab ntawm lub vijtsam Tshiab thiab xaiv lub sijhawm teem sijhawm. Nws yuav qhib ua phau ntawv ua haujlwm tshiab.
Yog tias koj xav siv cov ntawv luam theej ntawm lub sijhawm, teeb tsa thaj chaw luam ua ntej luam tawm.
FAQ
Kuv yuav xa tawm lub sijhawm Revit li cas rau hauv Excel?
In Revit, xaiv File > Export > Reports > Teem caij, tom qab ntawd xaiv qhov chaw txuag thiab xaiv Txuag Xaiv cov kev xaiv export thiab yuav cov ntaub ntawv xa tawm li cas, tom qab ntawd xaiv OK Hauv Excel, xaiv Data > Tau & Hloov Cov Ntaub Ntawv > From Text/CSV Ces xaiv lub sijhawm xa tawm Revit thiab xaiv Import
Kuv tuaj yeem ua lub sijhawm them nyiaj hauv Excel li cas?
Ua ntej, tsim ib daim ntawv nthuav dav tshiab lossis qhib ib qho uas twb muaj lawm thiab nkag mus rau qhov tsim nyog qiv, paj, thiab cov ntaub ntawv them nyiaj. Hauv cell B4 (xav tias lwm cov ntaub ntawv tseem ceeb yog nyob rau hauv kab B saum toj no), siv qhov sib npaug =ROUND(PMT($B$2/12, $B$3, -$B$1, 0), 2) Qhov no yuav suav koj cov nyiaj them txhua hli.
Kuv yuav hloov hnub hom li cas hauv kuv lub sijhawm Excel?
Right-click the cell you want to change and select Format Cells. Los ntawm qhov ntawd, xaiv lub Number tab, xaiv Date hauv qeb, xaiv hom hnub uas koj xav siv, tom qab ntawv lees paub nrog OK.
Kuv yuav xa tawm lub sijhawm Excel li cas ntawm ib nplooj ntawv?
Select Page Layout > Dialog Box Launcher > Page tab, ces xaivFit nyob rau hauv Scaling. Xaiv ib nplooj ntawv dav los ntawm ib nplooj siab, tom qab ntawd lees paub nrog OK . Tom qab ntawd, xa tawm lub sijhawm zoo li koj xav nrog lwm cov ntawv Excel.
Kuv yuav muab lub sijhawm Excel rau hauv kuv daim ntawv qhia hnub hli li cas?
Txawm li cas los xa tawm lossis txuag lub sijhawm Excel raws li CSV lossis ICS yog li nws yuav ua tau zoo nrog Google Calendar. Hauv daim ntawv qhia hnub, xaiv Settings > Ntshuam & Export > xaiv cov ntaub ntawv sib xws los import. Tom ntej no, xaiv daim ntawv qhia hnub twg los import cov ntaub ntawv mus rau, thiab paub meej los ntawm kev xaiv Import