Qhov wikiHow no qhia koj yuav ua li cas, tsim, khiav, thiab txuag macros hauv Microsoft Excel. Macros yog cov haujlwm me me uas tso cai rau koj ua cov haujlwm nyuaj, xws li suav cov qauv lossis tsim kab kos, hauv Excel. Macros tuaj yeem txuag lub sijhawm tseem ceeb thaum siv rau kev rov ua haujlwm, thiab ua tsaug rau Excel's "Record Macro" qhov tshwj xeeb, koj tsis tas yuav paub dab tsi txog kev ua haujlwm txhawm rau tsim macro.
Cov kauj ruam
Ntu 1 ntawm 4: Pab kom Macros
Kauj Ruam 1. Qhib Excel
Ob npaug nias rau lub Excel app icon, uas zoo ib yam li dawb "X" ntawm lub thawv ntsuab, tom qab ntawv nyem rau Phau ntawv dawb paug.
Yog tias koj muaj cov ntaub ntawv tshwj xeeb uas koj xav qhib hauv Excel, ob npaug nias cov ntawv ntawd los qhib nws
Kauj Ruam 2. Nyem Cov Ntaub Ntawv
Nws yog nyob rau sab saud sab laug ntawm lub qhov rais Excel.
Ntawm Mac, nyem Excel nyob rau sab saud sab laug ntawm lub vijtsam kom pom cov ntawv qhia zaub mov nco-down.
Kauj Ruam 3. Nyem Xaiv
Koj yuav pom qhov no ntawm sab laug ntawm lub qhov rais Excel.
Ntawm Mac, koj yuav nyem Nyiam … nyob rau hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Nyem Customize Ribbon
Nws nyob rau sab laug ntawm Excel Options window.
Ntawm Mac, nyem dua Ribbon & Toolbar nyob rau hauv Preferences window.
Kauj Ruam 5. Kos rau lub npov "Developer"
Lub npov no nyob ze rau hauv qab ntawm "Cov Tab Tab" cov npe xaiv.
Kauj Ruam 6. Nyem OK
Nws nyob hauv qab ntawm lub qhov rais. Tam sim no koj tuaj yeem siv macros hauv Excel.
Ntawm Mac, koj yuav nyem Txuag nov xwb.
Ntu 2 ntawm 4: Kaw Macro
Kauj Ruam 1. Sau cov ntaub ntawv tsim nyog
Yog tias koj qhib phau ntawv ua haujlwm dawb, sau cov ntaub ntawv uas koj xav siv ua ntej mus.
Koj tseem tuaj yeem kaw Excel thiab qhib cov ntaub ntawv tshwj xeeb Excel los ntawm ob-nias nws
Kauj Ruam 2. Nyem rau Tus Tsim Tawm tab
Nws nyob rau sab saum toj ntawm Excel qhov rai. Ua li ntawd qhib lub cuab yeej ntawm no.
Kauj Ruam 3. Nyem Sau Macro
Nws nyob hauv toolbar. Ib lub qhov rai pop-up yuav tshwm.
Kauj Ruam 4. Sau lub npe rau lub macro
Hauv kab ntawv "Macro name", ntaus lub npe rau koj lub macro. Qhov no yuav pab koj txheeb xyuas cov macro tom qab.
Kauj Ruam 5. Tsim kom muaj cov yuam sij ua ke yog tias koj nyiam
Nias lub ⇧ Hloov ua ke nrog rau lwm tus ntawv tseem ceeb (piv txwv li, E tus yuam sij) los tsim cov keyboard luv. Koj tuaj yeem siv cov keyboard luv no kom ua haujlwm macro tom qab.
Ntawm Mac, txoj kev sib txuas ua ke luv yuav xaus ua ⌥ Kev Xaiv+⌘ Hais kom ua thiab koj tus yuam sij (piv txwv li, ption Xaiv+⌘ Hais kom+T)
Kauj Ruam 6. Nyem rau "Khw Macro hauv" lub thawv nco-down
Nws nyob nruab nrab ntawm lub qhov rais. Ua li ntawd hais kom ua cov ntawv qhia zaub mov nco-down.
Kauj Ruam 7. Nyem Phau Ntawv Qhia Ua Haujlwm no
Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down. Koj lub macro yuav raug khaws cia hauv koj daim ntawv nthuav tawm, ua rau txhua tus neeg uas muaj daim ntawv nthuav qhia nkag mus rau lub macro.
Kauj ruam 8. Nyem OK
Nws nyob hauv qab ntawm lub qhov rais. Ua qhov no txuag koj cov chaw teeb tsa macro thiab pib kaw.
Kauj Ruam 9. Ua cov kauj ruam macro
Txhua kauj ruam uas koj ua thaum nyem OK thiab nyem Nres Cov Ntaub Ntawv thaum ntxiv rau macro. Piv txwv li, yog tias koj xav tsim lub macro uas hloov ob kab ntawv tus nqi ntawm cov ntaub ntawv rau hauv kab ntawv, koj yuav ua cov hauv qab no:
- Nyem thiab luag koj tus nas hla cov ntaub ntawv los xaiv nws.
- Nyem Ntxig
- Xaiv daim duab duab.
- Nyem daim duab uas koj xav siv.
Kauj Ruam 10. Nyem Nthuav Tawm Cov Ntaubntawv
Nws nyob hauv Tsim tawm toolbar. Qhov no yuav cawm koj cov macro.
Ntu 3 ntawm 4: Txuag Macro-Enabled Spreadsheet
Kauj Ruam 1. Nkag siab tias vim li cas koj yuav tsum khaws daim ntawv nthuav tawm nrog macros qhib
Yog tias koj tsis khaws koj daim ntawv nthuav tawm ua cov ntawv nthuav dav macro (hom ntawv XLSM), qhov loj yuav tsis raug khaws cia ua ib feem ntawm daim ntawv nthuav qhia, txhais tau tias lwm tus neeg ntawm cov khoos phis tawj sib txawv yuav tsis muaj peev xwm siv koj lub macro yog tias koj xa phau ntawv ua haujlwm rau lawv.
Kauj Ruam 2. Nyem Cov Ntaub Ntawv
Nws nyob rau sab saud sab laug ntawm lub qhov rais Excel (Windows) lossis lub vijtsam (Mac). Ua li ntawd yuav ua rau lub tshuab raj nco-down.
Kauj Ruam 3. Nyem Txuag Li
Qhov kev xaiv no yog nyob rau sab laug ntawm lub qhov rais (Windows) lossis hauv cov ntawv qhia zaub mov nco (Mac).
Kauj Ruam 4. Nyem ob npaug rau Lub PC no
Nws nyob hauv kab ntawv txuag chaw nyob ze rau sab laug ntawm lub qhov rais. Lub qhov rai "Txuag Raws Li" yuav qhib.
Hla qhov kauj ruam no ntawm Mac
Kauj Ruam 5. Sau lub npe rau koj daim ntawv Excel
Hauv kab ntawv "Npe", ntaus lub npe rau koj daim ntawv Excel.
Kauj Ruam 6. Hloov cov ntawv ua hom ntawv rau XLSM
Nyem rau ntawm lub npov "Txuag raws li hom", tom qab ntawd nyem rau Phau ntawv Excel Macro-Enabled Workbook hauv qhov tshwm sim nco-down ntawv qhia zaub mov.
Ntawm Mac, koj yuav hloov "xlsx" tom kawg ntawm cov ntaub ntawv lub npe nrog xlsm
Kauj Ruam 7. Xaiv qhov chaw txuag
Nyem rau daim nplaub tshev uas koj xav khaws Excel cov ntaub ntawv (piv txwv li, Duab).
Ntawm Mac, koj yuav tsum xub nyem lub pob "Qhov twg" nco lub thawv
Kauj Ruam 8. Nyem Txuag
Nws nyob hauv qab ntawm lub qhov rais. Ua li ntawd yuav txuag koj daim ntawv Excel rau koj qhov chaw xaiv, thiab koj cov macro yuav raug cawm nrog nws.
Ntu 4 ntawm 4: Khiav Macro
Kauj Ruam 1. Qhib cov ntawv nthuav tawm macro
Nyem ob npaug rau daim ntawv nthuav qhia uas muaj cov lej hauv nws los qhib daim ntawv nthuav tawm hauv Excel.
Kauj Ruam 2. Nyem Enable Content
Nws nyob hauv kab daj nyob rau sab saud ntawm lub qhov rai Excel. Qhov no yuav qhib daim ntawv nthuav qhia thiab tso cai rau koj siv lub macro.
Yog tias koj tsis pom qhov kev xaiv no, hla cov kauj ruam no
Kauj Ruam 3. Nyem rau Developer tab
Qhov kev xaiv no yog nyob rau sab saum toj ntawm Excel qhov rai.
Koj tseem tuaj yeem tsuas yog nias qhov tseem ceeb ua ke uas koj teev rau lub macro. Yog tias koj ua li ntawd, macro yuav ua haujlwm, thiab koj tuaj yeem hla tus txheej txheem no
Kauj ruam 4. Nyem Macros
Koj yuav pom nws hauv Tsim tawm tab toolbar. Lub qhov rai pop-up yuav qhib.
Kauj Ruam 5. Xaiv koj lub macro
Nyem lub npe ntawm macro uas koj xav khiav.
Kauj Ruam 6. Nyem Khiav
Nws nyob sab xis ntawm lub qhov rais. Koj lub macro yuav pib ua haujlwm.
Kauj Ruam 7. Tos kom cov macro ua tiav kev ua haujlwm
Nyob ntawm seb koj lub macro loj npaum li cas, qhov no tuaj yeem siv sijhawm ob peb feeb.