哈喽大家好,这里是一周进步。
我是爱折腾Excel的若梦。
前几天有一个做文秘的小姐姐在后台留言说,年末了,要汇总公司的新品信息,但Excel经常不听话,光插入图片这一步就让她很抓狂。
我相信有这种抓狂瞬间的同学们一定可以感同身受她的无奈(和暴躁)。
那么到底Excel图表要怎么批量把图片导入到Excel表格里并且一一对应名称呢?
我来教你!
视频教程
文字教程
01.首先选中姓名,把姓名的排序改为升序,然后点击插入图片,同样把文件夹内的图片排序也改为递增。
*注意:批量操作之前,图片命名需要与表格姓名对应一致。
如:需要给“马云”的表格栏对应放上“马云”的照片,则需要先把照片命名为【马云】。
02.再选中所有图片点击插入,然后将图片改为合适的大小,把下面的图片拖到最底下。
03.再按ctrl+A全选图片,点击上方排列,对齐选择纵向分布和左对齐。
这样插入的图片,就和姓名一一对应啦。
你学会了吗,赶紧动手试试吧!
听说一键三连的人新的一年会有好运噢!【点赞+在看+转发↪️】
我是若梦,我们下期再见!
什么?!你居然问我有没有PPT的课程?!
当然有啦!
来得早不如来得巧,我们设计小白营开班啦!
在这里不仅可以学习PPT技能,还有机会当做副业赚钱,即使对设计完全不了解也可以参与!
每天只要花30分钟,就可以入门成为PPT素材设计师,不需要熬夜肝也能赚取收入,这大概是今年zui适合普通人做的副业了。
专为0基础小白打造,学完学费全返
国内顶级PPT培训师全程答疑辅导
开启你设计赚钱的好机会
点击下方图片,直接联系我们
x-_p-_o-[U2FsdGVkX18PyfvT/qle+DOX67uExfk5ypWFnpUIFPeAR/cWZAPSuokOMH17rjy8IjB6+eBEBlX4wu+XKBKOrJeah7/+2P1Nh63Gt+YX5/aMaFt1/zHkpqH3AzLlKz9/HxDcNR8qqYTeRSGTftMK/JYG/ybDc3oQShqTqZnBAMaLt4sS7rIsUw7EPUwNBPehiUC8bfkWbM1Ni2Q9b9vewJUnPwUpPifoXtC+v6Y0LUWmS5lYGDFXBpr1jF3oMCSA9JWxLFug2J+abaWfcEVDq4DbLyI6IpPjIGk4IToMpCS2AXEio7CSl7FosnLkqH1rJqCQ9TlN0dAR+GWLv0Ib9BlNJKbrse2kJGqHxljPmixlf0VVxJyNT7rXeS8qqRHmHHGGjazCi3/sed1upJYjaY1WrTZyjdvyzRbkBrlZ1Co4VTG25Mnj/bBdkwD2isiCb0xvZOcVeUme5us4ZwBpQ5E8KlJ6JaGSQvQbRRxJ9745vAun7XdV1hjXG/o3Xspsn+j2wQyRWMK5kG37Sixp6OAyyKZSmhOs/SMlqvzQtMFP6iJalO7SNE+duBprOaa/cG3Zi2/TXtkOXmwka1ht+scXoPQEkoJF1dduDQLKbbUrQPyJh28FcpMfUGrvFLujcCYcbsbZpNp0BInOiZ3Zk8yCsGO90dF2Rl1LoO4sfCPyTx7EMUw8LBkX8HdZQ4AK9v/rlmZulgu2K6qMRJ6tOPp8tvTlQcva5hcuvkVYQfIJhndFQzkCGCPa4UfMU+0xR5OZADL53YdkvORhEBRVYoqGmXmKZuwkKxbIHVC8CvFN8qpWft0TXx23YwawTQHHihwl26OFElrSra9FeI4H0IZTjuCSfRyDg/d/VbowzkeW9/IuP9CGqOFFd2uB7/dHQTSxhRqh1oDhLPJttDwteGPMXqeX/CbKNsaHFvHmGmJUSp8sK6KOiYijVgzNLFK+yswe0r3r9pM/yO0vk++b/kYtJuZXVK46Jy8+r4kMyeIXeX5PFumf9RSeyEkud761qs7m/WiW/Cyk77EyInjq4QWj3B14mq3WYhoahijEGsLH3LauT3KUdptiA6qtG8fYsda3G5Pcc/NW+su38ycjaWLsQqLGWKnKdaLgG2rNU/EoPU8f2rM6h4w3PF/cPfyRllCeMzoS/mWgsja1nvC5MZnqh0QcYmgNbP2BXGuecjl0ald6FzJbnosy9rZcXtaPPJAbNege/uhT2shTXOKQh6mMvIHYIXYgKqL7TjVDMH35/7Eqjuk4COehAuGY9aI7Oke4XonUiTHigGqUXdQC1qAw0nMPgmoUqZbcGpWhf41cFpnYfDVDKjiI1lOCiTLMFE4ZlccjGzKUzqv/xNgKfZIfonz4dE+HmBXttkdeIzJb4w4yHE+Cz9YDB9XoDMwIezwjz+xGfJ070+OsWt3ib48awd823oTafYyr7KoUYBJTJMZK02a/0OuSBgFqTg0xYBygobQ5gWj21tLa90p6EqPgaYSfzYrwCzWZHUdsVKa4pnZ/tYxSIay/jRy59/t/UsRUPN+SkK+5nGxfutRfJ0+Rd0DY6JYZ/693np/uLKTMVuODCCQpPKUj5lONTK4Bp3Q7wH6KFdEebHi49RR3mH5WcZUAjtIuAeMVUTFVh2/m6pfc+KXnQb7LG1rQvfoFeX9S62wDyrAhVfb6N/PVAfFPflatBd5RaGr6dB7NLNyPz849CAb28q6hAWYM0F0+gHrnN/RiHrYISKlfaEVm+p5vlLqfq2jzD/C5v31E+8sAnJJt+d3hduD5azWJKdYGBX14xR99h2COlCkwdOfX3UaEAQmYg0qtnAsi8YQqbg3LVoOdxDDHAG5E4j+JrRcPF3sZMDJodtamMxwKM19j5JnDar9iGOejddV/c/yJofBIRY4T8r0m2E3ifIKUM09X+yw6nwtEWNpe/oojukUznjesEceozlZkWaIbjw24N9x7pIaFWIMOeAEmpmvOwDXmjyCuX/BlPhWG2sYx+YaiBh2c9BSh9UGykmCbOJmrEuRP4YJCYcixZ1SUOq6xdUZNGjkGgphO2/Qq9sMMU9voDb4RKF/IFnXf1RJ/5HuXs0Rw/JVLSumY7V7ZKe8XP3j3VEW7t7g3fprqKSf6jB0rmmDLCuMgg/CmovxyqGKQ32Vx4B+RLHUMoJZ5mwlMMDwSvF/wOa1i13LAJXn4uZq3oN2ABDwQP7gZvLL6+cdfWBMMQAzV0QKG+gnL7ihImaPS4tmyUjPx0xQZhkPniqe0QmNN6UIXxOR8Fo+DJxk3eFfzTXT4sSJwD5lkl6ZuGKUUwJPpPi8l10N5T8gVFB/0F8n2iWUqdwVzMOeA6/Y3SmHFFbhFfZNjViLoxr39aUSUayMqvFdwe1X6AyD3PiUmle+x3xwWcKWWEHMIhAzdgXDofZzc93IRKEc50Mtx0wzac4TZQD4L2kTITXxfI/6aN1ggOymYbzbTcTuL0ZZ7NVdOeMg+AOa5Lonjsw/V7E3pA7uGyymk29AOSVofhWv/hLNy7wAesoefHVsUNc0zKYFDeOubxiV6guDe7kO5/l95NulU6abQqAokHEQVP8rHCzkNhoC4F7njj+RU+TaQsuVN9V8teByIQlt34n8RUNwmIirnHbadfpIQ4z3S7EMdcEL83GdV6ORnHDsPjdlgtBCtlE0yBIlaD9wrZi6lIEHm2hOJY8bhzwvpeya6jjYLtobql9S0CWt4HKGod6R5AWFaVIYmHHNSOKcomwik2dSq79n7XHXIpdSCngWaDedcZ92nq9Vd7t3OYW4E/DNOO6jL0WlM4GMyfwqFxfw22KaYGCDvVjBCNvKV+Zrwdsvgzfl9HhKuAup/qlzxMBx8Kplk4ikJFkXAW/TraGx7IRBPWkU3ul6dW6BXPiWD4TJTqyrAL5M2os64ZIzvakOuBwXKJ3q2FOaW1sh/TkbgxWkEN9mZL59XA9vIHjiSrxCZLSYRvN28mIDbyo8E3YGuO+ATghMbZw73v0gj+D9m6ejhUcfpYoHrSYRu9zu67bejYBhDBJp47mFbxhYPA+bFV8CybW6wdwG0rSlaTwy8EScJZWyQfkTXGt+lnjbyT40I1KKAv4rNhb7kw0bVFMl8cAGEfDEu+1E2nVYl1A4MqpcqYKh+2kKTnG1/G7RhVR5Qz5llDEO2BEG94fNnabnY4dPTX0q6A5CBBgVj9pMMATpoAUvyv5OjW9gckDz2/8TY1vh5cw4S6BkAfoBYRkgBHKwWk3vV3PgFjGRzZY22BourQEfPnuU92HSTJG2G++PKYL1PiTQCsamrBoA4O7P8n5bx4IeXnW6qOKDXYqFrlOseKQZG5Bqz6qKEaR6DXBYrDetQpd+6GnzvrLhPDx42Ql66BuDRpOzL8yajeXQozkhAPIRNF/oBEIi5sfXd6CeCbaCOhsEoFIKE7MeJ2UugnNQCppd90xDcKm56qCQxMuqlqaWXciWNl+zv7YybpG2wIbiSTs2HoBrGaU0ESxDmr1yCeImWVZASAzVAS7lCiNuSi3JAn9u98owH9dyTUULP4lUjTSNpnrbpLosxSJ3+n8C6VGbb5LkBNkcfndTUuAEG09DVF/jOYsPktD1ILBy7h1rD6sFFZ8M2wSpSTY6w6QWZtEdtxWLonLv+St7hlyGK0Ni+KEA6XumfWr5fMsz+1ZaIJm4OM17UTqc0Rm9FMgRjbJW51C2FmsqVY07o+pScgShZqhhkSoZ4EclNdjQ+M6yy2Hv7Zla3S59c6gMSK0KjVnJvkGW9C6SzD8ttjkbD2ySYRwOIWNhJAzOALxQWCqSEe3WDrn0dMZhCsA2elc4bsPTa7VcDXiO8R+RvG5kYt0buFzVGjtKiXNXQvyCzabTvE6GBW6ChtgrZq56Rz02DG9Lm7pp1BtCxSrsl3tNBfu9id84ePh1PpYX5n8Rmg8oXoQyHVPk0T5CaG5hBa3X3+nYd4fzhD/N1/YmL+zhIpOZ8pdqAqD09d0+Qu1mc0hzThZwCmW+WG5XSYrNCjaiHpEw8ofmnB2drpIwbHkyt++rxOJIqimw9AnUkk1/rk4KtMzBa8rahZzZtpzgJRlVzAykUEELVcXDmJBEkqqZ3lbhii8BhsMw2GrYkRAJs9MbHHYKl+TILDl4r7DJGrYJFHKhd8F7zZgMLsEwQGzo/cLjLSTrp3HAbpeaQYYZ5J+Lkz/thlnMKIDKhEnDtNtj/S8XC/oJErwpdxfO9ES1rYLiDnE3qJ6vuuy5icnBCtBo9D8ILwOgJsyOZIXOOBeLgBFIG4dLELOQmRRqfKH+2hTJGpYUQwO4/NVRvvhQSA5cuwvz4AJQ5CrtiQn3bBAIIaq/6kxstfjca6GKMmiH/p+YY7jpTzaFfp2c/bGP3LfmlPiq8Je0RxpIH7n4Vt4t5qyjLODJH6S8yxFm9s8Y8l84cVrvMEQPHENHBp9bA50/wY3l+Ym72R7SV33haGQGa3wYRUGYQ/4Yi8PG7FugSWNE6SYtOuR3iN0n/EHx4EcaEgNz00hXCPsvqpUJlmbANvnzjONUX5eAo9HVz1YpjntAW7iERkxp3lEj2vjpap1hboevuykieJfcfxhFVVw5shZ1+m2hCzh+BmRrZwO6i6EXem7C1DkARR6cDPENvCHDLOkhXHIvf97jNQwyR+XXkndSvxcjUKEWAYjSLLHP8ud+96N0ycIJnADNVRAeiqL0w3j+DQuN236KyUwo5OVmyofEUwNH/NJtUKPrTjUKz1zPUq6YPeLAbC/quauPbiIHuDCBPwHr3IFbQSi5/M3nsgfxChYEWXyliwjEjKFsCgswWZ3SqRCh8qH4bqbNtzQ==]-o_q-_-x
热门跟贴