Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys

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:

  1. Ntau.
  2. Nyiaj txiag.
  3. Tus lej.
  4. Nyiaj txiag.
  5. Ntawv.
  6. Hnub Tim.
  7. Lub sijhawm.
  8. Me me.
  9. Feem pua.
  10. 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.

Txoj Kev 1: Cov ntawv qhia zaub mov

Siv cov ntawv qhia zaub mov los hloov kho ib hom ntawv yog ib txoj hauv kev siv ntau tshaj plaws. Kev taug kev:

  1. 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 ...".
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
1
  1. 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".
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
2
  1. 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:

  1. 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.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
3
  1. Cov kev xaiv tseem ceeb tau tshwm sim. Xaiv qhov koj xav tau hauv thaj chaw xaiv. Cov formatting tau hloov lawm.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
4
  1. 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".
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
5
  1. Tom qab txhaj rau lub caij no, lub qhov rais paub yuav tshwm sim nrog tag nrho cov kev xaiv formatting (pib thiab ntxiv).
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
6

Txoj Kev 3: "Cells" toolbox

Cov kev hloov kho tom ntej yog ua los ntawm "Cells" thaiv. Kev taug kev:

  1. 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 ...".
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
7
  1. 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.

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
8

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:

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
9

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:

  1. Tus naj npawb 1 yog Lub Ib Hlis 1, 1900.
  2. 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:

  1. Cia peb mus rau "Cov ntaub ntawv".
  2. Nyem "Options" thiab txav mus rau "Advanced" seem.
  3. 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.

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
10

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:

  1. 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.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
11
  1. 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.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
12
  1. 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 hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
13

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:

  1. 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.
  1. Siv cov cuab yeej nyob hauv "Font" thaiv ntawm "Tsev" tab.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
14
  1. Siv lub thawv Format Cells. Ntawm no koj tuaj yeem teeb tsa qhov kev xav tau hauv ntu "Hloov kho" thiab "Inscription" ntu.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
15

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.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
16
  • 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.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
17

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:

  1. 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.
  2. 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.

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
18

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:

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
19

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.

Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
20

Vim li cas lub npe Styles thiaj li tsim nyog

Lub hom phiaj tseem ceeb ntawm kev siv cov style:

  1. Tsim cov style tshwj xeeb rau kev kho cov ncauj lus, subheadings, ntawv nyeem, thiab lwm yam.
  2. Siv cov qauv tsim.
  3. 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:

  1. Mus rau "Tsev" tab, nrhiav "Cell Styles" thaiv.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
21
  1. Lub tsev qiv ntawv ntawm cov qauv npaj tau tshwm sim ntawm qhov screen.
  2. Xaiv qhov xav tau ntawm tes thiab nyem rau ntawm cov style koj nyiam.
  3. 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:

  1. Xaiv ib lub xovtooj ntawm tes thiab format nws. Peb yuav tsim ib style raws li qhov formatting.
  2. Mus rau ntu "Tsev" thiab txav mus rau "Cell Styles" thaiv. Nyem "Tsim Cell Style". Lub qhov rais hu ua "Style" qhib.
Yuav ua li cas hloov cell hom hauv Excel. Los ntawm cov ntawv qhia zaub mov, cov cuab yeej thiab hotkeys
22
  1. Sau ib qho "Style Name".
  2. Peb teeb tsa tag nrho cov kev tsim nyog uas koj xav siv rau cov qauv tsim.
  3. Peb nyem "OK".
  4. 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:

  1. Mus rau ntu "Tsev" thiab xaiv "Cell Styles".
  2. Txoj cai-nias ntawm cov style koj xav hloov kho thiab nyem Kho kom raug.
  3. Lub qhov rais Style qhib.
  4. 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".
  5. 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:

  1. Peb rhuav tshem cov ntaub ntawv uas cov qauv tsim nyob.
  2. Tsis tas li ntawd, qhib lwm daim ntawv uas peb xav hloov cov qauv tsim.
  3. Hauv daim ntawv nrog cov qauv, mus rau "Tsev" tab thiab nrhiav "Cell Styles" thaiv.
  4. Nyem "Combine". Lub qhov rais hu ua "Merge Styles" tshwm sim.
  5. 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.

Sau ntawv cia Ncua