txheem
Txhua lub hlwb muaj nws tus kheej hom uas tso cai rau koj ua cov ntaub ntawv hauv ib daim ntawv lossis lwm qhov. Nws yog ib qho tseem ceeb uas yuav tsum tau teeb tsa kom raug kom tag nrho cov kev suav tsim nyog tau ua tiav. Los ntawm tsab xov xwm koj yuav kawm yuav ua li cas hloov cov hom ntawm cov hlwb hauv Excel spreadsheet.
Lub ntsiab hom ntawm formatting thiab lawv hloov
Muaj kaum hom qauv hauv tag nrho:
- Ntau.
- Nyiaj txiag.
- Tus lej.
- Nyiaj txiag.
- Ntawv.
- Hnub Tim.
- Lub sijhawm.
- Me me.
- Feem pua.
- ntxiv
Qee hom ntawv muaj lawv tus kheej subspecies ntxiv. Muaj ob peb txoj hauv kev los hloov hom ntawv. Cia peb tsom xam txhua yam kom ntxaws ntxiv.
Siv cov ntawv qhia zaub mov los hloov kho ib hom ntawv yog ib txoj hauv kev siv ntau tshaj plaws. Kev taug kev:
- Koj yuav tsum xaiv cov cell uas nws hom koj xav hloov. Peb nyem rau ntawm lawv nrog txoj cai nas khawm. Cov ntawv qhia zaub mov tshwj xeeb tau qhib. Nyem rau ntawm lub ntsiab "Format Cells ...".
- Ib lub thawv hom ntawv yuav tshwm sim ntawm qhov screen. Peb txav mus rau ntu hu ua "Number". Them mloog mus rau qhov thaiv "Number formats". Nov yog tag nrho cov hom ntawv uas twb muaj lawm uas tau muab los saum toj no. Peb nyem rau ntawm hom ntawv uas sib haum rau hom ntaub ntawv uas tau muab rau hauv lub xov tooj ntawm tes lossis ntau lub xov tooj. Nyob rau sab xis ntawm lub hom ntawv thaiv yog qhov teeb tsa subview. Tom qab ua txhua qhov chaw, nyem "OK".
- Npaj txhij. Kho kom raug hom ntawv tau ua tiav.
Txoj Kev 2: Tus lej toolbox ntawm lub ribbon
Cov cuab yeej ribbon muaj cov ntsiab lus tshwj xeeb uas tso cai rau koj hloov cov qauv ntawm cov hlwb. Kev siv txoj kev no yog nrawm dua li yav dhau los. Kev taug kev:
- Peb ua qhov kev hloov pauv mus rau ntu "Tsev". Tom ntej no, xaiv qhov xav tau ntawm tes lossis ntau lub cell thiab qhib lub thawv xaiv hauv "Number" thaiv.
- Cov kev xaiv tseem ceeb tau tshwm sim. Xaiv qhov koj xav tau hauv thaj chaw xaiv. Cov formatting tau hloov lawm.
- Nws yuav tsum to taub tias daim ntawv teev npe no tsuas muaj cov hom ntawv tseem ceeb xwb. Txhawm rau nthuav tawm tag nrho cov npe, koj yuav tsum nyem "Lwm tus lej hom".
- Tom qab txhaj rau lub caij no, lub qhov rais paub yuav tshwm sim nrog tag nrho cov kev xaiv formatting (pib thiab ntxiv).
Txoj Kev 3: "Cells" toolbox
Cov kev hloov kho tom ntej yog ua los ntawm "Cells" thaiv. Kev taug kev:
- Peb xaiv lub xovtooj ntawm tes lossis ntau lub cell uas peb xav hloov. Peb txav mus rau ntu "Tsev", nyem rau ntawm daim ntawv "Format". Cov khoom no yog nyob rau hauv "Cells" thaiv. Hauv daim ntawv teev npe, nyem rau ntawm "Format Cells ...".
- Tom qab qhov kev txiav txim no, lub qhov rais formatting ib txwm tshwm sim. Peb ua txhua yam tsim nyog ua, xaiv hom ntawv xav tau thiab nyem "OK".
Txoj Kev 4: hotkeys
Cov ntawv xovtooj tuaj yeem kho tau siv cov ntawv tshwj xeeb hotkeys. Ua ntej koj yuav tsum xaiv lub hlwb xav tau, thiab tom qab ntawd nias qhov tseem ceeb ua ke Ctrl + 1. Tom qab cov kev hloov pauv, cov kev paub hloov pauv qhov rai yuav qhib. Raws li nyob rau hauv cov txheej txheem dhau los, xaiv hom ntawv xav tau thiab nyem "OK". Tsis tas li ntawd, muaj lwm cov keyboard shortcuts uas tso cai rau koj los hloov kho lub cell hom yam tsis tau tso tawm lub thawv hom:
- Ctrl + Ua haujlwm + - - general.
- Ctrl + Ua haujlwm + 1 - tus lej nrog tus lej cim.
- Ctrl + Ua haujlwm + 2 - sijhawm.
- Ctrl + Ua haujlwm + 3 - hnub.
- Ctrl + Ua haujlwm + 4 - nyiaj.
- Ctrl + Ua haujlwm + 5 - feem pua.
- Ctrl + Ua haujlwm + 6 - O.OOE + 00 hom ntawv.
Hnub tim hom ntawv nrog lub sij hawm hauv Excel thiab 2 cov tshuab ua haujlwm
Daim ntawv hnub tuaj yeem hloov kho ntxiv siv cov cuab yeej sib txuas. Piv txwv li, peb muaj cov ntsiav tshuaj no nrog cov ntaub ntawv. Peb yuav tsum xyuas kom meej tias cov cim qhia hauv kab raug coj mus rau hauv daim ntawv teev npe hauv kab npe.
Nyob rau hauv thawj kem, hom ntawv yog pib teem kom raug. Cia peb saib ntawm kab thib ob. Xaiv tag nrho cov hlwb ntawm cov cim ntawm kab thib ob, nias qhov tseem ceeb ua ke CTRL + 1, hauv ntu "Number", xaiv lub sijhawm, thiab hauv "Hom" tab, xaiv cov qauv kev coj ua raws li daim duab hauv qab no:
Peb ua cov haujlwm zoo sib xws nrog cov kab thib peb thiab plaub. Peb teeb tsa cov hom ntawv thiab tso saib hom uas sib haum rau cov npe kab lus tshaj tawm. Muaj 2 hnub tso saib tshuab hauv daim ntawv nthuav qhia:
- Tus naj npawb 1 yog Lub Ib Hlis 1, 1900.
- Tus lej 0 yog Lub Ib Hlis 1, 1904, thiab tus lej 1 yog 02.01.1904/XNUMX/XNUMX.
Hloov cov zaub ntawm cov hnub yog ua raws li hauv qab no:
- Cia peb mus rau "Cov ntaub ntawv".
- Nyem "Options" thiab txav mus rau "Advanced" seem.
- Hauv "Thaum rov xam phau ntawv no" thaiv, xaiv "Siv 1904 hnub system" kev xaiv.
Alignment Tab
Siv lub "Alignment" tab, koj tuaj yeem teeb tsa qhov chaw ntawm tus nqi hauv lub xov tooj ntawm tes los ntawm ntau qhov tsis muaj:
- mus rau;
- kab rov tav;
- ntsug;
- txheeb ze rau qhov chaw;
- thiab thiaj li nyob.
Los ntawm lub neej ntawd, tus lej ntaus hauv lub xovtooj yog txoj cai-txhim kho, thiab cov ntaub ntawv xov xwm yog sab laug-aligned. Nyob rau hauv lub "Tshaj" thaiv, "Tsev" tab, koj tuaj yeem pom cov ntsiab lus yooj yim formatting.
Nrog kev pab los ntawm ribbon ntsiab lus, koj tuaj yeem hloov kho font, teeb ciam teb thiab hloov qhov sau. Koj tsuas yog yuav tsum xaiv ib lub xovtooj ntawm tes lossis ntau lub xovtooj thiab siv cov cuab yeej saum toj kawg nkaus los teeb tsa txhua qhov kev xav tau.
Kuv kho cov ntawv
Cia peb saib ob peb txoj hauv kev los kho cov ntawv hauv lub hlwb kom ua cov ntxhuav nrog cov ntaub ntawv nyeem tau raws li qhov ua tau.
Yuav ua li cas hloov Excel font
Cia peb saib ob peb txoj hauv kev los hloov font:
- Txoj kev ib. Xaiv lub cell, mus rau ntu "Tsev" thiab xaiv "Font" caij. Ib daim ntawv qhib uas txhua tus neeg siv tuaj yeem xaiv tus font tsim nyog rau lawv tus kheej.
- Txoj kev ob. Xaiv ib lub cell, right-click rau nws. Cov ntawv qhia zaub mov tau tshwm sim, thiab hauv qab no nws yog lub qhov rai me me uas tso cai rau koj los tsim cov font.
- Txoj kev peb. Xaiv lub xovtooj thiab siv qhov tseem ceeb ua ke Ctrl + 1 hu rau "Format Cells". Hauv qhov rai uas tshwm, xaiv "Font" seem thiab ua txhua yam tsim nyog.
Yuav Ua Li Cas Xaiv Excel Styles
Bold,italic, thiab underline styles yog siv los qhia cov ntaub ntawv tseem ceeb hauv cov ntxhuav. Txhawm rau hloov cov style ntawm tag nrho cov xov tooj ntawm tes, koj yuav tsum nyem rau ntawm nws nrog rau sab laug nas khawm. Txhawm rau hloov ib feem ntawm lub xov tooj nkaus xwb, koj yuav tsum tau nyem ob npaug rau ntawm lub xov tooj ntawm tes, thiab tom qab ntawd xaiv qhov xav tau rau formatting. Tom qab xaiv, hloov cov style siv ib qho ntawm cov hauv qab no:
- Kev siv cov txheej txheem tseem ceeb:
- Ctrl + B - bold;
- Ctrl + I - italic;
- Ctrl + U - hauv qab;
- Ctrl + 5 - hla tawm;
- Ctrl + = - subscript;
- Ctrl + Ua haujlwm ++ - superscript.
- Siv cov cuab yeej nyob hauv "Font" thaiv ntawm "Tsev" tab.
- Siv lub thawv Format Cells. Ntawm no koj tuaj yeem teeb tsa qhov kev xav tau hauv ntu "Hloov kho" thiab "Inscription" ntu.
Aligning cov ntawv hauv cell
Alignment ntawm cov ntawv hauv hlwb yog ua los ntawm cov hauv qab no:
- Mus rau ntu "Tshaj Tawm" ntawm ntu "Tsev". Ntawm no, nrog kev pab los ntawm cov cim, koj tuaj yeem kho cov ntaub ntawv.
- Hauv "Format Cells" lub thawv, mus rau ntu "Tshaj Tawm". Ntawm no koj tuaj yeem xaiv txhua hom kev sib dhos uas twb muaj lawm.
Autoformat ntawv hauv Excel
Ua tib zoo mloog! Cov ntawv ntev nkag mus rau hauv lub xov tooj yuav tsis haum rau hauv nws thiab tom qab ntawd nws yuav tshwm sim tsis raug. Nws muaj qhov pib-formatting feature kom tsis txhob muaj teeb meem no.
Ob txoj kev ntawm autoformatting:
- Siv lo lus qhwv. Xaiv cov hlwb uas xav tau, mus rau ntu "Tsev", tom qab ntawd mus rau "Txuas" thaiv thiab xaiv "Tsiv Ntawv". Enabling no feature tso cai rau koj mus siv lo lus wrapping thiab ua kom cov kab siab.
- Siv AutoFit muaj nuj nqi. Mus rau "Format Cells", tom qab ntawd "Alignment" thiab khij lub npov nyob ib sab ntawm "AutoFit Width".
Yuav ua li cas sib txuas cov hlwb hauv Excel
Feem ntau, thaum ua hauj lwm nrog cov ntxhuav, nws yuav tsum tau ua ke cov hlwb. Qhov no tuaj yeem ua tiav siv lub pob "Merge thiab Center", uas nyob rau hauv "Kev Sib Txuas" thaiv ntawm ntu "Tsev". Siv qhov kev xaiv no yuav ua ke tag nrho cov cell xaiv. Cov nqi hauv cov hlwb tau ua raws li qhov chaw.
Hloov Cov Lus Qhia thiab Kev Taw Qhia ntawm Cov Ntawv
Cov ntawv qhia kev taw qhia thiab kev taw qhia yog ob qhov chaw sib txawv uas qee cov neeg siv tsis sib haum xeeb. Hauv daim duab no, thawj kem siv cov kev taw qhia, thiab kab thib ob siv cov kev taw qhia:
Los ntawm kev mus rau ntu "Tsev", qhov "Txhim Kho" thaiv thiab "Kev Taw Qhia", koj tuaj yeem siv ob qhov kev txwv no.
Ua haujlwm nrog Excel Cell Formatting Styles
Siv formatting yeej tuaj yeem ua kom cov txheej txheem ntawm formatting lub rooj thiab muab nws zoo nkauj tsos.
Vim li cas lub npe Styles thiaj li tsim nyog
Lub hom phiaj tseem ceeb ntawm kev siv cov style:
- Tsim cov style tshwj xeeb rau kev kho cov ncauj lus, subheadings, ntawv nyeem, thiab lwm yam.
- Siv cov qauv tsim.
- Automation ntawm kev ua hauj lwm nrog cov ntaub ntawv, txij li thaum siv cov style, koj muaj peev xwm format kiag li tag nrho cov ntaub ntawv nyob rau hauv lub xaiv ntau yam.
Siv cov qauv rau cov ntawv ua haujlwm
Muaj ntau tus lej ntawm kev sib xyaw ua ke npaj ua tiav hauv cov ntawv nthuav qhia processor. Kauj ruam los ntawm kauj ruam qhia rau siv cov style:
- Mus rau "Tsev" tab, nrhiav "Cell Styles" thaiv.
- Lub tsev qiv ntawv ntawm cov qauv npaj tau tshwm sim ntawm qhov screen.
- Xaiv qhov xav tau ntawm tes thiab nyem rau ntawm cov style koj nyiam.
- Cov style tau siv rau ntawm tes. Yog tias koj tsuas yog hover koj tus nas dhau qhov kev pom zoo, tab sis tsis txhob nyem rau ntawm nws, koj tuaj yeem saib seb nws yuav zoo li cas.
Tsim Cov Qauv Tshiab
Feem ntau, cov neeg siv tsis muaj kev npaj ua kom txaus, thiab lawv siv los tsim lawv tus kheej. Koj tuaj yeem ua koj tus kheej tshwj xeeb style raws li hauv qab no:
- Xaiv ib lub xovtooj ntawm tes thiab format nws. Peb yuav tsim ib style raws li qhov formatting.
- Mus rau ntu "Tsev" thiab txav mus rau "Cell Styles" thaiv. Nyem "Tsim Cell Style". Lub qhov rais hu ua "Style" qhib.
- Sau ib qho "Style Name".
- Peb teeb tsa tag nrho cov kev tsim nyog uas koj xav siv rau cov qauv tsim.
- Peb nyem "OK".
- Tam sim no koj cov style tshwj xeeb tau ntxiv rau hauv cov tsev qiv ntawv style, uas tuaj yeem siv rau hauv daim ntawv no.
Hloov Cov Qauv Tseem Ceeb
Npaj-ua qauv nyob rau hauv lub tsev qiv ntawv tuaj yeem hloov pauv ntawm nws tus kheej. Kev taug kev:
- Mus rau ntu "Tsev" thiab xaiv "Cell Styles".
- Txoj cai-nias ntawm cov style koj xav hloov kho thiab nyem Kho kom raug.
- Lub qhov rais Style qhib.
- Nyem "Format" thiab nyob rau hauv lub qhov rai tso tawm "Format Cells" kho cov formatting. Tom qab ua tiav tag nrho cov manipulations, nyem "OK".
- Nyem OK dua kom kaw lub thawv Style. Kev hloov kho ntawm cov style tiav tiav, tam sim no nws tuaj yeem siv rau cov ntaub ntawv.
Hloov Cov Qauv rau Lwm Phau Ntawv
Tseem ceeb! Ib tug tsim style tsuas yog siv tau nyob rau hauv cov ntaub ntawv uas nws tau tsim, tab sis muaj ib tug tshwj xeeb feature uas tso cai rau koj mus hloov cov qauv mus rau lwm yam ntaub ntawv.
Kev taug kev:
- Peb rhuav tshem cov ntaub ntawv uas cov qauv tsim nyob.
- Tsis tas li ntawd, qhib lwm daim ntawv uas peb xav hloov cov qauv tsim.
- Hauv daim ntawv nrog cov qauv, mus rau "Tsev" tab thiab nrhiav "Cell Styles" thaiv.
- Nyem "Combine". Lub qhov rais hu ua "Merge Styles" tshwm sim.
- Lub qhov rais no muaj cov npe ntawm tag nrho cov ntaub ntawv qhib qhib. Xaiv cov ntaub ntawv uas koj xav hloov cov qauv tsim thiab nyem lub pob "OK". Npaj txhij!
xaus
Muaj ntau txoj hauv kev uas tso cai rau koj los hloov kho cov qauv ntawm tes hauv daim ntawv nthuav qhia. Ua tsaug rau qhov no, txhua tus neeg ua haujlwm hauv qhov program tuaj yeem xaiv rau nws tus kheej txoj hauv kev yooj yim dua los daws qee yam teeb meem.