报表组内序号

企业报表 未结 0 163
rolldata
rolldata 站长 2024年4月29日 17:38 编辑
<p id="descriptionP"><h2 name="1" id="94edc0d8aa0b37f5" style="margin-top: 0px; margin-bottom: 0px; padding-bottom: 10px; border: 0px; text-size-adjust: none; font-size: 22px; line-height: 26px; color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Semibold !important;">1. 概述</h2><p><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">分组了重新设置序号即组内序号,就是对每一组的元素分别进行编号,如下图中可以看出特制品的分组为一个编号,肉/家禽的分组为另外一个编号,两者的编号是不连续的。</span><br></p><p><img src="http://www.wrenchdata.com:8443/uploaded/202404/20240429173432_el.png" style="max-width:100%;"><br></p><p><br></p><h2 name="1" id="94edc0d8aa0b37f5" style="margin-top: 0px; margin-bottom: 0px; padding-bottom: 10px; border: 0px; text-size-adjust: none; font-size: 22px; line-height: 26px; color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Semibold !important;">2. 序号设置</h2><p><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">使用</span><span style="display: inline-block; padding-right: 4px; padding-left: 4px; background: rgb(249, 249, 249); color: rgb(120, 130, 140); font-size: 13px; font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">&amp;Cell</span><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">进行编号</span><br></p><p><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">如下图所示,在 C4 单元格中,输入公式</span><span style="display: inline-block; padding-right: 4px; padding-left: 4px; background: rgb(249, 249, 249); color: rgb(120, 130, 140); font-size: 13px; font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">=&amp;D4</span><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;"></span><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;">,左父格设置为 D4;然后D4的左父格设置为B4,则可显示组内序号,这种方式会自动限制在 B4 组内。</span><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;"><br></span></p><p><img src="http://www.wrenchdata.com:8443/uploaded/202404/20240429173705_ra.png" style="max-width:100%;"><span style="color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Regular;"><br></span></p><p><br></p><h2 name="1" id="94edc0d8aa0b37f5" style="margin-top: 0px; margin-bottom: 0px; padding-bottom: 10px; border: 0px; text-size-adjust: none; font-size: 22px; line-height: 26px; color: rgb(51, 67, 86); font-family: &quot;Microsoft YaHei&quot;, PingFangSC-Semibold !important;">3. 效果查看</h2><p></p><p><img src="http://www.wrenchdata.com:8443/uploaded/202404/20240429173649_jg.png" style="max-width:100%;"><br></p><p></p><p><br></p></p><p><br></p>
收藏(0)  分享
相关标签: 表格报表
注意:本文归作者所有,未经作者允许,不得转载
0个回复
  • 消灭零回复