/iknow-pic.cdn.bcebos.com/b03533fa828ba61e59764fd84f34970a314e59a9"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b03533fa828ba61e59764fd84f34970a314e59a9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b03533fa828ba61e59764fd84f34970a314e59a9"/>
2、文件,打开,选择需要设置的套打文件。这里选销售出库单
/iknow-pic.cdn.bcebos.com/e7cd7b899e510fb328f9f360d733c895d0430c60"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e7cd7b899e510fb328f9f360d733c895d0430c60?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb328f9f360d733c895d0430c60"/>
3、首先自定义单据头。拖动位置,双击打开,自定义文字
/iknow-pic.cdn.bcebos.com/a1ec08fa513d26972bdb8faa5bfbb2fb4316d839"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a1ec08fa513d26972bdb8faa5bfbb2fb4316d839?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/a1ec08fa513d26972bdb8faa5bfbb2fb4316d839"/>
4、如果默认的文字框不够用,可以新建一个。但快捷的是直接复制原有的文本框作修改。
/iknow-pic.cdn.bcebos.com/c2fdfc039245d688da5d3553aac27d1ed31b24ed"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c2fdfc039245d688da5d3553aac27d1ed31b24ed?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/c2fdfc039245d688da5d3553aac27d1ed31b24ed"/>
5、拖到适合的位置,双击编辑内容。字体格式大小可以在文本属性里面修改
/iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe41470ef6526034a85fdf72ee"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe41470ef6526034a85fdf72ee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe41470ef6526034a85fdf72ee"/>
6、其他有一样的方法逐个修改。细心活需要点耐心哦。全部改完,保存
/iknow-pic.cdn.bcebos.com/d50735fae6cd7b89ba32bd74012442a7d8330eee"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d50735fae6cd7b89ba32bd74012442a7d8330eee?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d50735fae6cd7b89ba32bd74012442a7d8330eee"/>
7、回到金蝶,打开销售单,文件、套打设置。打开套打选择框。
/iknow-pic.cdn.bcebos.com/aec379310a55b319d0d905824da98226cffc1720"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/aec379310a55b319d0d905824da98226cffc1720?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/aec379310a55b319d0d905824da98226cffc1720"/>
8、先注册套打,浏览,打开刚才保存的套打文件
/iknow-pic.cdn.bcebos.com/9f510fb30f2442a7f0d37952df43ad4bd0130263"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9f510fb30f2442a7f0d37952df43ad4bd0130263?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a7f0d37952df43ad4bd0130263"/>
9、打印选项,选择刚才注册的套打格式
/iknow-pic.cdn.bcebos.com/7a899e510fb30f2465bd6bf4c695d143ad4b0325"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7a899e510fb30f2465bd6bf4c695d143ad4b0325?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/7a899e510fb30f2465bd6bf4c695d143ad4b0325"/>
10、预览,即可看到设置出来的效果和样式。不满意可以忽略前面繁杂的步骤,继续打开该文件,修改,保存。直接在金蝶预览即可。
/iknow-pic.cdn.bcebos.com/14ce36d3d539b600a6138b40e750352ac75cb76c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/14ce36d3d539b600a6138b40e750352ac75cb76c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/14ce36d3d539b600a6138b40e750352ac75cb76c"/>
你要问的是excel怎么设置套选菜单吗?按照以下步骤 *** 作即可:1、文档中想要设置成选择项,可以在空白处输入它的选项明细。
2、先把鼠标放在单元格B2中,在上方菜单栏的“数据”、“有效性”下拉菜单中选择“有效性”,会d出一个数据有效性的对话框。
3、在有效性条件中的“允许”下方点“任何值”选择“序列”。
4、在来源中,用鼠标选择选项所在的区域。
5、选择后,会在来源中体现选择所在单元格的区域,点确定就好。
6、点击“确定”按钮后,在之前选择的单元格B2中,即可看到设置的多项选择下拉菜单。
7、最后可以把空白的单元格B2下拉复制,B3到B20也同样出现下拉选项,下次录的时候,直接选择,不需要再输入选项。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)