Excel AutoFormat

Txhim kho kev nyeem ntawv thiab txuag lub sijhawm nrog AutoFormat

Ib txoj kev los piv rau txoj hauj lwm ntawm kev ua cov ntawv ua haujlwm hauv Excel yog siv qhov kev xaiv AutoFormat.

Formatting tsis ua li cas los ua cov ntawv ua haujlwm zoo. Xaiv tom qab xim, font style, font loj, thiab lwm yam kev xaiv formatting yuav ua rau cov ntaub ntawv yooj yim nyeem, thiab cov ntaub ntawv tseem ceeb tshaj nyob rau hauv daim ntawv khom nqi yooj yim pom, tag nrho thaum muab lub spreadsheet ib tug neeg zoo ..

Cov Ntawv Tseem Ceeb

Muaj 17 Autoriments yeej muaj nyob hauv Excel. Cov hom kev cuam tshuam no muaj feem xyuam rau 6 lub ntsiab lus:

• Teeb meem zauv
• Ciam teb
• Fonts
• Cov qauv thiab tom qab xim
• Alignment
• Kem thiab kab loj

Yuav ua li cas ntxiv AutoFormat mus rau Access Quick Toolbar

Txawm hais tias siv tau los ntawm cov ntawv xaiv zaub mov hauv versions dhau los, AutoFormat tsis tau muaj nyob rau ntawm ib lub tabs ntawm txoj cai txij thaum Excel 2007.

Siv AutoFormat, ntxiv rau AutoFormat icon mus rau Lub Ceev Ntaub Ntawv Teeb Tseg kom nws tuaj yeem nkag thaum tsim nyog.

Qhov no yog kev ua hauj lwm ib zaug. Tom qab nws ntxiv, lub icon tseem nyob ntawm Quick Access Toolbar.

1. Nias rau hauv qab xub nyob ntawm qhov kawg ntawm Quick Access Toolbar los qhib ib lub tshuab raj me me.
2. Xaiv dua lus txib los ntawm cov npe kom qhib qhov Customize Quick Access Toolbar dialog box .
3. Nias ntawm xub hauv qhov kawg ntawm qhov Xaiv cov lus xaiv los ntawm kab qhib ib lub tshuab raj.
4. Xaiv Tag nrho cov lus txib ntawm daim ntawv kom pom tag nrho cov lus txib muaj nyob hauv Excel nyob rau sab laug pane.
5. Tshem ntawm qhov kev sau npe ntawm tus tsiaj ntawv no kom thiaj li pom AutoFormat hais kom ua.
6. Nias rau ntawm Add khawm ntawm qhov hais kom ua qhov ceeb taw los ntxiv rau AutoFormat khawm rau ntawm Quick Access Toolbar.
7. Nyem OK los ua kom tiav qhov sib ntxiv.

Thov kev AutoFormat Style

Txhawm rau siv qhov AutoFormat style:

1. Ua kom pom cov ntaub ntawv hauv daim ntawv uas koj xav kom tau.
2. Nias rau ntawm AutoFormat khawm ntawm Quick Access Toolbar los nqa qhov feature's dialog box.
3. Nyem ntawm ib qho ntawm cov qauv muaj .
4. Nias OK los siv qhov style thiab kaw lub thawv ntawv.

Hloov qhov AutoFormat Style ua ntej thov

Yog hais tias tsis muaj leej twg muaj peev xwm ua rau koj nyiam, lawv tuaj yeem hloov kho ua ntej lossis tom qab lawv tau ua ntawv thov rau ib daim ntawv ua haujlwm.

Hloov qhov AutoFormat Style Ua ntej nws thov

1. Nias ntawm qhov xaiv khawm hauv qab ntawm qhov AutoFormat dialog box.
2. Deselect ib yam ntawm cov formatting 6 yam xws li font, ciam teb rau, los sis ua kom zoo dua tshem cov kev xaiv no tawm ntawm txhua tus qauv.
3. Cov piv txwv nyob rau hauv qhov kev sib tham qhib lub qhov rai kom pom cov kev hloov.
4. Nyem OK los thov qhov hloov style.

Hloov qhov AutoFormat Style Tom Qab Thov Nws

Thaum ua ntawv thov, ib daim qauv yuav muab hloov kho ntxiv uas siv cov Excel cov kev xaiv cov kev xaiv nyob rau hauv-feem ntau cov feem-nyob rau hauv Tsev Tsev ntawm kev sib tw.

Qhov kev hloov kho AutoFormat hloov tau ces tau txais kev cawmdim raws li kev cai nyiam, uas ua rau nws rov qab siv dua nrog cov ntawv khom nqi ntxiv.