Yuav ua li cas teem sijhawm hauv Excel

Cov txheej txheem:

Yuav ua li cas teem sijhawm hauv Excel
Yuav ua li cas teem sijhawm hauv Excel
Anonim

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.

Image
Image

Ua raws li cov kauj ruam no los tsim lub sijhawm xya hnub nrog kev thaiv ib teev rau ib tus neeg siv.

  1. Pib Excel thiab qhib phau ntawv ua haujlwm tshiab.

    Image
    Image
  2. Xaiv lub xovtooj ntawm A1:E2, tom qab ntawd xaiv Merge & Center hauv pawg Alignment ntawm lub Tsev tab.

    Image
    Image
  3. Type " WEEKLY SCHEDULE" rau hauv A1:E2, hloov qhov loj ntawm font rau 18, thiab xaiv Middle Align hauv pawg Alignment.

    Image
    Image
  4. Xaiv hlwb F1:H2, xaiv lub Borders poob rau hauv pawg Font ntawm lub Tsev tab, tom qab ntawd xaivTxhua tus ciam teb.

    Image
    Image
  5. 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.

    Image
    Image
  6. Xaiv tes A3 thiab sau " TIME."

    Image
    Image
  7. 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."

    Image
    Image
  8. 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.

    Image
    Image

    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.

  9. 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."

    Image
    Image
  10. Txawj tus ua tus tuav mus rau sab xis kom tau txais cov hnub seem ntawm lub lim tiam ntawm lub sijhawm.

    Image
    Image
  11. Xaiv Raw 3. Ua tus font Bold thiab hloov font loj rau 14.

    Image
    Image
  12. Hloov qhov loj me ntawm lub sijhawm hauv Kab A rau 12.

    Image
    Image

    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.

  13. Xaiv tus Xaiv Txhua lub cim lossis nias Ctrl + A thiab xaiv Center hauv kev sib tw pab pawg ntawm Tsev tab.

    Image
    Image
  14. 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.

    Image
    Image
  15. 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)
    Image
    Image

    Hla cov kauj ruam no yog tias koj nyiam lub sijhawm teem caij dub thiab dawb.

  16. Xaiv lub cev ntawm lub sijhawm. Xaiv qhov Ciam Teb poob rau hauv pawg Font thiab xaiv Txhua Ciam Teb.

    Image
    Image
  17. 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.

  1. Xaiv File > Export > Hloov hom ntaub ntawv.

    Image
    Image
  2. Xaiv Template > Save As. Lub thawv Txuag Raws li lub thawv yuav qhib.

    Image
    Image
  3. Qhib Kev Cai Chaw Ua Haujlwmfolder.

    Image
    Image
  4. Sau lub npe rau tus qauv thiab xaiv Save.

    Image
    Image
  5. 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.

    Image
    Image

    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

Pom zoo: