txheem
Formatting yog ib qho ntawm cov txheej txheem tseem ceeb thaum ua haujlwm nrog daim ntawv nthuav qhia. Los ntawm kev thov formatting, koj tuaj yeem hloov cov tsos ntawm cov ntaub ntawv tabular, nrog rau cov kev xaiv ntawm tes. Nws yog ib qho tseem ceeb uas yuav tsum tau siv nws kom raug thiaj li ua tau koj txoj haujlwm hauv qhov kev pab cuam sai thiab ua tau zoo. Los ntawm tsab xov xwm koj yuav kawm yuav ua li cas format lub rooj kom raug.
Table Formatting
Formatting yog ib txheej ntawm kev ua uas tsim nyog los hloov kho cov tsos ntawm lub rooj thiab cov ntsuas hauv nws. Cov txheej txheem no tso cai rau koj los kho cov font loj thiab xim, cell loj, sau, hom, thiab lwm yam. Cia peb txheeb xyuas txhua lub ntsiab lus kom ntxaws ntxiv.
Auto formatting
Autoformatting tuaj yeem siv rau txhua yam ntawm cov cell. Spreadsheet processor yuav nws tus kheej hloov kho qhov xaiv ntau yam, siv cov kev txwv tsis pub rau nws. Kev taug kev:
- Peb xaiv ib lub xovtooj, ntau lub cell lossis tag nrho cov lus.
- Mus rau ntu "Tsev" thiab nyem "Format as Table". Koj tuaj yeem pom cov ntsiab lus no hauv "Styles" thaiv. Tom qab txhaj, lub qhov rais nrog txhua qhov ua tau npaj ua tau tshwm sim. Koj tuaj yeem xaiv ib qho ntawm cov qauv. Nyem rau ntawm qhov kev xaiv uas koj nyiam.
- Ib lub qhov rais me me tau tshwm sim rau ntawm qhov screen, uas yuav tsum tau lees paub qhov tseeb ntawm qhov nkag mus ua haujlwm. Yog tias koj pom tias muaj qhov yuam kev hauv qhov ntau, koj tuaj yeem hloov kho cov ntaub ntawv. Koj yuav tsum ua tib zoo xav txog cov khoom "Table with headers." Yog tias lub rooj muaj cov npe, ces cov cuab yeej no yuav tsum tau kuaj xyuas. Tom qab ua txhua qhov chaw, nyem "OK".
- Npaj txhij! Lub phaj tau coj los ntawm cov tsos ntawm cov style koj tau xaiv. Txhua lub sijhawm, qhov style no tuaj yeem hloov mus rau lwm qhov.
Hloov mus rau formatting
Qhov muaj peev xwm ntawm kev tsis siv neeg formatting tsis haum rau txhua tus neeg siv ntawm cov ntawv nthuav qhia. Nws yog ua tau manually format lub phaj siv tshwj xeeb tsis. Koj tuaj yeem hloov kho qhov zoo li siv cov ntawv qhia zaub mov lossis cov cuab yeej nyob ntawm kab. Kev taug kev:
- Peb ua ib qho kev xaiv ntawm qhov tsim nyog kho qhov chaw. Nyem rau nws RMB. Cov ntawv qhia zaub mov ntsiab lus yog tshwm rau ntawm qhov screen. Nyem rau ntawm "Format Cells ..." element.
- Ib lub thawv hu ua "Format Cells" tshwm rau ntawm qhov screen. Ntawm no koj tuaj yeem ua ntau cov ntaub ntawv tabular kho kom raug.
Tshooj Tsev muaj ntau yam cuab yeej formatting. Txhawm rau siv lawv rau koj lub hlwb, koj yuav tsum xaiv lawv, thiab tom qab ntawd nyem rau ntawm ib qho ntawm lawv.
Cov Ntaub Ntawv Formatting
Cov ntawv xovtooj ntawm tes yog ib qho ntawm cov txheej txheem yooj yim formatting. Cov ntsiab lus no tsis tsuas yog hloov kho cov tsos, tab sis kuj qhia cov txheej txheem txheej txheem ua haujlwm ntawm tes. Raws li nyob rau hauv txoj kev dhau los, qhov kev txiav txim no tuaj yeem siv los ntawm cov ntawv qhia zaub mov lossis cov cuab yeej nyob hauv cov kab tshwj xeeb ntawm Lub Tsev tab.
Los ntawm qhib lub "Format Cells" qhov rai siv cov ntsiab lus teb ntawv qhia zaub mov, koj tuaj yeem hloov kho hom ntawv los ntawm "Number Formats" seem, nyob rau hauv "Number" thaiv. Ntawm no koj tuaj yeem xaiv ib qho ntawm cov qauv hauv qab no:
- hnub tim;
- sijhawm;
- nquag;
- tus lej;
- text, lwm.
Tom qab xaiv hom ntawv xav tau, nyem "OK".
Tsis tas li ntawd, qee hom ntawv muaj kev xaiv ntxiv. Los ntawm kev xaiv tus lej hom, koj tuaj yeem hloov kho tus lej tom qab tus lej lej rau cov lej feem.
Los ntawm kev teeb tsa "Hnub" hom, koj tuaj yeem xaiv yuav ua li cas hnub yuav tshwm rau ntawm qhov screen. Qhov "Lub Sijhawm" parameter muaj tib qhov chaw. Los ntawm txhaj rau "Tag nrho cov hom", koj tuaj yeem saib tag nrho cov subspecies ntawm kev kho cov ntaub ntawv hauv lub xov tooj ntawm tes.
Los ntawm kev mus rau ntu "Tsev" thiab nthuav tawm cov npe nyob rau hauv "Number" thaiv, koj tuaj yeem hloov kho hom ntawv ntawm tes lossis ntau lub xov tooj. Daim ntawv teev npe no muaj tag nrho cov qauv loj.
Los ntawm txhaj rau ntawm cov khoom "Lwm tus lej tawm tswv yim ..." lub qhov rais uas twb paub lawm "Format of cells" yuav tshwm sim, uas koj tuaj yeem ua kom ntxaws ntxiv rau cov hom ntawv.
Cov ntsiab lus sib dhos
Los ntawm kev mus rau "Format Cells" lub thawv, thiab tom qab ntawd mus rau ntu "Tshaj Tawm", koj tuaj yeem ua ntau qhov chaw ntxiv kom pom cov phaj zoo dua. Qhov rai no muaj ntau qhov chaw. Los ntawm kev txheeb xyuas lub thawv ntawm ib lossis lwm qhov parameter, koj tuaj yeem sib koom ua ke ntawm tes, qhwv cov ntawv los ntawm cov lus, thiab tseem siv cov kev xaiv dav dav.
Tsis tas li ntawd, nyob rau hauv seem no, koj tuaj yeem siv qhov chaw ntawm cov ntawv hauv lub xov tooj ntawm tes. Muaj kev xaiv ntawm cov ntawv sau ntsug thiab kab rov tav.
Hauv seem "Kev taw qhia", koj tuaj yeem kho lub kaum sab xis ntawm cov ntawv nyeem hauv lub xov tooj ntawm tes.
Hauv seem "Tsev" muaj ib qho thaiv ntawm cov cuab yeej "Txhim kho". Ntawm no, raws li nyob rau hauv lub "Format Cells" qhov rais, muaj cov ntaub ntawv sib raug zoo chaw, tab sis nyob rau hauv ib tug ntau cropped daim ntawv.
Kev teeb tsa font
Ntu "Font" tso cai rau koj los ua ntau yam kev ua haujlwm los hloov cov ntaub ntawv hauv cov xov tooj ntawm tes los yog ntau lub hlwb. Ntawm no koj tuaj yeem hloov kho cov hauv qab no:
- ib hom;
- qhov loj;
- Xim;
- style, thiab lwm yam.
Nyob rau hauv ib tug tshwj xeeb ribbon yog ib tug thaiv ntawm cov cuab yeej "Font", uas tso cai rau koj mus ua tib yam transformations.
Ciam teb thiab kab
Hauv seem "Txuas" ntawm "Format Cells" qhov rai, koj tuaj yeem kho cov kab hom, nrog rau teeb tsa cov xim xav tau. Ntawm no koj tuaj yeem xaiv cov style ntawm ciam teb: sab nraud lossis sab hauv. Nws muaj peev xwm tshem tawm tag nrho ciam teb yog tias nws tsis xav tau hauv lub rooj.
Hmoov tsis zoo, tsis muaj cov cuab yeej los kho cov lus ciam teb ntawm cov kab saum toj kawg nkaus, tab sis muaj cov khoom me me uas nyob hauv "Font" thaiv.
Sau cov hlwb
Hauv seem "Fill" ntawm "Format Cells" lub thawv, koj tuaj yeem hloov kho cov xim ntawm lub rooj cell. Nws muaj peev xwm nthuav tawm ntau yam qauv.
Raws li nyob rau hauv lub dhau los, tsuas muaj ib tug khawm ntawm lub toolbar, uas yog nyob rau hauv lub "Font" thaiv.
Nws tshwm sim tias tus neeg siv tsis muaj cov qauv tsim txaus los ua haujlwm nrog cov ntaub ntawv tabular. Hauv qhov no, koj yuav tsum mus rau ntu "Lwm cov xim ..." los ntawm lub pob nyob rau hauv "Font" thaiv. Tom qab txhaj, lub qhov rais tso tawm kom pom uas tso cai rau koj xaiv cov xim sib txawv.
Cell hom
Koj tuaj yeem tsis tsuas yog teeb tsa lub xov tooj ntawm tes koj tus kheej, tab sis kuj xaiv los ntawm cov kev sib xyaw ua ke rau hauv daim ntawv nthuav qhia nws tus kheej. Lub tsev qiv ntawv ntawm cov qauv yog qhov dav, yog li txhua tus neeg siv yuav tuaj yeem xaiv qhov zoo rau lawv tus kheej.
Kev taug kev:
- Xaiv cov hlwb tsim nyog los siv cov style tiav.
- Mus rau ntu "Tsev".
- Nyem "Cell Styles".
- Xaiv qhov koj nyiam style.
Cov ntaub ntawv tiv thaiv
Kev tiv thaiv kuj belongs rau lub realm ntawm formatting. Hauv lub qhov rais "Format Cells" paub, muaj ib ntu hu ua "Kev Tiv Thaiv". Ntawm no koj tuaj yeem teeb tsa kev tiv thaiv kev tiv thaiv uas yuav txwv tsis pub kho cov kab mob uas tau xaiv. Thiab ntawm no koj tuaj yeem pab kom zais cov qauv.
Ntawm cov cuab yeej ribbon ntawm Tshooj Tsev, nyob rau hauv Cells thaiv, muaj lub hom phiaj uas tso cai rau koj ua qhov kev hloov pauv zoo sib xws. Los ntawm txhaj rau "Hom ntawv", lub vijtsam yuav tso tawm cov npe uas muaj "Kev Tiv Thaiv" muaj. Los ntawm txhaj rau "Protect sheet ...", koj tuaj yeem txwv tsis pub kho tag nrho daim ntawv ntawm cov ntaub ntawv xav tau.
Cov ntsiab lus rooj
Hauv daim ntawv nthuav qhia Excel, nrog rau lo lus processor Word, koj tuaj yeem xaiv lub ntsiab ntawm daim ntawv.
Kev taug kev:
- Mus rau "Page Layout" tab.
- Nyem rau ntawm qhov "Themes" element.
- Xaiv ib qho ntawm cov ntsiab lus npaj txhij.
Kev hloov pauv mus rau "Smart Table"
Lub rooj "ntse" yog hom tshwj xeeb ntawm kev formatting, tom qab ntawd cov xov tooj ntawm tes tau txais qee yam muaj txiaj ntsig zoo uas ua rau nws yooj yim rau kev ua haujlwm nrog ntau cov ntaub ntawv. Tom qab hloov dua siab tshiab, qhov ntau ntawm cov hlwb raug txiav txim siab los ntawm qhov kev pab cuam raws li tag nrho cov khoom. Siv cov haujlwm no txuag cov neeg siv los ntawm kev suav cov qauv tom qab ntxiv cov kab tshiab rau lub rooj. Tsis tas li ntawd, lub rooj "Smart" muaj cov nyees khawm tshwj xeeb hauv cov headers uas tso cai rau koj lim cov ntaub ntawv. Txoj haujlwm muab lub peev xwm los pin lub rooj header mus rau sab saum toj ntawm daim ntawv. Hloov mus rau hauv "Smart Table" yog ua raws li hauv qab no:
- Xaiv thaj chaw yuav tsum tau kho. Ntawm qhov toolbar, xaiv cov khoom "Styles" thiab nyem "Format as Table".
- Lub vijtsam qhia cov npe ntawm cov qauv npaj ua tiav nrog cov kev ntsuas ua ntej. Nyem rau ntawm qhov kev xaiv uas koj nyiam.
- Lub qhov rais pabcuam tau tshwm sim nrog cov chaw rau qhov ntau thiab cov npe ntawm cov npe. Peb teeb tag nrho cov kev ntsuas tsim nyog thiab nyem lub pob "OK".
- Tom qab ua cov teeb tsa no, peb cov ntsiav tshuaj tau hloov mus rau hauv Smart Table, uas yooj yim dua rau kev ua haujlwm nrog.
Table Formatting Piv txwv
Cia peb ua ib qho piv txwv yooj yim ntawm yuav ua li cas format lub rooj ib kauj ruam. Piv txwv li, peb tau tsim ib lub rooj zoo li no:
Tam sim no cia peb mus rau nws cov ncauj lus kom ntxaws editing:
- Cia peb pib nrog lub npe. Xaiv qhov ntau A1 ... E1, thiab nyem rau ntawm "Merge thiab txav mus rau qhov chaw." Cov khoom no yog nyob rau hauv seem "Formatting". Cov hlwb raug muab sib koom ua ke thiab cov ntawv sau sab hauv yog qhov chaw nruab nrab. Teem lub font rau "Arial", qhov loj rau "16", "Bold", "Underlined", qhov ntxoov ntxoo font rau "Purple".
- Wb mus rau formatting cov kab ntawv kab lus. Xaiv cov hlwb A2 thiab B2 thiab nyem "Merge Cells". Peb ua cov haujlwm zoo sib xws nrog cov hlwb A7 thiab B7. Peb teeb tsa cov ntaub ntawv hauv qab no: font - "Arial Black", qhov loj - "12", alignment - "Sab laug", font ntxoov ntxoo - "Purple".
- Peb xaiv C2 ... E2, thaum tuav "Ctrl", peb xaiv C7 ... E7. Ntawm no peb teeb tsa cov kev txwv hauv qab no: font - "Arial Black", qhov loj - "8", kev sib dhos - "Centered", font xim - "Purple".
- Wb mus rau kho cov ntawv. Peb xaiv cov cim tseem ceeb ntawm lub rooj – cov no yog cov hlwb A3 … E6 thiab A8 … E8. Peb teeb tsa cov kev txwv hauv qab no: font - "Arial", "11", "Bold", "Centered", "Blue".
- Teem rau sab laug ntug B3 ... B6, thiab B8.
- Peb nthuav tawm cov xim liab hauv A8 … E8.
- Peb xaiv D3 ... D6 thiab nias RMB. Nyem "Format Cells ...". Nyob rau hauv lub qhov rais uas tshwm, xaiv cov ntaub ntawv tus lej. Peb ua qhov zoo sib xws nrog cell D8 thiab teeb peb tus lej tom qab tus lej lej.
- Wb mus rau formatting ciam teb. Peb xaiv A8 ... E8 thiab nyem "Txhua Ciam Teb". Tam sim no xaiv "Thick Outer Ciam Teb". Tom ntej no, peb xaiv A2 ... E2 thiab xaiv "Thick sab ciam teb". Ib yam li ntawd, peb format A7 … E7.
- Peb ua xim xim. Xaiv D3…D6 thiab muab lub teeb turquoise xim. Peb xaiv D8 thiab teeb lub teeb daj daj.
- Peb mus rau kev teeb tsa kev tiv thaiv ntawm daim ntawv. Peb xaiv cell D8, right-click rau nws thiab nyem "Format Cells". Ntawm no peb xaiv lub "Kev Tiv Thaiv" thiab muab lub cim khij ntawm ib sab ntawm "Kev Tiv Thaiv Cell" caij.
- Peb txav mus rau cov ntawv qhia zaub mov tseem ceeb ntawm cov ntawv nthuav qhia thiab mus rau ntu "Kev Pabcuam". Tom qab ntawd peb tsiv mus rau "Kev Tiv Thaiv", qhov twg peb xaiv lub caij "Protect Sheet". Kev teeb tsa tus password yog qhov kev xaiv xaiv tau, tab sis koj tuaj yeem teeb nws yog tias koj xav tau. Tam sim no lub xovtooj no tsis tuaj yeem hloov kho.
Hauv qhov piv txwv no, peb tau tshuaj xyuas kom meej tias koj tuaj yeem tsim ib lub rooj nyob rau hauv ib kauj ruam zuj zus. Cov txiaj ntsig ntawm formatting zoo li no:
Raws li peb tuaj yeem pom, lub cim tau hloov pauv ntawm sab nraud. Nws qhov tsos tau dhau los ua kev nyiam thiab nthuav tawm. Los ntawm cov kev ua zoo sib xws, koj tuaj yeem ua txhua lub rooj thiab muab kev tiv thaiv los ntawm kev hloov kho tsis raug. Phau ntawv formatting txoj kev yog ntau npaum li cas ntau npaum li cas siv predefined yeej, txij li thaum koj muaj peev xwm manually teem tsis tshwj xeeb rau txhua hom rooj.
xaus
Cov ntawv nthuav qhia processor muaj ntau qhov chaw uas tso cai rau koj los tsim cov ntaub ntawv. Qhov kev zov me nyuam tau yooj yim tsim-hauv cov qauv tsim nrog cov kev xaiv xaiv, thiab los ntawm "Format Cells" qhov rai, koj tuaj yeem siv koj tus kheej cov chaw manually.