</span>  可以试使用下面快捷键的方法来实现特殊符号的快速输入。<span lang="EN-US"><br>
</span>  快捷键的使用方法是:<strong>先按住<span lang="EN-US">Alt</span>键不放,然后依次分别按下小键盘上的数字键,最后松开<span lang="EN-US">Alt</span>键,即可自动输入。</strong><span lang="EN-US"><br>
</span>  </span><span lang="EN-US" style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;color:red">AIt+215 </span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">   功能:输入</span><span lang="EN-US" style="font-size:12.0pt;
font-family:"Microsoft YaHei Western";mso-fareast-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">×</span><span style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;color:red">乘号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">AIt+41420 </span>  功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">√</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">打勾<span lang="EN-US"> <br>
</span>  <span lang="EN-US">AIt+41409 </span>  功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">×</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">打叉<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+41446</span>   功能:输入</span><span style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red"> </span><span style="font-size:12.0pt;
font-family:宋体;mso-bidi-font-family:宋体;color:red">℃</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">摄氏度<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+247 </span>   功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">÷</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">除号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+128 </span>   功能:输入欧元符号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+137</span>   功能:输入千分号</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">‰ <br>
</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">  <span lang="EN-US">Alt+153</span>   功能:输入商标<span lang="EN-US">(tm) <br>
</span>  <span lang="EN-US">Alt+165</span>   功能:输入人民币¥<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+174</span>   功能:输入商标<span lang="EN-US">(r) <br>
</span>  <span lang="EN-US">Alt+177</span>   功能:输入正负符号</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">± <br>
</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">  <span lang="EN-US">Alt+178</span>   功能:设置上标<span lang="EN-US">2 <br>
</span>  <span lang="EN-US">Alt+179</span>   功能:设置上标<span lang="EN-US">3 <br>
</span>  <span lang="EN-US">Alt+185</span>   功能:输入上标<span lang="EN-US">1 <br>
</span>  <span lang="EN-US">Alt+186</span>   功能:输入上标<span lang="EN-US">o <br>
</span>  <span lang="EN-US">Alt+188</span>   功能:输入<span lang="EN-US">1/4 <br>
</span>  <span lang="EN-US">Alt+189</span>   功能:输入<span lang="EN-US">1/2 <br>
</span>  <span lang="EN-US">Alt+190</span>   功能:输入<span lang="EN-US">3/4<o:p></o:p></span></span></p>

<p class="MsoNormal" style="text-indent:23.25pt"><span lang="EN-US" style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">Alt+42677 </span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">输入:</span><span style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:微软雅黑;color:red">直径符号<span lang="EN-US"><o:p></o:p></span></span></p>"/> </span>  可以试使用下面快捷键的方法来实现特殊符号的快速输入。<span lang="EN-US"><br>
</span>  快捷键的使用方法是:<strong>先按住<span lang="EN-US">Alt</span>键不放,然后依次分别按下小键盘上的数字键,最后松开<span lang="EN-US">Alt</span>键,即可自动输入。</strong><span lang="EN-US"><br>
</span>  </span><span lang="EN-US" style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;color:red">AIt+215 </span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">   功能:输入</span><span lang="EN-US" style="font-size:12.0pt;
font-family:"Microsoft YaHei Western";mso-fareast-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">×</span><span style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;color:red">乘号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">AIt+41420 </span>  功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">√</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">打勾<span lang="EN-US"> <br>
</span>  <span lang="EN-US">AIt+41409 </span>  功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">×</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">打叉<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+41446</span>   功能:输入</span><span style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red"> </span><span style="font-size:12.0pt;
font-family:宋体;mso-bidi-font-family:宋体;color:red">℃</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">摄氏度<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+247 </span>   功能:输入</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">÷</span><span style="font-size:12.0pt;
font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:Arial;
color:red">除号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+128 </span>   功能:输入欧元符号<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+137</span>   功能:输入千分号</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">‰ <br>
</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">  <span lang="EN-US">Alt+153</span>   功能:输入商标<span lang="EN-US">(tm) <br>
</span>  <span lang="EN-US">Alt+165</span>   功能:输入人民币¥<span lang="EN-US"> <br>
</span>  <span lang="EN-US">Alt+174</span>   功能:输入商标<span lang="EN-US">(r) <br>
</span>  <span lang="EN-US">Alt+177</span>   功能:输入正负符号</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Microsoft YaHei Western";mso-fareast-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">± <br>
</span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:
微软雅黑;mso-bidi-font-family:Arial;color:red">  <span lang="EN-US">Alt+178</span>   功能:设置上标<span lang="EN-US">2 <br>
</span>  <span lang="EN-US">Alt+179</span>   功能:设置上标<span lang="EN-US">3 <br>
</span>  <span lang="EN-US">Alt+185</span>   功能:输入上标<span lang="EN-US">1 <br>
</span>  <span lang="EN-US">Alt+186</span>   功能:输入上标<span lang="EN-US">o <br>
</span>  <span lang="EN-US">Alt+188</span>   功能:输入<span lang="EN-US">1/4 <br>
</span>  <span lang="EN-US">Alt+189</span>   功能:输入<span lang="EN-US">1/2 <br>
</span>  <span lang="EN-US">Alt+190</span>   功能:输入<span lang="EN-US">3/4<o:p></o:p></span></span></p>

<p class="MsoNormal" style="text-indent:23.25pt"><span lang="EN-US" style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">Alt+42677 </span><span style="font-size:12.0pt;font-family:微软雅黑;mso-hansi-font-family:微软雅黑;mso-bidi-font-family:
Arial;color:red">输入:</span><span style="font-size:12.0pt;font-family:微软雅黑;
mso-hansi-font-family:微软雅黑;mso-bidi-font-family:微软雅黑;color:red">直径符号<span lang="EN-US"><o:p></o:p></span></span></p>"/>

EXCEL表格快捷键及技巧

1 楼

需要在文档或表格中输入一些特殊符号,如:平方、立方等。平方米在Word中虽然可以通过插入特殊符号来实现,但在Excel中却没有相关设置。如果通过复制、粘贴的老方法来移花接木,则显得过于麻烦。若是通过设置单元格上标的方法来输入,又会使工作效率大打折扣。
  可以试使用下面快捷键的方法来实现特殊符号的快速输入。
  快捷键的使用方法是:先按住Alt键不放,然后依次分别按下小键盘上的数字键,最后松开Alt键,即可自动输入。
  
AIt+215    功能:输入×乘号
  AIt+41420   功能:输入
打勾
  AIt+41409   功能:输入
×打叉
  Alt+41446   功能:输入
摄氏度
  Alt+247    功能:输入
÷除号
  Alt+128    功能:输入欧元符号
  Alt+137   功能:输入千分号

  Alt+153   功能:输入商标(tm)
  Alt+165   功能:输入人民币¥
  Alt+174   功能:输入商标(r)
  Alt+177   功能:输入正负符号
±
  Alt+178   功能:设置上标2
  Alt+179   功能:设置上标3
  Alt+185   功能:输入上标1
  Alt+186   功能:输入上标o
  Alt+188   功能:输入1/4
  Alt+189   功能:输入1/2
  Alt+190   功能:输入3/4

Alt+42677 输入:直径符号

2014-07-15 13:40:43
txqq_3f2c955386e604fe7ee40e
2 楼
不错,看了很时用
2015-08-02 18:48:22
colindocx
3 楼
2015-08-16 12:29:27