秋水长天
发表于 2008-3-19 23:42
[练习题]自定义格式的练习题
<p>请在G列的G6:G554前加入"东风镇",如:G6显示:东风镇李元村张庄,以下同.附件中给出的只是一部分数据,原数据很多,所以不用手工逐条添加,要用基本操作来完成.</p><p>限二系一班同学答题,答对前三名每人奖2个金币</p><p>答题时请写出操作步聚<br/></p><br/>
[此贴子已经被我是特特于2008-3-20 9:00:32编辑过]
ravine
发表于 2008-3-20 00:02
**** Hidden Message *****
君柳
发表于 2008-3-20 08:52
<p>请班长带头做好标题规范榜样</p>
cy8152
发表于 2008-3-20 08:59
**** Hidden Message *****<br/></p><p>再想想，提示一下：自定义格式</p>
[此贴子已经被作者于2008-3-29 12:55:50编辑过]
jzx79
发表于 2008-3-20 12:56
**** Hidden Message *****
亭
发表于 2008-3-20 12:59
又没我的份!
jzx79
发表于 2008-3-20 13:04
4楼的你把G列删掉,公式不就错误了
wylyan
发表于 2008-3-20 13:49
<p>要怎样才能上传附件呀!</p>
亭
发表于 2008-3-20 13:50
<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>wylyan</i>在2008-3-20 13:49:00的发言：</b><br/><p>要怎样才能上传附件呀!</p></div><p>浏览文件后,再点击上传啊</p>
wylyan
发表于 2008-3-20 13:53
<table cellspacing="0" cellpadding="0" width="252" border="0" xstr="" style="WIDTH: 189pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="137" style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 4384;"></col><col width="115" style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 3680;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl29" width="137" height="71" rowspan="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 103pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 53.25pt; BACKGROUND-COLOR: yellow;">住址</td><td class="xl28" width="115" rowspan="3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">住址</td></tr><tr height="18" style="HEIGHT: 13.5pt; mso-height-source: userset;"></tr><tr height="33" style="HEIGHT: 24.75pt; mso-height-source: userset;"></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村张庄</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村张庄</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村后元</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村后元</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村老庄</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村老庄</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村西王</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村西王</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村老庄</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村老庄</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村张庄</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村张庄</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村林厂</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村林厂</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村庙前</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村庙前</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村卢庙</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村卢庙</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村前邵</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村前邵</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村卢庙</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村卢庙</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村卢庙</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村卢庙</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村西王</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村西王</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村老庄</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村老庄</td></tr><tr height="26" style="HEIGHT: 19.5pt; mso-height-source: userset;"><td class="xl25" height="26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 19.5pt; BACKGROUND-COLOR: yellow;">东风镇李元村庙前</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">李元村庙前</td></tr></tbody></table>我的方法是：在一个空白的单元格内输入“东风镇”之后，在G列前插入一空白列，后在这一空白列中设公式，引用这个输入有“东风镇”的单元格和G列中的单元格，中间用"&"连接，就可得出上列黄色列的结果。