Cov txheej txheem:

Kuv yuav tsim ib daim ntawv qhia hnub hauv Excel 2010 li cas?
Kuv yuav tsim ib daim ntawv qhia hnub hauv Excel 2010 li cas?

Video: Kuv yuav tsim ib daim ntawv qhia hnub hauv Excel 2010 li cas?

Video: Kuv yuav tsim ib daim ntawv qhia hnub hauv Excel 2010 li cas?
Video: Tu Tu Siab Rau Ib Tug Nkauj Hmoob Los Tsuas Official Music Video Lis Koob Xyooj 2021 2024, Kaum ib hlis
Anonim

Nov yog yuav ua li cas siv tus qauv tsim ua ntej muaj nyob hauv Excel:

  1. Nyem Cov Ntaub Ntawv> Tshiab.
  2. Hom Daim ntawv qhia hnub hauv kev tshawb nrhiav.
  3. Koj yuav pom ntau yam kev xaiv, tab sis rau qhov piv txwv no, nyem qhov Ib xyoos ib hlis daim ntawv qhia hnub thiab nias Tsim .

Yog li ntawd, kuv yuav ua li cas los tsim ib daim ntawv teev npe poob hauv Excel?

Txhawm rau tsim qhov kev tswj xyuas qhov tseeb, ua cov hauv qab no:

  1. Xaiv C4.
  2. Nyem qhov Data tab.
  3. Hauv Pawg Cov Cuab Yeej Cov Ntaub Ntawv, nyem Cov Ntaub Ntawv Validation.
  4. Nyob rau hauv lub resulting dialog, xaiv Hnub los ntawm Allowdropdown.
  5. Nyem rau hauv Start Hnub tswj thiab nkag mus =C1.
  6. Hauv Kev Tswj Hnub Kawg, nkag mus =C2 (Daim duab C).
  7. Nyem OK.

Tsis tas li ntawd, kuv yuav tsim Google daim ntawv qhia hnub hauv Excel li cas? Nyem rau ntawm " Tsim " khawm nyob rau sab laug ntawm lub vijtsam thiab tom qab ntawd nyem "Los ntawm template" los ntawm cov npe ntawm cov kev xaiv uas tshwm sim. Ib lub tab tshiab yuav qhib rau hauv koj tus browser. Muab koj tus cursor rau hauv lub thawv tshawb rau saum toj ntawm lub vijtsam thiab nkag mus rau "editorial calender. "Tom qab ntawd nyem rau ntawm "Search Templates" khawm.

Ib yam li ib tug yuav nug, Kuv yuav tsim daim ntawv qhia hnub xyoo hauv Excel li cas?

Tua tawm Excel thiab nyem rau ntawm "Cov ntaub ntawv" tab. Nyem qhov "Tshiab" kev xaiv thiab xaiv qhov " Daim ntawv qhia hnub ” khawm nyob rau hauv nruab nrab ntawm qhov muaj Templates screen. Muab ob npaug rau-nias cov ntaub ntawv nplaub tshev nrog rau xyoo rau koj xav tau daim ntawv qhia hnub . Cov xyoo ntawm koj software yuav txiav txim siab xyoo ntawm daim ntawv qhia hnub muaj.

Koj puas tuaj yeem tso daim ntawv qhia hnub hauv Excel?

Nov yog yuav ua li cas siv lub pre-made template muaj nyob rau hauv Excel : Nyem File> New. Hom Daim ntawv qhia hnub hauv cov ntawv no. Koj 'yuav pom ntau yam kev xaiv, tab sis rau qhov piv txwv no, nyem qhov Ib xyoos ib hlis daim ntawv qhia hnub thiab nyemCreate.

Pom zoo: