接龙:Excel格式刷的秘密 (每个方法5个币币)

兰色幻想

<p>格式刷一般用来复制格式,但它也有不少扩展的应用, 今天又看到一个格式刷超强用法, </p><p>我想知道到底它有多少绝密用法呢, 如果你知道,就告诉我吧，每个应用奖励5个币币。</p><p>&nbsp;</p><p>&nbsp;</p>

格子布圣诞鹿

<p>隐藏第二行，</p><p>按SHIFT选定第一行</p><p>格式刷</p><p>选整张工作表</p><p>可以隐藏偶数行</p>

君柳

<p>等同于CTRL+V：</p><p>选中区域－双击格式刷－目标区域－ENTER</p>

habf2008

<p>选中你要用其格式的单元格，单击你常用工具栏上的格式刷，然后在你要格式化的单元格上单击就可以。如果要对多个单元格做同样的格式化，就要双击格式刷，若要关闭格式刷，则按下“Esc”键或再次单击格式刷即可（此方法同样适用于Word）。</p><p>设置快捷键：首先在视图/工具栏中点自定义，在弹出的对话框中选择命令选卡。 类别选择：格式，命令选择<br/>格式刷这个按钮，点击，选择“图像与文本”这一项，最后在命名中的格式刷(&amp;F)改为格式刷(&amp;A)，退出自定义即可。这时就可以用ALT+A调用格式刷了。</p><p></p>

[此贴子已经被作者于2008-3-24 11:48:29编辑过]

11111

[转帖] <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20pt; mso-char-indent-count: 2.0;"><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">通常在数据校对时要用到查找，找到之后就用不同格式区分</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">(</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">如字体为红色、底纹为黄色等等</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">)</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">，如此重复。</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20pt; mso-char-indent-count: 2.0;"><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">例如：先找到第一个数据并将字体改为红色</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">,</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">然后双击格式刷</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">,</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">当查找到其它相同数据时</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">,</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">再按</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">Ctrl+A</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">，</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;">excel</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma;">就会将新找到的数据自动改为红色与之区分</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma;"><p></p></span></p><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">具体操作为：</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">Ctrl+F</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">在查找栏输入要查找的值</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">查找下一个</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">设置格式（不要退出查找对话框）</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">双击格式刷</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">查找全部</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">Ctrl+A</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">→</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">关闭</span>

接龙:Excel格式刷的秘密 (每个方法5个币币)

<br/>

格子布圣诞鹿

5楼居然直接把ALEX帖子里的图片拿出来用

11111

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>格子布圣诞鹿</i>在2008-3-24 11:57:00的发言：</b><br/>5楼居然直接把ALEX帖子里的图片拿出来用</div><p></p>我说了是转帖，不是扫地的图片[em05]

habf2008

<p>&nbsp;</p><p>谢谢楼主，第一次获得这么多币币，激动的一塌糊涂、、、</p>[em01][em01][em02][em02][em05][em05]

晓

<p>自动填充公式（格式刷的妙用）：选择某一列中已经存在公式的单元格（至少要四行），然后点格式刷，再点一下整一列，这样余下的空的单元格都会自动有公式，但是查看该单元格却不会看见，只有在存在数据的下一列填上内容才会计算出来。（如果中间跳过一行，即下面的都没有自动公式）</p><p>这是在网上看到的，可是我老是试不出来，看看哪个能试出来</p>

jx1680000

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>晓</i>在2008-3-24 12:46:00的发言：</b><br/><p>自动填充公式（格式刷的妙用）：选择某一列中已经存在公式的单元格（至少要四行），然后点格式刷，再点一下整一列，这样余下的空的单元格都会自动有公式，但是查看该单元格却不会看见，只有在存在数据的下一列填上内容才会计算出来。（如果中间跳过一行，即下面的都没有自动公式）</p><p>这是在网上看到的，可是我老是试不出来，看看哪个能试出来</p></div><p></p>

接龙:Excel格式刷的秘密 (每个方法5个币币)

<br/>