Office Excel中如何将手机号转为二维码显示
<h3 id="top_0" style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255); text-align: center;"><span style="font-size: 24px;"><strong>Office Excel中如何将手机号转为二维码显示</strong></span></h3><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">问题：</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">需要把Excel表里的手机号转为二维码显示</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"> </p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">操作方法：</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">1、在Excel主界面依次点击“开发工具”→“插入”→“其他控件”</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/99ec0c69fc7f71b476df825a6b26c931-1764299898371.png&name=mceclip0.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"></p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"> </p><div class="wikimodel-emptyline" style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">2、在弹出的对话框中，选择Microsoft BarCode Control 16.0，接着拖动鼠标在手机号下方单元格选中一个区域，会自动生成一个条码，如下图：</div><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/af2020d399bc098024820846795b31c0-1764299944381.png&name=mceclip2.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/403ba9b43e3ade20999d4f3039e143a8-1764299949993.png&name=mceclip3.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/d1adc99289f703302e5601b4b6c7509e-1764299963991.png&name=mceclip4.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"></p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"> </p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">3、在条码上右击，选择“属性”</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/84ac556ac17ef68e826a682500b5d065-1764299978481.png&name=mceclip5.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"></p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"> </p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);">4、在弹出的属性对话框中，点击”自定义”右边的三个点，在”样式”中选择”11-QR Code”点击确定，在Value中输入手机号，回车确认。其他单元格可以复制二维码后修改Value值即可，如下图：</p><p style="color: rgb(52, 52, 52); font-family: "Microsoft YaHei", Arial, sans-serif, 宋体; background-color: rgb(255, 255, 255);"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/144a5177c3a50bf28e30c6b77516b24e-1764299991401.png&name=mceclip6.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"><img src="https://chinakb.lenovo.com.cn/chinakb/prod-api/file/downloadFile?key=uniko/IMAGE/b72a179295175af764af3740ff756771-1764299995898.png&name=mceclip7.png" style="cursor: pointer; border: 0px; max-width: 100%; height: auto !important;"></p> SF页:
[1]
