如何快速填充空单元格，并合并为一列

jx1680000 · 发表于 2008-3-11 11:55

[em02]

hxqzccct · 发表于 2008-3-11 11:59

看看答案[em01][em01][em01]

君柳 · 发表于 2008-3-11 12:01

[em02]

天正蓝 · 发表于 2008-3-11 15:15

试试看

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

xlf4050 · 发表于 2008-3-11 15:39

[此贴子已经被作者于2008-3-11 16:00:55编辑过]

xlf4050 · 发表于 2008-3-11 15:58

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>yanruyu</i>在2008-3-11 11:44:00的发言：</b><br/><div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xlf4050</i>在2008-3-11 9:44:00的发言：</b></div><p><strong><font style="BACKGROUND-COLOR: #f3f3f3;">可是这样,填充完的内容不是一样样的,但看班长的A列和B列不是一样的啊</font></strong></p><p><strong><font style="BACKGROUND-COLOR: #f3f3f3;">难道我操作错了吗?</font></strong></p><p><strong><font style="BACKGROUND-COLOR: #f3f3f3;">第二步很好使</font></strong></p><br/></div><p><table cellspacing="0" cellpadding="0" width="288" border="0" xstr="" style="WIDTH: 216pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">科目代码</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">科目名称</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">业务日期</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">凭证字号</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" width="72" height="19" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;"><font face="宋体">1</font></td><td class="xl28" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体" size="2">Ctrl</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">加</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">Enter</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">就能</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" width="72" height="19" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;"><font face="宋体">3</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">一次</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">填空</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">挺实</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" align="right" width="72" height="19" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;"><font face="宋体">5</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">用的</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl31" width="72" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">94</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl29" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td><td class="xl31" width="72" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font face="宋体">94</font></td><td class="xl30" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体">　</font></td></tr></tbody></table></p><table cellspacing="0" cellpadding="0" width="288" border="0" xstr="" style="WIDTH: 216pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="4" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="288" colspan="4" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 216pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">我做了个上表，重试了一下，可以吗！</font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="432" border="0" xstr="" style="WIDTH: 324pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="6" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="432" colspan="6" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 324pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">不过，第一步不点击</font><font class="font6">A3,</font><font class="font7" face="宋体">而点击表内任一单元格也可以。</font></td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="576" border="0" xstr="" style="WIDTH: 432pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="8" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="576" colspan="8" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 432pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">现在想想，此题也不一定答对，因借贷方不可能在同一行同时出现。但愿这不是题目的要求。</td></tr></tbody></table><img title="em04" src="http://www.excelpx.com/Skins/Default/emot/em04.gif" style="CURSOR: pointer;" alt=""/><img title="em04" src="http://www.excelpx.com/Skins/Default/emot/em04.gif" style="CURSOR: pointer;" alt=""/><img title="em04" src="http://www.excelpx.com/Skins/Default/emot/em04.gif" style="CURSOR: pointer;" alt=""/>

winflowerzhl · 发表于 2008-3-12 09:53

天正蓝 · 发表于 2008-3-12 10:08

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

yadog · 发表于 2008-3-13 10:30

<p>一直没有明白题意</p>

小华970403 · 发表于 2008-3-13 12:48

看看啊

		自动登录	找回密码
密码			注册

[问题] 如何快速填充空单元格，并合并为一列