返回目录：excel表格制作
1、首先在自己电脑上，打开复Excel一份表格。
2、在打开的表格D1单元格上，输入转拼音的汉字制，然后在D2单元格里输入=getpy(A2)公式。因为姓名百在A列上，所以需要引用单元格选择A2。
3、输入完公式选中好引用名度字的单元格之后，按下确定键在D2单元格就可以看到知姓名已经转换成拼音了。
4、然后选中D2单元格的拼音名字，向下道拉对下列单元格进行转换即可。
1、首先输入文字。
2、然后选中要加拼百音的文字度，并点击“开始”。知
3、选择“开始”菜单中的“wen文”（拼音在上方）。
4、这里道可以专更改一些数据，包括对齐方式、字号等，其中偏移量是属调整拼音和文字之间的间隔的。
5、可以根据需要调整，这里随便选了几个，好了点击“确定”。
6、如果加了拼音后文字变得不整齐了，可以调整一下，直接选中后按空格键即可。完成效果图。
Excel中可以利用自定义函数来实现将汉字转换成拼音。
所用工具：Office2007
举例说明如下：
1.将A列数据转换成拼音：
2.alt+F11插入模块，在模块中输入如下代码，代码很多（由于篇幅限制，无法将全部代码发上来，可以搜索汉字ASC码来获取），但原理很简单，利用每个汉字的ASC码来得到这个汉字的拼音，e799bee5baa6e997aee7ad94e58685e5aeb9332然后依次提取单元格中的每一个汉字，分别获得其拼音。
Function pinyin(p As String) As String
i = Asc(p)
Select Case i
Case -20319 To -20318: pinyin = "a "
Case -20317 To -20305: pinyin = "ai "
Case -20304 To -20296: pinyin = "an "
Case -20295 To -20293: pinyin = "ang "
Case -20292 To -20284: pinyin = "ao "
Case -20283 To -20266: pinyin = "ba "
Case -20265 To -20258: pinyin = "bai "
Case -20257 To -20243: pinyin = "ban "
Case -20242 To -20231: pinyin = "bang "
Case -20230 To -20052: pinyin = "bao "
Case -20051 To -20037: pinyin = "bei "
Case -20036 To -20033: pinyin = "ben "
Case -20032 To -20027: pinyin = "beng "
Case -20026 To -20003: pinyin = "bi "
Case -20002 To -19991: pinyin = "bian "
Case -19990 To -19987: pinyin = "biao "
Case -19986 To -19983: pinyin = "bie "
……
Case -11055 To -11053: pinyin = "za "
Case -11052 To -11046: pinyin = "zai "
Case -11045 To -11042: pinyin = "zan "
Case -11041 To -11039: pinyin = "zang "
Case -11038 To -11025: pinyin = "zao "
Case -11024 To -11021: pinyin = "ze "
Case -11020 To -11020: pinyin = "zei "
Case -11019 To -11019: pinyin = "zen "
Case -11018 To -11015: pinyin = "zeng "
Case -11014 To -10839: pinyin = "zha "
Case -10838 To -10833: pinyin = "zhai "
Case -10832 To -10816: pinyin = "zhan "
Case -10815 To -10801: pinyin = "zhang "
Case -10800 To -10791: pinyin = "zhao "
Case -10790 To -10781: pinyin = "zhe "
Case -10780 To -10765: pinyin = "zhen "
Case -10764 To -10588: pinyin = "zheng "
Case -10587 To -10545: pinyin = "zhi "
Case -10544 To -10534: pinyin = "zhong "
Case -10533 To -10520: pinyin = "zhou "
Case -10519 To -10332: pinyin = "zhu "
Case -10331 To -10330: pinyin = "zhua "
Case -10329 To -10329: pinyin = "zhuai "
Case -10328 To -10323: pinyin = "zhuan "
Case -10322 To -10316: pinyin = "zhuang "
Case -10315 To -10310: pinyin = "zhui "
Case -10309 To -10308: pinyin = "zhun "
Case -10307 To -10297: pinyin = "zhuo "
Case -10296 To -10282: pinyin = "zi "
Case -10281 To -10275: pinyin = "zong "
Case -10274 To -10271: pinyin = "zou "
Case -10270 To -10263: pinyin = "zu "
Case -10262 To -10261: pinyin = "zuan "
Case -10260 To -10257: pinyin = "zui "
Case -10256 To -10255: pinyin = "zun "
Case -10254 To -10254: pinyin = "zuo "
Case Else: pinyin = p
End Select
End Function
Function py(str)
For i = 1 To Len(str)
py = py & pinyin(Mid(str, i, 1))
Next i
End Function
3.这样，返回Excel利用自定义的py函数即可：
4.下拉填充，就可以得到全部汉字的拼音：
1.打开excel2007---“开始”菜单下，如图：
2.找到“显示和隐藏字知段的标识”。
3.选中有汉道字的单元格，然后点击这个标识旁边的倒三角，选择——编辑内拼音，就可以为汉字编辑拼音了，编辑完之后，选中该单元格，再点击倒三角，选择——显示拼音字段，就标注好了容。