Yuav Paub
- Add AutoFormat to Quick Access toolbar: Xaiv Quick Access Toolbar > Ntau Commands > Xaiv cov lus txib los ntawm> Txhua yam lus txib.
- Scroll los ntawm cov npe thiab xaiv AutoFormat > Add > OK. Txhawm rau siv AutoFormat style rau ib lub rooj, taw qhia cov ntaub ntawv.
- Tom ntej, xaiv AutoFormat los ntawm Quick Access Toolbar, xaiv tus qauv, thiab nyem OK. Xaiv qhov AutoFormat style cov kev xaiv los hloov nws.
Kab lus no piav qhia yuav ua li cas siv Excel's AutoFormat kev xaiv los tsim cov kws tshaj lij, huv daim ntawv ua haujlwm thaum txhim kho koj daim ntawv nthuav qhia Microsoft Excel nyeem tau thiab txuag sijhawm. Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, thiab 2010, nrog rau Excel rau Microsoft 365.
Ntxiv AutoFormat rau Quick Access Toolbar
Txhawm rau siv AutoFormat, ntxiv AutoFormat icon rau Quick Access Toolbar kom nws nkag tau thaum koj xav tau. Tom qab koj ntxiv AutoFormat, nws tseem nyob ntawm Quick Access Toolbar.
Muaj 17 AutoFormat styles muaj nyob hauv Excel. Cov qauv no cuam tshuam rau tus lej formatting, ciam teb, fonts, qauv thiab xim tom qab, sib dhos, thiab kab thiab kab loj.
-
Xaiv tus Quick Access Toolbar poob xub.
Image -
Xaiv Ntau Cov Lus txib txhawm rau qhib Kho lub cuab yeej ceev nrawm dialog box.
Image -
Xaiv tus Xaiv cov lus txib los ntawm tus xub poob.
Image -
Xaiv Txhua Cov Lus txib txhawm rau tso tawm tag nrho cov lus txib muaj nyob hauv Excel.
Image -
Scroll los ntawm cov npe tsiaj ntawv thiab xaiv AutoFormat.
Image -
Xaiv Ntxiv.
Image - Xaiv OK ntxiv rau AutoFormat icon rau Quick Access Toolbar.
Thov ib qho AutoFormat Style
Txhawm rau nrawm nrawm rau AutoFormat style rau lub rooj:
-
Highlight cov ntaub ntawv hauv daim ntawv ua haujlwm uas koj xav format.
Image - Mus rau Quick Access Toolbar thiab xaiv AutoFormat.
-
In the AutoFormat dialog box, xaiv tus style.
Image - Xaiv OK txhawm rau kaw lub dialog.
-
Tus qauv tshiab yog siv rau lub rooj.
Image - Yog xav siv tus qauv sib txawv, xaiv ib lub xovtooj ntawm lub rooj thiab xaiv AutoFormat.
Hloov kho qhov AutoFormat Style Ua ntej thov nws
Yog tias koj tsis nyiam ib qho ntawm cov qauv uas muaj, hloov kho tus qauv ua ntej koj siv rau daim ntawv ua haujlwm.
-
In the AutoFormat dialog box, xaiv Options.
Image -
In the Formats to apply, clear the check boxes for the formats you don't want to use in the table.
Image - Cov piv txwv hauv lub dialog box hloov tshiab los cuam tshuam cov kev hloov pauv.
- Xaiv OK txhawm rau siv tus qauv hloov kho.
Hloov kho qhov AutoFormat Style Tom Qab Thov Nws
Tom qab koj siv cov style rau ib lub rooj, hloov lub rooj style nrog cov kev xaiv formatting nyob rau ntawm Home tab ntawm kab. Tom qab ntawd, txuag qhov hloov kho AutoFormat style raws li kev cai style uas tuaj yeem siv nrog lwm cov rooj thiab cov ntawv ua haujlwm.
To tsim kev cai AutoFormat styles rau cov ntxhuav:
- Xaiv ib lub xovtooj ntawm lub rooj.
-
mus rau Home tab, xaiv Format as Table, tom qab ntawd xaiv Tshaj Tawm Tshiab.
Image -
Nyob hauv Tshiab Table Style dialog box, xaiv ib lub rooj thiab xaiv Format siv tus font, ciam teb, los yog sau formatting koj nyiam. Ua qhov no rau txhua lub ntsiab lus koj xav hloov.
Image - Xaiv lub Teem raws li lub rooj style rau daim ntawv no kos lub thawv yog tias koj xav tau siv cov qauv no thaum formatting cov ntxhuav, ces xaiv OKtxhawm rau txuag AutoFormat style.
- Yuav siv cov kev cai style, tsom ib lub rooj, mus rau Home , xaiv Format as Table, thiab xaiv tus qauv kev cai.
