Cov txheej txheem:

Yuav ua li cas kuv ntxig ib hnub xaiv daim ntawv qhia hnub poob hauv Excel?
Yuav ua li cas kuv ntxig ib hnub xaiv daim ntawv qhia hnub poob hauv Excel?

Video: Yuav ua li cas kuv ntxig ib hnub xaiv daim ntawv qhia hnub poob hauv Excel?

Video: Yuav ua li cas kuv ntxig ib hnub xaiv daim ntawv qhia hnub poob hauv Excel?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Hlis ntuj nqeg
Anonim

Yuav ua li cas ntxig lossis hloov hnub hauv ib lub xovtooj siv Popup Calendar

  1. Xaiv ib lub xovtooj.
  2. Hauv Hnub tim / Lub sijhawm pab pawg, nyem qhov ' Ntxig Hnub ' khawm> The hnub xaiv yuav poob nqis ib sab ntawm lub cell.
  3. Xaiv a hnub koj xav tau los ntawm daim ntawv qhia hnub > Ua tau.

Yog li, kuv yuav ua li cas thiaj tsim tau ib tus neeg xaiv hnub hauv Excel?

Tom qab ntawd, nyem rau ntawm "Developer" tab nyob rau hauv cov ntawv qhia zaub mov ribbon. Hauv "Controls," nyem "Insert" thiab tom qab ntawd nyem "Ntau Tswj" hauv "ActiveX Controls." Xaiv "Microsoft Hnub tim thiab Sijhawm Xaiv Tswj 6.0 (SP6)" hauv cov ntawv qhia zaub mov thiab nyem "OK." Tom qab ntawd, nyem lub xov tooj uas koj xav ntxiv hnub xaiv.

Tsis tas li ntawd, Excel puas muaj daim ntawv qhia hnub? Ntau daim ntawv qhia hnub templates muaj rau siv hauv Microsoft Excel . A tus qauv muab ib qho yooj yim daim ntawv qhia hnub layout uas koj tuaj yeem hloov kho tau yooj yim rau koj cov kev xav tau. Ib Excel daim ntawv qhia hnub template muaj muaj ib lossis ntau dua ntawm cov yam ntxwv no: Kaum ob lub hlis hauv ib lossis cais cov ntawv ua haujlwm.

Hauv qhov no, yuav ua li cas kuv ntxig ib tus neeg xaiv hnub hauv Excel 365?

Muab qhov tam sim no hnub hauv a hnub xaiv Nyem qhov Data tab. Hauv Ntxig Formula dialog box, nyem Ntxig Muaj nuj nqi. Hauv cov npe Categories hauv cov Ntxig Muaj nuj nqi dialog box, nyem Hnub tim thiab Sijhawm. Hauv daim ntawv teev cov haujlwm, nyem hnub no, thiab tom qab ntawd nyem OK ob zaug rov qab mus rau Hnub Xaiv Properties dialog box.

Kuv yuav ntxiv ib daim ntawv qhia hnub li cas?

Teem ib daim ntawv qhia hnub tshiab

  1. Hauv koj lub computer, qhib Google Calendar.
  2. Nyob rau sab laug, saum toj "Kuv daim ntawv qhia hnub," nyem Ntxiv lwm daim ntawv qhia hnub tshiab.
  3. Ntxiv ib lub npe thiab cov lus piav qhia rau koj daim ntawv qhia hnub.
  4. Nyem Tsim daim ntawv qhia hnub.
  5. Yog tias koj xav qhia koj daim ntawv qhia hnub, nyem rau ntawm nws nyob rau sab laug bar, ces xaiv Qhia rau cov neeg tshwj xeeb.

Pom zoo: