Muaj ob yam kev tswj hauv Microsoft Office Excel: daim ntawv tswj thiab ActiveX tswj. Cov tom kawg yog ywj siab software Cheebtsam hu ua los ntawm Excel. Lawv muaj peev xwm los tuav web scripts thiab VBA macros.
Tsim nyog
nruab rau Microsoft Office Excel daim ntawv thov
Cov Lus Qhia
Kauj ruam 1
Txhawm rau nkag mus rau ActiveX cov kev tswj hwm, koj yuav tsum teeb kho Excel kom tso tawm Daim Ntawv Qhia Tus Tsim Tawm. Koj tuaj yeem ua qhov no raws li hauv qab no: nyem Lub Chaw Haujlwm khawm nyob rau sab saud sab laug ntawm lub qhov rais, hauv qab qis ntawm cov ntawv qhia zaub mov, nyem khawm Excel Options.
Kauj ruam 2
Lub thawv ntawv tshiab yuav qhib, xaiv tshooj "General" hauv nws. Hauv cov pab pawg "Cov kev xaiv yooj yim rau kev ua haujlwm nrog Excel" teeb tus cim rau thaj teb "Pom tus tsim tab ntawm Ribbon". Nyem rau ntawm OK khawm rau hauv qab ntawm lub qhov rais txuag cov chaw tshiab.
Kauj ruam 3
Txhawm rau tsim ib qho khoom kom nquag, mus rau ntawm tus tsim tab thiab xaiv Ntu Kev Tswj ntawm qhov toolbar. Nyem rau ntawm "Ntxig" Xais khawm. Cov ntsiab lus teb tshuab raj yuav nthuav dav. Hauv cov pab pawg "ActiveX tswj" xaiv ib qho ntawm cov khoom siv (teb, xov tooj cua khawm, daim ntawv teev npe, thiab lwm yam) los ntawm txhaj rau nws nrog sab laug nas khawm.
Kauj ruam 4
Lub cim tsa ncauj yuav hloov nws qhov tsos. Siv tus ntoo khaub lig-zoo li tus taw tes kom loj me rau koj qhov khoom thaum tuav cia rau sab laug nas khawm. Thaum tsim tiav, tso tawm. Thaum koj xaiv ib qho ntawm cov ActiveX tswj ntawm lub twj cuab tam, Excel cia nkag mus hom tsim. Nws yog nyob rau hauv hom no uas qhov kev tswj xyuas tau muab tso rau ntawm daim ntawv yog muaj rau kev kho.
Kauj ruam 5
Txav tus cursor mus rau qhov khoom, xaiv nws thiab nyem rau ntawm xaiv nrog txoj khawm nas. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Hom ntawv". Lub thawv ntawv yuav qhib uas koj tuaj yeem kho lub zog thiab teeb tsa qhov loj me, tiv thaiv nws los ntawm kev hloov pauv. Lub Vev Xaib muaj ntau ntxiv thaum koj npaj siv phau ntawv lossis ntawv ci ua lub vev xaib.
Kauj Ruam 6
Txhawm rau nkag mus rau qhov kev tshaj lij ntawm ib qho khoom siv ActiveX, txav tus cursor rau nws thiab nyem ob npaug rau sab laug nas khawm. Lub Properties qhov rai yuav muaj. Nws yog lub luag haujlwm rau cov yam ntxwv ntawm yam khoom. Yog tias koj tsis txaus siab rau lub neej cov khoom qub, hloov pauv ntawm lub qhov rai no.
Kauj Ruam 7
Nco ntsoov tias koj tuaj yeem nkag mus siv lub hom khoom ActiveX thiab kho nws raws li koj pom zoo yog tias tsim hom qauv. Nyob rau hauv hom qub, tus kwv ua haujlwm ua lub luag haujlwm tswj hwm lub ntsiab lus - khawm tau nyem, cov pob txav tau raug kho, thiab lwm yam Txoj haujlwm qhib thiab tawm ntawm cov qauv tsim tawm tshwm sim thaum koj nyem lub pob ntiv tes khawm ntawm tib lub npe hauv seem "Tswj".
