Yuav ua li cas ua kom cov hlwb zoo ib yam hauv Excel

Feem ntau thaum ua haujlwm nrog Excel spreadsheets, nws yuav tsum tau hloov kho qhov loj me ntawm tes. Nws yog ib qho tsim nyog yuav tau ua qhov no kom haum rau tag nrho cov ntaub ntawv tsim nyog nyob ntawd. Tab sis vim hais tias ntawm xws li kev hloov, cov tsos ntawm lub rooj deteriorates ho. Yuav kom daws tau qhov teeb meem no, nws yog ib qho tsim nyog yuav tsum ua kom txhua lub xov tooj ntawm tes zoo ib yam li tus so. Tam sim no peb yuav kawm paub meej tias yuav tsum ua li cas thiaj ua tiav lub hom phiaj no.

Kev ntsuas cov ntsuas ntsuas

Muaj ob lub ntsiab tsis muaj feem cuam tshuam rau cov hlwb thiab ua rau lawv qhov ntau thiab tsawg:

1. Kab dav. Los ntawm lub neej ntawd, qhov tseem ceeb tuaj yeem nyob ntawm 0 txog 255. Tus nqi qub yog 8,43.
2. Kab qhov siab. Tus nqi tuaj yeem nyob ntawm 0 txog 409. Lub neej ntawd yog 15.

Txhua qhov taw tes yog sib npaug li 0,35 mm.

Nyob rau tib lub sijhawm, nws tuaj yeem hloov kho cov ntsuas ntsuas uas qhov dav thiab qhov siab ntawm cov hlwb yuav raug txiav txim siab. Txhawm rau ua qhov no, ua raws li cov lus qhia:

1. Nrhiav cov ntawv qhia zaub mov "File" thiab qhib nws. Yuav muaj cov khoom "Settings". Nws yuav tsum raug xaiv.
   

   

2. Tom ntej no, lub qhov rais yuav tshwm sim, nyob rau sab laug ntawm cov npe uas tau muab. Koj yuav tsum nrhiav qhov seem “Ntxiv ntxiv” thiab nias rau nws. Nyob rau sab xis ntawm lub qhov rais no, peb tab tom nrhiav rau ib pawg ntawm cov tsis hu ua Zaub. Nyob rau hauv cov ntaub ntawv ntawm cov laus versions ntawm Excel, nws yuav hu ua “Screen”. Muaj kev xaiv “Units on the line”, koj yuav tsum tau nyem rau ntawm tus nqi tam sim no los qhib ib daim ntawv teev npe ntawm txhua qhov ntsuas muaj nyob. Excel txhawb cov hauv qab no - nti, centimeters, millimeters.
   

   

3. Tom qab xaiv qhov kev xaiv uas xav tau, nyem "OK".
   

   

Yog li, tom qab ntawd koj tuaj yeem xaiv qhov ntsuas ntsuas uas tsim nyog tshaj plaws hauv ib kis. Ntxiv parameters yuav raug teem raws li nws.

Cell Area Alignment – ​​Txoj Kev 1

Txoj kev no tso cai rau koj los kho qhov loj me ntawm tes hauv qhov kev xaiv ntau yam:

1. Xaiv qhov ntau ntawm cov cell xav tau.
   

   

2. Qhib lub tab "Tsev"pawg nyob qhov twg “Cells”. Muaj ib lub pob nyob hauv qab ntawm nws. “Hom ntawv”. Yog tias koj nyem rau ntawm nws, ib daim ntawv teev npe yuav qhib, qhov twg hauv kab saum toj kawg nkaus yuav muaj kev xaiv “kab qhov siab”Cov. Koj yuav tsum nyem rau nws.
   

   

3. Tom ntej no, lub qhov rais nrog ncua sij hawm qhov siab xaiv yuav tshwm sim. Kev hloov pauv yuav raug ua rau txhua qhov ntsuas ntawm thaj chaw xaiv. Thaum txhua yam ua tiav, koj yuav tsum nyem rau ntawm "OK".
   

   

