1、打开电脑,首先在指定盘符中新建一个文件夹,并把需要导入到excel中图片复制到该文件夹内;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f31fbe096b63f6249ae144b08944ebf81b4ca3c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、接着启动excel2010,调整整张表格的大小,这里可以在a列进行演示操作演示,然后选择单元格a1,点击执行公式选项,点击定义名称命令选项,从中选择定义名称选项;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd111d390f93b712c8fcc2ce2df1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在新建名称对话框中输入名称为测试,引用位置设置为=files("G:\测试数据\*.jpg"),点击确定按钮;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/43a7d933c895d14338cf99907df082025baf07c3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、接着在单元格a1中输入公式=index (测试,row(a1)),点击回车键确认;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a461f9af68a6563f6246a60afcd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着把鼠标左键放在右下角出现黑色十字,往下拖拽填充即可批量导入excel。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cc11728b4710b912ba338b4dcdfdfc0393452296?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)