Yuav Ua Li Cas Ua Daim Duab Hauv Excel

Yuav Ua Li Cas Ua Daim Duab Hauv Excel
Yuav Ua Li Cas Ua Daim Duab Hauv Excel

Video: Yuav Ua Li Cas Ua Daim Duab Hauv Excel

Video: Yuav Ua Li Cas Ua Daim Duab Hauv Excel
Video: Qhia ua daim duab los npog qhov clip video li ib cov phooj ywg tau noog tuaj 23 Aug 2017 2024, Tej zaum
Anonim

Microsoft Excel tso cai rau koj los ua cov kab kos duab ntshiab. Ntxiv mus, nyob ntawm seb cov hom ntaub ntawv, ntau hom duab kos tau muab, uas ua rau nws muaj peev xwm nthuav tawm yuav luag txhua cov ntaub ntawv xov xwm kom meej meej li sai tau.

Tsim cov kab kos hauv Microsoft Excel
Tsim cov kab kos hauv Microsoft Excel

Txhawm rau tsim cov duab kos hauv Microsoft Excel, koj yuav tsum tsim cov ntaub ntawv cov lus hauv cov ntawv.

Duab
Duab

Ua piv txwv, cia peb siv txoj hauv kev ntawm plaub pawg, hauv kab ntawv tom ntej no peb tso lub txiaj ntsig ntawm cov pawg no. Cov naj npawb hauv kab ntawv thib ob ua qhov txiaj ntsig rau daim phiaj tom ntej.

Txhawm rau kos daim duab, koj yuav tsum mus rau "Ntxiv" tab thiab xaiv ib qho ntawm ntau pab pawg ntawm cov duab kos.

  • Cov kab kos yog ib hom kab kos uas tso cai rau koj los qhia qhov sib piv ntawm tib hom ntaub ntawv (piv txwv li, piv ntawm qhov ntim ntawm kev muag khoom ntawm kev sib txawv ntawm cov tuam txhab, sib piv cov ntsuas ntawm cov lag luam sib tw, thiab lwm yam). Cov kab kos hauv bar tuaj yeem siv rau cov hom phiaj zoo sib xws.
  • Daim duab - tso cai rau koj los qhia qhov kev hloov pauv ntawm cov txheej txheem dhau sijhawm (kev loj hlob hauv kev muag khoom hauv kev sib piv nrog lub sijhawm dhau los, kev cia siab rau kev siv cov kev pab cuam, thiab lwm yam).
  • Daim duab cov ncuav qab zib - ib hom kab kos uas tso cai rau koj los sawv cev ntawm cov feem ntawm tag nrho (kev nthuav qhia ntawm cov ntaub ntawv ntawm lub tuam txhab cov txiaj ntsig nrog kev sib txawv los ntawm kev taw qhia, thiab lwm yam)
  • Daim duab khib nyiab - tso cai rau koj los nthuav qhia cov kev ntsuas ntawm ib qho dav hlau.

Ua raws li lub ntsiab ntawm lub ntsiab, koj yuav tsum xaiv hom qauv duab. Tom ntej, cov qeb thiab qhov tseem ceeb yog qhia nrog nas. Tom qab ntawd, hauv "Ntxig" tab, pawg neeg yuav tsum tau xaiv, thiab tom qab ntawd - daim duab nws tus kheej.

Duab
Duab

Txhawm rau ua daim duab ntau dua qhov muag pom, koj tuaj yeem hloov xim ntawm txhua lub bar. Ua li no, muab ob npaug rau sab hauv kem nrog tus nas laug dua, yog li cais cov xaiv ntawm kem los ntawm lwm tus, thiab tom qab ntawd hu rau cov ntawv qhia zaub mov nrog khawm sab xis. Txhawm rau hloov cov txiaj ntsig ntawm cov kwv, siv cov "Cov ntaub ntawv taw tes hom". Hauv lub thawv ntawv uas zoo nkaus li, hauv qhov sau "Tab", Xaiv "Sau" "Sau" rau "Solid" xim rau "xim". Tsis tas li, yog tias tsim nyog, cov kab tuaj yeem pleev xim nrog cov gradient, uas yog, los ntawm kev ncab ntau xim, lossis sau nrog cov ntaub ntawv zoo nkauj.

Ntxiv rau, Cov Ntaub Ntawv Cov Ntaub Ntawv hom tso cai rau koj hloov cov hom thiab xim ntawm cov stroke, teeb cov teebmeem xws li keeb kwm yav dhau los thiab ntim ntawm cov khoom.

Pom zoo: