Hloov Pleev Xim thiab Qhia Cov Feem Xyuam Cov Ntaub Ntawv

Nquag, ib daim ntawv qhia kab lossis daim phiaj bar qhia txog tus nqi lossis tus naj npawb ntawm cov sij hawm tus nqi tshwm sim rau lub sijhawm teev tseg. Lub siab dua rau sab, ntau dua cov sij hawm tus nqi tshwm sim.

Tsis tas li ntawd, daim ntawv qhia feem ntau qhia txog ntau cov ntaub ntawv nrog txhua kem hauv koob ua cov xim tib.

Siv cov formatting nta muaj nyob rau hauv Excel, nws yog ib qho ua tau kom muaj ib daim ntawv qhia qhia ntawv ntxiv rau daim ntawv sau ua paj thiab khoom noj

• txawv coloured rau txhua kis ntawm ib cov ntaub ntawv tawm
• tus nqi ntawm feem pua ​​ntawm txhua kem sawv cev ntawm tus nqi tag nrho

Tom qab cov kauj ruam hauv txoj kev qhia no koj tuaj yeem tsim koj los ntawm kev tsim thiab kev xa tawm daim ntawv qhia kab ntawv qhia hauv daim duab saum toj no.

Nco Ntsoov:
* Yog tias koj tsuas xav hloov cov ntawv ntawm cov ntaub ntawv los qhia cov feem pua, cov ntaub ntawv tuaj yeem pom muaj nyob rau nplooj 3 hauv phau ntawv no
* Hloov cov xim xim muaj nyob hauv phab 4

01 ntawm 06

6 Cov kauj ruam mus rau Customizing Kem Daim ntawv hauv Excel

Ib qho lus qhia txog Excel lub ntsiab xim

Excel, zoo li tag nrho Microsoft Office cov kev pabcuam, siv cov ntsiab lus los tsim qhov zoo ntawm nws cov ntaub ntawv.

Lub ntsiab lus siv rau qhov kev nyeem no yog Hom Ntoo Hom .

Yog tias koj siv lwm lub ntsiab lus thaum ua raws li qhov kev qhia no, cov xim uas teev rau hauv cov kauj ruam kev qhia kuj yuav tsis muaj nyob rau hauv lub ntsiab lus uas koj siv. Yog hais tias tsis yog, cia li xaiv cov xim rau koj li kev hloov chaw thiab kev ua haujlwm.

02 ntawm 06

Pib ntawm Daim Ntawv Qhia Kem

Nkag Mus thiab Xaiv Cov Ntaub Ntawv Qhia Tawm

Nkag mus rau hauv cov ntawv qhia cov ntaub ntawv yeej yog thawj kauj ruam hauv kev tsim cov ntawv qhia - tsis muaj teeb meem dab tsi ntawm cov ntawv sau.

Cov kauj ruam thib ob yog qhov tseem ceeb ntawm cov ntaub ntawv siv los tsim cov ntawv qhia.

1. Sau cov ntaub ntawv uas tau muab teev rau hauv daim duab saum toj no rau hauv cov nplooj ntawv ua haujlwm tseeb
2. Thaum nkag, qhia ntau txog cov hlwb ntawm A3 rau B6

Tsim Tsa Sau Npe Sau

Cov kauj ruam nram qab no yuav tsim ib daim ntawv qhia kab ntawv yooj yim - ib daim ntawv dawb, tsis muaj qauv - uas qhia txog cov ntaub ntawv xaiv thiab cov kab xev .

Cov kauj ruam tom qab tsim cov qauv ntawv qhia tau yooj yim li cas los siv qee cov qauv siv ntau hom, uas, yog ua raws li, yuav hloov cov ntawv qhia yooj yim kom haum rau daim ntawv qhia sab nraud tau qhia hauv nplooj 1 hauv phau ntawv no.

1. Nias rau ntawm daim ntxig ntawm daim ntawv sau
2. Nyob rau hauv lub thawv ntawv ntawm txoj kab, nyem rau ntawm Daim Qhia Sab Nram Chart icon qhib qhov kev sau npe ntawm cov muaj qauv / daim ntawv qhia hom
3. Hover koj tus pointer nas hla ib hom ntawv coj los nyeem cov lus piav qhia ntawm daim phiaj
4. Nias ntawm Clustered Kem - thawj qhov xaiv nyob hauv 2-d Sab seem ntawm daim ntawv - xaiv nws
5. Daim ntawv qhia sau qhia yooj yim yog tsim thiab muab tso rau hauv daim ntawv ua haujlwm

Muab Daim Ntawv Chart Ntxiv

Kho kom raug lub npe Chart Title los txhaj rau nws ob zaug - tab sis tsis txhob muab ob npaug rau

1. Nias ib zaug rau ntawm lub npe hu ua nws xaiv - ib lub thawv yuav tsum tshwm nyob ib ncig ntawm cov lus ntawm Daim Ntawv Chart
2. Nyem ib zaug thib ob los muab cov Excel hloov kho hom , uas tso tus cursor hauv lub npov lub npe
3. Rho tawm cov qauv ntawv siv lub Delete / Backspace tuav ntawm cov keyboard
4. Sau lub npe ntawm daim ntawv qhia - Lub Xya Hli 2014 Cov Nqi Siv Nyiaj - rau hauv lub thawv npe

03 ntawm 06

Muab Cov Ntawv Sau Npe Ntxiv rau Feem Pua

Txhawm rau Tshooj Ib Feem ntawm Daim Ntawv Qhia

Muaj ntau ntau qhov sib txawv rau daim duab hauv Excel - xws li thaj tsam ntawm thaj chaw uas muaj cov kab sawv cev rau cov kab lus xaiv, cov kab rov tav thiab ntsug, daim ntawv qhia npe thiab cov ntawv sau, thiab cov kab sab tav toj.

Hauv cov kauj ruam nram qab no, yog tias koj cov qhabnias tsis zoo li cov teev nyob rau hauv kev nyeem, nws yuav yog qhov koj tsis muaj feem ntawm txoj cai xaiv thaum koj ntxiv qhov kev xaiv cov kev xaiv.

Qhov feem ntau ua yuam kev yog txhaj rau thaj tsam ntawm thaj tsam ntawm lub teeb duab thaum lub hom phiaj yog los xaiv tag nrho cov teeb.

Qhov yooj yim tshaj los xaiv tag nrho cov teeb yog nias rau sab laug sab laug los yog sab xis ntawm lub npe ntawv.

Yog hais tias muaj qhov yuam kev, nws tuaj yeem kho sai siv tus Excel lub undo feature kom tshem tawm qhov yuam kev. Tom qab ntawd, nyem rau ntawm sab xis ntawm daim qauv thiab sim dua.

Muab cov ntawv sau ntxiv

1. Nyem ib zaug ntawm cov ntawv qhia hauv cov ntawv - tag nrho plaub qho hauv cov ntawv qhia yuav tsum raug xaiv
2. Txoj cai nias ntawm cov Khoom Sau los qhib cov ntsiab lus teb cov ntsiab lus qhia hauv cov ntawv qhia
3. Nyob rau hauv cov ntawv qhia zaub mov, hover nas saum toj ntawm Add Data Labels xaiv qhib ob lub ntsiab lus teb ntsiab lus teb
4. Hauv daim ntawv qhia zaub mov thib ob, nias rau Ntxiv Cov Ntawv Sau Cov Ntaub Ntawv los ntxiv cov ntawv tawm ntawm cov kab ntawv hauv kab ntawv

Hloov Cov Ntawv Sau Qhia Cov Ntsiab Lus los Qhia Pes Tsawg

Cov ntawv xov xwm tam sim no tuaj yeem kho tau los qhia qhov feem pua ​​ntawm txhua kab hauv daim ntawv qhia sawv cev ntawm tag nrho cov nqi siv los ntawm kev siv tus xov tooj ntawm tes rau cov feem pua ​​teev hauv kab C ntawm cov lus qhia hauv cov formula .

Cov ntaub ntawv vim cov ntaub ntawv yuav raug kho los ntawm txhaj ob zaug ib qho, tab sis, dua, tsis txhob muab ob npaug rau.

1. Nyem ib zaug ntawm daim 25487 daim ntawv qhia saum toj kawg nkaus Kem hauv cov ntawv qhia - tag nrho plaub daim ntawv teev lus hauv daim ntawv yuav tsum raug xaiv
2. Nyem ib zaug ntxiv nyob rau hauv Daim Ntawv Qhia Cov Ntaub Ntawv - tsuas yog 25487 daim ntawv lo cim yuav tsum xaiv
3. Nyem ib zaug hauv qhov formula formula hauv qab no
4. Nkag mus rau qhov formula = C3 rau hauv qhov chaw formula thiab nias tus Enter nkag rau ntawm cov keyboard
5. Daim ntawv lo ntawm 25487 yuav tsum hloov mus nyeem 46%
6. Nyem ib zaug ntawm daim ntawv sau npe ntawm 13275 saum toj sau Daim Ntawv Qhia Kab Taws Teeb (Utilities ) hauv daim phiaj qhia - tsuas yog tias daim ntawv lo yuav tsum xaiv
7. Sau cov formula nram qab no = C4 mus rau hauv lub voj voos thiab nias tus Sau yuam
8. Cov ntawv sau qhia yuav tsum hloov mus nyeem 24%
9. Nyem ib zaug ntawm 8547 daim ntawv qhia saum toj kawg nkaus ntawm Daim Ntawv Qhia Tsheb thauj mus rau hauv daim phiaj qhia - tsuas yog tias daim ntawv sau qhia yuav tsum raug xaiv
10. Sau cov formula nram qab no = C5 mus rau hauv lub voj voos thiab nias tus Sau yuam
11. Cov ntawv sau qhia yuav tsum hloov mus nyeem 16%
12. Nyem ib zaug ntawm 7526 daim ntawv qhia saum toj sau cov khoom siv rau hauv daim phiaj qhia - tsuas yog tias cov ntawv sau cim yuav tsum raug xaiv
13. Sau cov formula nram qab no = C6 rau hauv lub voj voos thiab nias tus Sau yuam
14. Cov ntawv sau qhia yuav tsum hloov mus nyeem 14%

Muab cov Gridlines thiab cov Axis ntsug cov ntawv

1. Hauv daim phiaj, nyem ib zaug ntawm 20,000 gridline khiav hauv nruab nrab ntawm lub teeb duab - tag nrho cov phiaj xwm sab nraud yuav tsum muaj kev vam meej (cov voj voog xiav ntawm qhov kawg ntawm txhua daim phiaj)
2. Nias qhov rho tawm yawm ntawm cov keyboard kom rho tawm cov gridlines
3. Nyem ib zaug ntawm daim ntawv Axis Y - cov lej ntawm sab laug ntawm daim ntawv qhia - xaiv lawv
4. Nias qhov rho tawm yawm ntawm cov keyboard kom rho tawm cov ntawv lo

Nyob rau ntawm qhov no, yog tias tag nrho cov kauj ruam saum toj no tau ua raws, koj daim ntawv qhia kab ntawv yuav tsum zoo li daim phiaj hauv daim duab saum toj no.

04 ntawm 06

Hloov Lub Daim Ntawv Qhia Cheeb Tsib Xim thiab Ntxiv Lus Dab Neeg

Cov Ntawv Sib Ceeb Cov Tabs

Raws li muaj nyob rau hauv daim duab saum toj no, thaum ib daim ntawv teev lus hauv Excel, los yog thaum twg ib daim ntawv xaiv tsa tau xaiv los ntawm txhaj rau nws, ob qho ntxiv tabs ntxiv rau daim ntawv sau .

Cov Chart Tools tab - tsim thiab hom ntawv - muaj cov kev xaiv thiab kev xaiv teeb tsa tshwj xeeb rau cov kab kos, thiab lawv yuav raug siv nyob rau hauv cov kauj ruam nram qab no los ua kom tiav daim qauv qhia kab ntawv.

Hloov Cov Ntawv Nrho Cov Ntawv Xim

Ntxiv nrog rau kev hloov cov xim ntawm txhua kem hauv daim duab, ib gradient ntxiv rau txhua kem ua formatting txhua kem ua ob txoj haujlwm.

1. Nyem ib zaug ntawm cov ntawv qhia hauv cov ntawv - tag nrho plaub qho hauv cov ntawv qhia yuav tsum raug xaiv
2. Tshum ib zaug dua zaum thib ob ntawm Cov Khoom Siv hauv cov ntawv - tsuas yog Kem ntawm cov ntaub ntawv yuav tsum xaiv
3. Nias rau ntawm Hom ntawv ntawm daim qauv
4. Nias rau ntawm Daim Phiaj Dab Piav txog qhov qhib Phiaj Xim cov ntawv qhia
5. Nyob hauv Cheeb Tsam Xim ntawm cov ntawv qhia xaiv xiav
6. Nias rau ntawm Daim Phiaj Xaiv qhov thib ob kom rov qhib cov zaub mov
7. Hover tus pointer nas hla Gradient xaiv nyob ze rau hauv qab ntawm lub tshuab raj qhib lub Gradient zaub mov
8. Nyob rau hauv Koog Variations ntawm Gradient ntawv qhia zaub mov, nyem rau ntawm thawj qhov kev xaiv ( Tawm Diagonal - Sab Saum Sab Qab Rau Qab Txoj Cai ) los ntxiv qhov gradient rau Cov Khoom Siv
9. Nyem ib zaug ntawm daim ntawv Utilities hauv daim phiaj qhia - tsuas yog Tsav Tsheb yuav tsum xaiv
10. Nias rau ntawm Daim Phiaj Dab Xaiv thiab tom qab ntawd thiab xaiv Xim liab los ntawm Tus Txheem Tshooj ntawm cov ntawv qhia zaub mov
11. Rov ua li cov kauj ruam 6 mus rau 8 sab saud los ntxiv qhov gradient mus rau txoj cai Utilities
12. Nyem ib zaug ntawm txoj kab npauj Thauj thiab rov ua dua cov kauj ruam 10 thiab 11 saum toj no los hloov cov Columns thauj mus rau ntsuab thiab ntxiv qhov gradient
13. Nyem ib zaug ntawm cov khoom seem thiab rov ua dua cov kauj ruam 10 thiab 11 saum toj no los hloov cov khoom Tshaj Tawm rau Purple thiab ntxiv qhov gradient
14. Cov xim plaub ntawm txhua kab ntawv hauv daim duab yuav tsum tam sim no kom phim cov duab hauv daim duab nyob rau nplooj 1 ntawm kev nyeem

Muab cov lus dab neeg ntxiv thiab xa cov X Cov Xeem Ntawv

Tam sim no hais tias txhua kem yog xim txawv, tus lus dab neeg yuav raug ntxiv rau hauv qab lub npe daim ntawv thiab X axis cov ntawv sau rau hauv qab daim phiaj qhia tawm

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho cov ntawv qhia
2. Nias ntawm qhov Tsim tsim ntawm txoj xov
3. Nias rau ntawm Daim Ntawv Qhia Ntxiv Chart nyob ntawm sab laug tes sab ntawm cov ntawv sau los qhib cov ntawv sau cia
4. Xaiv lus dab neeg> Saum toj ntawm daim ntawv ntxiv rau cov lus dab neeg saum toj no
5. Nyem ib zaug ntawm daim ntawv x-axis - cov npe hauv qab daim ntawv qhia - xaiv lawv
6. Nias qhov rho tawm yawm ntawm cov keyboard kom rho tawm cov ntawv lo

05 ntawm 06

Txhawm rau Cov Ntawv Sau Tseg thiab Tsav Daim Ntawv Cheeb Tswb

Formatting Task Pane

Ob peb kauj ruam tom qab ntawm kev nyeem ntawv siv qhov kev ua hauj lwm pane formatting , uas muaj feem ntau ntawm cov kev xaiv formatting rau cov kab kos.

Nyob hauv Excel 2013, thaum qhib txais, cov pane tshwm nyob rau ntawm sab tes xis ntawm daim Excel raws li muaj nyob hauv daim duab saum toj no. Cov nqe lus thiab cov hau kev xaiv hauv pane hloov nyob ntawm cheeb tsam ntawm daim ntawv teev lus xaiv tau.

Tsiv Cov Ntawv Sau Tseg

Cov kauj ruam no yuav hloov cov ntawv ntawm sab saum toj ntawm txhua kem.

1. Nyem ib zaug ntawm 64% daim ntawv qhia saum toj kawg nkaus Kem hauv cov ntawv qhia - tag nrho plaub daim ntawv lo nyob hauv daim ntawv yuav tsum raug xaiv
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog
3. Nias ntawm Hom Kev Xaiv Npe ntawm sab laug ntawm txoj kab ntawv qhib lub Formatting Task pane ntawm sab xis ntawm lub vijtsam
4. Yog tias tsim nyog, nias ntawm qhov kev xaiv icon hauv pane qhib cov ntawv xaiv lus qhia raws li muaj nyob hauv daim duab saum toj no
5. Nias ntawm Xaiv qhov kawg ntawm kev xaiv nyob rau hauv daim ntawv qhia qhov chaw ntawm pane kom tshem tag nrho plaub daim ntawv ceeb toom rau sab hauv ntawm lawv daim duab txhua

Ncav Tsav Daim Ntawv Cheeb Tsam

Tsav cov ntawv qhia kab ke yuav cia peb nce cov ntawv me me ntawm cov ntaub ntawv, ua kom yooj yim nyeem ntawv.

Nrog rau Formatting Task Pane qhib,

1. Nyem ib zaug ntawm Cov Khoom Siv hauv cov ntawv qhia - tag nrho plaub qho hauv cov ntawv qhia yuav tsum raug xaiv
2. Yog tias tsim nyog, nyem rau ntawm qhov kev xaiv icon hauv pane qhib cov kev xaiv ua ke
3. Teem Chaw Rau Gap mus rau 40% los nce qhov dav ntawm tag nrho plaub qho hauv daim duab

Ntxiv ib tug duab ntxoov ntxoo rau txhua kem

Cov kauj ruam yuav ntxiv tus duab ntxoov ntxoo qab txhua kab ntawm daim duab.

Nrog rau Formatting Task Pane qhib,

1. Nyem ib zaug ntawm Cov Khoom Siv hauv cov ntawv qhia - tag nrho plaub qho hauv cov ntawv qhia yuav tsum raug xaiv
2. Nyem ib zaug ntawm cov teebmeem hauv cov txheej txheem kev xaiv kom pom cov kev xaiv series
3. Nyem ib zaug ntawm tus duab ntxoov ntxoo taw qhib lub duab ntxoov ntxoo
4. Qhib lub vaj huam sib luag preset ntxoov ntxoo los txhaj rau Presets icon
5. Hauv seem ntawm Perspectives , nyem rau ntawm Kab Ntsig Ntawm Txoj Kev Cai Ntawm Txoj Cai
6. Tus duab ntxoov ntxoo yuav tsum tshwm sim tom qab txhua daim ntawv qhia kab

06 ntawm 06

Ntxiv ib Background Xim Gradient thiab Formatting cov ntawv nyeem

Ntxiv ib Background Gradient Gradient

Cov kauj ruam no yuav ntxiv xim gradient mus rau tom qab siv cov kev xaiv hauv Daim Qauv Ua Pag Ua Piav raws li muaj nyob hauv daim duab saum toj no.

Yog tias tsis muaj peb lub gradient nres tam sim no thaum lub pane qhib, siv qhov ntxiv / tshem tawm qhov chaw nres tsheb sab nraud ntawm qhov chaw nres tsheb nrawm rau teev kom muaj tus lej mus rau peb.

Nrog rau Formatting Task Pane qhib,

1. Nias ntawm tus keeb kwm yav dhau los xaiv tag nrho cov teeb
2. Nias ntawm qhov sau & Kab icon (xim muaj peev xim) hauv pane
3. Nias ntawm qhov sau npe mus qhib cov kev xaiv
4. Nyem ntawm Gradient xaiv nyob rau hauv cov npe kom qhib qhov gradient seem hauv qab hauv kab
5. Hauv seem gradient, xyuas kom paub tseeb tias Hom Kev xaiv raug teem rau lub Teem Pov Thawj
6. Teem cov kev taw qhia kev xaiv los tawm Tsav los tsim ib tav toj zuag tom qab gradient li pom hauv daim duab ntawm nplooj 1
7. Nyob rau hauv Gradient nres bar, nyem rau ntawm sab laug-feem ntau gradient nres
8. Xyuas kom meej tias nws Txoj hauj lwm tus nqi yog 0%, thiab teem nws cov xim xim rau White Background 1 siv qhov xim xaiv hauv qab lub gradient nres
9. Ndliv qhov nrawm sab nrawm
10. Xyuas kom meej tias nws Txoj hauj lwm tus nqi yog 50%, thiab teem nws cov xim rau Tan Tus Background 2 Tsaus dua 10% hloov cov gradient nres xim mus rau lub teeb tan
11. Nias ntawm txoj cai nrawm nrawm
12. Xyuas kom meej tias nws Txoj hauj lwm tus nqi yog 100%, thiab muab nws tso rau xim tom qab dawb 1

Hloov Cov Qauv Hom, Me Nyuam, thiab Xim

Hloov qhov loj thiab hom ntawv siv nyob rau hauv daim phiaj qhia, yuav tsis tsuas yog kev txhim kho cov qauv siv nyob rau hauv daim ntawv qhia, tab sis nws tseem yuav ua kom yooj yim nyeem cov npe thiab cov ntaub ntawv tseem ceeb hauv daim phiaj.

Lus Cim : Qhov luaj li cas ntawm cov font yog ntsuas nyob rau hauv cov ntsiab lus - feem ntau luv rau pt .
72 pt ntawv yog sib npaug li ib nti (2.5 cm) hauv qhov loj.

1. Nyem ib zaug hauv daim ntawv qhia lub npe xaiv nws
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nyob rau hauv seem ntawm cov ntawv sau ntawm txoj kab, nyem rau ntawm Lub Thawv Sau ntawv kom qhib lub npe ntawm cov ntawv sau muaj
4. Tshaj mus nrhiav thiab nias rau ntawm font Bondini MT Black nyob rau hauv daim ntawv sau hloov lub npe rau daim ntawv no
5. Nyob rau hauv lub thawv ntawv loj ntawm lub npov ntawm lub thawv ntawv, muab lub npe ntawv loj rau 18 pt
6. Nyem ib zaug ntawm cov lus dab neeg xaiv nws
7. Siv cov kauj ruam saum toj no, teev cov lus dab neeg rau 10 pt Bondini MT Black
8. Nyem ib zaug ntawm 64% cov ntawv qhia hauv cov ntawv qhia hauv cov ntawv qhia - tag nrho plaub daim ntawv teev lus hauv cov ntawv qhia yuav tsum raug xaiv
9. Teem cov ntawv sau rau 10.5 pt Bondini MT Black
10. Nrog cov ntawv sau tseem xaiv, nias ntawm Font xim icon lub Ribbon (tsab ntawv A) qhib lub Xim Ntawv Xim ntawm Xim
11. Ndliv qhov Background 1 xim xim nyob rau hauv lub vaj huam sib luag los hloov daim ntawv qhia cov xim ntawv xim dawb

Nyob rau ntawm qhov no, yog tias koj tau ua raws li tag nrho cov kauj ruam hauv phau ntawv no, koj daim ntawv yuav tsum piv rau tus qauv nyob hauv phab 1.