Yuav ua li cas muab cov zuam nyob rau hauv expele: 5 txoj kev ua haujlwm

Hauv Microsoft Office Program Program, cov neeg siv qee zaum yuav tsum tau ntxig tus zuam lossis, ua ib qho sib txawv yog hu ua cov khoom no, kos lub thawv (˅). Qhov no tuaj yeem ua rau ntau lub hom phiaj: Tsuas yog rau lub cim ntawm qee yam khoom, kom muaj ntau qhov xwm txheej, thiab lwm yam. Cia peb kawm seb yuav nruab tus zuam nyob rau hauv expele.

Txhim Kho Tus Chij

Muaj ob peb txoj hauv kev los tso tus zuam hauv Excel. Txhawm rau txiav txim siab cov kev xaiv tshwj xeeb, koj yuav tsum tau sau tam sim, uas koj xav tau los nruab lub npov: tsuas yog teeb tsa qee yam thiab cov xwm txheej?

Zaj Lus Qhia: Yuav ua li cas muab tus zuam hauv Microsoft Word

Txoj Kev 1: Ntxig los ntawm cov ntawv qhia zaub mov "lub cim"

Yog tias koj xav tau los tso tus zuam rau ntawm cov phiaj duab tsuas yog mus kos cim qee yam khoom, koj tuaj yeem siv "lub cim" khawm nyob ntawm daim kab xev.

1. Nruab tus cursor hauv lub xovtooj ntawm cov cim kos yuav tsum nyob. Mus rau "ntxig" tab. Nyem rau ntawm "lub cim" khawm, uas yog nyob hauv "cov cim" toolbar.



2. Lub qhov rai qhib nrog ib daim ntawv loj loj ntawm ntau yam. Peb tsis mus qhov twg, tab sis tseem nyob hauv "cov cim" tab. Nyob rau hauv font teb, ib qho ntawm cov qauv fonts tuaj yeem sau tseg: Arial, Verdana, lub sijhawm tshiab Roman, thiab lwm yam. Txhawm rau tshawb nrhiav cov cim xav tau hauv "teeb" teb, teeb tsa lub parameter "cov ntawv hloov pauv". Peb tab tom nrhiav ib lub cim "˅". Peb tau qhia nws thiab nyem rau ntawm "paste".

Tom qab ntawd, cov ntsiab lus xaiv yuav tshwm sim nyob rau hauv lub xovtooj ua ntej.

Nyob rau hauv tib txoj kev, koj tuaj yeem ntxig tus zuam muaj ntau dua nrog sab nraud lossis kos cim rau hauv CexBox (me me square (ib qho me me, rau kev teeb tsa tus chij). Tab sis rau qhov no, koj yuav tsum tau qhia nyob rau hauv "Font" teb hloov chaw ntawm tus qauv txheem kev xaiv Werdings tshwj xeeb. Tom qab ntawd koj yuav tsum poob rau hauv qab ntawm cov npe ntawm cov cim thiab xaiv cov cim xav tau. Tom qab ntawd, peb nyem rau "paste".

Cov phiajcim xaiv tau muab tso rau hauv lub cell.

Txoj Kev 2: Cim Hloov

Kuj tseem muaj cov neeg siv uas tsis tau teev los ntawm kev ua raws li cov cim. Yog li ntawd, hloov chaw txhim kho tus qauv kos cim, "V" cim hauv kev hais lus Askiv yog yooj yim luam tawm ntawm cov keyboard. Qee zaum nws yog kev ncaj ncees, vim tias cov txheej txheem no yuav siv sijhawm me me. Thiab sab nraud, cov kev hloov no yog qhov pom tsis tau pom.

Txujci 3: Cov zuam pheb hauv Chekbox

Tab sis nyob rau hauv kev txiav txim rau cov xwm txheej ntawm lub installation lossis tshem tawm ntawm tus zuam tua qee qhov xwm txheej, koj yuav tsum ua haujlwm nyuaj dua. Ua ntej tshaj plaws, cov thawv yuav tsum ntsia. Qhov no yog xws li ib lub square me me uas lub cim khij tau teeb tsa. Txhawm rau nkag tau cov khoom no, koj yuav tsum ua kom cov ntawv qhia zaub mov tsim tawm, uas tau tua los ntawm lub neej ntawd hauv expele.

1. Ua nyob rau hauv "File" tab, nyem rau ntawm "tsis muaj" yam khoom, uas nyob rau sab laug ntawm lub qhov rai sab laug.



2. Lub parameter qhov rais pib. Mus rau ntawm "kab xev". Nyob rau sab xis ntawm lub qhov rais, peb tau nruab ib tus zuam (nws yuav tsum tau uas peb yuav tsum tau nruab rau daim ntawv) rov qab ua "tus tsim tawm" parameter. Nyob rau hauv qab ntawm lub qhov rais nyem rau ntawm "OK" khawm. Tom qab ntawd, tus tsim tawm tab yuav tshwm sim ntawm daim kab xev.



3. Mus rau qhov tshiab qhib qhib "tsim tawm". Hauv "kev tswj hwm" toolbar ntawm Ribbon Peb nyem rau "paste" khawm ". Nyob rau hauv cov npe uas qhib hauv "Daim Ntawv Tswj" pab pawg, xaiv "Checkbox".



4. Tom qab ntawd, tus cursor hloov mus rau hauv tus ntoo khaub lig. Nyem rau lawv rau thaj chaw ntawm daim ntawv uas koj yuav tsum tau sau ib daim ntawv.

   

   Npliag chekbox pom.



5. Txhawm rau nruab rau hauv nws, koj yuav tsum tau nyem nyem rau cov khoom no thiab daim tshev yuav raug ntsia.



6. Txhawm rau tshem tawm cov qauv sau ntawv, uas feem ntau tsis xav tau los ntawm txhaj rau sab laug nas khawm ntawm lub caij, xaiv cov lus sau thiab nias lub khawm rho tawm. Hloov chaw ntawm cov ntawv sau tseg, koj tuaj yeem ntxig lwm tus, thiab koj tsis tuaj yeem ntxig txhua yam, tawm hauv Chekbox tsis muaj npe. Qhov no yog nyob ntawm kev txiav txim siab ntawm tus neeg siv.



7. Yog tias muaj kev xav tau tsim ntau daim tshev, tom qab ntawd koj tsis tuaj yeem tsim ib qho rau ib kab rau ib zaug, tab sis yuav luam nws npaj txhij, uas yuav ua kom txuag tau lub sijhawm. Txhawm rau ua qhov no, peb tam sim ntawd tso cov nas nyem daim ntawv, ces clamp lub khawm laug thiab rub daim ntawv mus rau ntawm tes xav tau. Tsis txhob pov lub pob nas, clamp lub CTRL tus yuam sij, thiab tom qab ntawd tso cov khawm nas. Peb tab tom muaj kev ua haujlwm zoo sib xws nrog lwm tus neeg uas koj xav tau ntxig zuam.

Txoj kev 4: Tsim ib chekbox los ua ib tsab ntawv

Saum toj no peb tau kawm yuav ua li cas tso tus zuam hauv lub cell hauv ntau txoj kev. Tab sis cov yeeb yam no tuaj yeem siv tsis tsuas yog rau kev pom kev, tab sis kuj tseem daws cov haujlwm tshwj xeeb. Koj tuaj yeem nruab ntau qhov xwm txheej xaiv thaum hloov lub npov hauv Chekbox. Peb yuav tshawb xyuas tias nws ua haujlwm li cas ua haujlwm ntawm tus yam ntxwv hloov cov xim ntawm lub xov tooj ntawm tes.

1. Tsim ib qho ntsuas ntawm lub algorithm piav nyob rau hauv txoj kev dhau los siv cov tsim tawm los.
2. Nyem rau ntawm cov khoom muaj cai nias. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "hom ntawm cov khoom ...".



3. Lub formatting qhov rooj qhib. Mus rau "tswj" tab, yog tias nws tau qhib rau lwm qhov. Hauv "tus nqi" tsis muaj, lub xeev tam sim no yuav tsum tau teev tseg. Qhov ntawd yog, yog tias lub npov yog tam sim no tau ntsia, hloov chaw yuav tsum sawv ntsug hauv "teeb ​​tsa", yog tias tsis yog, hauv txoj haujlwm "tshem tawm". Qhov "sib xyaw" txoj haujlwm tsis pom zoo. Tom qab ntawd, peb nyem rau ntawm lub icon ze ntawm daim teb "kev sib txuas lus nrog cell".



4. Lub formatting lub qhov rooj yog tais, thiab peb yuav tsum tau hais txog cell ntawm ib daim ntawv nrog lub npo khij nrog daim tshev kos. Tom qab kev xaiv yog tsim, rov nias lub pob tib ua cov duab pictogram, uas tau sib tham saum toj no rov qab mus rau lub qhov rais format.



5. Nyob rau hauv lub formatting qhov rai, nyem rau ntawm "OK" khawm kom txuag tau cov kev hloov pauv.

   

   Raws li koj tuaj yeem pom, tom qab ua cov haujlwm no hauv lub xov tooj ntawm lub xov tooj thaum lub npov khij hauv lub cim, qhov "tseeb" tau tshwm sim. Yog tias tus zuam raug tshem tawm, ces qhov "dag" yuav raug tso tawm kom pom. Ua kom tiav peb txoj haujlwm, uas yog, los hloov cov xim ntawm cov ntawv sau, koj yuav tsum tau txuas cov txiaj ntsig no hauv ib qho kev ua.



6. Peb qhia txog lub xov tooj ntawm tes thiab nyem rau ntawm nws lub pob khawm, xaiv cov "xovtooj ntawm tes ..." hauv cov ntawv qhia zaub mov qhib.



7. Cell Kev Ua Haujlwm Qhib Lub Qhov Rooj Qhib. Hauv "Naj npawb" tab, peb faib cov "Txhua Hom" khoom hauv "cov lej" tsis txheeb ". Lub teb "hom", uas nyob hauv nruab nrab ntawm lub qhov rais, sau cov lus qhia hauv qab no yam tsis muaj nqi: ";;;; Nyem rau ntawm "OK" khawm nyob hauv qab ntawm lub qhov rais. Tom qab cov kev ua no, cov lus sau pom "qhov tseeb" ntawm lub cell ploj, tab sis tus nqi tseem.



8. Peb faib cov neeg muaj feem cuam tshuam thiab mus rau "lub tsev" tab. Nyem rau ntawm "kev xaiv hom" khawm ", uas nyob hauv cov qauv" qauv ". Nyob rau hauv daim ntawv kos rau ntawm cov khoom "tsim txoj cai ...".



9. Cov kev cai tsim cov cai tsim lub qhov rooj qhib. Nyob rau hauv nws sab saum toj koj yuav tsum xaiv hom kev cai. Xaiv cov lus qhia tseeb hauv cov npe: "Siv cov qauv los txiav txim siab cov qauv xov tooj." Hauv "hom ntawv tus nqi rau cov qauv hauv qab no yog qhov tseeb" tau faib cov chaw nyob ntawm nws), thiab tom qab kev sib koom tes tau tshwm sim hauv kab, ntxiv cov lus qhia "= Qhov Tseeb" hauv nws. Txhawm rau teem cov xim xaiv, nyem rau ntawm "hom ntawv ..." khawm.



10. Cell Kev Ua Haujlwm Qhib Lub Qhov Rooj Qhib. Peb xaiv cov xim uas xav tau ncuav lub cell thaum zuam tig mus. Nyem rau ntawm "OK" khawm.



11. Rov qab mus rau tus tsim cov kev cai lub qhov rai, nyem rau ntawm "OK" khawm.

Tam sim no, thaum lub thawv khib nyiab tig mus, lub cev sib txuam yuav pleev xim rau hauv cov xim xaiv.

Yog tias lub npov yog ntxuav, ntawm tes yuav rov ua kom dawb.

Zaj Lus Qhia: Tab tom sau ntawv hauv Excel

Txoj Kev 5: Kev Nruab Nrab Zig Siv Cov Cuab Yeej nquag

Daim zuam tuaj yeem muab nruab nrog cov cuab yeej nquag. Cov yam ntxwv no muaj tsuas yog los ntawm cov tsim tawm ntawv qhia zaub mov. Yog li ntawd, yog tias cov tab no tsis qhib, nws yuav tsum tau ua kom tiav, raws li tau piav qhia saum toj no.

1. Mus rau tus tsim tawm tab. Nyem rau ntawm "ntxig" khawm, uas tau muab tso rau hauv "Kev tswj" Toolbar. Nyob rau hauv lub qhov rais uas qhib nyob rau hauv lub activex cov khoom thaiv, xaiv lub npov.



2. Xws li nyob rau lub sijhawm dhau los, tus cursor yuav siv ib daim ntawv tshwj xeeb. Peb nyem rau ntawm lawv los ntawm qhov chaw ntawm daim ntawv, qhov twg daim ntawv yuav tsum muab tso rau.



3. Txhawm rau teem cov cim kos rau Chekbox, koj yuav tsum nkag mus rau cov khoom ntawm cov khoom no. Kuv nyem rau ntawm nws nrog txoj cai nas khawm thiab xaiv cov "hluav taws xob" khoom hauv cov zaub mov qhib.



4. Nyob rau hauv cov khoom lub qhov rais uas qhib, tus nqi ntsuas. Nws muab tso rau hauv qab. Rov qab nws hloov tus nqi nrog tsis tseeb ntawm qhov tseeb. Peb ua nws, tsuas yog tau tsav cov cim los ntawm cov keyboard. Tom qab txoj haujlwm tiav lawm, kaw cov khoom hluav taws xob los ntawm txhaj rau tus qauv txheem kaw khawm nyob rau hauv daim ntawv ntawm liab square nyob rau hauv lub ces kaum sab sauv ntawm lub qhov rais.

Tom qab ua yeeb yam no, lub npov khij hauv lub thawv ntawv yuav raug ntsia.

Kev ua tiav ntawm cov xwm txheej uas siv cov khoom siv nquag siv tau siv VBA cov cuab yeej, uas yog, los ntawm kev sau macros. Ntawm chav kawm, nws yog ntau ntau nyuaj dua li siv cov khoom siv uas tab Txoj kev tshawb no ntawm qhov teeb meem no yog cais cov ncauj lus txawv. Sau cov yeeb yam tuaj yeem tsuas yog cov neeg siv tau tsuas yog cov neeg siv nrog kev paub txog kev paub ua haujlwm hauv kev ua haujlwm tau ntau dua li qib nrab.

Txhawm rau mus rau VBA Editor, uas koj tuaj yeem sau ib qho, koj yuav tsum tau nyem rau ntawm cov khoom, hauv peb kis los ntawm checkbox, sab laug nas khawm. Tom qab ntawd, cov kab ntawv kho phau ntawv kho yuav raug tsim tawm, uas koj tuaj yeem sau cov cai ntawm cov haujlwm tau ua.

Zaj Lus Qhia: Yuav ua li cas los tsim cov macro hauv excel

Raws li koj tuaj yeem pom, muaj ob peb txoj hauv kev los nruab ib tus zuam hauv Excel. Txoj hauv kev los xaiv, ua ntej txhua yam nyob ntawm cov hom phiaj teeb tsa. Yog tias koj xav tau tsuas yog Mark Qee cov khoom, nws ua rau tsis muaj kev nkag siab ua ib txoj haujlwm los ntawm cov khoom lag luam tsim tawm, raws li nws yuav siv sijhawm ntau. Nws yooj yim dua los siv cov ntxig rau ntawm lub cim lossis txhua yam tsuas yog hu ua ntawv Askiv "v" ntawm cov keyboard hloov cov zuam. Yog tias koj xav teeb tsa cov ntawv tshwj xeeb uas siv daim tshev, tom qab ntawd nyob rau hauv cov ntaub ntawv no lub hom phiaj no tsuas yog ua tiav siv cov cuab yeej tsim tawm.