[求助]有关工资表的问题

basionwell44

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">制作工资盘遇到很多细节的问题，希望大家能够帮我解答</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">此表格是由多个表分类汇总得出的一个部分</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">问题</span><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、如何让常规的数据</span><font face="Times New Roman">
                </font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">如货币</span><font face="Times New Roman">
                        <span lang="EN-US">001</span></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，汇款</span><font face="Times New Roman">
                        <span lang="EN-US">99 </span></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">汇款账号</span><span lang="EN-US"><font face="Times New Roman">828029496608093001</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Times New Roman">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">汇款人名称可以复制填充相对应的列里呢，通常我们都是通过双击就可以复制，</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">可是这个好象不行，请问是不是要怎么转换一下单元的格的格式就可以直接通过双击就把每一列填充完毕呢？</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、如何让如列</span><span lang="EN-US"><font face="Times New Roman">A</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，</span><span lang="EN-US"><font face="Times New Roman">I</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，</span><span lang="EN-US"><font face="Times New Roman">J</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，</span><span lang="EN-US"><font face="Times New Roman">K</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">这些数据可以全部都落到帐号汇总那一行呢？</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、如何在选定一个单元格后，在向下复制公式的过程中</span><font face="Times New Roman">
                </font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">用什么快捷键可以把该列直接选完，而不必一直拖鼠标呢？</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">呵呵问题都比较低，不过还是希望各位给我一个好的建议，</span></p> YIKJQm9g.rar (2.8 KB, 下载次数: 8)

2007-7-17 16:28 上传

点击文件名下载附件
[求助]有关工资表的问题

<br/>

nbzhou

<p>好像不太明白你的意思</p><p>能否详细一点？</p>

basionwell44

不会吧，哪里不明白呢

dsp5000

<p>问题1、2、双击复制的前提是左列数据没有空白单元格，在这个表里填充空白行可以用下面的方法：</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 选中<span lang="EN-US" twffan="done"><font face="Times New Roman">A</font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'times new roman'; mso-hansi-font-family: 'times new roman';">，</span><span lang="EN-US" twffan="done"><font face="Times New Roman">I</font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'times new roman'; mso-hansi-font-family: 'times new roman';">，</span><span lang="EN-US" twffan="done"><font face="Times New Roman">J</font></span><span twffan="done" style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'times new roman'; mso-hansi-font-family: 'times new roman';">，</span><span lang="EN-US" twffan="done"><font face="Times New Roman">K列-----ctrl＋G------定位空值-----F2键-----&nbsp; =A2&nbsp; ------ctrl+enter</font></span></p><p><span lang="EN-US" twffan="done"><font face="Times New Roman"></font></span></p><p><span lang="EN-US" twffan="done"><font face="Times New Roman">问题3、如果A1有数据，要从A1填充到A10000，可以在名称栏填写A1:A10000，ctrl+D</font></span></p><p><span lang="EN-US" twffan="done"><font face="Times New Roman"></font></span></p><p><span lang="EN-US" twffan="done"><font face="Times New Roman">&nbsp; </font></span></p><p><span lang="EN-US" twffan="done"><font face="Times New Roman"></font></span></p>

basionwell44

<p>1、2问题已经圆满解决，但是问题3我不是很明白“<font face="Times New Roman">如果A1有数据，要从A1填充到A10000，可以在名称栏填写A1:A10000，ctrl+D</font>”名称栏是什么具体怎么操作？</p><p>难道就是在A1里面数据原有的基础上作呢？</p>