4. Tom qab tag nrho cov kev ua no, nws tuaj yeem kho qhov siab ntawm txhua lub hlwb. Tab sis nws tseem yuav tau kho qhov dav ntawm kab. Txhawm rau ua qhov no, koj yuav tsum xaiv cov khoom qub dua (yog tias vim qee qhov kev xaiv raug tshem tawm) thiab qhib tib cov ntawv qhia zaub mov, tab sis tam sim no peb txaus siab rau kev xaiv “kem dav”. Nws yog thib peb ntawm sab saum toj.
   

   

5. Tom ntej no, teeb tsa tus nqi tsim nyog. Tom qab ntawd, peb paub meej tias peb ua los ntawm nias lub pob "OK".
   

   

6. Hooray, nws tau ua tiav tam sim no. Tom qab ua tiav cov manipulations tau piav saum toj no, tag nrho cov cell loj tsis zoo ib yam nyob rau hauv tag nrho cov ntau yam.
   

   

Tab sis qhov no tsis yog tib txoj hauv kev los xyuas kom meej tias txhua lub hlwb muaj qhov loj tib yam. Txhawm rau ua qhov no, koj tuaj yeem kho nws ntawm lub vaj huam sib luag tswj:

1. Txhawm rau teeb tsa qhov siab ntawm lub hlwb, txav tus cursor mus rau lub vaj huam sib luag ntsug, qhov twg xaiv cov lej ntawm txhua kab thiab tom qab ntawd hu rau cov ntawv qhia zaub mov los ntawm txoj cai-nias ntawm txhua lub xovtooj ntawm pawg tswj hwm. Yuav muaj kev xaiv “kab qhov siab”, nyob rau hauv uas koj yuav tsum tau nyem twb nrog rau sab laug khawm.
   

   

2. Tom qab ntawd tib lub qhov rais yuav pop li hauv qhov piv txwv yav dhau los. Peb yuav tsum xaiv qhov siab tsim nyog thiab nyem rau ntawm "OK".
   

   

3. Qhov dav ntawm txhua kab yog teem rau tib txoj kev. Txhawm rau ua qhov no, nws yog ib qho tsim nyog los xaiv qhov xav tau ntau yam ntawm lub vaj huam sib luag kab rov tav thiab tom qab ntawd qhib cov ntawv qhia zaub mov, qhov twg xaiv qhov kev xaiv “kem dav”.
   

   

4. Tom ntej no, qhia tus nqi xav tau thiab nyem "OK".

Aligning daim ntawv tag nrho - txoj kev 2

Qee zaum, nws yog ib qho tsim nyog yuav tsum ua kom tsis muaj qhov tshwj xeeb, tab sis tag nrho cov ntsiab lus. 

1. Lawm, tsis tas yuav tsum muaj tag nrho cov hlwb los xaiv tus kheej. Nws yog ib qho tsim nyog yuav tau nrhiav ib daim duab plaub me me nyob ntawm qhov sib txuas ntawm cov kab ntsug thiab kab rov tav. Los yog lwm qhov kev xaiv yog cov keyboard shortcut Ctrl + A.
   

   

2. Nov yog yuav ua li cas kom pom cov ntawv ua haujlwm hauv ib qho kev txav zoo nkauj. Tam sim no koj tuaj yeem siv txoj kev 1 los teeb tsa cov cell tsis.
   

   

Self-configuration - txoj kev 3

Hauv qhov no, koj yuav tsum ua haujlwm nrog cov ciam teb ntawm tes ncaj qha. Txhawm rau siv txoj kev no, koj xav tau:

1. Xaiv ib cheeb tsam lossis tag nrho cov cell ntawm ib daim ntawv tshwj xeeb. Tom qab ntawd, peb yuav tsum txav tus cursor mus rau ib qho ntawm kab ciam teb nyob rau hauv cheeb tsam uas tau xaiv. Tsis tas li ntawd, tus cursor yuav dhau los ua ib qho me me ntxiv rau kos npe nrog cov xub ua nyob rau hauv ntau cov lus qhia. Thaum qhov no tshwm sim, koj tuaj yeem siv lub pob nas laug los hloov txoj haujlwm ntawm ciam teb. Txij li ib cheeb tsam cais tau raug xaiv hauv qhov piv txwv peb tab tom piav qhia, cov kev hloov pauv tau siv rau nws.
   

   

2. Ntawd yog nws, tam sim no tag nrho cov hlwb hauv ib qho chaw muaj qhov dav tib yam. Lub hom phiaj ua tiav, raws li lawv hais.
   

   

3. Tab sis peb tuaj yeem pom hauv lub screenshot saum toj no tias qhov siab tseem txawv. Txhawm rau kho qhov tsis zoo no, koj yuav tsum tau kho qhov loj ntawm cov kab hauv tib txoj kev. Nws yog ib qho tsim nyog los xaiv cov kab sib txuas ntawm lub vaj huam sib luag ntsug (lossis tag nrho cov ntawv) thiab hloov txoj hauj lwm ntawm ciam teb ntawm ib qho ntawm lawv. 17.png
4. Tam sim no nws tau ua tiav lawm. Peb tau tswj xyuas kom paub tseeb tias txhua lub hlwb yog tib yam.

Txoj kev no muaj ib tug drawback - nws yog tsis yooj yim sua kom kho qhov dav thiab qhov siab. Tab sis yog tias qhov tseeb tsis tsim nyog, nws yog qhov yooj yim dua li thawj txoj kev.

Tseem ceeb! Yog tias koj xav kom ntseeg tau tias txhua lub hlwb ntawm daim ntawv muaj qhov loj me, koj yuav tsum xaiv txhua tus ntawm lawv siv lub thawv nyob rau sab laug sab sauv lossis siv qhov sib xyaw ua ke. Ctrl + A, thiab teeb qhov tseeb qhov tseem ceeb hauv tib txoj kev.

Yuav ua li cas ua kom kab tom qab ntxig ib lub rooj - Txoj Kev 4

Nws feem ntau tshwm sim tias thaum ib tug neeg sim muab lub rooj los ntawm cov ntawv teev cia, nws pom tias nyob rau hauv cov kab ntau dhau ntawm cov hlwb, lawv qhov ntau thiab tsawg tsis haum rau cov thawj. Ntawd yog, lub hlwb ntawm cov thawj thiab cov rooj tso tawm muaj qhov sib txawv qhov siab thiab qhov dav. Yog tias koj xav kom phim lawv, koj tuaj yeem siv txoj hauv qab no:

1. Ua ntej koj yuav tsum qhib lub rooj uas peb yuav tsum luam thiab xaiv nws. Tom qab ntawd nrhiav cov cuab yeej pab pawg “Clipboard” tab "Tsev"khawm nyob qhov twg "Luam". Koj yuav tsum nyem rau ntawm nws. Tsis tas li ntawd, cov yuam sij kub tuaj yeem siv tau Ctrl + Ctxhawm rau luam cov kab uas xav tau ntawm cov cell mus rau cov ntawv teev cia.
   

   

2. Tom ntej no, koj yuav tsum tau nyem rau ntawm lub xovtooj ntawm tes uas cov theej fragment yuav muab tso. Nws yog nws leej twg yuav dhau los ua lub ces kaum sab laug ntawm lub rooj yav tom ntej. Txhawm rau ntxig cov seem uas xav tau, koj yuav tsum tau nyem rau ntawm nws. Hauv cov ntawv qhia zaub mov pop-up, koj yuav tsum nrhiav qhov kev xaiv "Paste Special". Tab sis tsis txhob nyem rau ntawm xub nyob ib sab ntawm cov khoom no, vim tias nws yuav qhib cov kev xaiv ntxiv, thiab lawv tsis xav tau tam sim no.
   

   

3. Tom qab ntawd lub dialog box pops, koj yuav tsum nrhiav ib pab pawg neeg “Ntxig”qhov khoom nyob qhov twg “Kem Dav”, thiab nyem rau ntawm lub xov tooj cua khawm ib sab ntawm nws. Tom qab xaiv nws, koj tuaj yeem paub meej tias koj qhov kev ua los ntawm nias "OK".
   

   

4. Tom qab ntawd cov cell loj tsis hloov pauv kom lawv cov nqi zoo ib yam li hauv cov lus qub.
   

   

5. Qhov ntawd yog nws, tam sim no nws muaj peev xwm muab cov kab no tso rau hauv lwm daim ntawv lossis daim ntawv kom qhov loj ntawm nws lub hlwb sib phim cov ntaub ntawv qub. Qhov kev tshwm sim no tuaj yeem ua tiav hauv ntau txoj hauv kev. Koj tuaj yeem nyem rau ntawm lub xov tooj uas yuav yog thawj lub xov tooj ntawm lub rooj - ib qho uas tau theej los ntawm lwm qhov chaw. Tom qab ntawd cov ntawv qhia zaub mov ntsiab lus yuav tshwm sim, thiab qhov ntawd koj yuav tsum nrhiav cov khoom “Ntxig”. Muaj ib lub pob zoo sib xws ntawm lub tab "Tsev". Tab sis qhov yooj yim tshaj plaws yog nias qhov tseem ceeb ua ke Ctrl + V. Txawm hais tias nws yog qhov nyuaj rau nco ntsoov ntau dua li siv ob txoj hauv kev dhau los, tab sis thaum nws tau cim tseg, koj tuaj yeem txuag sijhawm ntau.
   

   

Nws raug nquahu kom kawm cov lus qhia feem ntau Excel hotkey. Txhua qhov thib ob ntawm kev ua haujlwm tsis yog tsuas yog lub sijhawm ntxiv rau kev cawmdim, tab sis kuj tseem muaj sijhawm kom tsis txhob nkees.

Ntawd yog nws, tam sim no qhov loj ntawm tes ntawm ob lub rooj yuav zoo ib yam.

Siv Macro los kho qhov dav thiab qhov siab

Yog tias koj feem ntau yuav tsum xyuas kom meej tias qhov dav thiab qhov siab ntawm cov hlwb zoo ib yam, nws yog qhov zoo dua los sau cov macro me me. Txhawm rau ua qhov no, koj yuav tsum hloov kho cov cuab yeej muaj txiaj ntsig siv VBA lus. RowHeight и ColumnWidth.

Yog tias peb tham txog kev xav, tom qab ntawd txhawm rau kho qhov siab thiab dav ntawm lub xov tooj ntawm tes, koj yuav tsum tswj cov kab thiab kab ke.

Lub macro tso cai rau koj los kho qhov siab tsuas yog hauv cov ntsiab lus, thiab qhov dav hauv cov cim. Nws tsis tuaj yeem teeb tsa cov ntsuas ntsuas uas koj xav tau.

Txhawm rau kho cov kab siab, siv cov cuab yeej RowHeight yam khoom -. Piv txwv li, yog.

ActiveCell.RowHeight = 10

Ntawm no, qhov siab ntawm kab uas lub active cell nyob yuav yog 10 ntsiab lus. 

Yog tias koj nkag mus rau cov kab no hauv macro editor, qhov siab ntawm kab thib peb yuav hloov, uas nyob rau hauv peb rooj plaub yuav yog 30 ntsiab lus.

Rows(3).RowHeight = 30

Raws li peb lub ntsiab lus, qhov no yog qhov koj tuaj yeem hloov qhov siab ntawm txhua lub hlwb suav nrog hauv qee yam:

Range(«A1:D6»).RowHeight = 20

Thiab zoo li no - tag nrho kab:

Columns(5).RowHeight = 15

Tus naj npawb ntawm kab yog muab rau hauv kab lus. Nws zoo ib yam nrog cov hlua - tus lej ntawm txoj hlua tau muab rau hauv cov hlua khi, uas yog sib npaug rau cov ntawv ntawm cov tsiaj ntawv sib raug rau tus lej.

Txhawm rau hloov kho kab dav, siv cov cuab yeej ColumnWidth yam khoom -. Cov syntax zoo ib yam. Ntawd yog, nyob rau hauv peb rooj plaub, koj yuav tsum tau txiav txim siab ntawm qhov ntau yam uas koj xav hloov. Cia nws yog A1: D6. Thiab tom qab ntawd sau cov kab hauv qab no ntawm code:

Range(«A1:D6»).KumnWidth = 25

Raws li qhov tshwm sim, txhua lub xov tooj hauv qhov ntau yog 25 cim dav.

Txoj kev twg los xaiv?

Ua ntej tshaj plaws, koj yuav tsum tsom mus rau cov haujlwm uas tus neeg siv yuav tsum ua kom tiav. Feem ntau, nws tuaj yeem kho qhov dav thiab qhov siab ntawm ib lub xov tooj ntawm tes siv kev hloov kho ntawm cov pixel. Txoj kev no yog qhov yooj yim uas nws tuaj yeem kho qhov dav-rau-siab qhov sib piv ntawm txhua lub hlwb. Qhov tsis zoo yog tias nws siv sijhawm ntau dua. Tom qab tag nrho, koj yuav tsum xub txav tus nas cursor hla lub ribbon, ces nkag mus rau qhov siab cais ntawm cov keyboard, cais qhov dav, nias lub pob "OK". Txhua yam no siv sijhawm.

Nyob rau hauv lem, txoj kev thib ob nrog phau ntawv hloov kho ncaj qha los ntawm lub vaj huam sib luag tswj tau yooj yim dua. Koj tuaj yeem hais nyob rau hauv ob nas clicks ua qhov loj me me rau tag nrho cov hlwb ntawm ib daim ntawv los yog ib feem ntawm ib daim ntawv.

Ib qho macro, ntawm qhov tod tes, yog qhov kev xaiv ua tiav tag nrho uas tso cai rau koj los kho cov cell tsis nyob hauv ob peb clicks. Tab sis nws yuav tsum muaj kev txawj programming, txawm hais tias nws tsis yooj yim rau kev paub nws thaum nws los txog rau cov kev pab cuam yooj yim.

cov lus xaus

Yog li, muaj ntau ntau txoj hauv kev los kho qhov dav thiab qhov siab ntawm cov hlwb, txhua qhov tsim nyog rau qee yam haujlwm. Yog li ntawd, lub rooj tuaj yeem ua tau zoo heev los saib thiab nyiam nyeem. Qhov tseeb, txhua yam no ua tiav rau qhov no. Ua kom tiav cov ntaub ntawv tau txais, peb tau txais cov hauv qab no:

1. Kho qhov dav thiab qhov siab ntawm ib qho tshwj xeeb ntawm cov hlwb los ntawm ib pab pawg “Cells”, uas tuaj yeem pom ntawm lub tab "Tsev".
2. Kho cov cell parameters ntawm tag nrho cov ntaub ntawv. Txhawm rau ua qhov no, koj yuav tsum nyem rau ntawm qhov sib xyaw ua ke Ctrl + A los yog ntawm ib lub xovtooj ntawm qhov sib txuas ntawm kab nrog kab zauv thiab kab nrog cov npe ntawm cov tsiaj ntawv.
3. Kev hloov kho ntawm cov xov tooj ntawm tes siv lub vaj huam sib luag tswj. 
4. Tsis siv neeg hloov pauv ntawm cov xov tooj ntawm tes kom lawv haum rau cov khoom seem. Ntawm no lawv tau ua tib yam li lub rooj uas tau theej los ntawm lwm daim ntawv lossis phau ntawv ua haujlwm.

Feem ntau, tsis muaj dab tsi nyuab txog qhov no. Txhua txoj kev piav qhia yog nkag siab ntawm qib intuitive. Nws yog txaus los siv lawv ob peb zaug kom tsis txhob siv lawv tus kheej xwb, tab sis kuj qhia ib tug tib neeg.