【征集】征集隔行插入表标题方法

轩辕轼轲

<p>表格如下，当然，真实数据远远不止这么一点行数。现在需要隔行插入表标题。</p><p>一、凡是可以实现的技巧类方法都可以，VBA方法不算；</p><p>二、回贴所说的方法楼上没有出现过；</p><p>三、写出你的操作步骤，操作方法最好不要过于繁琐。</p><table cellspacing="0" cellpadding="0" width="288" border="0" style="WIDTH: 216pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" width="72" height="16" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">标题一</font></p></td><td class="xl22" width="72" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600; WIDTH: 54pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">标题二</font></p></td><td class="xl22" width="72" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600; WIDTH: 54pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">标题三</font></p></td><td class="xl22" width="72" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600; WIDTH: 54pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">标题四</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">548</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">810</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">74</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">106</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">135</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">339</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">961</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">790</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">232</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">796</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">198</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">824</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">454</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">889</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">37</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">845</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">297</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">603</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">180</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">143</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">352</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">200</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">993</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">764</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">219</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">741</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">355</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">781</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">254</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">176</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">147</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">870</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">796</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">646</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">225</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">980</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">81</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">425</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">835</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">257</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">601</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">178</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">964</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">724</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">988</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">412</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">142</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">213</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">193</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">741</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">262</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">818</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">71</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">988</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">548</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">99</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">930</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">657</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">224</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">785</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">503</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">503</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">198</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">51</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">351</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">826</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">725</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">921</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">83</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">510</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">177</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">91</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">71</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">930</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">526</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">865</font></p></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl22" height="16" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">606</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">802</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">726</font></p></td><td class="xl22" xfmla="=INT(RAND()*1000)" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><p align="center"><font face="宋体" size="2">543</font></p></td></tr></tbody></table><p>我先给出一个例子：</p><p>1、添加一辅助列A列，给行按1、2、3、4……编号，设最后一行为n</p><p>2、从空行处在按1、2、3、4……编n行，并将空行处填充成表标题</p><p>3、按照该辅助列排序。</p><p>收集的方法汇总：</p><p><font color="#0938f7"><strong>方法一：</strong></font></p><p><font color="#0938f7"><strong>3楼提供</strong></font></p><p><font color="#0938f7"><strong>=IF(MOD(ROW(),2),A$1,INDEX(A:A,ROW(A4)/2)) </strong></font></p><p><font color="#0938f7"><strong>向右向下填充</strong></font></p><p><br/></p>

[此贴子已经被作者于2010-11-15 12:43:20编辑过]

Dj_soo

<p><a href="http://user.qzone.qq.com/114152850/blog/1272343841">http://user.qzone.qq.com/114152850/blog/1272343841</a></p><p>这个不知道算不算</p>

Zipall

=IF(MOD(ROW(),2),A$1,INDEX(A:A,ROW(A4)/2))<div>向右向下填充</div>

anchangmei

游客，如果您要查看本帖隐藏内容请回复

桂林灬迷失

楼上是什么方法？

无聊的疯子

<p>添加辅助列,使用2次定位</p><p><br/></p>

vbyou127

dfdsd