打开App
360P
[Excel] 引用 绝对引用和相对引用 统计数据源表变了怎么办
介绍了下绝对引用和相对引用，做了个演示
Excel 一些简单的知识分享4/11
![[Excel]需要从网页上复制表格里面的数据，可是复制粘贴不太好用](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/98c9fa1b2fbc4bbbbe277a938260fd75~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250129084404C072EFE0C369556D9E2F&requestFrom=704&version_code=80402&x-expires=1769647444&x-signature=rsH3bB7DAU20fnz%2FUAyvIXXdMfw%3D)
App03:57![[Excel]内容填写要规范，方便日后的工作，也不给同事添麻烦](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/6580a19ea4a748888ef8a6646d858e56~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250129084404C072EFE0C369556D9E2F&requestFrom=704&version_code=80402&x-expires=1769647444&x-signature=P%2BlXycVTEO%2B%2BvjAXPphn%2FFCwi9k%3D)
App05:44![[Excel]函数concat 单元格添加前缀或者后缀，批量编写通知消息](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/0fd156478a4344b5a2c3f8879505fafa~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250129084404C072EFE0C369556D9E2F&requestFrom=704&version_code=80402&x-expires=1769647444&x-signature=0wXYmanqjhkMqilX9c4TRttVdfo%3D)
App13:20![[Excel] 引用 绝对引用和相对引用 统计数据源表变了怎么办](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/9a33a9d709c24735a938dbd234d13d67~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250129084404C072EFE0C369556D9E2F&requestFrom=704&version_code=80402&x-expires=1769647444&x-signature=ROcYbkPusiqDfuNxkonPyMDI2zQ%3D)
App03:19![[Excel] 公式中引号的用法，带引号表示字符，不带表示地址](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/e4d8ec79abef4aa4af69dfce7c3401dc~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250129084404C072EFE0C369556D9E2F&requestFrom=704&version_code=80402&x-expires=1769647444&x-signature=%2Bi0ghF0s7GuH1tZ31E%2Fc4%2BO8su8%3D)
App02:39
App04:13
App05:09
App09:28
App02:51
App10:10
App02:36打开App观看
介绍了下绝对引用和相对引用，做了个演示
App03:57App05:44App13:20App03:19App02:39App04:13App05:09App09:28App02:51App10:10App02:36
