Yuav Paub
- Tseem thov ib tsoom phooj ywg pab txhawb nqas > Home > Styles > Ntau > Style Gallery > xaiv lub cell style.
- Rau kev cai cell style, Home > Styles > Ntau> New Cell Style > Style name > Format > OK >Style > Style Includes (Los Piv Txwv) > OK.
- Rau cov xov tooj uas twb muaj lawm, Home > Styles> Ntau > Modify> Style name > Format > Format Cells > OK> Style > Style Includes > OK.
Kab lus no piav qhia yuav ua li cas tsim, luam, thiab hloov kho cov qauv ntawm tes hauv Excel. Cov lus qhia siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Excel 2007.
Yuav ua li cas thov ib qho hauv Cell Style
Nws yog ib qho tseem ceeb kom nkag siab txog yuav ua li cas siv cov qauv ntawm tes hauv Excel ua ntej koj kawm paub tsim thiab siv tus qauv kev cai lossis hloov kho ntawm tes.
- Xaiv ntau lub hlwb uas koj xav kom format.
-
Ntawm Home tab, nyob rau hauv Styles pawg, xaiv tus Ntau poob xub nyob rau hauv Style Gallery.
In Excel versions 2007-2013, xaiv Styles, ua raws li Ntau khawm ntawm ib sab ntawm lub xov tooj ntawm tes.
Image -
Xaiv lub xovtooj ntawm tes uas koj xav thov.
Cell styles yog raws li cov ntaub ntawv ntsiab lus uas tau siv rau tag nrho phau ntawv ua haujlwm. Cov ntsiab lus sib txawv muaj cov kev xaiv sib txawv, yog li yog tias cov ntaub ntawv hloov pauv, cov qauv ntawm tes rau cov ntaub ntawv kuj hloov.
Creating a Custom Cell Style
Ntawm no yog yuav ua li cas los tsim ib qho kev cai ntawm tes los ntawm kev xaiv qhov koj xav tau formatting xaiv:
-
Ntawm Home tab, hauv Styles pab pawg, xaiv Ntaunqes nqes hauv style gallery.
In Excel versions 2007-2013, ntawm Home tab, hauv pawg Styles, xaiv Cell Styles.
- Xaiv Tshiab Cell Style.
- Nyob hauv Style name lub npov, ntaus lub npe rau tus qauv cell tshiab.
- Xaiv Format.
- Ntawm cov tab sib txawv hauv Format Cells dialog box, xaiv cov formatting uas koj xav tau, thiab tom qab ntawd xaiv OK.
- Rov qab rau hauv Style dialog box, nyob rau hauv Style suav nrog (Los piv txwv), tshem cov checkboxes ntawm txhua hom ntawv koj tsis ua xav suav nrog hauv cell style.
- Xaiv OK. Koj txoj kev cai tshiab ntawm tes tau tsim.
Tsim lub Cell Style los ntawm Kev Hloov Kho Cov Qauv Cell uas twb muaj lawm
Yog tias koj xav tweak ob peb hom kev xaiv ntawm tus qauv cell uas twb muaj lawm los tsim koj tus kheej version ntawm nws, ntawm no yog li cas:
-
Ntawm Home tab, nyob rau hauv Styles pawg, xaiv tus Ntaupoob xub hauv style gallery.
In Excel versions 2007-2013, ntawm Home tab, hauv pawg Styles, xaiv Cell Styles.
- Right-click on a cell style to open the context menu, and then choose Modify.
-
Nyob hauv Style name lub npov, ntaus lub npe rau tus qauv cell tshiab.
Yog tias koj tsis ntaus lub npe tshiab, tus qauv tsim ntawm tes yuav raug hloov kho nrog txhua qhov kev hloov pauv uas koj ua.
- Xaiv Format.
- Ntawm ntau lub tab hauv Format Cells dialog box, xaiv cov formatting koj xav tau, thiab tom qab ntawd xaiv OK.
-
In the Style dialog box, nyob rau hauv Style Includes, xaiv lossis tshem lub checkboxes rau ib qho formatting koj tsis xav suav nrog hauv cell style.
- Xaiv OK. Hloov kho cell style yuav hloov kho kom muaj kev cuam tshuam cov kev hloov pauv.
Duplicating a Existing Cell Style
Tsim ib qhov sib npaug ntawm tus qauv tsim los yog tus qauv kev cai siv cov kauj ruam hauv qab no:
Nws yog qhov zoo tshaj plaws los hloov kho qhov sib npaug ntawm qhov tsim-hauv style es tsis yog tus qauv nws tus kheej.
-
Ntawm Home tab, nyob rau hauv Styles pawg, xaiv tus Ntaupoob xub hauv style gallery.
In Excel versions 2007-2013, ntawm Home tab, hauv pawg Styles, xaiv Cell Styles.
- Right-click on a cell style to open the context menu, and then xaiv Duplicate.
- In the Style dialog box, ntaus lub npe rau tus qauv tshiab.
-
Xaiv OK kom kaw lub dialog box thiab rov qab mus rau daim ntawv ua haujlwm. Cov qauv ntawm tes duplicated yuav raug hloov kho kom pom cov kev hloov pauv.
Tshem tawm Cell Style Formatting Los Ntawm Cov Ntawv Ua Haujlwm
Ntawm no yog yuav ua li cas tshem tawm cov qauv cell formatting los ntawm cov cell ntawm cov ntaub ntawv yam tsis tas yuav rho tawm cov qauv ntawm tes.
- Xaiv cov hlwb formatted nrog lub cell style koj xav tshem tawm.
- Ntawm Home tab, hauv Styles pab pawg, nyem qhov More poob xub hauv style gallery.
-
Nyob hauv Zoo, phem, thiab nruab nrab, xaiv qhov Normal kev xaiv kom tshem tawm tag nrho cov kev siv formatting.
Siv cov kauj ruam no los tshem tawm formatting uas tau siv manually rau cov ntawv ua haujlwm, ib yam nkaus.
Txhob Cia Ib Txoj Cai
Tshwj tsis yog tus qauv ib txwm, uas tsis tuaj yeem tshem tawm, nws tuaj yeem tshem tawm tag nrho lwm cov qauv tsim thiab kev cai ntawm tes.
-
Ntawm Home tab, hauv Styles pab pawg, xaiv Ntaunqes nqes hauv style gallery.
In Excel versions 2007-2013, ntawm Home tab, hauv pawg Styles, xaiv Cell Styles.
- Txoj cai-nias ntawm lub xovtooj ntawm tes los qhib cov ntawv qhia zaub mov.
-
Xaiv Delete. Cov qauv ntawm tes tau raug tshem tawm tam sim ntawd los ntawm lub tsev.
Txhawm rau tshem tawm cov qauv ntawm tes hauv Excel 2007-2013, ntawm Home tab, hauv pawg Styles, xaivCell Styles . Tom qab ntawd, nyob rau hauv Zoo, phem, thiab nruab nrab , xaiv Nom.
