txheem
Qhov kub tseem ceeb ua ke yog ib qho kev xaiv los ntawm qhov uas nws muaj peev xwm ntaus ib qho kev sib xyaw ua ke ntawm cov keyboard, uas koj tuaj yeem nkag mus rau qee yam nta ntawm Excel editor. Hauv tsab xov xwm, peb yuav xav txog txoj hauv kev los rho tawm kab hauv lub rooj editor siv cov yuam sij kub.
Rho tawm ib kab los ntawm cov keyboard nrog hotkeys
Txoj kev ceev tshaj plaws los rho tawm ib kab lossis ob peb yog siv cov yuam sij kub ua ke. Txhawm rau tshem tawm cov ntsiab lus inline siv cov keyboard shortcut, koj tsuas yog yuav tsum nyem 2 khawm, ib qho yog "Ctrl" thiab qhov thib ob yog "-".
Nws yuav tsum tau muab sau tseg tias kab (los yog ob peb yam) yuav tsum tau xaiv ua ntej. Cov lus txib yuav rho tawm qhov kev teev tseg nrog kev nce qib offset. Daim ntawv thov yuav ua kom nws txo tau lub sij hawm siv thiab tsis kam ua tsis tsim nyog nrog kev pab los ntawm lub dialog box hu ua. Nws muaj peev xwm ua kom ceev cov txheej txheem rau kev rho tawm cov kab uas siv cov yuam sij kub, txawm li cas los xij, rau lub hom phiaj no, koj yuav tsum ua 2 kauj ruam. Ua ntej, txuag lub macro, thiab tom qab ntawd muab nws ua tiav rau ib qho kev sib xyaw ntawm cov nyees khawm.
Txuag lub macro
Los ntawm kev siv macro code tshem tawm ib qho inline, nws tuaj yeem tshem tawm yam tsis siv tus nas pointer. Qhov kev ua haujlwm yuav pab txiav txim seb tus naj npawb ntawm cov khoom hauv kab nyob qhov twg cov cim xaiv nyob thiab tshem tawm cov kab nrog kev nce siab. Txhawm rau ua qhov kev txiav txim, koj tsis tas yuav xaiv lub caij nws tus kheej ua ntej tus txheej txheem. Txhawm rau hloov cov lej no mus rau PC, koj yuav tsum luam nws thiab muab nws ncaj qha rau hauv qhov project module.
Muab cov keyboard shortcut rau macro
Nws yog ib qho ua tau los teeb tsa koj tus kheej hotkeys, kom cov txheej txheem rau kev rho tawm cov kab yuav nrawm me ntsis, txawm li cas los xij, rau lub hom phiaj no, 2 yuav tsum ua. Thaum xub thawj, koj yuav tsum khaws cov macro hauv phau ntawv, thiab tom qab ntawd kho nws qhov kev ua tiav nrog qee qhov yooj yim tseem ceeb ua ke. Txoj kev txiav txim siab ntawm kev rho tawm kab yog tsim nyog rau cov neeg siv ntau dua ntawm Excel editor.
Tseem ceeb! Nws yuav tsum raug sau tseg tias nws yog ib qho tsim nyog los xaiv cov yuam sij kub rau kev rho tawm cov kab kom zoo zoo, vim tias ntau qhov kev sib txuas tau siv los ntawm Excel daim ntawv thov nws tus kheej.
Tsis tas li ntawd, tus editor paub qhov txawv ntawm cov tsiaj ntawv ntawm tsab ntawv teev tseg, yog li ntawd, txhawm rau kom tsis txhob tsom mus rau qhov teeb tsa thaum ua haujlwm macro, nws muaj peev xwm luam tawm nrog lub npe sib txawv thiab xaiv qhov tseem ceeb ua ke rau nws siv lub pob zoo sib xws.
Macro rau rho tawm kab los ntawm qhov xwm txheej
Kuj tseem muaj cov cuab yeej tshaj lij rau kev siv cov txheej txheem hauv nqe lus nug, siv uas koj tsis tas yuav tsom mus nrhiav cov kab yuav raug tshem tawm. Piv txwv li, peb tuaj yeem coj tus macro uas tshawb nrhiav thiab tshem tawm cov ntsiab lus hauv kab uas muaj cov ntawv teev cov neeg siv, thiab ntxiv rau Excel. Nws tshem tawm cov kab uas muaj ntau yam sib txawv thiab muaj peev xwm los teeb tsa lawv hauv lub thawv sib tham.
xaus
Txhawm rau tshem tawm cov ntsiab lus inline hauv Excel editor, muaj ntau yam cuab yeej siv tau. Koj tuaj yeem siv hotkeys los ua qhov haujlwm zoo li no, nrog rau tsim koj tus kheej macro kom tshem tawm cov ntsiab lus hauv kab hauv lub rooj, qhov tseem ceeb tshaj plaws yog ua raws li algorithm ntawm kev ua kom raug.