Formatting koj Excel spreadsheets muab lawv ib tug ntau polished saib, thiab kuj ua rau nws yooj yim dua los nyeem thiab txhais cov ntaub ntawv, thiab yog li zoo dua haum rau cov rooj sib tham thiab kev nthuav qhia. Excel muaj cov ntawv sau ua ntej-txhim kho cov qauv los ntxiv xim rau koj daim ntawv ua haujlwm uas tuaj yeem coj mus rau qib tom ntej.
Cov lus qhia no siv rau Excel rau Microsoft 365 thiab Excel 2019, 2016, 2013, thiab 2010.
Dab tsi yog Cell Style?
A cell style hauv Excel yog kev sib xyaw ua ke ntawm cov kev xaiv xaiv, suav nrog qhov loj me thiab xim, tus lej hom, ciam teb ntawm tes, thiab ntxoov ntxoo uas koj tuaj yeem sau npe thiab khaws cia ua ib feem ntawm daim ntawv ua haujlwm.
Apply a Cell Style
Excel muaj ntau cov qauv hauv tes uas koj tuaj yeem thov raws li yog rau daim ntawv ua haujlwm lossis hloov kho raws li qhov xav tau. Cov qauv tsim hauv no kuj tseem tuaj yeem ua lub hauv paus rau cov qauv ntawm tes uas koj tuaj yeem txuag thiab sib qhia ntawm phau ntawv ua haujlwm.
-
Xaiv lub ntau ntawm cov hlwb koj xav format.
Image -
Ntawm Home tab ntawm ribbon, xaiv lub Cell Styles khawm hauv Styles ntu, txhawm rau qhib lub vev xaib ntawm cov qauv muaj.
Image -
Xaiv lub xovtooj uas xav tau los siv nws.
Image
Customize Cell Styles
Ib qhov zoo ntawm kev siv cov qauv yog tias koj hloov kho cov qauv ntawm tes tom qab siv nws hauv daim ntawv ua haujlwm, txhua lub hlwb siv cov qauv ntawd hloov kho kom pom cov kev hloov pauv.
Ntxiv mus, koj tuaj yeem suav nrog Excel lub xauv lub hlwb ua haujlwm rau hauv cov qauv ntawm tes los tiv thaiv kev hloov pauv tsis raug cai rau cov hlwb tshwj xeeb, daim ntawv ua haujlwm, lossis phau ntawv ua haujlwm.
Koj tuaj yeem hloov kho cov qauv ntawm tes los ntawm kos lossis siv tus qauv tsim los ua qhov pib.
- Xaiv ib daim ntawv xovtooj.
- Siv tag nrho cov kev xaiv formatting xav tau rau lub xovtooj no.
-
Ntawm Home tab ntawm ribbon, xaiv lub Cell Styles khawm hauv Styles ntu, txhawm rau qhib lub vev xaib ntawm cov qauv muaj.
Image -
Xaiv New cell styles nyob rau hauv qab ntawm lub gallery.
Image -
Hloov lub npe rau cov qauv tshiab hauv Style lub thawv.
Image -
Xaiv lub Format khawm hauv Style dialog box kom qhib lub Format Cells dialog box.
Image -
Xaiv ib tab hauv lub dialog box kom pom cov kev xaiv muaj.
Image - Thov txhua qhov kev hloov pauv uas xav tau.
- Xaiv OK rov qab mus rau Style dialog box.
- Hauv qab lub npe yog cov npe ntawm cov kev xaiv hom uas koj xaiv. Tshem cov checkboxes rau tej yam tsis xav formatting.
-
Xaiv OK txhawm rau kaw lub thawv thiab rov qab mus rau daim ntawv ua haujlwm.
Tus tshiab style lub npe tam sim no yuav tshwm nyob rau sab saum toj ntawm Cell Styles Gallery nyob rau hauv Custom nqe lus. Txhawm rau siv koj cov style rau cov hlwb hauv daim ntawv ua haujlwm, ua raws cov kauj ruam saum toj no rau kev siv tus qauv tsim.
Kho kom raug cell formatting, tso lub Cell Styles Gallery thiab right-click ntawm cell stylethiab xaiv Modify > Format . Txoj cai-nias ntawv qhia zaub mov tseem suav nrog Duplicate kev xaiv.
Copy a Cell Style to another Workbook
Thaum koj tsim ib qho kev cai ntawm tes hauv phau ntawv ua haujlwm, nws tsis muaj nyob hauv Excel. Koj tuaj yeem luam cov qauv kev cai yooj yim rau lwm phau ntawv ua haujlwm, txawm li cas los xij.
- Qhib thawj phau ntawv ua haujlwm muaj cov qauv kev cai uas koj xav luam tawm.
-
Qhib phau ntawv ua haujlwm thib ob.
-
Nyob hauv phau ntawv ua haujlwm thib ob, xaiv Cell Styles ntawm ribbon los qhib lub Cell Styles gallery.
Image -
Xaiv Merge Styles nyob rau hauv qab ntawm lub gallery qhib lub Merge Styles dialog box.
Image -
Xaiv npe ntawm thawj phau ntawv ua haujlwm thiab xaiv OK txhawm rau kaw lub dialog.
Image
Ib qho alert box yuav pop tuaj nug seb koj puas xav muab cov qauv nrog tib lub npe. Tshwj tsis yog tias koj muaj cov qauv kev cai nrog tib lub npe tab sis txawv hom kev xaiv hauv ob phau ntawv ua haujlwm, nyem lub pob Yeskom ua tiav qhov hloov mus rau hauv phau ntawv ua haujlwm.
Tshem tawm Cell Style Formatting
Thaum kawg, koj tuaj yeem tshem tawm txhua hom ntawv koj siv rau lub xov tooj yam tsis tas yuav rho tawm cov ntaub ntawv lossis cov qauv ntawm tes uas tau khaws tseg. Koj tseem tuaj yeem rho tawm tus qauv ntawm tes yog tias koj tsis xav siv nws lawm.
- Xaiv lub hlwb uas siv lub xov tooj ntawm tes uas koj xav tshem tawm.
-
Ntawm Home tab ntawm ribbon, xaiv lub Cell Styles khawm hauv Styles ntu, txhawm rau qhib cov duab uas muaj.
Image -
Nyob hauv Zoo, bad, thiab Neutral ntu ze rau sab saum toj ntawm gallery, xaiv Nomtxhawm rau tshem tawm tag nrho cov kev siv formatting.
Image
Cov kauj ruam saum toj no kuj tseem siv tau los tshem tawm cov hom ntawv uas tau siv manually rau cov ntawv ua haujlwm.
Delete a Style
Koj tuaj yeem tshem tawm cov qauv tsim thiab kev cai ntawm tes los ntawm Cell Styles gallery tshwj tsis yog rau Ib txwm, uas yog lub neej ntawd. Thaum koj rho tawm ib qho style, txhua lub xov tooj ntawm tes uas tau siv nws yuav plam tag nrho cov kev sib txuam formatting.
-
Ntawm Home tab ntawm ribbon, xaiv lub Cell Styles khawm hauv Styles ntu, txhawm rau qhib cov duab uas muaj.
Image -
Right-click ntawm tus qauv ntawm tes los qhib cov ntawv qhia zaub mov thiab xaiv Delete. Cov qauv ntawm tes tau raug tshem tawm tam sim ntawd los ntawm lub tsev.
Image
