excel宏代码编写教程如下:
电脑:LenovoG460
系统:Windows11
软件:Excel2019
1、打开excel,点击菜单栏视图,宏,录制宏。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/574e9258d109b3dec2e6e7ffdebf6c81810a4ccf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在弹出的窗口中随便设置一个快捷键,例如Ctrl+shift+L,点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40fe29fcd4ab964034f79f019cf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击停止录制宏,查看宏。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7acb0a46f21fbe099607c08379600c338644adc8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的宏窗口中点击编辑。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/91ef76c6a7efce1bd873cb5dbd51f3deb58f65c8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在宏模块中输入一行代码,例如selectionentirerowselect,意为按照选中的单元格选择整行,保存。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fd039245d688d43f00f192656f1ed21b0ff43bc8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、在表格中输入几个数据,选中所在的单元格,使用快捷键Ctrl+shift+L即可选择单元格所在的行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b151f8198618367a1fd17c4a3c738bd4b21ce5c9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)